Bug 627910 - Sync repositories from webUI doesn't work
Summary: Sync repositories from webUI doesn't work
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 540
Hardware: All
OS: Linux
high
medium
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Petr Sklenar
URL:
Whiteboard:
Depends On:
Blocks: sat540-repo-sync
TreeView+ depends on / blocked
 
Reported: 2010-08-27 11:24 UTC by Petr Sklenar
Modified: 2010-10-28 14:56 UTC (History)
4 users (show)

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

Attachments (Terms of Use)

Description Petr Sklenar 2010-08-27 11:24:24 UTC 
Description of problem:
Sync repositories from webUI doesn't work. It seems like taskomatic issue 

Version-Release number of selected component (if applicable):
sat540, today installed
spacewalk-schema-1.2.6-1.el5sat
satellite-schema-5.4.0.2-1.el5sat
spacewalk-backend-1.2.8-1.el5sat


How reproducible:
always

Steps to Reproduce:
1. webUI
2. Channels > Manage Software channel > repositories
3. Sync > Sync now
  
Actual results:
taskomatic has an issue

Expected results:
its synced

Additional info:

   1.
      INFO   | jvm 1    | 2010/08/27 07:12:37 | 2010-08-27 07:12:36,998 [DefaultQuartzScheduler_Worker-5] ERROR com.redhat.rhn.manager.satellite.SystemCommandExecutor - Error encountered executing (args=[/usr/bin/spacewalk-repo-sync, --channel, testchannel, --type])
   2.
      INFO   | jvm 1    | 2010/08/27 07:12:37 | 2010-08-27 07:12:36,998 [DefaultQuartzScheduler_Worker-5] ERROR com.redhat.rhn.manager.satellite.SystemCommandExecutor - Error message from process: usage: spacewalk-repo-sync [options]
   3.
      INFO   | jvm 1    | 2010/08/27 07:12:37 |
   4.
      INFO   | jvm 1    | 2010/08/27 07:12:37 | spacewalk-repo-sync: error: --type option requires an argument
   5.
      INFO   | jvm 1    | 2010/08/27 07:12:37 |
   6.
      INFO   | jvm 1    | 2010/08/27 07:12:37 | 2010-08-27 07:12:36,998 [DefaultQuartzScheduler_Worker-5] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - usage: spacewalk-repo-sync [options]
   7.
      INFO   | jvm 1    | 2010/08/27 07:12:37 |
   8.
      INFO   | jvm 1    | 2010/08/27 07:12:37 | spacewalk-repo-sync: error: --type option requires an argument
   9.
      INFO   | jvm 1    | 2010/08/27 07:12:37 |
  10.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,038 [DefaultQuartzScheduler_Worker-8] INFO  com.redhat.rhn.taskomatic.task.ErrataQueue - In the queue: 0
  11.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,086 [DefaultQuartzScheduler_Worker-1] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 0
  12.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,104 [DefaultQuartzScheduler_Worker-10] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
  13.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,104 [DefaultQuartzScheduler_Worker-10] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  14.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |
  15.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,104 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - RuntimeExceptioneError trying to sync to cobbler: could not execute query
  16.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | org.hibernate.exception.SQLGrammarException: could not execute query
  17.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
  18.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  19.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.doList(Loader.java:2223)
  20.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
  21.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.list(Loader.java:2099)
  22.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
  23.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
  24.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
  25.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.redhat.rhn.domain.kickstart.KickstartFactory.listAllKickstartData(KickstartFactory.java:898)
  26.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.redhat.rhn.manager.kickstart.cobbler.CobblerProfileSyncCommand.store(CobblerProfileSyncCommand.java:72)
  27.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.redhat.rhn.taskomatic.task.CobblerSyncTask.execute(CobblerSyncTask.java:102)
  28.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
  29.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:168)
  30.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
  31.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
  32.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | Caused by:
  33.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  34.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |
  35.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  36.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
  37.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
  38.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
  39.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
  40.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
  41.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
  42.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
  43.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
  44.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
  45.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
  46.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.doQuery(Loader.java:674)
  47.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
  48.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       at org.hibernate.loader.Loader.doList(Loader.java:2220)
  49.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |       ... 12 more
  50.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,105 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - re-throwing exception since we havent yet.
  51.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,106 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - could not execute query
  52.
      INFO   | jvm 1    | 2010/08/27 07:13:00 | 2010-08-27 07:13:00,106 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  53.
      INFO   | jvm 1    | 2010/08/27 07:13:00 |
  54.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,037 [DefaultQuartzScheduler_Worker-7] INFO  com.redhat.rhn.taskomatic.task.ErrataQueue - In the queue: 0
  55.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,079 [DefaultQuartzScheduler_Worker-6] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 0
  56.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,101 [DefaultQuartzScheduler_Worker-3] WARN  org.hibernate.util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
  57.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,101 [DefaultQuartzScheduler_Worker-3] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  58.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |
  59.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,101 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - RuntimeExceptioneError trying to sync to cobbler: could not execute query
  60.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | org.hibernate.exception.SQLGrammarException: could not execute query
  61.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
  62.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  63.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.doList(Loader.java:2223)
  64.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
  65.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.list(Loader.java:2099)
  66.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
  67.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
  68.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
  69.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.redhat.rhn.domain.kickstart.KickstartFactory.listAllKickstartData(KickstartFactory.java:898)
  70.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.redhat.rhn.manager.kickstart.cobbler.CobblerProfileSyncCommand.store(CobblerProfileSyncCommand.java:72)
  71.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.redhat.rhn.taskomatic.task.CobblerSyncTask.execute(CobblerSyncTask.java:102)
  72.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:80)
  73.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:168)
  74.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
  75.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
  76.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | Caused by:
  77.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  78.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |
  79.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  80.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
  81.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
  82.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
  83.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
  84.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154)
  85.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
  86.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415)
  87.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
  88.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
  89.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
  90.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.doQuery(Loader.java:674)
  91.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
  92.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       at org.hibernate.loader.Loader.doList(Loader.java:2220)
  93.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |       ... 12 more
  94.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,102 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - re-throwing exception since we havent yet.
  95.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,103 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - could not execute query
  96.
      INFO   | jvm 1    | 2010/08/27 07:14:00 | 2010-08-27 07:14:00,103 [DefaultQuartzScheduler_Worker-3] ERROR com.redhat.rhn.taskomatic.task.CobblerSyncTask - java.sql.SQLException: ORA-00904: "THIS_"."PARTITION_DATA": invalid identifier
  97.
      INFO   | jvm 1    | 2010/08/27 07:14:00 |
Comment 1 Tomas Lestach 2010-08-27 11:40:16 UTC 
repo sync issue fix 

the commit fixes following two error messages:
Error encountered executing (args=[/usr/bin/spacewalk-repo-sync, --channel, testchannel, --type])
Error message from process: usage: spacewalk-repo-sync [options]

spacewalk.git: 161b88c0c1de45df155ab111292203010b34cab7

other log entries don't relate to repo sync
f.e. ORA-00904 points that you do not have the correct schema.
Comment 2 Petr Sklenar 2010-09-03 12:46:01 UTC 
issue is fixed now;
verified with Satellite-5.4.0-RHEL5-re20100827.0
Comment 4 Garik Khachikyan 2010-10-18 12:48:30 UTC 
# VERIFIED against errata.stage 
(signed packages -satellite-5.4.0-20101015-rhel-5)

Scenario:
1. make custom channel
2. create repo from: http://mirror.centos.org/centos/5/os/x86_64/
3. assign repo to channel
4. do repo sync from: "https://<sat>/rhn/channels/manage/Sync.do?cid=<cid>"
5. follow that progress start (packages count changes) in "/var/log/rhn/reposync/<channel-name>-<timestamp>.log" log or through Satellite UI (checking the packages count - should get incremented during the sync process).
Comment 5 Clifford Perry 2010-10-28 14:52:04 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.