2472929 - Processes are in sleeping status with stacktrace showing kmrtmsg function and not able to kill -- SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2472929 - Processes are in sleeping status with stacktrace showing kmrtmsg function and not able to kill -- SAP ASE

Symptom

  • The processes are in sleeping state and has the open transactions.
  • On running the below command, we can see the process is the long running process and in sleeping state
  • dbcc traceon(3604)
    go
    dbcc stacktrace(<SPID>)
    go
    pc: 0x0000000001895f1e upsleepgeneric+0x5be()
    pc: 0x00000000018847e4 kmrtmsg+0x2d4()
    pc: 0x0000000001884187 smget+0x57()
    [Handler pc: 0x0x0000000001536e08 aud_handle installed by the following function:-]
    [Handler pc: 0x0x0000000001536e08 aud_handle installed by the following function:-]
    pc: 0x000000000153624e audproc+0x1534()
    dbcc stacktrace finished
     
  • The sp_who output shows the status as sleeping
     fid          spid             status                           loginame                         blk_spid                         cmd   
    ------------------------------------------------------------------------------------------------------------
       0            XXX             sleeping                         NULL                             NULL         XXXXXXXXXXX
  • systransaction shows the SPID entry.
  • Even if you kill the process the process may not be killed normally.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7, 16.x
  • SAP Adaptive Server Enterprise (ASE) Clustered Edition 15.7, 16.x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

Sleeping process, kmrtmsg, "number of messages", kill, SAP ASE , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.