Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 891314

Summary:	Repeating CertificateRevocationListTask error in stage logs
Product:	[Community] Candlepin (Migrated to Jira)	Reporter:	Dennis Crissman <dcrissman>
Component:	candlepin	Assignee:	candlepin-bugs
Status:	CLOSED DUPLICATE	QA Contact:	Eric Sammons <esammons>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	0.9
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-01-03 19:29:12 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Dennis Crissman 2013-01-02 15:08:53 UTC

[2013-01-02T09:55:16-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:] ERROR org.quartz.core.JobRunShell - Job cron group.CertificateRevocationListTask-53c12dba-09c8-4ddc-90a0-47802ac2944f threw an unhandled Exception: 
[2013-01-02T09:55:16.548012-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:org.hibernate.StaleStateException] Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
[2013-01-02T09:55:16.548020-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:85)
[2013-01-02T09:55:16.548020-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:70)
[2013-01-02T09:55:16.548024-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:90)
[2013-01-02T09:55:16.548024-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
[2013-01-02T09:55:16.548062-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
[2013-01-02T09:55:16.548062-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
[2013-01-02T09:55:16.548067-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
[2013-01-02T09:55:16.548087-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
[2013-01-02T09:55:16.548087-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
[2013-01-02T09:55:16.548091-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1030)
[2013-01-02T09:55:16.548091-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.model.AbstractHibernateCurator.saveOrUpdateAll(AbstractHibernateCurator.java:158)
[2013-01-02T09:55:16.548094-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.controller.CrlGenerator.getNewSerialsToAppendAndSetThemConsumed(CrlGenerator.java:119)
[2013-01-02T09:55:16.548094-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.pinsetter.tasks.CertificateRevocationListTask.execute(CertificateRevocationListTask.java:73)
[2013-01-02T09:55:16.548098-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.controller.CrlGenerator.syncCRLWithDB(CrlGenerator.java:87)
[2013-01-02T09:55:16.548098-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.quartz.core.JobRunShell.run(Unknown Source)
[2013-01-02T09:55:16.548101-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
[2013-01-02T09:55:16.548101-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.pinsetter.core.TransactionalPinsetterJob.execute(TransactionalPinsetterJob.java:50)
[2013-01-02T09:55:16.548237-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(Unknown Source)
[2013-01-02T09:55:16-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:] ERROR org.quartz.core.ErrorLogger - Job (cron group.CertificateRevocationListTask-53c12dba-09c8-4ddc-90a0-47802ac2944f threw an exception.
[2013-01-02T09:55:16.548476-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:org.quartz.SchedulerException] Job threw an unhandled exception. [See nested exception: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1]
[2013-01-02T09:55:16.548476-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.quartz.core.JobRunShell.run(Unknown Source)
[2013-01-02T09:55:16.548483-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(Unknown Source)
[2013-01-02T09:55:16.548483-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:85)
[2013-01-02T09:55:16.548487-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:70)
[2013-01-02T09:55:16.548487-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
[2013-01-02T09:55:16.548490-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
[2013-01-02T09:55:16.548494-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:90)
[2013-01-02T09:55:16.548494-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
[2013-01-02T09:55:16.548499-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
[2013-01-02T09:55:16.548499-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
[2013-01-02T09:55:16.548505-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
[2013-01-02T09:55:16.548505-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1030)
[2013-01-02T09:55:16.548511-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.model.AbstractHibernateCurator.saveOrUpdateAll(AbstractHibernateCurator.java:158)
[2013-01-02T09:55:16.548511-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.controller.CrlGenerator.getNewSerialsToAppendAndSetThemConsumed(CrlGenerator.java:119)
[2013-01-02T09:55:16.548517-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.controller.CrlGenerator.syncCRLWithDB(CrlGenerator.java:87)
[2013-01-02T09:55:16.548517-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.pinsetter.tasks.CertificateRevocationListTask.execute(CertificateRevocationListTask.java:73)
[2013-01-02T09:55:16.548523-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:66)
[2013-01-02T09:55:16.548523-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    at org.candlepin.pinsetter.core.TransactionalPinsetterJob.execute(TransactionalPinsetterJob.java:50)
[2013-01-02T09:55:16.548529-05:00] [host:s03.candlepin.stage.ext.phx2.redhat.com] [app:]    ... 2 more

Comment 1 Dennis Crissman 2013-01-03 19:29:12 UTC

In stage the CRL job was schedule to run multiple times. Closing as duplicate.

mysql> select * from QRTZ_CRON_TRIGGERS;
+----------------------+--------------------------------------------------------------------+---------------+-----------------+------------------+
| SCHED_NAME           | TRIGGER_NAME                                                       | TRIGGER_GROUP | CRON_EXPRESSION | TIME_ZONE_ID     |
+----------------------+--------------------------------------------------------------------+---------------+-----------------+------------------+
| ITClusteredScheduler | CertificateRevocationListTask-0f63b281-8046-4f6b-a80a-4053a658d9c6 | cron group    | 0/5 * * * * ?   | US/Eastern       |
| ITClusteredScheduler | CertificateRevocationListTask-2cff169b-01ef-4f54-a946-5e441c4cdad2 | cron group    | 0/2 * * * * ?   | US/Eastern       |
| ITClusteredScheduler | CertificateRevocationListTask-4db75071-193c-484f-b896-5ed371e3fb62 | cron group    | 0 0 0/2 * * ?   | America/New_York |
| ITClusteredScheduler | CertificateRevocationListTask-53c12dba-09c8-4ddc-90a0-47802ac2944f | cron group    | 0/2 * * * * ?   | US/Eastern       |
| ITClusteredScheduler | CertificateRevocationListTask-939f284e-2695-4823-a90a-43be1bb8702a | cron group    | 0 0 0/2 * * ?   | US/Eastern       |
| ITClusteredScheduler | CertificateRevocationListTask-a5b8a23c-a2fa-495c-924b-574a645bc68f | cron group    | 0 0 0/2 * * ?   | US/Eastern       |
| ITClusteredScheduler | JobCleaner-ceff3cb3-23d0-4be9-9cb9-6742d422a720                    | cron group    | 0 0 12 * * ?    | US/Eastern       |
+----------------------+--------------------------------------------------------------------+---------------+-----------------+------------------+
7 rows in set (0.00 sec)

*** This bug has been marked as a duplicate of bug 886211 ***