On Wed, Dec 21, 2011 at 02:20:16PM -0500, Eric Lake wrote: > On Wed, Dec 21, 2011 at 1:46 PM, Jan Pazdziora <jpazdzi...@redhat.com> wrote: > > If you still have the schema dump that you used to migrate from Oracle, > > could you check whether it contains a line which would look like > > > > select pg_catalog.setval('rhn_tasko_template_id_seq', 1330170, > > false); > > > > ? Because the sequences should be set via the schema dump as well. > > Looks like the line was there but the value was not 1330170. So the > import process pulled in what was in the dump correctly. Not sure why > the value was low in the dump though. > > grep "select pg_catalog.setval('rhn_tasko_template_id_seq', " > spacewalk-oracle-10-24-11.dump > select pg_catalog.setval('rhn_tasko_template_id_seq', 1329890, false);
Is it possible that taskomatic was (still) running while you were doing the dump? We process the sequences first, so it's possible that we saw the value 1329890 in the sequence, but before the script got to dump the actual table data, taskomatic processed something, fetched some more values from the sequence, and inserted those values to the table. -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel