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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview