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

[Rudd, Richard]

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(JobStoreSupport.java:1778)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1218)
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(T2CPreparedStatement.java:530)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:713)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertFiredTrigger(StdJDBCDelegate.java:3360)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:1771)
INFO   | jvm 1    | 2011/02/03 16:54:47 |       at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1218)
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