[Spacewalk-list] SummaryPopulation failing after 1.5 -> 1.7 upgrade
Daniel Jabbour
drj at inigral.com
Fri Jun 29 21:13:21 UTC 2012
Hey All-
I recently upgraded from Spacewalk 1.5 to Spacewalk 1.7. Everything seems to have gone okay, including the schema upgrade. Yet I'm getting some SQL errors when the SummaryPopulation task runs at night. It looks like this is something internal to the Java code in Spacewalk. Any recommendations?
012-06-28 23:00:03,775 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - ORA-01878: specified field not found in datetime or interval
com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval
at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:453)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:430)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:336)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:341)
at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:281)
at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:126)
at com.redhat.rhn.taskomatic.task.SummaryPopulation.orgsWithRecentActions(SummaryPopulation.java:100)
at com.redhat.rhn.taskomatic.task.SummaryPopulation.execute(SummaryPopulation.java:67)
at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:169)
at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.sql.SQLDataException: ORA-01878: specified field not found in datetime or interval
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)
at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
... 12 more
2012-06-28 23:00:03,778 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval
2012-06-28 23:00:03,778 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.SummaryPopulation - com.redhat.rhn.common.db.WrappedSQLException: ORA-01878: specified field not found in datetime or interval
--
Daniel Jabbour
Senior Agnostic Algorithmatist
Inigral, Inc. | The Social Web For Education
drj at inigral.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120629/0873b18d/attachment.htm>
More information about the Spacewalk-list
mailing list