SAP Knowledge Base Article - Preview

2756423 - infected with signal 11 on function cudf_start_query causing server down - ASE

Symptom

  • Query using datachange() function and enabling "set plan for show_execio_xml to message on" may cause an infected with signal 11 on function cudf_start_query which may lead to server crash.
  • The stack will show cursor functions like curs_clean, curs_fetch and datachange() related get_datachange.
  • 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, DATACHANGE() , cursors , infected with signal 11 (SIGSEGV) , _DeleteObj,  curs_execute, s_setupcursor, set plan for show_execio_xml to message on , 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.