SAP Knowledge Base Article - Preview

2512231 - Waiting for multi-database prepared transaction -SAP ASE for BS

Symptom

  • ASE error log shows the following:

00:0003:00000:00536:2017/07/29 08:45:20.83 server Processes trying to issue an I/O operation on the quiesced database(s) will be suspended until the user executes a QUIESCE DATABASE command with the RELEASE option.
00:0002:00000:00538:2017/07/29 08:45:21.28 server QUIESCE DATABASE command with tag tagname_sybmgmtdb is being executed by process 538.
00:0003:00000:00538:2017/07/29 08:45:23.26 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 1.
00:0003:00000:00538:2017/07/29 08:45:25.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 2.
00:0003:00000:00538:2017/07/29 08:45:27.29 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 3.
00:0002:00000:00538:2017/07/29 08:45:29.26 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 4.
00:0002:00000:00538:2017/07/29 08:45:31.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 5.
00:0003:00000:00538:2017/07/29 08:45:33.28 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 6.
00:0003:00000:00538:2017/07/29 08:45:35.30 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 7.
00:0003:00000:00538:2017/07/29 08:45:37.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 8.
00:0003:00000:00538:2017/07/29 08:45:39.26 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 9.
00:0003:00000:00538:2017/07/29 08:45:41.30 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 10.
00:0003:00000:00538:2017/07/29 08:45:43.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 11.
00:0003:00000:00538:2017/07/29 08:45:45.26 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 12.
00:0003:00000:00538:2017/07/29 08:45:47.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 13.
00:0002:00000:00538:2017/07/29 08:45:49.26 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 14.
00:0002:00000:00538:2017/07/29 08:45:51.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 15.
00:0003:00000:00538:2017/07/29 08:45:53.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 16.
00:0003:00000:00538:2017/07/29 08:45:55.27 server QUIESCE DATABASE: Waiting for multi-database prepared transactions to complete. Retry count: 17.
00:0002:00000:00538:2017/07/29 08:45:57.29 server Error: 2236, Severity: 16, State: 1
00:0002:00000:00538:2017/07/29 08:45:57.30 server Process 538 is aborted by QUIESCE DATABASE, as transactions in a prepare state did not finish within the prescribed time limit.
00:0002:00000:00133:2017/07/29 08:51:03.36 kernel Cannot read, host process disconnected: SMP 6344 spid: 133
00:0003:00000:00053:2017/07/29 09:08:02.31 kernel Cannot read, host process disconnected: SMP 8416 spid: 53
00:0002:00000:00016:2017/07/29 09:20:00.28 server Error: 12205, Severity: 17, State: 2
00:0002:00000:00016:2017/07/29 09:20:00.28 server Could not acquire a lock within the specified wait period. SERVER level wait period=1800 seconds, spid=16, lock type=shared


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • SAP NETWEAVER 7.4 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

QUIESCE fails, deadlock , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.