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.
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.