[OPEN-ILS-GENERAL] Evergreen 2.9.3 - 2.10.3 upgrade issues

[Jesse McCarty]

Thanks for the information Josh. We had been running 2.4.4 in the past and skipped over the 2.5 series, upgrading directly to 2.6.3 from 2.4.4 (Our support company performed this upgrade). From 2.6.3 we went to 2.7.3, 2.8.3 and now we are running 2.9.3.

Could simply running the 2.4.3-2.5.0-upgrade-db.sql prior to the current DB scripts work, or would only certain portions of that file need to be run? My test server is a VM with snapshots, so reverting and re-testing anything is trivial.

Thanks again.

Jesse McCarty
City of Burlington
IT Technical Assistant

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Josh Stompro
Sent: Thursday, June 02, 2016 8:13 AM
To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
Subject: Re: [OPEN-ILS-GENERAL] Evergreen 2.9.3 - 2.10.3 upgrade issues

Hello Jesse, it might help to know the history of your system.  What version you started with and how often you have upgraded?

The 2.9.3-2.10.0_DBError02.jpg issue is because the config.z3950_index_field_map table doesn't exist.  So you probably missed a schema update in the past.  Maybe something in the 2.5 upgrade?  Looks like the 2.4.3-2.5.0-upgrade-db.sql includes adding that table.

Maybe you were on 2.4.4 or greater and missed some updates when you moved to 2.5?

Josh Stompro - LARL IT Director

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Jesse McCarty
Sent: Wednesday, June 01, 2016 6:07 PM
To: open-ils-general at list.georgialibraries.org<mailto:open-ils-general at list.georgialibraries.org>
Subject: [OPEN-ILS-GENERAL] Evergreen 2.9.3 - 2.10.3 upgrade issues

Hello Everyone,

I am working on testing our next upgrade of Evergreen (2.9.3 to 2.10.3) and am running into issues with the database upgrade scripts and was wondering if anyone had similar issues or insight into what might be happening. I have attached screen shots of the errors I have been running into for reference.

The first error occurs when running the 2.9.3-2.10.0 db upgrade script (2.9.3-2.10.0_DBError01.jpg) and appears to be informational with no impact on the script.

The next issue shows up at the end of the 2.9.3-2.10.0 script (2.9.3-2.10.0_DBError02.jpg and 2.9.3-2.10.0_DBError02B.jpg) which appears to undo some of the changes it had made/attempted to make, but still appears to finish some changes.

The next issue happens when trying to run the 2.01.0-2.10.1 db upgrade script and this is as far as I got, since it indicates a rollback and no changes made (I did try for kicks to run the 2.10.1-2.10.2 script, which failed as well).

I also noticed that the Reingest that is part of the 2.9.3-2.10.0 script gets to a point that requires intervention before conintinueing. The screen hangs with a : at the bottom waiting for some input. I typed in q (like quitting vim) and it then seemed to continue on as normal and I'm not sure if typing q just exited the screen or canceled the work it was going to do.

Any help is greatly appreciated,

Thanks,

Jesse McCarty
City of Burlington
IT Technical Assistant

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160602/f039e39a/attachment.html>