SAP Knowledge Base Article - Preview

1955065 - SELECT from tempdb fails with error 12336 and stack trace signal 11 - SAP ASE

Symptom

  • A simple SELECT query fails with ASE error 12336 and terminates the session:

1> select * from tempdb..testtable
2> go
Msg 12336, Level 16, State 1:
Server 'SYBASE', Line 1:
Definition time object 'database 'tempdb' (2), object 'testtable' (484186798)' found at run time as an attempt to drop the table had failed in aprevious query.
Please drop the above mentioned table using the DROP TABLE command.
1> go
CT-LIBRARY error:
      ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read.
CT-LIBRARY error:
      ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect

0:0006:00000:00017:2012/05/24 13:59:51.24 kernel  Current process (0x37001c) infected with signal 11 (SIGSEGV)
00:0006:00000:00017:2012/05/24 13:59:51.25 kernel  Address 0x00000000805d7764 (_$o1cezaO0.ResRelOpProcess+0x2dc), siginfo (code, address) = (1, 0x0000000000000000)

  • The above error is returned only to the client session. 
  • The ASE errorlog will report a signal 11 stack trace in the code module ResRelOpProcess().
  • ASE statement cache is enabled when this problem occurs. 
    This can be checked with the command:   sp_configure "statement cache size". A non-zero run value indicates statement cache is enabled. 

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

statement cache, Error 12336, Level 16, state 1, signal 11, ResRelOpProcess, CR709370, CR#709370, 709370 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.