Executing multiple console events on MVS can cause Oracle Deadlock

Document ID : KB000084861
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
U00000006 DEADLOCK

 
Executing multiple console events on MVS can cause Oracle Deadlock.
 
A deadlock situation may occurr within post script (PSCRIPT) processing on MVS console events.  This deadlock is a result of an update on the EH_MESSAGE table without a lock on the EH record before the update.
 
Example:

Messages from the Automation Engine log file.
11 - 20160718/094208.979 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '14:832.437.999'
11 - 20160718/094208.979 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
10 - 20160718/094215.120 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
01 - 20160718/094215.122 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '26:027.636.000'
01 - 20160718/094215.122 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName   = ?'
10 - 20160718/094216.126 - U00000006 DEADLOCK
10 - 20160718/094216.126 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '11:141.533.000'
10 - 20160718/094216.126 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
06 - 20160718/094216.978 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '17:725.383.000'
06 - 20160718/094216.978 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
01 - 20160718/094225.980 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
06 - 20160718/094226.895 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
11 - 20160718/094226.898 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '17:818.142.000'
11 - 20160718/094226.898 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
06 - 20160718/094227.900 - U00000006 DEADLOCK
06 - 20160718/094227.900 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '10:921.096.999'
06 - 20160718/094227.900 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ?'
01 - 20160718/094230.987 - U00000006 DEADLOCK
01 - 20160718/094230.987 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '15:859.073.999'
01 - 20160718/094230.987 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
08 - 20160718/094236.111 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '28:855.837.999'
08 - 20160718/094236.111 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName   = ?'
11 - 20160718/094237.996 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
11 - 20160718/094243.000 - U00000006 DEADLOCK
11 - 20160718/094243.000 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '16:102.329.000'
11 - 20160718/094243.000 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ?'
08 - 20160718/094246.996 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
10 - 20160718/094246.997 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '30:750.384.000'
10 - 20160718/094246.997 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName   = ?'
08 - 20160718/094247.999 - U00000006 DEADLOCK
08 - 20160718/094247.999 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '11:882.239.999'
08 - 20160718/094248.000 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
06 - 20160718/094248.128 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '20:161.630.999'
06 - 20160718/094248.129 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
10 - 20160718/094256.977 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
01 - 20160718/094256.980 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '19:171.170.000'
01 - 20160718/094256.980 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName   = ?'
10 - 20160718/094258.982 - U00000006 DEADLOCK
10 - 20160718/094258.982 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '11:978.030.000'
10 - 20160718/094258.982 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
06 - 20160718/094258.996 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
06 - 20160718/094304.000 - U00000006 DEADLOCK
06 - 20160718/094304.000 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '15:871.235.999'
06 - 20160718/094304.000 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ?'
01 - 20160718/094307.180 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
11 - 20160718/094307.182 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'SLCU' time: '24:081.219.000'
11 - 20160718/094307.182 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName   = ?'
01 - 20160718/094309.183 - U00000006 DEADLOCK
01 - 20160718/094309.184 - U00003524 UCUDB: ===> Time critical DB call!       OPC: 'EXEC' time: '12:197.288.000'
01 - 20160718/094309.184 - U00003525 UCUDB: ===> 'UPDATE EH SET EH_Message = ? WHERE EH_AH_Idnr = ?'
11 - 20160718/094317.861 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'

 
== end ==
 
Environment:
OS: MVS
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Executing multiple console events on MVS can cause Oracle Deadlock.
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 –Available
Automation Engine 11.1.7 - Available
Additional Information:
Workaround :
N/A