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:
- Take down the web server running MusicBrainz, if you’re running a web server.
- Turn off cron jobs if you are automatically updating the database via cron jobs.
- Make sure your REPLICATION_TYPE setting is RT_SLAVE
- Switch to the new code with git fetch origin followed by git checkout v-2012-01-12-schema-change-2
- Install any necessary perl modules by running perl ./Makefile.PL and sudo make installdeps
- Run ./upgrade.sh from the top of the source directory.
- Set DB_SCHEMA_SEQUENCE to 14 in lib/DBDefs.pm
- Turn cron jobs back on, if needed.
- 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.
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’?
Invisibleman78: Could you please open a ticket in http://tickets.musicbrainz.org , which is the appropriate place to report issues?
Thanks!