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@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/spacew...@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@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
<ya...@cct.lsu.edu>

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to