2155463 - How to clear long-running open transaction held for spid 0? - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2155463 - How to clear long-running open transaction held for spid 0? - SAP ASE

Symptom

  • How to clear long-running open transaction held for spid 0?
  • ASE outputs from syslogshold, sp_transaction and sp_lock show long-running open transaction holding lock(s) for spid 0
select dbid, spid, xactid, starttime, name from master..syslogshold
go

dbid spid xactid starttime name
------ ------ -------------------- ----------------------- ------------------------------------------------------------------------- 6 0 0x000e4016000c Jan 20 2015 3:02PM 000007D6_ejsNdzoMd3sQnP4PcjcUcj8OdlYMnP1vrmBDnRlMr6Zxp5hOomhBsOQNej

sp_transactions go
xactkey type coordinator starttime state connection dbid spid loid failover srvname namelen xactname ------------------------------ ----------- ----------- -------------------- ----------------- ---------- ------ ------ ----------- -------------------------- ------------------------------ ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 0x000e4016000c00004267be370006 External XA Jan 20 2015 3:02PM Prepared-Detached Detached 6 0 8053 Resident Tx NULL 182 000007D6_ejsNdzoMd3sQnP4PcjcUcj8OdlYMnP1vrmBDnRlMr6Zxp5hOomhBsOQNejAJd5ZvnRY0000000000000000003_bjARdzoPc3sMdlYNcP4Ucz0Rdj1vnRZv000000000000000000000000000000000000000000000000000003 sp_lock

 id          dbid   page       type   spid   class                          fid    context row    loid        partitionid nodeid
----------- ------ ---------- ------ ------ ------------------------------ ------ ------- ------ ----------- ----------- ------
467842048      6          0      3      0 Non Cursor Lock                     0       0      0       39571           0   NULL
1299636792      6          0      3      0 Non Cursor Lock                     0       0      0       39571           0   NULL

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.