SAP Knowledge Base Article - Preview

2756423 - Signal 11 in cudf_start_query() causing ASE down - SAP ASE

Symptom

  • A query using the datachange() function and enabling "set plan for show_execio_xml to message on" may cause an "infected with signal 11" error in the function cudf_start_query() together with a stack trace:

Current process (0x80309f8) infected with signal 11 (SIGSEGV)
Address 0x0x0000000000dcdd94 (cudf_start_query+0x19), siginfo (code, address) = (1, 0x0x0000000000000018)

  • The stack trace shows the following functions:

cudf_start_query
exec_lava
curs_clean
curs_fetch
get_datachange

   Note: A complete stack trace is available under Attachments.

  • This error may lead to an ASE server crash.
     
  • The query looks like:

set plan for show_execio_xml to message on
go
select
 datachange(object_name(i.id),p.name,null) as DATACHANGE
from
 sysindexes i
join
 sysobjects o on o.id = i.id and o.type = 'U'
join
 syspartitions p on o.id = p.id and p.indid = i.indid
join
 systabstats t on i.id = t.id and i.indid = t.indid and t.partitionid = p.partitionid
go

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR818362, CR#818362, 818362, CR818523, CR#818523, 818523, cursor, curs_execute, s_setupcursor, XML, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, 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.