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 ONE Support launchpad (Login required).

Search for additional results

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