Symptom
- A session running the stored procedure sp_sp (which is sp_showplan with the "long" option) is terminated.
- ASE errorlog resports an "Infected with signal 11 (SIGSEGV)" error in the module prE_PARAMs_buf() with a stacktrace:
Current process (0x3f7912ab) infected with signal 11 (SIGSEGV)
Address 0x0x000000000110bbc4 (prE_PARAMs_buf+0x85), siginfo (code, address) = (1, 0x0x0000000000010000)
- Stack trace shows functions:
prE_PARAMs_buf
query_text
- In the stack trace output:
SQL causing error : sp_sp 1821
Current Procedure: sp_showplan
SQL Text: sp_sp 1821
SQL Text: select @sqltxt = query_text(@spid)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
showplan, querytext, stacktrace, CR#824422, CR824422, 824422, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, registers , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.