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. Invisibleman78

    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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s