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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.