SAP Knowledge Base Article - Preview

3246351 - Current process infected with signal 11 at Optimize and leave phantom locks - ASE SAP

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

SAP Adaptive Server Enterprise 16.0

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.