SAP Knowledge Base Article - Preview

2884876 - Server rebooted and performance is much slower and finally timeslices- SAP ASE

Symptom

  • Errorlog shows numerous errors over a long period of time on the same spid:
    • Currently, there are no active temporary database members for the temporary database group (groupid 6).|
    • Temporary database based on the specified soft binding could not be assigned. Assigning temporary database 'IM_tempdb01' from the 'default' group.
    • Temporary database based on the specified soft binding could not be assigned. Assigning temporary database 'IM_tempdb02' from the 'default' group.
    • Waiting for native threads to be released, or for number of threads in syb_blocking_pool to be increased. (Message repeated 56 times in the past 5 minutes).
  • Followed by a time slice:

    timeslice -1581, current process infected at ffffffff7c5cc9e0 (sema_post+0x24)

aiowait
_libaio_close
close
utGetOsStat
generateThreadRow
utpApplyAll
mda_populate_monThread
mda_exec
VTABRemoteAccess::mdaStartScan
__1cILeScanOpJ_LeOpNext6MrnHExeCtxt__nKLeRetnCode__
LeRetnCode LeOperator::LeOpNext(ExeCtxt&)
LeRetnCode LeNaryNLJOp::_LeOpNext(ExeCtxt&)
LeRetnCode LeOperator::LeOpNext
LeRetnCode LeInsertOp::_LeOpNext
LeRetnCode LeEmitNoSndOp::_LeOpNext
LePlanNext


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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.