The Taskomatic is failing with errors like "Couldn't release acquired trigger: right sibling's left-link doesn't match: block 272 links to 276 instead of expected 9 in index "idx_qrtz_t_state" "

Solution Verified - Updated -

Issue

  • The taskomatic is throwing errors as below,
INFO   | jvm 1    | 2017/04/03 09:39:07 | 2017-04-03 09:39:07,556 [DefaultQuartzScheduler_QuartzSchedulerThread] ERROR org.quartz.core.ErrorLogger - An error occured while releasing trigger 'DEFAULT.single-channel-repodata-bunch-2'
INFO   | jvm 1    | 2017/04/03 09:39:07 | org.quartz.JobPersistenceException: Couldn't release acquired trigger: ERROR: right sibling's left-link doesn't match: block 272 links to 276 instead of expected 9 in index "idx_qrtz_t_state" [See nested exception: org.postgresql.util.PSQLException: ERROR: right sibling's left-link doesn't match: block 272 links to 276 instead of expected 9 in index "idx_qrtz_t_state"]
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport.releaseAcquiredTrigger(JobStoreSupport.java:2822)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport$37.execute(JobStoreSupport.java:2808)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3729)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3763)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3725)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport.releaseAcquiredTrigger(JobStoreSupport.java:2804)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:341)
INFO   | jvm 1    | 2017/04/03 09:39:07 | Caused by: 
INFO   | jvm 1    | 2017/04/03 09:39:07 | org.postgresql.util.PSQLException: ERROR: right sibling's left-link doesn't match: block 272 links to 276 instead of expected 9 in index "idx_qrtz_t_state"
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.util.PSQLException.<init>(PSQLException.java:18)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.util.PSQLException.<init>(PSQLException.java:24)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.util.PSQLException.<init>(PSQLException.java:29)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:330)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:106)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTriggerStateFromOtherState(StdJDBCDelegate.java:1610)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   at org.quartz.impl.jdbcjobstore.JobStoreSupport.releaseAcquiredTrigger(JobStoreSupport.java:2817)
INFO   | jvm 1    | 2017/04/03 09:39:07 |   ... 6 more

Environment

  • Red Hat Satellite 5.6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In