SAP Knowledge Base Article - Preview

3707833 - Server crash after timeslice due to dbcc proc_cache (free_unused) - SAP ASE

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

SAP Adaptive Server Enterprise 16.1

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.