Bug 891864 - satellite-sync: ORA-00060: deadlock detected
satellite-sync: ORA-00060: deadlock detected
Status: CLOSED DEFERRED
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server (Show other bugs)
550
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 Zazrivec
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:
Environment:
Last Closed: 2015-05-29 16:10:31 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:


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

  None (edit)
Description Milan Zazrivec 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
    self.syncer.syncCert()
  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
    sync_handlers.populate_channel_family_permissions(sat_cert)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 639, in populate_channel_family_permissions
    importer.run()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 627, in run
    self.submit()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/channelImport.py", line 279, in submit
    self.backend.processChannelFamilyPermissions(self.batch)
  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:
ORA-00060

Expected results:
No deadlock.

Additional info:
N/A
Comment 1 Milan Zazrivec 2013-01-04 04:20:55 EST
Created attachment 672343 [details]
/rhnsat/admin/rhnsat/udump/rhnsat_ora_13403.trc

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