Symptom
- A large select query with UNION ALL and many subquery terminated with Infected with signal 11.
- Errorlog report the following stacks which is an incorrect stack:
Current process (0xaf32c42) infected with signal 11 (SIGSEGV)
Address 0x0x000000000188de64 (Optimize+0x1b154), siginfo (code, address) = (2, 0x0x0000000003aa0290)
pc: 0x000000000188de64 Optimize+0x1b154()
pc: 0x0000000001a04e93 PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xb55b3()
pc: 0x0000000001a0d05c PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xbd77c()
pc: 0x0000000001a0b255 PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xbb975()
pc: 0x0000000001a072fe PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0xb7a1e()
pc: 0x00000000019a331e PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute()+0x53a3e()
pc: 0x0000000001fca257 CgpGlobal::CgpGenerate()+0xe7()
pc: 0x0000000001873077 Optimize+0x367()
pc: 0x0000000001da83a7 s_compile_stmt+0x787()
pc: 0x0000000001da5811 s_compile+0x8f1() - After translation using gdb on the addresses above, the correct stack is as followed:
Current process (0xaf32c42) infected with signal 11 (SIGSEGV)
Address 0x0x000000000188de64 (BmLight<VbmTcIdHidden>::BmLight), siginfo (code, address) = (2, 0x0x0000000003aa0290)
pc: 0x00000000017fe0cc terminate_process+0x1b6c()
pc: 0x0000000001305de2 kisignal+0x6fc()
pc: 0x000000000188de64 BmLight<VbmTcIdHidden>::BmLight(BmManager<BmLight<VbmTcIdHidden>, BmObject<BmLight<VbmTcIdHidden> > >*)
pc: 0x0000000001a04e93 PopBase::popGetFilterPred()
pc: 0x0000000001a0d05c PopScalar<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
pc: 0x0000000001a0b255 PopSubqNary<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
pc: 0x0000000001a072fe PopMergeUnionAll<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
pc: 0x00000000019a331e PopEmit<SerialCost, SerialProps>::popGenCgp(OptMap<short, tree*, _STL::less<short> >*) const
pc: 0x0000000001fca257 CgpGlobal::CgpGenerate()+0xe7()
pc: 0x0000000001873077 Optimize+0x367()
pc: 0x0000000001da83a7 s_compile_stmt+0x787()
pc: 0x0000000001da5811 s_compile+0x8f1()
Read more...
Environment
SAP Adaptive Server Entreprise ASE 16 SP02 PL08
Product
Keywords
BmLight,PopBase::popGetFilterPred,Optimize,PopRidJoin<ParallelCost, ParallelProps>::_popAvailPartCompute , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.