2049286 - A select statement raises a signal 11 @ address (memhilo+0x12), siginfo (code, address) = (128, 0x(nil)) process terminates - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2049286 - A select statement raises a signal 11 @ address (memhilo+0x12), siginfo (code, address) = (128, 0x(nil)) process terminates - SAP ASE

Symptom

This query will fail,  stacktrace and the process will exit each time it is executed:

1> select col1
2>    ,col2
3>    ,col3
4>    ,col4
5>    ,col5
6>    ,col6
7>    ,dbo.f_udf( 'BG',col7,col8,col9) as [xxx-BG]
8>    ,dbo.f_udf( '01',col7,col8,col9) as [xxx-01]
9>    ,dbo.f_udf( '02',col7,col8,col9) as [xxx-02]
10>    ,dbo.f_udf( '03',col7,col8,col9) as [xxx-03]
11>    ,dbo.f_udf( '04',col7,col8,col9) as [xxx-04]
12>    ,dbo.f_udf( '05',col7,col8,col9) as [xxx-05]
13>    ,dbo.f_udf( '06',col7,col8,col9) as [xxx-06]
14>    ,dbo.f_udf( '07',col7,col8,col9) as [xxx-08]
15>    ,dbo.f_udf( '08',col7,col8,col9) as [xxx-08]
16>    ,dbo.f_udf( '14',col7,col8,col9) as [xxx-08] from item_table where item_id = '0123456789' and cfg_code = '40x'

>>> Client side error:

ASE is terminating this process.

>>> ASE Errorlog:

Current process (0x160016) infected with signal 11 (SIGSEGV)
Address 0x0x00000000019fe302 (memhilo+0x12), siginfo (code, address) = (128, 0x(nil))
************************************
SQL causing error : select col1, col2, col3...
curdb = 4 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x10 p7stat = 0x10000
lasterror = 0 preverror = 0 transtate = 1
curcmd = 0 program = isql
extended error information: hostname: redhead login: sa

pcstkwalk+0x30()
ucstkgentrace+0x1a5()
ucbacktrace+0x43()
terminate_process+0xd9f()
kisignal+0x356()
memhilo+0x12()
find_dup_corrname+0x1b2()
yyparse+0x181c()
00013afc90 pars_hdl installed by the following function:-]
sqlpars+0x357()
tdsrecv_language+0x70()

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.5  ESD1

Product

Sybase Adaptive Server Enterprise 15.5

Keywords

stack trace, signal 11 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.