[Spacewalk-list] WEB TRACEBACK when syncing repos

[Justin Sherrill]

On 6/8/10 5:44 PM, Adam Yates wrote:
> Hi everyone-
> I seem to repeatedly get this error when trying to sync channels that I've
> created.  Any suggestions? What additional info is needed?
>
> Thanks,
> Adam
> -----------------------
> com.redhat.rhn.common.hibernate.HibernateRuntimeException: HibernateException executing CachedStatement
> 	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:469)
> 	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)
> Caused by: 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)
> 	... 11 more
>
>    
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
Hey Adam,

Did you ever get this resolved?

I would try clearing out the reposync queue:


sqlplus spacewalk/spacewalk at xe
sql>   delete from rhnTaskQueue where task_name = 'repo_sync';


Also, what version of spacewalk are you running?  One cause of this 
error was fixed in 0.7 (i think?), but there may be more.

-Justin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100611/918e24e1/attachment.htm>