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
Here is the output from the log.
STATUS | wrapper | 2011/12/20 10:38:11 | TERM trapped. Shutting down.
STATUS | wrapper | 2011/12/20 10:38:12 | <-- Wrapper Stopped
STATUS | wrapper | 2011/12/20 10:38:13 | --> Wrapper Started as Daemon
STATUS | wrapper | 2011/12/20 10:38:13 | Launching a JVM...
INFO | jvm 1 | 2011/12/20 10:38:13 | Wrapper (Version 3.2.1)
http://wrapper.tanukisoftware.org
INFO | jvm 1 | 2011/12/20 10:38:13 |
INFO | jvm 1 | 2011/12/20 10:38:17 | Dec 20, 2011 10:38:17 AM
com.mchange.v2.log.MLog <clinit>
INFO | jvm 1 | 2011/12/20 10:38:17 | INFO: MLog clients using
java 1.4+ standard logging.
INFO | jvm 1 | 2011/12/20 10:38:17 | Dec 20, 2011 10:38:17 AM
com.mchange.v2.c3p0.C3P0Registry banner
INFO | jvm 1 | 2011/12/20 10:38:17 | INFO: Initializing
c3p0-0.9.0 [built 13-July-2007 10:11:26 -0400; debug? false; trace: 5]
INFO | jvm 1 | 2011/12/20 10:38:17 | Dec 20, 2011 10:38:17 AM
com.mchange.v2.c3p0.PoolBackedDataSource getPoolManager
INFO | jvm 1 | 2011/12/20 10:38:17 | INFO: Initializing c3p0
pool... com.mchange.v2.c3p0.PoolBackedDataSource@6b62d1 [
connectionPoolDataSource ->
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@c5e2cf [
acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay
-> 1000, autoCommitOnClose -> false, automaticTestTable -> null,
breakAfterAcquireFailure -> false, checkoutTimeout -> 0,
connectionTesterClassName ->
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation
-> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->
c5e2cf, idleConnectionTestPeriod -> 300, initialPoolSize -> 5,
maxIdleTime -> 300, maxPoolSize -> 20, maxStatements -> 0,
maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource ->
com.mchange.v2.c3p0.DriverManagerDataSource@c8c7d6 [ description ->
null, driverClass -> null, factoryClassLocation -> null, identityToken
-> c8c7d6, jdbcUrl -> jdbc:postgresql:spaceschema, properties ->
{user=******, password=******, driver_proto=jdbc:postgresql} ],
preferredTestQuery -> null, propertyCycle -> 300,
testConnectionOnCheckin -> false, testConnectionOnCheckout -> false,
usesTraditionalReflectiveProxies -> false ], factoryClassLocation ->
null, identityToken -> 6b62d1, numHelperThreads -> 3 ]
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,116
[DefaultQuartzScheduler_Worker-1] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
23505
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,116
[DefaultQuartzScheduler_Worker-1] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value
violates unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,117
[DefaultQuartzScheduler_Worker-1] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,120
[DefaultQuartzScheduler_Worker-1] ERROR org.quartz.core.JobRunShell -
Job DEFAULT.errata-queue-default threw an unhandled Exception:
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,121
[DefaultQuartzScheduler_Worker-1] ERROR org.quartz.core.ErrorLogger -
Job (DEFAULT.errata-queue-default threw an exception.
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:225)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 1 more
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,244
[DefaultQuartzScheduler_Worker-2] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
23505
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,244
[DefaultQuartzScheduler_Worker-2] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value
violates unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,244
[DefaultQuartzScheduler_Worker-2] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,245
[DefaultQuartzScheduler_Worker-2] ERROR org.quartz.core.JobRunShell -
Job DEFAULT.cobbler-sync-default threw an unhandled Exception:
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,245
[DefaultQuartzScheduler_Worker-2] ERROR org.quartz.core.ErrorLogger -
Job (DEFAULT.cobbler-sync-default threw an exception.
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:225)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 1 more
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,444
[DefaultQuartzScheduler_Worker-3] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
23505
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,444
[DefaultQuartzScheduler_Worker-3] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value
violates unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,444
[DefaultQuartzScheduler_Worker-3] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,444
[DefaultQuartzScheduler_Worker-3] ERROR org.quartz.core.JobRunShell -
Job DEFAULT.channel-repodata-default threw an unhandled Exception:
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,445
[DefaultQuartzScheduler_Worker-3] ERROR org.quartz.core.ErrorLogger -
Job (DEFAULT.channel-repodata-default threw an exception.
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:225)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 1 more
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,590
[DefaultQuartzScheduler_Worker-4] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
23505
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,590
[DefaultQuartzScheduler_Worker-4] ERROR
org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value
violates unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,590
[DefaultQuartzScheduler_Worker-4] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,590
[DefaultQuartzScheduler_Worker-4] ERROR org.quartz.core.JobRunShell -
Job DEFAULT.sync-probe-default threw an unhandled Exception:
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
INFO | jvm 1 | 2011/12/20 10:39:00 | 2011-12-20 10:39:00,591
[DefaultQuartzScheduler_Worker-4] ERROR org.quartz.core.ErrorLogger -
Job (DEFAULT.sync-probe-default threw an exception.
INFO | jvm 1 | 2011/12/20 10:39:00 |
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:225)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.hibernate.exception.ConstraintViolationException: could not
insert: [com.redhat.rhn.taskomatic.TaskoRun]
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction(ConnectionManager.java:250)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction(HibernateFactory.java:328)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:150)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 1 more
INFO | jvm 1 | 2011/12/20 10:39:00 | Caused by:
org.postgresql.util.PSQLException: ERROR: duplicate key value violates
unique constraint "rhn_tasko_run_id_pk"
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:79)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
INFO | jvm 1 | 2011/12/20 10:39:00 | at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
INFO | jvm 1 | 2011/12/20 10:39:00 | ... 15 more
--
Thanks,
Eric Lake
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
