[OPEN-ILS-DEV] Errors Upgrading Evergreen 2.4.4 to 2.5.4

[Jesse McCarty]

Thanks Galen,

I have reverted to my snapshot and have run the suggested command to create a file to view. I have attached the output file for review.

Thanks!

Jesse McCarty
City of Burlington
IT Technical Assistant

-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Galen Charlton
Sent: Monday, May 19, 2014 11:09 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Errors Upgrading Evergreen 2.4.4 to 2.5.4

Hi,

On Mon, May 19, 2014 at 10:31 AM, Jesse McCarty <jessem at burlingtonwa.gov> wrote:
> For 2.4.3-2.5.0-upgrade-db.sql errors see attached 243-250Error.JPG 
> (this also shows the reingest records script information, which I ran 
> after running all the DB upgrade scripts).

At this point, one should stop and figure out what the problem is before running any further schema upgrade scripts.  This is because each script runs its statements in (at least) one big transaction.  If any statement in the big transaction fails, all of the following ones automatically fail as well (and the work done by any prior statements in the transaction will be rolled back).  Also, subsequent schema upgrade scripts assume that the previous ones have run successfully.

It is impossible to tell from the screenshot what statement had failed initially.  Thus, it is also helpful to redirect the output of a schema upgrade script to a file for further study, e.g.,

psql -U evergreen -f 2.4.3-2.5.0-upgrade-db.sql > log.apply_2.4.3-2.5.0 2>&1 &

> I have a snapshot of the VM I can revert to that was taken prior to 
> any update scripts running against the DB to work through the process 
> again for further testing if needed.

You should revert to that snapshot now and try again, this time noting the specific first error in the 2.4.3-2.5.0 step.

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: log.apply_2.4.3-2.5.0.rtf
Type: application/rtf
Size: 33581 bytes
Desc: log.apply_2.4.3-2.5.0.rtf
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/96e94b89/attachment-0001.rtf>