Bug 891864 - satellite-sync: ORA-00060: deadlock detected
satellite-sync: ORA-00060: deadlock detected
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server (Show other bugs)
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Jan Pazdziora
Red Hat Satellite QA List
Depends On:
Blocks: 462714
  Show dependency treegraph
Reported: 2013-01-04 04:20 EST by Milan Zázrivec
Modified: 2015-05-29 16:10 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2015-05-29 16:10:31 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
/rhnsat/admin/rhnsat/udump/rhnsat_ora_13403.trc (419.19 KB, text/plain)
2013-01-04 04:20 EST, Milan Zázrivec
no flags Details

  None (edit)
Description Milan Zázrivec 2013-01-04 04:20:10 EST
Description of problem:
A regularly scheduled satellite-sync finished with the following traceback:

Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 139, in main
    return satsync.Runner().main()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 225, in main
    ret = method()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 297, in _step_channel_families
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 544, in syncCert
    return self._process_cert(cert, store_cert)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 575, in _process_cert
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 639, in populate_channel_family_permissions
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 627, in run
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/channelImport.py", line 279, in submit
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 983, in processChannelFamilyPermissions
    cfp['channel_family'], cfp['max_members'], cfp['max_flex'])
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 292, in __call__
    retval = self._call_proc(args)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 326, in _call_proc
    return self._call_proc_ret(args, ret_type=None)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 341, in _call_proc_ret
    return self.cursor.callproc(self.name, args)
rhnFault: (23, 'ORA-00060: deadlock detected while waiting for resource\nORA-06512: at "RHNSAT.RHN_CHANNEL", line 689\nORA-06512: at "RHNSAT.RHN_ENTITLEMENTS", line 1597\nORA-06512: at "RHNSAT.RHN_ENTITLEMENTS", line 1632\nORA-06512: at "RHNSAT.RHN_ENTITLEMENTS", line 1515\nORA-06512: at line 1\n: org_id [1] family [rhel-server] max [2200]', 'Could not update database entry.')

Version-Release number of selected component (if applicable):
Satellite 5.5

How reproducible:
Ad-hoc (it seems)

Steps to Reproduce:
Not quite sure how to reproduce this ATM (satsync / tomcat deadlock).
Actual results:

Expected results:
No deadlock.

Additional info:
Comment 1 Milan Zázrivec 2013-01-04 04:20:55 EST
Created attachment 672343 [details]

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