SAP Knowledge Base Article - Preview

2574180 - Signal 11 at CgpPop::CgpInplaceUpdateVars if create table has exceed row size limit - SAP ASE

Symptom

ASE encountered signal 11 with stacktrace

00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  Current process (0xbb9005c) infected with signal 11 (SIGSEGV)
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  Current Process is running on Engine 0
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  Address 0x0x0000000002145344 (CgpPop::CgpInplaceUpdateVars(OptBlock*, OptMap<short, tree*, _STL::less<short> >*, tree*, tree*, CgpPop::ChildType)+0x5d4), siginfo (code, address) = (1, 0x0x0000000000000098)

00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  ************************************
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  SQL causing error : CREATE TABLE "wg9EdUMIcQlvTpXhSW3nzGDJRr46Y" ( "myxtpzQ7nC2" ) AS  ( SELECT DISTINCT subqry.tc_contents || NULL FROM (SELECT DWpN.* FROM transcache DW
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  ************************************

00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x0000000002145344 CgpPop::CgpInplaceUpdateVars(OptBlock*, OptMap<short, tree*, _STL::less<short> >*, tree*, tree*, CgpPop::ChildType)+0x5d4()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000018f5733 PopIndScan<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const+0x83c43()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000018f686f PopIndScan<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const+0x84d7f()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000018c2bae PopIndScan<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const+0x510be()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x000000000214b648 CgpGlobal::CgpGenerate()+0xd8()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000017956b3 Optimize+0x383()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x0000000001ec7716 s_compile_stmt+0x886()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x0000000001ec4140 s_compile+0x800()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  [Handler pc: 0x0x0000000001f3dc80 hdl_stack installed by the following function:-]
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  [Handler pc: 0x0x0000000001f03410 s_handle installed by the following function:-]
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x0000000001f0755e sequencer+0x8fe()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000016f700f tdsrecv_language+0x1df()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  [Handler pc: 0x0x000000000204fa20 ut_handle installed by the following function:-]
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x000000000170d278 conn_hdlr+0xfa8()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  pc: 0x00000000020b4ec0 kpstartproc+0x30()
00:0006:00000:00035:2017/02/06 10:55:18.61 kernel  end of stack trace, spid 35, kpid 196673628, suid 1


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR 805381, CgpPop::CgpInplaceUpdateVars, create table, exceed row size limit , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.