Schema change release, 2016-05-23 (with upgrade instructions)

11 thoughts on “Schema change release, 2016-05-23 (with upgrade instructions)”

1. We appreciate all your hard work and congratulate the team.
   Is there an update to the search server also available at this time? After upgrading the database to the new schema, the index building code crashes in building the recording index.

2. The search server is supposed to still work, actually (though its output won’t contain the new MBIDs for types etc.). It does on the MeB systems.

   There was only one issue (though not affecting the recording index, I think?) that is fixed in the newest commits on the master branch.

3. After a clean build of the search server index building proceeds to place index where it hangs. I have opened a ticket (SEARCH-429).

4. Any chance to have an updated VM ?

5. +1 on a new VM 🙂

6. I managed to upgrade the current VM by trial and error. See

   
   

   	# With the following commands I upgraded the current VM (2015-08-06) so it would import the current db dumps (Schema 23).
   	# Please follow the script step by step. It is not an automated script but rather a sequence of commands and instructions.
   	# You certainly have to adjust the postgres install section to your distro, the git tag to check out, and the import section at the end.
   	# https://github.com/metabrainz/musicbrainz-server/blob/master/INSTALL.md
   	cd /home/musicbrainz/musicbrainz-server
   	## update postgresql
   	sudo apt-get remove –purge postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3 postgresql-musicbrainz-collate postgresql-musicbrainz-unaccent
   	# https://www.postgresql.org/download/linux/ubuntu/
   	echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" | sudo tee -a /etc/apt/sources.list.d/pgdg.list
   	wget –quiet -O – https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
   	sudo apt-key add –
   	sudo apt-get update
   	sudo apt-get install postgresql-9.5 postgresql-server-dev-9.5 postgresql-contrib-9.5
   	## update mb-server
   	# https://blog.musicbrainz.org/2016/05/25/schema-change-release-2016-05-23-with-upgrade-instructions/
   	sudo git fetch origin
   	tag=v-2016-08-01
   	sudo git checkout ${tag}
   	## install postgresql extensions
   	cd ..
   	sudo git clone https://github.com/metabrainz/postgresql-musicbrainz-collate.git
   	cd postgresql-musicbrainz-collate
   	sudo make install
   	cd ..
   	sudo git clone https://github.com/metabrainz/postgresql-musicbrainz-unaccent.git
   	cd postgresql-musicbrainz-unaccent
   	sudo make install
   	cd musicbrainz-server
   	## set db schema sequence to 23, replication type to RT_STANDALONE
   	sudo vim lib/DBDefs.pm
   	## set postgresql permission
   	# insert "local all all trust"
   	sudo vim /etc/postgresql/9.5/main/pg_hba.conf
   	## update db
   	sudo dropdb -U musicbrainz musicbrainz
   	base=/media/sf_Downloads
   	sudo ./admin/InitDb.pl –createdb –import ${base}/mbdump.tar.bz2 ${base}/mbdump-derived.tar.bz2 –echo

   view raw
   
   mb.vm.upgrade.sh
   
   hosted with ❤ by GitHub

   for instructions

7. I think your link got eaten by wordpress? I’m just seeing two linebreaks between “See” and “for”…

8. You are right. gist.github.com/notEvil/be975e41693b88e0e5587fbf1dbe2ce3
   alternatively look for “mb.vm.upgrade.sh” at gist (gist.github.com)

9. Hi, thanks for providing the steps. I’ve hit a snag at the last step. When attempting to dropdb I get the following message:

   Peer authentication failed for user “musicbrainz”

10. google tells me that it’s an postgres auth issue. So did you insert “local all all trust” without ” (full access to all users) at the very top? And did you restart postgresql or the entire VM before dropping the db?

11. Hey @notEvil thanks for the excellent guide!

    @Steve I ran into the same snag. I’m not that knowledgeable but my guess is it has sth to do with how the Postgresql remove+install of 9.5 is done. Somehow doing “./admin/InitDb.pl –createdb –clean” (when in /home/musicbrainz/musicbrainz-server) and then continuing with the dropdb worked for me. Cheers.

This site uses Akismet to reduce spam. Learn how your comment data is processed.