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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.