[Spacewalk-list] Taskomatic error after upgrade to Spacewalk 1.2

[Rudd, Richard]

> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-
> bounces at redhat.com] On Behalf Of Rudd, Richard
> Sent: 03 February 2011 17:16
> To: spacewalk-list at redhat.com
> Subject: [Spacewalk-list] Taskomatic error after upgrade to Spacewalk 1.2
> 
> Hi,
> 
> I upgraded our Spacewalk installation to version 1.2 today and I'm now seeing
> the error below in the rhn_taskomatic_daemon.log every 2 minutes.  Does anyone
> have any idea how to fix it?
> 
> I didn't see any errors during the upgrade process, although we are using an
> Oracle 11g database so I've had to change some of the environment settings to
> make Spacewalk work with this.
> 
> Doing a select on the QRTZ_FIRED_TRIGGERS table shows no rows.
> 
> SQL> select * from QRTZ_FIRED_TRIGGERS;
> 
> no rows selected
> 
> SQL>
> 
> INFO   | jvm 1    | 2011/02/03 16:54:47 | 2011-02-03 16:54:47,451
> [DefaultQuartzScheduler_QuartzSchedulerThread] ERROR
> org.quartz.core.ErrorLogger - An error occured while scanning for the next
> trigger to fire.
> INFO   | jvm 1    | 2011/02/03 16:54:47 | org.quartz.JobPersistenceException:
> Couldn't acquire next trigger: ORA-01400: cannot insert NULL into
> ("SPACEWALK"."QRTZ_FIRED_TRIGGERS"."PRIORITY")
> INFO   | jvm 1    | 2011/02/03 16:54:47 |  [See nested exception:
> java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert
> NULL into ("SPACEWALK"."QRTZ_FIRED_TRIGGERS"."PRIORITY")
> INFO   | jvm 1    | 2011/02/03 16:54:47 | ]
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSuppor
> t.java:1778)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:121
> 8)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
> INFO   | jvm 1    | 2011/02/03 16:54:47 | * Nested Exception (Underlying
> Cause) ---------------
> INFO   | jvm 1    | 2011/02/03 16:54:47 |
> java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert
> NULL into ("SPACEWALK"."QRTZ_FIRED_TRIGGERS"."PRIORITY")
> INFO   | jvm 1    | 2011/02/03 16:54:47 |
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:737)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:647)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatemen
> t.java:530)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.ja
> va:713)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
> 307)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedState
> ment.java:3449)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStateme
> nt.java:3530)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePrepared
> StatementWrapper.java:1350)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPr
> eparedStatement.java:101)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegat
> e.java:3360)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSuppor
> t.java:1771)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:121
> 8)
> INFO   | jvm 1    | 2011/02/03 16:54:47 |       at
> org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
> 
> Regards,
> 
> Richard Rudd
> Systems Developer
> Exeter IT, Academic Services
> University of Exeter, EX4 4QE, UK
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list


Just an update to this issue.  I removed the NOT NULL constraint on the QRTZ_FIRED_TRIGGERS.PRIORITY field in the database and this appears to have fixed the issue.  However I'm not sure what else this might break?

Regards,
 
Richard Rudd
Systems Developer 
Exeter IT, Academic Services
University of Exeter, EX4 4QE, UK