Bug 891864
| Summary: | satellite-sync: ORA-00060: deadlock detected | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Milan Zázrivec <mzazrivec> | ||||
| Component: | Server | Assignee: | Jan Pazdziora (Red Hat) <jpazdziora> | ||||
| Status: | CLOSED DEFERRED | QA Contact: | Red Hat Satellite QA List <satqe-list> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 550 | CC: | cperry | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2015-05-29 20:10:31 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Bug Depends On: | |||||||
| Bug Blocks: | 462714 | ||||||
| Attachments: |
|
||||||
Created attachment 672343 [details]
/rhnsat/admin/rhnsat/udump/rhnsat_ora_13403.trc
|
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