SAP Knowledge Base Article - Preview

3036812 - CHKPOINT WRKR blocked by user process - SAP ASE

Symptom

System Process "CHKPOINT WRKR" was blocked by user process killed after hitting in log full for a specific database. This process was involved in a multi-database transaction then other processes were afftected despite of running in different databases.

The stack trace for blocker process is:

=====

log__newpage
plcblock__flush
plc__flush
xxs__lr_getmarker
xls_getmarker
rec_undo_session
abort__all
xact__rollbackxact
xact__rollback_local
xact_rollback
kill_proc
terminate_process
quitfn
ussflush
senderror
ex_printmsg
...
pg__allocate_syslogs_extent
pg_allocate_syslogs
la_alloc_one_page
log__newpage
plcblock__flush
plc__flush
xls_bufunpin

=====

While the stack trace for "CHKPOINT WRKR":

=====

kpsuspend
upsleepgeneric
lock__semawait
lock_psema
log__lock
xxs__loglast
xls_getmarker
dmpx__dealloc_possible
dmpx__setup
dmpx_truncatemain
ckpt_process_dbs

=====


Read more...

Environment

SAP ASE 16.0 SP03 PL04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

checkpoint CHKPOINT WRKR lock__semawait lock_psema log__lock xxs__loglast xls_getmarker dmpx__dealloc_possible dmpx__setup dmpx_truncatemain ckpt_process_dbs log__newpage plcblock__flush plc__flush rec_undo_session abort__all xact__rollbackxact xact__rollback_local xact_rollback pg__allocate_syslogs_extent pg_allocate_syslogs la_alloc_one_page log__newpage log semaphore ULC PLC lock multi-database transaction , KBA , 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.