2399785 - Dump tran hung and report 3653 on other node when node1 crashed | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2399785 - Dump tran hung and report 3653 on other node when node1 crashed

Symptom

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
2> go
 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.


Read more...

Environment

SAP Adaptive Server Enterprise/16.X
Adaptive Server Enterprise Clustered Edition 15.7

Product

Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

CR#793168, 793168, dmpld_lock_unlock_hist_file, dump tran hung , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed

About this page

This 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.