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

[Martha Driscoll]

Jesse,
You could try commenting out the two lines and see if it runs:

SELECT evergreen.upgrade_deps_block_check('0841', :eg_version);
SELECT evergreen.upgrade_deps_block_check('0842', :eg_version);

I actually ran 0794, 0795, and 0843 individually from the upgrade 
directory and then removed everything in 2.4.3-2.5.0-upgrade-db.sql from 
"SELECT evergreen.upgrade_deps_block_check('0794', :eg_version);" up to 
the beginning of the 0796 script.

Martha Driscoll
Systems Manager
North of Boston Library Exchange
Danvers, Massachusetts
www.noblenet.org

On 5/20/2014 11:19 AM, Jesse McCarty wrote:
> Thanks Martha,
>
> How much is there to comment out? Is it just the single line(s) that reads:
>
> SELECT evergreen.upgrade_deps_block_check('0841', :eg_version);
> SELECT evergreen.upgrade_deps_block_check('0842', :eg_version);
>
> Thanks again,
>
> 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 Martha Driscoll
> Sent: Monday, May 19, 2014 2:30 PM
> To: open-ils-dev at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-DEV] Errors Upgrading Evergreen 2.4.4 to 2.5.4
>
> Jesse,
> I found that upgrade scripts 0841 and 0842 which are contained in the
> 2.4.3-2.5.0 upgrade script were already applied in the upgrade to 2.4.4.
>    I commented out those two parts of the upgrade script.
>
> Martha Driscoll
> Systems Manager
> North of Boston Library Exchange
> Danvers, Massachusetts
> www.noblenet.org
>
> On 5/19/2014 1:31 PM, Jesse McCarty wrote:
>> Hi,
>>
>>
>> I am going through the process of upgrading our 2.4.4 installation of
>> Evergreen to 2.5.4. Currently running through the install on a test
>> server (which is an exact copy of our production server as it sat
>> several weeks ago, albeit with a different IP Address).
>>
>> After upgrading OpenSRF to 2.2.2 and the Evergreen code, I started
>> getting errors when running the update DB scripts. I started by
>> running the 2.4.3-2.5.0-upgrade-db.sql (There was no
>> 2.4.4-2.5.0-upgrade-db.sql) with more errors that could fit on a
>> screen shot, then ran into additional errors on different update scripts:
>>
>> 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).
>>
>> For 2.5.0-2.5.1-upgrade-db.sql errors see attached 250-251Error.JPG
>>
>> No errors where reported when running the 2.5.1-2.5.2-upgrade-db.sql script.
>>
>> For 2.5.2-2.5.3-upgrade-db.sql errors see attached 252-253Error.JPG
>>
>> For 2.5.3-2.5.4-upgrade-db.sql errors see attached 253-254Error.JPG
>>
>>
>> After starting Evergreen, I can connect via the web browser and login
>> to my account with no issues, searching the catalog produces and
>> internal server error. I can also connect to the staff client and
>> register the workstation and test/add SSL exemption with no issues.
>> Once the work station is registered I get a Network error (can ping
>> the server from the workstation connecting) show in the attached
>> StaffClientError.JPG file. If I close that error the Staff Client
>> loads and then I can browse patrons and interact with the Server OK.
>>
>> 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.
>>
>> Thanks,
>>
>>
>> Jesse McCarty
>>
>> City of Burlington
>>
>> IT Technical Assistant
>>