[OPEN-ILS-DEV] 2.0 Beta3 Upgrade Script Troubles

[Ben Shum]

Hi Dan,

Grabbed the changes from svn and ran 1.6.1-2.0 upgrade script against a
reloaded copy of our data.  Upgrade output looks clean and happy as far
as I can tell.

Ran through the reingest-1.6.1-2.0.pl script and .sql afterwards and
that looks happy too.

Thanks!

-- Ben

On 11/28/2010 09:58 AM, Dan Scott wrote:
> On 28 November 2010 06:23, Ben Shum <bshum at biblio.org> wrote:
>> I was poking around with the 1.6.1-2.0 upgrade script that comes with
>> Evergreen 2.0 Beta3.  Two issues came up during our upgrade process
>> using a copy of our live production data (based on a 1.6.1.4 system).
>>
>> Firstly, from line 33:
>>
>> SELECT SETVAL('asset.uri'::TEXT, (SELECT MAX(id) + 1 FROM asset.uri));
>>
>> This command seems to cause some problems when attempting to run against
>> our fake example asset.uri entry (which is set with id of "-1").  Will
>> have to verify this though, I only managed to test it twice and noting
>> that the upgrade was failing early on I commented out the line to
>> continue checking the rest of the process.
> Yeah, that should be updating the asset.uri ID sequence, not the
> asset.uri table. I'll fix it.
>
>> Secondly,
>>
>> psql:/home/opensrf/Evergreen-ILS-2.0-beta3/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql:17044:
>> ERROR:  syntax error at or near "use"
>> LINE 118: use strict;
>>
>> There were alot of failures starting at line 17044 of the upgrade
>> script.  Guessing there's some sort of syntax problem based on the error
>> messages I generated.  I'm attaching a full copy of my upgrade log.
> Looks like some weird copy and paste problem. I'll get that, too.
>
> Thanks for testing, Ben.
>

-- 
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113