[Spacewalk-list] WEB TRACEBACK when syncing repos

[Adam Yates]

Hi Justin, thanks for the reply.

I'm running Spacewalk 1.0 on Fedora 12.
I will try clearing the reposync queue and post back if I am
still having troubles.

Thanks!
Adam


On 06/11/2010 08:15 AM, Justin Sherrill wrote:
> 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
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

-- 
Adam Yates
Systems Administrator -- Research Infrastructure
Center for Computation and Technology
232 Johnston Hall,
Baton Rouge, LA 70803
W: 225.578.8235    C: 225.663.0218
<yates at cct.lsu.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100615/8e6bf787/attachment.htm>