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
