[TRAFODION-172] LP Bug: 1274296 - JDBC T2 driver generates many cores with segmentation fault when running Phoenix tests

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.7 (pre-incubation), 0.8 (pre-incubation)
• Component/s: sql-general
• External issue URL: https://bugs.launchpad.net/bugs/1274296
• Assignee: Unassigned
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:14
• Updated: 14/Aug/15 00:46
• Resolved: 14/Aug/15 00:46

Description

Using the JDBC T2 driver, phoenix tests ran into several cores. The stacks may vary, but they are mostly caused by SIGSEGV. Here is an example of the stack of such a core from the DescColumnSortOrderTest test suite. This is seen on the beta build trafodion-ci-release-trafodion_beta-20140128-v37024_release.tar.

(gdb) bt
#0 0x00000039e28328a5 in raise () from /lib64/libc.so.6
#1 0x00000039e2834085 in abort () from /lib64/libc.so.6
#2 0x00007ffff73d7455 in os::abort(bool) ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff7537717 in VMError::report_and_die() ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff73daf60 in JVM_handle_linux_signal ()
from /opt/home/tools/jdk1.7.0_09_64/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 setPrev (this=0x7fff9a7dbac0, nb=32776) at ../common/NAMemory.cpp:477
#7 unlinkLargeFragment (this=0x7fff9a7dbac0, nb=32776)
at ../common/NAMemory.cpp:1827
#8 NAHeap::tmallocLarge (this=0x7fff9a7dbac0, nb=32776)
at ../common/NAMemory.cpp:2140
#9 0x00007fffa7d5224b in NAHeap::allocateHeapMemory (this=0x7fff9a7dbac0,
userSize=32768, failureIsFatal=1) at ../common/NAMemory.cpp:3193
#10 0x00007fffa7d52544 in NAHeap::allocateBlock (this=0x7fff99150900,
size=<value optimized out>, failureIsFatal=<value optimized out>)
at ../common/NAMemory.cpp:2440
#11 0x00007fffa7d51cc6 in NAHeap::allocateHeapMemory (this=0x7fff99150900,
userSize=24, failureIsFatal=1) at ../common/NAMemory.cpp:3242
#12 0x00007fffa80c8cdb in CmpStatement::CmpStatement (this=0x7fff991631b8,
context=0x7fff99cc7090, outHeap=<value optimized out>,
memoryType=<value optimized out>) at ../arkcmp/CmpStatement.cpp:169
#13 0x00007fffa80c0180 in CmpContext::compileDirect (this=0x7fff99cc7090,
data=0x7fff9a7e6eb8 "\200", data_len=176, outHeap=0x7fff9b3d4108,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7ffff6c8f480,
gen_code_len=@0x7ffff6c8f488, parserFlags=0, diagsArea=0x7fff9a7e6f70)
at ../arkcmp/CmpContext.cpp:518
#14 0x00007fffa7108d97 in CliStatement::prepare2 (this=0x7fff9a7f31b0,
source=0x7fff9a7f3b68 "drop table DescColumnSortOrderTest cascade",
diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=15, unpackTdbs=1,
cliFlags=144) at ../cli/Statement.cpp:1783
#15 0x00007fffa7109246 in CliStatement::prepare (this=0x7fff9a7f31b0,
source=0x7fff9a7f3b68 "drop table DescColumnSortOrderTest cascade",
diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1374
#16 0x00007fffa70d50b1 in SQLCLI_Prepare (cliGlobals=0x107de20,
statement_id=0x8470e0, sql_source=0x7ffff6c8f600) at ../cli/Cli.cpp:5818
#17 0x00007fffa7113ade in SQL_EXEC_Prepare (statement_id=0x8470e0,
sql_source=0x7ffff6c8f600) at ../cli/CliExtern.cpp:4794
#18 0x00007fffa901bc50 in PREPARE (pSrvrStmt=0x846ad0)
at native/SqlInterface.cpp:1458
#19 0x00007fffa9017cac in SRVR_STMT_HDL::ExecDirect (this=0x846ad0,
inCursorName=0x0, inSqlString=<value optimized out>,
inStmtType=<value optimized out>, inSqlStmtType=0,
inHoldability=<value optimized out>, inQueryTimeout=0)
at native/CSrvrStmt.cpp:377
#20 0x00007fffa902b5df in odbc_SQLSvc_ExecDirect_sme_ (
objtag_=<value optimized out>, call_id_=<value optimized out>,
exception_=0x7ffff6c8f860, dialogueId=<value optimized out>,
stmtLabel=<value optimized out>, cursorName=0x0,
stmtExplainLabel=0x7fffa902cc9d "", stmtType=0, sqlStmtType=0,
sqlString=0x7ffff6c8f830, holdability=2, queryTimeout=0,
resultSet=140737333754376, estimatedCost=0x7ffff6c8f8b8,
outputDesc=0x7ffff6c8f880, rowsAffected=0x7ffff6c8f8b0,
sqlWarning=0x7ffff6c8f890, stmtId=0x7ffff6c8f8a8, currentStmtId=0)
at native/SrvrOthers.cpp:672
#21 0x00007fffa9027d35 in Java_com_hp_sqlmx_SQLMXStatement_executeDirect (
jenv=0x60f9d8, jobj=0x7ffff6c8fa70, server=<value optimized out>,
dialogueId=17322640, txid=0, autoCommit=1 '\001', txnMode=2,
stmtLabel=0x7ffff6c8fa38, cursorName=0x0, sql=0x7ffff6c8fa28,
isSelect=0 '\000', queryTimeout=0, holdability=2,
resultSet=0x7ffff6c8fa08, currentStmtId=0) at native/SQLMXStatement.cpp:128
#22 0x00007ffff331cf90 in ?? ()
#23 0x0000000000000002 in ?? ()
#24 0x00007ffff6c8fa38 in ?? ()
#25 0x0000000000000000 in ?? ()