Hi All,

I've upgraded an installation from 9.2.0 to 10.0.0 (a64.lnx) on 6th May. Its just been reported to me that several of the databases involved have totally lost their sequences. In one case the sequence changed from integer4 tointeger8.

I snapshot the database structure on a weekly basis and can confirm that the weekend before the upgrade all was fine, but the weekend after the upgrade the sequences were stuffed.

The upgradedb.log shows no errors on these database, all were promoted to Ingres10.0.0.

Obviously these sequences are not heaviliy used and we can recreate them asthey should be now we know they are gone.

My question is: Has anyone else observed this behaviour?

Martin Bowes

On Jun 13, 2011, at 6:22 AM, Martin Bowes wrote:

That's a strange one. I can see looking in the code that there's a typo
in the iisequence catalog definition that will cause the iisequence upgrade
to lose the seq_modify date (it will be set to the empty date, I think), and
yes, the integer sequence values are now i8 (although the type of the
sequenced column should remain the same). I'm not sure why sequences
would go missing entirely, though.

Is the iisequence catalog missing, or is it there and missing rows, or are
the rows there and messed up in some manner?

Karl

Hi Karl,

iisequence is there but is empty.

FYI. I'm in the process of trialling an upgrade on a dummy installation to see if I can repeat the problem.

Marty
-----Original Message-----
From: Karl Schendel [mailto:schendel (AT) kbcomputer (DOT) com]
Sent: 13 June 2011 12:20
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Missing sequences after upgrade to Ingres10


On Jun 13, 2011, at 6:22 AM, Martin Bowes wrote:

That's a strange one. I can see looking in the code that there's a typo
in the iisequence catalog definition that will cause the iisequence upgrade
to lose the seq_modify date (it will be set to the empty date, I think), and
yes, the integer sequence values are now i8 (although the type of the
sequenced column should remain the same). I'm not sure why sequences
would go missing entirely, though.

Is the iisequence catalog missing, or is it there and missing rows, or are
the rows there and messed up in some manner?

Karl



_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Hi Marty

Was this an upgradedb or an unload/reload? If you are able to
reproduce the behaviour please log an issue under Service Desk so we can
investigate further.

Thanks

Alex


--
hanal04

Hi Alex,

The upgrade was done with upgradedb. I allowed the upgrade script to upgrade all databases in the installation during the upgrade process.

Marty

-----Original Message-----
From: Ingres Forums [mailto:info-ingres (AT) kettleriverconsulting (DOT) com]
Sent: 13 June 2011 13:18
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Missing sequences after upgrade to Ingres10


Hi Marty

Was this an upgradedb or an unload/reload? If you are able to
reproduce the behaviour please log an issue under Service Desk so we can
investigate further.

Thanks

Alex


--
hanal04


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

I've just had it confirmed that a programmer noticed the missing sequence and recreated it specifying datatype integer..hence its now integer8.

Marty

Also I've just done an extra test...I'm starting to run out of installations so this will be the last one for now.

Tables with sequences defined as a default will survive the upgrade. However attempting to use the sequence default will produce an appropriate 'Sequence not found' error.

I added a test for synonyms. They survive the upgrade intact.

Marty