SAP Knowledge Base Article - Preview

2542965 - Signal 8 or timeslice error in s__collectdiagparam() - SAP ASE

Symptom

  • When the same prepared statement with a parameter runs 4,294,967,295 times on a running ASE without rebooting,
  • A divide-by-zero exception occurs in the module s__collectdiagparam().
     
    • On Linux or Unix platforms, the following error with a stack trace may be reported in the ASE errorlog:

Current process (0x2e3b00e7) infected with signal 8 (SIGFPE)
Address 0x0x000000000122e54e (s__collectdiagparam+0x128), siginfo (code, address) = (1, 0x0x000000000122e54e)

    • On Windows platforms, the following error with a stack trace may be reported in the ASE errorlog:

timeslice -1001, current process infected at 0000000000F02E5A (s__collectdiagparam+ 0x15a )
...
Adaptive Server Enterprise system exception (0xe0000001) generated by a process exceeding its time slice allotment.

  • The stack trace includes functions:

s__collectdiagparam
sequencer
tdsrecv__dynexec_xoltp
tdsrecv__dynexec
tdsrecv_dynamic

  Note: Complete stack traces are available under Attachments.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

811034, CR#811034, CR811034, DBCC, reset_cached_plan_stats, DYNAMIC_PREPARE, DYNAMIC, PREPAREm kisignal, stacktrace , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.