Symptom
- ASE infected signal 11 in the module "prSQLTEXT()" when executing 'dbcc sqltext()' in a store procedure
Current process (0x65df0cb7) infected with signal 11 (SIGSEGV)
Address 0x0x00000000013496ca (prSQLTEXT+0x808)
**** Saved signal context (0x0x000000017b56ec00): ****
...
General Registers (uc_mcontext.gregs):
PC : 0x00000000013496ca (prSQLTEXT+0x808)
RAX : 0x0000000000000001 RBX : 0x0000000001fd0cb8
RCX : 0x00000002820f0000 RDX : 0x0000000001fe406c
RBP : 0x000000017b573430 RSP : 0x000000017b56f1c0
R8 : 0x0000000000000001 R9 : 0x00000001448afb00
R10 : 0x0000000149327928 R11 : 0x00000000635d035b
R12 : 0x0000000000000182 R13 : 0x00000002820f0000
R14 : 0x00000002262c09d8 R15 : (nil)
RDI : 0x00000002262c09d8 RSI : (nil)
RIP : 0x00000000013496ca CSGSFS : 0x0000000000000033
TRAPNO : 0x000000000000000e ERR : 0x0000000000000004
EFL : 0x0000000000010282
**** end of signal context ****
kernel SQL causing error : select "sql text from dbcc sql_text"
select "------------------------------"
dbcc sqltext(SPID)
- The following stack trace is seen in ASE errorlog as well:
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
prSQLTEXT
exec_dbcc
s_execute
Read more...
Environment
- Adaptive Server Enterprise (ASE) 15.7
- Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
CR826037, CR#826037, dbcc sqltext, prSQLTEXT, signal , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.