Description of problem:
After upgrading to 5.3 from 5.2, satellite-sync fails with:
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
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
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
File "/usr/share/rhn/server/importlib/importLib.py", line 628, in run
File "/usr/share/rhn/server/importlib/channelImport.py", line 184, in submit
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
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.
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]
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.