2012-01-12 Schema change upgrade instructions for replicated setups

We just finished the latest schema change release! If you are running a full musicbrainz-server mirror, then follow these instructions for upgrading your installation:

  1. Take down the web server running MusicBrainz, if you’re running a web server.
  2. Turn off cron jobs if you are automatically updating the database via cron jobs.
  3. Make sure your REPLICATION_TYPE setting is RT_SLAVE
  4. Switch to the new code with git fetch origin followed by git checkout v-2012-01-12-schema-change-2
  5. Install any necessary perl modules by running perl ./Makefile.PL and sudo make installdeps
  6. Run ./upgrade.sh from the top of the source directory.
  7. Set DB_SCHEMA_SEQUENCE to 14 in lib/DBDefs.pm
  8. Turn cron jobs back on, if needed.
  9. Restart the MusicBrainz web server, if needed.

If you are running a mbslave mirror, check out the latest code and read the upgrade instructions in the README file.

2 thoughts on “2012-01-12 Schema change upgrade instructions for replicated setups”

  1. Full Dump Import doesn’t work anymore:

    I get dozens of:
    Thu Feb 2 16:08:50 2012 : load work_gid_redirect
    work_gid_redirect 0 0% 0Error loading /tmp/MBImport-vBMSsE6w/mbdump/work_gid_redirect: Can’t call method “pg_putcopydata” on an undefined value at /home/mb/musicbrainz-server/admin/MBImport.pl line 271, line 97.
    Thu Feb 2 16:08:50 2012 : load work_meta
    work_meta 0 0% 0Error loading /tmp/MBImport-_aQ64UJY/mbdump/work_meta: Can’t call method “pg_putcopydata” on an undefined value at /home/mb/musicbrainz-server/admin/MBImport.pl line 271, line 98.
    Thu Feb 2 16:08:50 2012 : load work_name
    work_name 0 0% 0Error loading /tmp/MBImport-vBMSsE6w/mbdump/work_name: Can’t call method “pg_putcopydata” on an undefined value at /home/mb/musicbrainz-server/admin/MBImport.pl line 271, line 99.
    Thu Feb 2 16:08:50 2012 : load work_tag
    work_tag 0 0% 0Error loading /tmp/MBImport-_aQ64UJY/mbdump/work_tag: Can’t call method “pg_putcopydata” on an undefined value at /home/mb/musicbrainz-server/admin/MBImport.pl line 271, line 100.

    What’s about this method ‘pg_putcopydata’?

Leave a comment

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