Bug 630027
| Summary: | taskomatic tracebacks - cobbler-sync | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Garik Khachikyan <gkhachik> |
| Component: | Server | Assignee: | Tomas Lestach <tlestach> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Garik Khachikyan <gkhachik> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | 540 | CC: | cperry, mkoci, paji, psklenar |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | spacewalk-java-1.2.18-1 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2010-10-28 14:52:07 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 487678 | ||
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 |
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: