Description of problem: There are thrown (and emailed) regularly about failures in "/var/lib/rhn/tasko/sat/cobbler-sync-bunch/cobbler-sync*_err" where there is: --- 2010-09-03 10:02:08,781 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - RuntimeExceptioneError trying to sync to cobbler: could not execute query org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at com.redhat.rhn.domain.kickstart.KickstartFactory.listAllKickstartData(KickstartFactory.java:898) at com.redhat.rhn.manager.kickstart.cobbler.CobblerProfileSyncCommand.store(CobblerProfileSyncCommand.java:72) at com.redhat.rhn.taskomatic.task.CobblerSyncTask.execute(CobblerSyncTask.java:102) at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80) at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:168) at org.quartz.core.JobRunShell.run(JobRunShell.java:214) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) Caused by: java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 12 more 2010-09-03 10:02:08,788 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - re-throwing exception since we havent yet. 2010-09-03 10:02:08,835 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - could not execute query 2010-09-03 10:02:08,835 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier --- Actually the "cobbler sync" command executes without any problems Version-Release number of selected component (if applicable): Satellite-5.4.0-RHEL5-re20100827.0-i386.iso How reproducible: always on satellites running the ISO above Steps to Reproduce: 1.just check the directory "/var/lib/rhn/tasko/sat/cobbler-sync-bunch/" in regular basis - you'll get the error files soon 2. 3. Actual results: Oracle tracebacks Expected results: No Oracle tracebacks. Presumably cobbler sync should be run behind. Additional info:
This issue was resolved on Aug 30 by commit: d69fdac266a9f73e50273c550ef33e78a5ee0e04
# VERIFIED agree: they disappeared. no more emails like that. checked with current iso: Satellite-5.4.0-RHEL5-re20100920.0
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332 RHEA-2010:0803 - RHN Tools enhancement update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333 RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334 RHEA-2010:0800 - RHN Satellite Server 5.4.0 https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335 Docs are available: http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html Regards, Clifford