SAP Knowledge Base Article - Preview

2617767 - If the configuration option 'auto query tuning' has been enabled, then getting the Signal 11 on aqt_create_new function using JDBC driver.

Symptom

Stacktrace as below :

00:0003:00000:00114:2017/11/22 07:41:28.01 kernel Current process (0x630032) infected with signal 11 (SIGSEGV)
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel Current Process is running on Engine 1
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel Address 0x0x0000000000faa975 (aqt_create_new+0x8e), siginfo (code, address) = (1, 0x0x00000000000002e8)
...
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001456000 pcstkwalk+0x482()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000014559bf ucstkgentrace+0x20f()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000014522d2 ucbacktrace+0x54()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001715d16 terminate_process+0x1216()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x000000000148222a kisignal+0x5f4()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000000faa975 aqt_create_new+0x8e()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000000f7ba0b s_ap_learning_store+0x3a0()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x000000000094b7b0 PlanLearningSet::lrnAddPersistent(oheader*, int, syb_metrics*)+0x278()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001a12a49 ApPlan::ApCapture(PopBase*)+0x719()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000018a506f PopBase::_popEmitFinalize(OptGlobal*, PopBase*, PopBase*)+0xef()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x000000000195cb10 PopIndScan<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const+0xad4d0()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000017cfd33 OptGlobal::_GblAddTopLevel(bool)+0xea3()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000017d1e0d OptGlobal::GblOptimize(int*)+0x1cd()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000017d2cf4 Optimize+0x1d4()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f0eb24 s_compile_stmt+0x894()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f0b7f8 s_compile+0xa48()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel [Handler pc: 0x0x0000000001f85c30 hdl_stack installed by the following function:-]
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel [Handler pc: 0x0x0000000001f4acf0 s_handle installed by the following function:-]
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f4f8d0 sequencer+0x1370()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f362f1 execproc+0xc61()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f23e81 s_execute+0x40e1()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel [Handler pc: 0x0x0000000001f85c30 hdl_stack installed by the following function:-]
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel [Handler pc: 0x0x0000000001f4acf0 s_handle installed by the following function:-]
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x0000000001f4f248 sequencer+0xce8()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000008a4ce6 tdsrecv__dynexec+0x1a6()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x00000000017336ba tdsrecv_dynamic+0x40a()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel [Handler pc: 0x0x000000000209b030 ut_handle installed by the following function:-]
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel pc: 0x000000000174aaf9 conn_hdlr+0x16c9()
00:0003:00000:00114:2017/11/22 07:41:28.01 kernel end of stack trace, spid 114, kpid 6488114, suid 1


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP03 PL03

Product

SAP Adaptive Server Enterprise all versions

Keywords

CR#814005, CR814005, 814005 ,aqt_create_new, auto query tuning , ASE, signal 11 , 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.