Bug 630027 - taskomatic tracebacks - cobbler-sync
Summary: taskomatic tracebacks - cobbler-sync
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 540
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Garik Khachikyan
URL:
Whiteboard:
Depends On:
Blocks: sat540-blockers
TreeView+ depends on / blocked
 
Reported: 2010-09-03 15:13 UTC by Garik Khachikyan
Modified: 2015-01-04 21:57 UTC (History)
4 users (show)

Fixed In Version: spacewalk-java-1.2.18-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-10-28 14:52:07 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Garik Khachikyan 2010-09-03 15:13:46 UTC
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:

Comment 2 Tomas Lestach 2010-09-03 15:30:07 UTC
This issue was resolved on Aug 30 by commit: d69fdac266a9f73e50273c550ef33e78a5ee0e04

Comment 3 Garik Khachikyan 2010-09-22 10:53:48 UTC
# VERIFIED

agree: they disappeared. no more emails like that.

checked with current iso: Satellite-5.4.0-RHEL5-re20100920.0

Comment 6 Clifford Perry 2010-10-28 14:47:20 UTC
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


Note You need to log in before you can comment on or make changes to this bug.