mxosrvr core generated during select count(*)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Invalid
|
High
|
Daniel Lu |
Bug Description
Encountered on cluster with 20150324_0830 build.
From client-side, trafci session:
SQL>select count(*) from nosalt1reg;
*** ERROR[1] The message id: problem_
*** ERROR[1] The message id: header_
*** ERROR[1] The message id: problem_
*** ERROR[1] The message id: header_
Stack trace from core:
Core was generated by `mxosrvr -ZKHOST rhel-qa1.
Program terminated with signal 6, Aborted.
#0 0x0000003e8d632925 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install cyrus-sasl-
(gdb) where
#0 0x0000003e8d632925 in raise () from /lib64/libc.so.6
#1 0x0000003e8d63408d in abort () from /lib64/libc.so.6
#2 0x00007f5441f6ca55 in os::abort(bool) ()
from /usr/java/
#3 0x00007f54420ecf87 in VMError:
from /usr/java/
#4 0x00007f5441f7196f in JVM_handle_
from /usr/java/
#5 <signal handler called>
#6 0x00000000004c4b88 in odbc_SQLSrvr_
call_
cursorName=
stmtType=0, sqlStmtType=1,
sqlString=
queryTimeout=0, inputRowCnt=0, txnID=0, holdableCursor=0)
at SrvrConnect.
#7 0x0000000000493aa6 in SQLEXECUTE_
call_
#8 0x0000000000493b54 in DISPATCH_
call_
at Interface/
#9 0x0000000000433872 in BUILD_TCPIP_REQUEST (pnode=0x2af42b0)
at ../Common/
#10 0x000000000043420d in PROCESS_
at ../Common/
#11 0x00000000004623f6 in CNSKListenerSrv
at Interface/
#12 0x00007f5441522290 in sb_thread_sthr_disp (pp_arg=0x2acde60)
at threadl.cpp:253
#13 0x0000003e8da079d1 in start_thread () from /lib64/
#14 0x0000003e8d6e8b5d in clone () from /lib64/libc.so.6
Arvind's initial investigation:
Seems like statement allocate failed – pSrvrStmt is null.
2015-03-25 13:44:28,728, ERROR, MXOSRVR, Node Number: 4, CPU: 4, PIN:26182, Process Name:$Z040LD2 , , ,A SQL/MX query failed. SQLCODE: SQL statement allocate failed, sqlcode = -8811, sql error = *** ERROR[8811] Trying to close a statement that is either not in the open state or has not reached EOF. [2015-03-25 13:44:28].
Error Text: <5>.
(gdb) p pSrvrStmt
$18 = (SRVR_STMT_HDL *) 0x0
(gdb)
Changed in trafodion: | |
assignee: | nobody → Daniel Lu (ping-lu) |
Changed in trafodion: | |
status: | New → In Progress |
summary: |
Not able to reproduce the issue at will or with any regularity.