On Wed, Dec 21, 2011 at 5:57 AM, Tomas Lestach <tlest...@redhat.com> wrote:
> Looking at the code we've used RHN_TASKO_TEMPLATE_ID_SEQ sequence (not the
> RHN_TASKO_RUN_ID_SEQ) for the rhnTaskoRun table.
>
> Would you please check, what's the sequence number of the
> RHN_TASKO_TEMPLATE_ID_SEQ in your DB dump generated by the spacewalk-dump-
> schema?
I bumped up the last_value in rhn_tasko_run_id_seq to match the
highest id in rhntaskorun but that did not seem to help.
spaceschema=# select * from rhn_tasko_run_id_seq;
sequence_name | last_value | start_value | increment_by |
max_value | min_value | cache_value | log_cnt | is_cycled |
is_called
----------------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
rhn_tasko_run_id_seq | 1329996 | 1 | 1 |
9223372036854775807 | 1 | 1 | 1 | f |
f
(1 row)
Here is the rhn_tasko_template_id_seq information.
spaceschema=# select * from rhn_tasko_template_id_seq;
sequence_name | last_value | start_value | increment_by |
max_value | min_value | cache_value | log_cnt | is_cycled |
is_called
---------------------------+------------+-------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
rhn_tasko_template_id_seq | 1329951 | 1 | 1 |
9223372036854775807 | 1 | 1 | 31 | f |
t
(1 row)
> You also can verify the RHN_TASKO_TEMPLATE_ID_SEQ sequence number in your
> oracle-xe db in case you still have it.
I still have the oracle-xe db around just not exactly sure how to get
the same information from it. I am looking into it.
--
Thanks,
Eric Lake
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
