2248928 - Stacktrace which contain a reference to the LeHashContext::HB1stOpen() routine - SAP ASE

Cached or procedural parallel queries containing 2phase hash joins may SEGV in certain timing related scenarios. Two symptomatic stacktraces could occur. In the most common case, the stack would contain a reference to the LeHashContext::HB1stOpen() routine. In other/less common cases, the SEGV could occur during the hash probe phase of processing and a call to memhilo() would typically appear on the stack.

The stacktrace will look like as described below:

00:0007:00022:00079:2014/03/05 19:49:00.94 kernel Current process (0x5d002f) infected with signal 11 (SIGSEGV)
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel Address 0x0000000101c2671c (void LeHashContext::HB1stOpen(ExeCtxt&)+0x5c), siginfo (code, address) = (1, 0x00000000000000e8)
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel **** Saved signal context (0x0000010002dc6e30): ****
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel uc_flags: 0x2f, uc_link: 0x0
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel uc_sigmask: 0xefbe7877 0xfff7 0x0 0x0
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel uc_stack: ss_sp: 0xffffffff7af00000, ss_size: 0x2080768, ss_flags: 0x0
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel General Registers (uc_mcontext.gregs):
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel PC : 0000000101c2671c (void LeHashContext::HB1stOpen(ExeCtxt&)+0x5c)
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel Next PC : 0000000101c26720 (void LeHashContext::HB1stOpen(ExeCtxt&)+0x60)
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel CCR : 0000000000000000 Y : 0000000000000000
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel ASI : 0000000000000082 FPRS : 0000000000000005
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel g0 : 0000000000000000 g1 : 0000000000000000 g2 : 0000000000102c00
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel g3 : 0000000000000000 g4 : 00000100174f27e8 g5 : 000001001950e098
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel g6 : 0000000000000000 g7 : ffffffff7ec08a40
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel o0 : 0000010013b8f000 o1 : 0000000000000000 o2 : 000000010045ad2c
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel o3 : 0000010013106c38 o4 : 0000000000000000 o5 : 0000000010000000
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel o6 : 0000010002dc6a11 o7 : 00000001004c99b8
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel Windowed Registers (from stack frame 0000010002dc7210):
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel l0 : 0000000102ed0000 l1 : 0000000000000003 l2 : 0000000000000002
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel l3 : 0000010002dc79b8 l4 : 0000010013106028 l5 : 0000000000000008
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel l6 : 00000100174f2f68 l7 : 00000100174f2f60
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel i0 : 00000100174f2998 i1 : 0000010013b8f000 i2 : 0000010013105b90
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel i3 : 000001000faf7b48 i4 : 00000100174f2f30 i5 : 00000100174f29b0
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel i6 : 0000010002dc6ac1 i7 : 0000000101c26160
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel previous stack frame : 0000010002dc72c0
00:0007:00022:00079:2014/03/05 19:49:00.94 kernel **** end of signal context ****
00:0007:00022:00079:2014/03/05 19:49:01.14 server Thread (spid=79) initiating parallel primary error processing.
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel ************************************
00:0007:00022:00079:2014/03/05 19:49:01.14 server SQL Text: [no text]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel curdb = 5 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel p3stat = 0x8800 p4stat = 0x0 p5stat = 0x80000 p6stat = 0x0 p7stat = 0x10000
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel lasterror = 0 preverror = 0 transtate = 1
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel curcmd = 193 program = qasql
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel extended error information: hostname: qpsolaris3 login: user0
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001015fe198 pcstkwalk+0x18(0x0000010002dc5a70, 0x0000010002dc38e8, 0x000000000000270f, 0x0000000000000002, 0x000000000000000c)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001015fe038 ucstkgentrace+0x2b8(0x00000000005d002f, 0x0000000000000002, 0x000000000000270f, 0x0000000000000000, 0x0000000000000000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001015fa164 ucbacktrace+0xd4(0x00000000005d002f, 0x0000000000000001, 0x0000000000000008, 0x0000000000000000, 0x000001000faf7b48)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001003c5c54 terminate_process+0x14e8(0x0000000000008c00, 0xffffffffffffffff, 0x0000000000000000, 0x000000000000d000, 0x0000000102792358)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101654780 kisignal+0x44c(0x000000000000000b, 0x0000010000000340, 0x0000010002dc6e30, 0x0000000102b4b000, 0x0000000000102b4b)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101c2671c void LeHashContext::HB1stOpen(ExeCtxt&)+0x5c(0x00000100174f2998, 0x0000010013b8f000, 0x0000010013105b90, 0x000001000faf7b48, 0x00000100174f2f30)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101c26160 void LeHashContext::Open(ExeCtxt&)+0xd0(0x0000000000000004, 0x0000010013b8f000, 0x00000100174f2818, 0x0000000000000000, 0x0000000000000001)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101c22b34 LeRetnCode LeHashOp::_LeOpOpen(ExeCtxt&)+0x11c(0x0000000000000001, 0x0000010013b8f000, 0x0000010013106028, 0x0000000004000220, 0x0000010013b8f500)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000100450c74 LeRetnCode LeOperator::LeOpOpen(ExeCtxt&)+0xd0(0x0000010013106028, 0x0000010013b8f000, 0x0000000000000001, 0x0000000000000000, 0x00000100174f2998)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x000000010046d940 LeRetnCode LeEmitXchgOp::_LeOpOpen(ExeCtxt&)+0x8(0x0000010013106c38, 0x0000010013b8f000, 0x0000000000000000, 0x0000010013b8f570, 0x0000000000000000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000100450c74 LeRetnCode LeOperator::LeOpOpen(ExeCtxt&)+0xd0(0x0000010013106c38, 0x0000010013b8f000, 0x0000000000000002, 0x0000000102de8710, 0x00000100174f2830)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x000000010044d3bc LePlanOpen+0x37c(0x0000010013b8f000, 0x000000000000d000, 0x0000010013106c38, 0x0000010013b8f058, 0x000000000000d090)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x000000010044c208 LePlanOpenAndExecute+0x1ac(0x0000010013b8f000, 0x0000000000000000, 0x000000010045ad2c, 0x0000010013106c38, 0x0000000000000000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001004c99b8 LeExecuteWorkUnits+0x154(0x0000000000000000, 0x0000000000000000, 0x0000010013b8f500, 0x0000010013b8f000, 0x0000000000000002)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x0000000100f41b90 le_execerr installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000100f41270 exec_lava+0xb90(0x000001001e4a6180, 0x000001000faf7b48, 0x0000010013b8f000, 0x0000000000000004, 0x000000000000a000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001004c4430 LavaThreadDriverMain+0x4e4(0x0000010002dc7d30, 0x000000000000cfd8, 0x000000000000d000, 0x000001000faf7b48, 0x0000000000000001)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x0000000100d9b488 so_handle installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x00000001012001ac hdl_stack installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x000000010118fa44 s_handle installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x000000010120019c hdl_backout installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel [Handler pc: 0x0000000100f204c8 debug_backout installed by the following function:-]
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x00000001004a908c LavaThreadDriver+0x164(0x0000000000000000, 0x000001000070ae20, 0x000000000000ffff, 0x00000001024be000, 0x00000000058bf000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101644754 kw_exec+0x134(0x000001001e4a6240, 0x0000010002dc7ec0, 0x0000010003b037e0, 0x000000000000ffff, 0x00000001004a8f28)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x000000010164425c kw_member+0x23c(0x0000010003b037e0, 0x0000010003b84a60, 0x0000000000000034, 0x0000000000010000, 0x000000000000ffff)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel pc: 0x0000000101633024 _coldstart(0x0000000000000000, 0x0000000101644020, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
00:0007:00022:00079:2014/03/05 19:49:01.14 kernel end of stack trace, spid 79, kpid 6094895, suid 3

• SAP Adaptive Server Enterprise (ASE) 16.0 GA PL02 for Business Suite
• SAP NetWeaver (NW) - All versions
• SAP Adaptive Server Enterprise (ASE)

parallel queries 2phase hash joins stacktrace LeHashContext::HB1stOpen() memhilo(), CR759376, CR#759376, 759376 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem