Previously, I noted that I was not able to reindex. I tracked it down to the following. My biblio_metadata file wasempty, and therefore my reindex could not retrieve any biblio information. Now that I know what to look for, there was this error during the upgrade: [Thu Jun 22 22:29:11 2017] updatedatabase.pl: DBD::mysql::db do failed: *Cannot add or update a child row: a foreign key constraint fails* (`kohadb2015`.`biblio_metadata`, CONSTRAINT `biblio_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement " [Thu Jun 22 22:29:11 2017] updatedatabase.pl: INSERT INTO biblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM biblioitems; I think this is where the upgrade failed; the newly created biblio_metadata has a foreign key: *CONSTRAINT `biblio_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES biblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE* When doing the bulk migration, we probably need to turn off foreign key checks before doing the update: SET FOREIGN_KEY_CHECKS=0; And then put them back once it has been done: SET FOREIGN_KEY_CHECKS=1; [update having solved the problem] This glitch was caused primarily by a few different things: 1) a previous update to the mysql did not upgrade all the users. The debian-sys-maint user was somewhat broken. Various things that depended on this user failed during the upgrade. 2) We have some broken data in our install. At one time we had a number of records get corrupted, which resulted in records that do not have the records corresponding to their foreign keys. 3) I did not immediately notice the importance of the error logs (above) telling me that my data had not been copied over. To fix my mysql issues with debian-sys-maint, I ended up running # mysql_upgrade --force -uroot -p This repaired the mysql users table. Being a wise sysadmin, I had a backup database [kohadb2015] which had our original data. To populate that table with the marc data, I ran the following sql: SET FOREIGN_KEY_CHECKS=0; INSERT INTO koha_opac.biblio_metadata ( biblionumber, format, marcflavour, metadata ) SELECT biblionumber, 'marcxml', 'CHANGEME', marcxml FROM kohadb2015.biblioitems; UPDATE biblio_metadata SET marcflavour = (SELECT value FROM systempreferences WHERE variable="marcflavour"); SET FOREIGN_KEY_CHECKS=1; After that, I was able to reindex fine. When the reindex was complete, the pages would still not load. I was getting an error rendering the page. Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627 I am not entirely sure if this is yet another problem with my data, or if I have some odd setting somewhere. What I did, however, was to modify the koha code to avoid it blowing up: vi /usr/share/koha/lib/C4/Biblio.pm +1627 if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches" ) { *if(defined(Koha::Libraries->find($value)))* { return Koha::Libraries->find($value)->branchname; } - Tim Young