I'm trying to track down why tasks are no longer executing on my
Spacewalk server (1.0, running on RHEL5). I discovered that there was a
bogus entry in the RhnTaskQueue table - it had a null value in the
task_data field. Each time taskomatic started up it immediately threw
an exception and stopped processing, so other tasks were getting queued
up but never processing. So I went into the database and just deleted
that row from the table. The next time taskomatic ran it emptied the
table but threw a number of other exceptions.
2010-05-10 14:57:00,032 [DefaultQuartzScheduler_Worker-0] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not
synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row
count from update [0]; actual row count: 0; expected: 1
at
org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at
org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2520)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2697)
at
org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:74)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:146)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at
com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:853)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:441)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:335)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:340)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:280)
at
com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:105)
at
com.redhat.rhn.taskomatic.task.repomd.ChannelRepodataDriver.getCandidates(ChannelRepodataDriver.java:86)
at
com.redhat.rhn.taskomatic.task.threaded.TaskQueue.run(TaskQueue.java:106)
at
com.redhat.rhn.taskomatic.task.ChannelRepodata.execute(ChannelRepodata.java:59)
at
com.redhat.rhn.taskomatic.task.SingleThreadedTestableTask.execute(SingleThreadedTestableTask.java:54)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Any ideas what might be causing this?
Thanks,
-Bruce
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
