SAP Knowledge Base Article - Preview

2075298 - Timeslice when running 'dbcc resource' - SAP ASE

Symptom

  • A spid is unexpectedly terminated
  • When running 'dbcc resource' command
  • ASE errorlog contains a timeslice message and
  • Stack containing functions which can include : prPMCTRL, prPMCTRL_list, prRESOURCE, d_resource, d_callresource or exec_dbcc

Sample messages from ASE errorlog :

kernel timeslice -#, current process infected at (_memcpy+0x74)
timeslice error: spid # exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of # ticks (# milliseconds). It has been marked for termination.

kernel  SQL causing error : dbcc resource

 

followed by a stacktrace containing functions :

prPMCTRL+0x9c
prPMCTRL_list+0xf8
prRESOURCE+0x8a0
d_resource+0x48
d_callresource+0x4
exec_dbcc+0x1ce4

(offsets will vary per platform )


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

memcpy _memcpy , 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.