On Tuesday 20 of December 2011 14:20:25 Eric Lake wrote: > Around 2 months ago we moved from an oracle-xe backend to postgresql > because we were hitting the 4GB limit that oracle-xe has. The > migration seemed to go fine but just recently we noticed that > taskomatic was not running. It seems to be an issue in the database > where taskomatic is trying to update the database and it can't because > of a unique constraint in rhn_tasko_run_id_pk. > > When I look at the rhntaskorun table I see that it has an id of 1329996. > > select * from rhntaskorun order by id desc; > id | template_id | schedule_id | org_id | > start_time | end_time | > std_output_path | std_error_path | status | > created | modified > --------------+------------------+-----------------+----------+------------- > -----------------------+-----------------------------------+---------------- > ---------------+---------------------------+----------------+--------------- > --------------------+--------------------------------- 1329996 | > 5 | 3 | | > 2011-10-24 16:05:00-04 | 2011-10-24 16:05:00-04 | > | | FINISHED | 2011-10-24 > 16:05:00-04 | 2011-10-24 16:05:00-04 > > However the sequence thinks that the highest id is 1. > > 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 > | 1 | 1 | > 1 | 9223372036854775807 | 1 | 1 | > 1 | f | f >
Hello Eric, 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? You also can verify the RHN_TASKO_TEMPLATE_ID_SEQ sequence number in your oracle-xe db in case you still have it. Regards, -- Tomas Lestach RHN Satellite Engineering, Red Hat > [...] > > -- > Thanks, > > Eric Lake > > _______________________________________________ > Spacewalk-devel mailing list > Spacewalk-devel@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-devel _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
