SAP Knowledge Base Article - Preview

3291530 - "CHKPOINT WRKR" thread hang when performing "DUMP TRANSACTION" - SAP ASE

Symptom

  • Checkpoint worker processes began hanging when dumping a transaction log. This process causing blocking of other processes. 
  • The transaction log starts to filling up and the ASE needs to reboot to clear the issue.
  • sp_who show the processes in lock sleep and blocked by another checkpoint worker thread:

       0    45 lock sleep NULL    NULL        NULL                 47 db      tempdb           CHKPOINT WRKR    0 syb_default_pool
       0    46 lock sleep NULL    NULL        NULL                 47 db      tempdb           CHKPOINT WRKR    0 syb_default_pool
       0    47 sleeping   NULL    NULL        NULL                  0 db       tempdb           CHKPOINT WRKR    0 syb_default_pool
       0    48 lock sleep NULL    NULL        NULL                 47 db      tempdb           CHKPOINT WRKR    0 syb_default_pool

  • The stacks for the hanging spid includes:
    upsleepgeneric()
    cm__waitfor_io()
    cm_writedes()
    bufwritedes()
    pdes_checkpoint()
    checkpoint()
    dmpx_truncatemain()


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.x

Product

SAP Adaptive Server Enterprise 16.0

Keywords

827593 #827593 checkpoint hung MASS_DESTROY 818342 822380 ckpt_process_dbs ckptworker  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.