On Wed, Dec 21, 2011 at 08:09:03AM -0500, Eric Lake wrote:
> 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.
select * from user_sequences where sequence_name =
upper('rhn_tasko_run_id_seq') ;
select * from user_sequences where sequence_name =
upper('rhn_tasko_template_id_seq') ;
should return information about sequences in Oracle.
--
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
