Symptom
- ASE errorlog shows (many) timeslices
- Due to running of command dbcc proc_cache(free_unused)
- As a result ASE server may crash
- Due to many timeslices, the log entries will not appear chronological order or in clear sequence
- Typical log entries include
-- output showing dbcc proc_cache(free_unused) was run
DBCC TRACEON 3604, SPID 1234 Procedures in cache before free unused:106776
-- timeslice in freeprocs with stack functions
timeslice -1501, current process infected at 0xd14632 (freeprocs.cold+0x1a)
d__freeprocs
d_proccache
-- spinlock being held, cause of server crash
Spinlock Resource->rprocmgr_spin at address 0x00007ec845a39580 owned by 978783887-- many other timeslices with stack functions that will include some or all of
proc__cacherm
proc__free
proc_clean
des__clean
des_objdrop
ssql__rmplans
ssql_save_SQL
sqt_put_in_stmtcache
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP04 & 16.1
Product
Keywords
proc__cacherm.cold+0x150() , proc__free+0x13() , proc_clean+0x21e() , des__clean+0x146() , des_objdrop+0x82() , ssql__rmplans+0x205() , ssql_save_SQL+0x1adc() , sqt_put_in_stmtcache+0x17d() , d__freeprocs+0x9a() , d_proccache+0x56() , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.
SAP Knowledge Base Article - Preview