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 stack 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.