SAP Knowledge Base Article - Preview

2352929 - ASE hangs due to COMMIT processes failing in bufpindirty - SAP ASE

Symptom

You are running applications on SAP ASE 160.

You find the ASE to hang or become unresponsive all of a sudden. New connections are not accepted and existing server processes (spids) seem to hang.

A check for running processes shows several COMMIT and/or ROLLBACK spids  - as in,  many transactions stay in COMMIT or ROLLBACK state

Furthermore, the ASE errorlog contains the following errors ----  NOTE: these could be (and most likely are) reported much before the ASE assumes a "hung" state  ----

  • WARNING: 1 buffer was found in a predirty state during the termination of spid 3488 (Pss: 0x0x00000004b86ab8d8).
     ************************************
    kernel  SQL causing error : commit
     ************************************
  • signal 11 in bufpindirty()
  • stacktraces referencing functions: plcblock__flush(), xls_flush_plcqueue(), finishlog(), xact_commit()
  • in some cases, signal 11 in smp_bufpredirty() is encountered

 


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0

Keywords

800396, signal 11, CR800396, bufpindirty, plcblock__flush, commit, transaction , KBA , hung, running slow , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.