SAP Knowledge Base Article - Preview

2820054 - CHKPOINT WRKR hanging waiting for I/O - SAP ASE

Symptom

  • CHKPOINT WRKR (checkpoint worker) process hanging waiting for I/O
  • No I/O activities from the sysprocesses for the CHECKPOINT

  • dbcc stacktrace on the CHECKPOINT show the following stack if the "trunc log on chkpt" is enable on the database.
    Start dbcc stacktrace...
    pc: 0x0000000001f522d7 upsleepgeneric+0x517()
    pc: 0x0000000001b2d77f cm__waitfor_io+0x53f()
    pc: 0x0000000001b2c2ac cm_writedes+0x6ec()
    pc: 0x0000000001af23cf bufwritedes+0x8f()
    [Handler pc: 0x0x0000000000c133fc des__errhdl installed by the following function:-]
    pc: 0x0000000001b4c1ac des_checkpoint+0x7ec()
    [Handler pc: 0x0x0000000000f3e651 hdl_backout_msg installed by the following function:-]
    pc: 0x00000000019065fb checkpoint+0x76b()
    [Handler pc: 0x0x0000000000b7bddf dpdb_handle installed by the following function:-]
    pc: 0x0000000001ad8293 dmpx_truncatemain+0x2b3()
    [Handler pc: 0x0x00000000009024e0 ckptproc_backout installed by the following function:-]
    pc: 0x00000000015d4c92 ckpt_process_dbs+0x422()
    pc: 0x0000000000902af1 ckptworker+0x252()
    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 (ASE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.5 ; Sybase Adaptive Server Enterprise Cluster Edition 15.7

Keywords

Sybase, ASEServer, SAPASE, dataserver, checkpoint, chkpoint, worker, wrkr, hang, block,818342,CR 818342 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.