When first node goes down abruptly, Error 3653 is reported in second node and the first node A remains in init state.
Due to this the dump tran become sleeping state and rest of the dump tran also get hung
If you run the below query you may see the dump tran process with below status for longer period
1> select spid, status, cmd, blocked, instanceid from master..sysprocesses where spid = 958
spid status cmd blocked instanceid
958 sleeping DUMP TRANSACTION NULL 2
In the errorlog of node2 we can see the below error:
02:0008:00000:00110:2016/12/01 08:03:49.39 kernel instance 1 eventdone.
02:0003:00000:00000:2016/12/01 08:03:49.39 kernel Work in failure table for instance 1 is completed.
02:0008:00000:00666:2016/12/01 08:03:49.40 kernel Job Scheduler recovery attempt completed for failed server map: 0x1
02:0002:00000:00742:2016/12/01 08:17:24.03 server Error: 3653, Severity: 20, State: 4
dbcc stacktrace will show dmpld_lock_unlock_hist_file-->ocm_lock
Start dbcc stacktrace...
pc: 0x000000000186b8de upsleepgeneric+0x5be()
pc: 0x0000000000f2fc01 ocm_lock+0x821()
pc: 0x0000000000d27c7e dmpld_lock_unlock_hist_file+0x25()
[Handler pc: 0x0x0000000001406220 hdl_backout_msg installed by the following function:-]
pc: 0x0000000000d2953d dmpld_upd_dump_history_file+0x11b()
[Handler pc: 0x0x0000000000d3c6a8 dpdb_handle installed by the following function:-]
pc: 0x0000000000d30c7a dmpx__truncatemain+0x84a()
pc: 0x0000000000d30334 dmpxact+0x64()
dbcc stacktrace finished.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
SAP Adaptive Server Enterprise/16.X
Adaptive Server Enterprise Clustered Edition 15.7
CR#793168, 793168, dmpld_lock_unlock_hist_file, dump tran hung , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.