SAP Knowledge Base Article - Preview

2928400 - ASE hangs after database backups fail with timeslice errors - SAP ASE 16.0

Symptom

  • On SAP ASE 16.0 SP03 PL05, PL08 and PL08 HF1, database backups and connections to the ASE Backup Server via SITE HANDLER fail due to timeslice errors.
  • These are examples of timeslice errors in the ASE errorlog:

    • timeslice -501, current process infected at 0x2179091 (pausenonatomic+0x3) 
      timeslice error: spid <n> exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1000 ticks (100000 milliseconds). It has been marked for termination.
    •  
    • timeslice -1001, current process infected at 0xcb499d (lc_findconn+0xe0)
      timeslice error: spid <n> exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1000 ticks (100000 milliseconds). It has been marked for termination.
  • SQL causing error:

    • SYB_BACKUP...sp_who
    • DUMP DATABASE 
    • DUMP TRANSACTION
       
  • These timeslice errors are accompanied by stack traces with the following sets of functions:
     
    • sb_getsite
      lc__fill

      lc_newconn
      openremote
      estremote
      execrproc
      setprocenv
      execproc
      s_execute
       
    • lc_findconn
      readremote

      rpcdata
      dpdb_poll_async_bs_rpc
      dpdb_main
      s_execute  

Note: Complete stack traces are available under Attachments.

  • ASE errorlog also reports spinlock messages:

Spinlock SITEBUF_SPIN at address 0x0000000146dcfa00 is an orphan locked spinlock. llock : 1 lowner : 0. Task 51839372 was the lastowner of this lock and timeslice of this task will be reset to release the orphan locked spinlock properly

  • Following a spate of above timeslice errors, the ASE server becomes inaccessible. It needs to be shut down and restarted.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL05 HF1
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 and SP03 PL08 HF1
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL08 and SP03 PL08 HF1 for Business Suite

Product

SAP Adaptive Server Enterprise 16.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

CR#819810, CR819810, 819810, CR#821814, CR821814, 821814, cpu, grace, timeouts, connection_hangup, stacktrace , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.