Symptom
- A SQL hit signal 11 at Optimize() and leaves phantom locks.
- ASE print hundreds of MB messages when print the SQL Text in errorlog.
...
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text: har', 'nvarchar')) or t.usertype = ut.usertype)) LEFT JOIN dbo.sysobjects¿*
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
00:0112:00000:15398:2022/09/07 18:40:24.79 server SQL Text:
... - The stack includes the following:
Current process (0x54bf0713) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001877d5b (Optimize+0x504b)
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
kisignal
Optimize
OptGlobal::Destructor
Optimize
s_compile_stmt
s_compile
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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.