Bug 523251
| Summary: | satellite sync fails after upgrade to 530 | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Thomas Cameron <tcameron> | ||||||
| Component: | Satellite Synchronization | Assignee: | Pradeep Kilambi <pkilambi> | ||||||
| Status: | CLOSED NOTABUG | QA Contact: | Brandon Perkins <bperkins> | ||||||
| Severity: | high | Docs Contact: | |||||||
| Priority: | low | ||||||||
| Version: | 530 | CC: | sdodson | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | All | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2009-09-17 00:45:46 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: | |||||||||
| Attachments: |
|
||||||||
Wow - sosreport is almost a gigabyte, don't think it makes sense to upload it. See http://www.camerontech.com/sosreport-tcameron.523251-394871-effb1d.tar.bz2 for the sosreport if you need it. The only step I've taken so far per Jan Pazdziora is to delete all the content under /var/cache/rhn and re-run satellite-sync. It did not help. I also deleted all beta channels using satrm.py since the error references "beta." That also did not help. Any ideas? Created attachment 360968 [details]
sosreport without /tftpboot
Here is the sosreport without the /tftpboot directory so it's a sane size.
Created attachment 360991 [details]
satellite-sync logs
I'm seeing the same problem, log attached.
I'm no longer having this problem. If Thomas can confirm I suggest we close this as a temporary networking/services problem within RHN. Ditto here - it seems to be working now. Closing this BZ. |
Description of problem: After upgrading to 5.3 from 5.2, satellite-sync fails with: 09:29:30 SYNC ERROR: unhandled exception occurred: Exception reported from satellite.tc.redhat.com Time: Mon Sep 14 09:29:30 2009 Exception type server.rhnSQL.sql_base.SQLError Exception Handler Information Traceback (most recent call last): File "/usr/bin/satellite-sync", line 142, in main return satsync.Runner().main() File "/usr/share/rhn/satellite_tools/satsync.py", line 212, in main ret = method() File "/usr/share/rhn/satellite_tools/satsync.py", line 286, in _step_channels self.syncer.process_channels() File "/usr/share/rhn/satellite_tools/satsync.py", line 627, in process_channels orgid=OPTIONS.orgid or None) File "/usr/share/rhn/satellite_tools/sync_handlers.py", line 221, in import_channels importer.run() File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run self.submit() File "/usr/share/rhn/server/importlib/channelImport.py", line 184, in submit self.backend.processChannelProduct(channel) File "/usr/share/rhn/server/importlib/backend.py", line 1135, in processChannelProduct channel['channel_product_id'] = self.lookupChannelProduct(channel) File "/usr/share/rhn/server/importlib/backend.py", line 1205, in lookupChannelProduct return self.createChannelProduct(channel) File "/usr/share/rhn/server/importlib/backend.py", line 1220, in createChannelProduct beta = channel['channel_product_beta']) File "/usr/share/rhn/server/rhnSQL/sql_base.py", line 161, in execute return apply(self._execute_wrapper, (self._execute, ) + p, kw) File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 118, in _execute_wrapper raise apply(sql_base.SQLError, ret) SQLError: (1400, 'ORA-01400: cannot insert NULL into ("RHNSAT"."RHNCHANNELPRODUCT"."VERSION")\n', 'INSERT INTO rhnChannelProduct (id, product, version, beta) VALUES (:id, :product, :version, :beta)') Version-Release number of selected component (if applicable): RHN Satellite 5.3 i386. Will attach sosreport. I had to stop the rhn-satellite service as there were oracle processes in D state and sosreport warned that it might hang.