You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:08 UTC
[jira] [Created] (TRAFODION-778) LP Bug: 1394649 - Mxosrvr cores at
Generator::createVirtualTableDesc()
Alice Chen created TRAFODION-778:
------------------------------------
Summary: LP Bug: 1394649 - Mxosrvr cores at Generator::createVirtualTableDesc()
Key: TRAFODION-778
URL: https://issues.apache.org/jira/browse/TRAFODION-778
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Weishiun Tsai
Assignee: Anoop Sharma
Priority: Critical
When populating QA global tables on a 4-node cluster, it encountered this core once. At this moment, it’s not clear if this is just a one-time occurrence or if it is a more a widespread problem. This bug report is filed as High for now to document this particular core and its stack trace. The severity of the bug report can be adjusted in the future accordingly.
The problem was triggered by a simple ‘select [first 1] * from trafodion.g_tpcds1x.customer’ statement. However, the statement wasn’t the real cause, as rerunning the same scripts passed on the second time. The stack trace is a long one. The original select statement on a user table eventually led to a select statement on histograms tables internally, which then led to another select statement on the metadata table "_MD_".OBJECTS internally. That’s when Generator::createVirtualTableDesc() cored.
This is seen on the v1119_0830 build installed on a 4-node cluster.
Here is the stack trace of the core:
#0 0x00007ffff527f8a5 in raise () from /lib64/libc.so.6
#1 0x00007ffff528100d in abort () from /lib64/libc.so.6
#2 0x00007ffff6388a55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff6508f87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff638d96f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007ffff537fd5f in __strlen_sse42 () from /lib64/libc.so.6
#7 0x00007fffee225173 in Generator::createVirtualTableDesc (
inTableName=<value optimized out>, numCols=<value optimized out>,
columnInfo=0x7fffcee71a38, numKeys=-823510152,
keyInfo=<value optimized out>, numConstrs=0, constrInfo=0x0, numIndexes=1,
indexInfo=0x7fffcee734a8, numViews=0, viewInfo=0x0, tableInfo=0x0,
seqInfo=0x0) at ../generator/Generator.cpp:1322
#8 0x00007ffff01f90ed in CmpSeabaseDDL::getSeabaseMDTableDesc (
this=<value optimized out>, catName=..., schName=<value optimized out>,
objName=..., objType=0x7fffeeea9d9d "BT")
at ../sqlcomp/CmpSeabaseDDLtable.cpp:5586
#9 0x00007ffff02009be in CmpSeabaseDDL::getSeabaseTableDesc (
this=0x7fffe4a4d020, catName=..., schName=..., objName=...,
objType=0x7fffeeea9d9d "BT", includeInvalidDefs=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:6644
#10 0x00007fffeeba0eb8 in NATableDB::get (this=0x7fffd04dc930, corrName=...,
bindWA=0x7fffe4a4f7e0, inTableDescStruct=0x0)
at ../optimizer/NATable.cpp:7622
#11 0x00007fffee91145a in BindWA::getNATable (this=0x7fffe4a4f7e0,
corrName=..., catmanCollectTableUsages=1, inTableDescStruct=0x0)
at ../optimizer/BindRelExpr.cpp:1446
#12 0x00007fffee92eb8e in Scan::bindNode (this=0x7fffcee83dd8,
bindWA=0x7fffe4a4f7e0) at ../optimizer/BindRelExpr.cpp:7277
#13 0x00007fffee901057 in RelExpr::bindChildren (this=0x7fffcee88db8,
bindWA=0x7fffe4a4f7e0) at ../optimizer/BindRelExpr.cpp:2181
#14 0x00007fffee93bb5e in RelRoot::bindNode (this=0x7fffcee88db8,
bindWA=0x7fffe4a4f7e0) at ../optimizer/BindRelExpr.cpp:5215
#15 0x00007ffff01b3493 in CmpMain::compile (this=0x7fffe4a51b70,
input_str=0x7fffceeac208 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCDS1X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffe4a51aa8, gen_code=0x7fffcee827e0,
gen_code_len=0x7fffcee827d8, heap=0x7fffe358eec0, phase=CmpMain::END,
fragmentDir=0x7fffe4a51cc8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe4a51ab8, begTime=0x7fffe4a51a90, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2027
#16 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe4a51b70,
input_str=0x7fffceeac208 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCDS1X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffe4a51aa8, gen_code=0x7fffcee827e0,
gen_code_len=0x7fffcee827d8, heap=0x7fffe358eec0, phase=CmpMain::END,
fragmentDir=0x7fffe4a51cc8, op=3004, useQueryCache=1,
cacheable=0x7fffe4a51ab8, begTime=0x7fffe4a51a90, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#17 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe4a51b70, input=...,
gen_code=0x7fffcee827e0, gen_code_len=0x7fffcee827d8, heap=0x7fffe358eec0,
phase=CmpMain::END, fragmentDir=0x7fffe4a51cc8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#18 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffcee79fd8,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#19 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffd04d70a0,
data=0x7fffe358fc18 "\200", data_len=296, outHeap=0x7fffe3ffa0f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe4a52250,
gen_code_len=@0x7fffe4a52258, parserFlags=4325376, diagsArea=
0x7fffe358fd48) at ../arkcmp/CmpContext.cpp:687
#20 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffe35924c0,
source=0x7fffd1ccd7c0 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCDS1X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", diagsArea=...,
passed_gen_code=<value optimized out>, passed_gen_code_len=3825180912,
charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1799
#21 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffe35924c0,
source=0x7fffd1ccd7c0 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCDS1X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", 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:1390
#22 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf43ab0,
statement_id=0x7fffd062bce0, sql_source=0x7fffcf699d58, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffe4a53620,
query_comp_stats_info=0x7fffe4a52520, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x0, flags=0) at ../cli/Cli.cpp:5908
#23 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0x7fffd062bce0,
sql_source=0x7fffcf699d58, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7fffe4a53620,
comp_stats_info=0x7fffe4a52520, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
flags=0) at ../cli/CliExtern.cpp:4955
#24 0x00007ffff371100b in ExeCliInterface::prepare (this=0x7fffe4a53f70,
stmtStr=<value optimized out>, module=<value optimized out>,
stmt=0x7fffd062bce0, sql_src=0x7fffcf699d58, input_desc=0x7fffd060f770,
output_desc=0x7fffd060ef20, outputBuf=0x7fffe4a53fa8, outputVarPtrList=
0x0, inputBuf=0x7fffe4a53fe0, inputVarPtrList=0x0, uniqueStmtId=0x0,
uniqueStmtIdLen=0x0, query_cost_info=0x0, comp_stats_info=0x0,
monitorThis=0) at ../executor/ExExeUtilCli.cpp:321
#25 0x00007ffff3712a0a in ExeCliInterface::fetchRowsPrologue (
this=0x7fffe4a53f70,
sqlStrBuf=0x7fffe4a537a0 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCDS1X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", noExec=1, monitorThis=0,
stmtName=0x0) at ../executor/ExExeUtilCli.cpp:1031
#26 0x00007fffeeb7d299 in lookupObjectUid (qualName=<value optimized out>,
objectType=<value optimized out>) at ../optimizer/NATable.cpp:6389
#27 0x00007fffeeb82046 in NATable::lookupObjectUid (this=0x7fffd06d90c0)
at ../optimizer/NATable.cpp:6435
#28 0x00007fffee2f37bb in objectUid (this=0x7fffe4a54d60,
generator=0x7fffe4a56630) at ../optimizer/NATable.h:509
#29 HbaseAccess::codeGen (this=0x7fffe4a54d60, generator=0x7fffe4a56630)
at ../generator/GenRelScan.cpp:2509
#30 0x00007fffee2db475 in RelRoot::codeGen (this=0x7fffd0608ec8,
generator=0x7fffe4a56630) at ../generator/GenRelMisc.cpp:1379
#31 0x00007fffee22604e in Generator::genCode (this=0x7fffe4a56630,
source=0x7fffd06f6710 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
expr_node=0x7fffd0608ec8) at ../generator/Generator.cpp:529
#32 0x00007ffff01b42ea in CmpMain::compile (this=0x7fffe4a596a0,
input_str=0x7fffd06f6710 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
charset=15, queryExpr=@0x7fffe4a595d8, gen_code=0x7fffd0a59db8,
gen_code_len=0x7fffd0a59db0, heap=0x7fffe35ed1c0, phase=CmpMain::END,
fragmentDir=0x7fffe4a597f8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe4a595e8, begTime=0x7fffe4a595c0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2293
#33 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe4a596a0,
input_str=0x7fffd06f6710 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
charset=15, queryExpr=@0x7fffe4a595d8, gen_code=0x7fffd0a59db8,
gen_code_len=0x7fffd0a59db0, heap=0x7fffe35ed1c0, phase=CmpMain::END,
fragmentDir=0x7fffe4a597f8, op=3004, useQueryCache=1,
cacheable=0x7fffe4a595e8, begTime=0x7fffe4a595c0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#34 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe4a596a0, input=...,
gen_code=0x7fffd0a59db8, gen_code_len=0x7fffd0a59db0, heap=0x7fffe35ed1c0,
phase=CmpMain::END, fragmentDir=0x7fffe4a597f8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#35 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffd0a0afd0,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#36 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffd0d60090,
data=0x7fffe358cb10 "\200", data_len=536, outHeap=0x7fffe3ffa0f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe4a59d80,
gen_code_len=@0x7fffe4a59d88, parserFlags=4194304,
diagsArea=0x7fffe358cd30) at ../arkcmp/CmpContext.cpp:687
#37 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffe35e3e68,
source=0x7fffe358e6a0 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=3825180912, charset=15, unpackTdbs=1, cliFlags=144)
at ../cli/Statement.cpp:1799
#38 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffe35e3e68,
source=0x7fffe358e6a0 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
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:1390
#39 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf43ab0,
statement_id=0x7fffcea00e18, sql_source=0x7fffcea00e50, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffe4a5b110,
query_comp_stats_info=0x7fffe4a5a010, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x0, flags=0) at ../cli/Cli.cpp:5908
#40 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0x7fffcea00e18,
sql_source=0x7fffcea00e50, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7fffe4a5b110,
comp_stats_info=0x7fffe4a5a010, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
flags=0) at ../cli/CliExtern.cpp:4955
#41 0x00007fffefc5de20 in HSCursor::prepareQuery (this=0x43424d0,
cliStr=0x4342738 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
numParams=<value optimized out>, numResults=<value optimized out>)
at ../ustat/hs_cli.cpp:6263
#42 0x00007fffefcf7a8f in HSHistogrmCursor::open (this=0x7fffe4a5b310)
at ../ustat/hs_read.cpp:1944
#43 0x00007fffefcf9dd7 in readHistograms (tabDef=0x7fffce9f9b10,
fullQualName=..., histogramTableName=..., histintsTableName=...,
specialTable=<value optimized out>, type=<value optimized out>, colArray=
..., statsTime=@0x7fffce98a540, allFakeStat=@0x7fffe4a5c5dc, preFetch=1,
fakeHistogram=0x7fffce9f8940, emptyHistogram=0x7fffce9f8998,
smallSampleHistogram=0x7fffce9f89f0, smallSampleSize=0x7fffcea00d20,
colmap=0x7fffcea00dc0, histogramRowCount=@0x7fffe4a5c478,
cs=0x7fffe4a5bca0, offset=0) at ../ustat/hs_read.cpp:1377
#44 0x00007fffefcfa92f in FetchHistograms (
qualifiedName=<value optimized out>, type=ExtendedQualName::NORMAL_TABLE,
colArray=..., colStatsList=..., isSQLMPTable=0, heap=0x7fffcea00dc0,
histModTime=@0x7fffe4a5c5d0, statsTime=@0x7fffce98a540,
allFakeStat=@0x7fffe4a5c5dc, preFetch=1, createStatsSize=0)
at ../ustat/hs_read.cpp:1042
#45 0x00007fffeeb8f084 in HistogramCache::createColStatsList (
this=0x7fffe2a1f978, table=..., cachedHistograms=0x0)
at ../optimizer/NATable.cpp:587
#46 0x00007fffeeb8f495 in HistogramCache::getHistograms (this=0x7fffe2a1f978,
table=...) at ../optimizer/NATable.cpp:418
#47 0x00007fffeeb8f98e in NATable::getStatistics (this=0x7fffce98a140)
at ../optimizer/NATable.cpp:5537
#48 0x00007fffeee3274e in TableDesc::getTableColStats (this=0x7fffce99b1a0)
at ../optimizer/TableDesc.cpp:382
#49 0x00007fffeec4a2e7 in tableColStats (this=0x7fffd1f85418,
normWAPtr=0x7fffe4a5f5f0) at ../optimizer/TableDesc.h:130
#50 Scan::synthLogProp (this=0x7fffd1f85418, normWAPtr=0x7fffe4a5f5f0)
at ../optimizer/OptLogRelExpr.cpp:5059
#51 0x00007fffeec45454 in RelExpr::synthLogProp (this=0x7fffce9e2878,
normWAPtr=0x7fffe4a5f5f0) at ../optimizer/OptLogRelExpr.cpp:618
#52 0x00007fffeec45454 in RelExpr::synthLogProp (this=0x7fffd1f85ed0,
normWAPtr=0x7fffe4a5f5f0) at ../optimizer/OptLogRelExpr.cpp:618
#53 0x00007fffeec45e3d in RelRoot::synthLogProp (this=0x7fffd1f85ed0,
normWAPtr=<value optimized out>) at ../optimizer/OptLogRelExpr.cpp:4640
#54 0x00007fffeebdb0db in RelRoot::normalizeNode (this=0x7fffd1f85ed0,
normWARef=...) at ../optimizer/NormRelExpr.cpp:7141
#55 0x00007ffff01b37ad in CmpMain::compile (this=0x7fffe4a60980,
input_str=0x7fffcfde4058 "select [first 1] * from trafodion.g_tpcds1x.customer", charset=15, queryExpr=@0x7fffe4a608b8, gen_code=0x7fffcee478a0,
gen_code_len=0x7fffcee47898, heap=0x7fffe3588be8, phase=CmpMain::END,
fragmentDir=0x7fffe4a60ad8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe4a608c8, begTime=0x7fffe4a608a0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2137
#56 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe4a60980,
input_str=0x7fffcfde4058 "select [first 1] * from trafodion.g_tpcds1x.customer", charset=15, queryExpr=@0x7fffe4a608b8, gen_code=0x7fffcee478a0,
gen_code_len=0x7fffcee47898, heap=0x7fffe3588be8, phase=CmpMain::END,
fragmentDir=0x7fffe4a60ad8, op=3004, useQueryCache=1,
cacheable=0x7fffe4a608c8, begTime=0x7fffe4a608a0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#57 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe4a60980, input=...,
gen_code=0x7fffcee478a0, gen_code_len=0x7fffcee47898, heap=0x7fffe3588be8,
phase=CmpMain::END, fragmentDir=0x7fffe4a60ad8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#58 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffd1f83fd0,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#59 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffe29f1090,
data=0x7fffe35dff88 "\200", data_len=184, outHeap=0x7fffe3ffa0f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe4a61060,
gen_code_len=@0x7fffe4a61068, parserFlags=4194304,
diagsArea=0x7fffe35e0048) at ../arkcmp/CmpContext.cpp:687
#60 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffd0994c98,
source=0x7fffd1cb0d80 "select [first 1] * from trafodion.g_tpcds1x.customer", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=3825180912, charset=15, unpackTdbs=1, cliFlags=129)
at ../cli/Statement.cpp:1799
#61 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffd0994c98,
source=0x7fffd1cb0d80 "select [first 1] * from trafodion.g_tpcds1x.customer", diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
unpackTdbs=1, cliFlags=129) at ../cli/Statement.cpp:1390
#62 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf43ab0,
statement_id=0x322c188, sql_source=0x7fffe4a613a0, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x322c3b8,
query_comp_stats_info=0x322c408, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x322c2ec, flags=1) at ../cli/Cli.cpp:5908
#63 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0x322c188,
sql_source=0x7fffe4a613a0, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x322c3b8, comp_stats_info=0x322c408,
uniqueStmtId=0x322c2f0 "", uniqueStmtIdLen=0x322c2ec, flags=1)
at ../cli/CliExtern.cpp:4955
#64 0x00007ffff6e7a8e9 in SRVR::WSQL_EXEC_Prepare2 (statement_id=0x322c188,
sql_source=<value optimized out>, gencode_ptr=<value optimized out>,
gencode_len=<value optimized out>, ret_gencode_len=<value optimized out>,
query_cost_info=<value optimized out>, comp_stats_info=0x322c408,
uniqueQueryId=0x322c2f0 "", uniqueQueryIdLen=0x322c2ec, flags=1)
at SQLWrapper.cpp:800
#65 0x00007ffff6e6f285 in SRVR::PREPARE2 (pSrvrStmt=0x322bb70,
isFromExecDirect=184) at sqlinterface.cpp:5016
#66 0x00007ffff6e9f6f0 in odbc_SQLSvc_Prepare2_sme_ (inputRowCnt=0,
sqlStmtType=1, stmtLabel=<value optimized out>,
sqlString=0x4e21cd4 "select [first 1] * from trafodion.g_tpcds1x.customer", holdableCursor=0, returnCode=0x7fffe4a618a8,
sqlWarningOrErrorLength=0x7fffe4a618a4, sqlWarningOrError=@0x7fffe4a61880,
sqlQueryType=0x7fffe4a6189c, stmtHandle=0x7fffe4a61860,
estimatedCost=0x7fffe4a61898, inputDescLength=0x7fffe4a61890,
inputDesc=@0x7fffe4a61870, outputDescLength=0x7fffe4a6188c,
outputDesc=@0x7fffe4a61868, isFromExecDirect=true) at srvrothers.cpp:926
#67 0x00000000004d20f9 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0x4df62a0,
call_id_=0x4df62f8, dialogueId=172476172, stmtLabel=0x4e21d15 "SQL_CUR_1",
cursorName=0x0, stmtExplainLabel=<value optimized out>, stmtType=0,
sqlStmtType=1,
sqlString=0x4e21cd4 "select [first 1] * from trafodion.g_tpcds1x.customer", sqlAsyncEnable=0, queryTimeout=0, inputRowCnt=0, txnID=0, holdableCursor=0)
at SrvrConnect.cpp:6991
#68 0x00000000004a1a36 in SQLEXECUTE_IOMessage (objtag_=0x4df62a0,
call_id_=0x4df62f8, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#69 0x00000000004a1ae4 in DISPATCH_TCPIPRequest (objtag_=0x4df62a0,
call_id_=0x4df62f8, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#70 0x0000000000432a02 in BUILD_TCPIP_REQUEST (pnode=0x4df62a0)
at ../Common/TCPIPSystemSrvr.cpp:603
#71 0x000000000043339d in PROCESS_TCPIP_REQUEST (pnode=0x4df62a0)
at ../Common/TCPIPSystemSrvr.cpp:581
#72 0x0000000000470ad6 in CNSKListenerSrvr::tcpip_listener (arg=0xde5450)
at Interface/linux/Listener_srvr_ps.cpp:397
#73 0x00007ffff50329f0 in sb_thread_sthr_disp (pp_arg=0xf114d0)
at threadl.cpp:253
#74 0x00007ffff4bf9851 in start_thread () from /lib64/libpthread.so.0
#75 0x00007ffff533590d in clone () from /lib64/libc.so.6
-----------------------------------------------------------------
Here is another core showing the same stack. The statement was "upsert using load into lineitem select * from trafodion.g_tpch2x.lineitem where l_orderkey <= 6001215"
#0 0x00007ffff527f8a5 in raise () from /lib64/libc.so.6
#1 0x00007ffff528100d in abort () from /lib64/libc.so.6
#2 0x00007ffff6388a55 in os::abort(bool) ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#3 0x00007ffff6508f87 in VMError::report_and_die() ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#4 0x00007ffff638d96f in JVM_handle_linux_signal ()
from /usr/java/jdk1.7.0_67/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00007ffff537fd5f in __strlen_sse42 () from /lib64/libc.so.6
#7 0x00007fffee225173 in Generator::createVirtualTableDesc (
inTableName=<value optimized out>, numCols=<value optimized out>,
columnInfo=0x7fffc87c38d0, numKeys=-931343568,
keyInfo=<value optimized out>, numConstrs=0, constrInfo=0x0, numIndexes=1,
indexInfo=0x7fffc87c5340, numViews=0, viewInfo=0x0, tableInfo=0x0,
seqInfo=0x0) at ../generator/Generator.cpp:1322
#8 0x00007ffff01f90ed in CmpSeabaseDDL::getSeabaseMDTableDesc (
this=<value optimized out>, catName=..., schName=<value optimized out>,
objName=..., objType=0x7fffeeea9d9d "BT")
at ../sqlcomp/CmpSeabaseDDLtable.cpp:5586
#9 0x00007ffff02009be in CmpSeabaseDDL::getSeabaseTableDesc (
this=0x7fffe462f8d0, catName=..., schName=..., objName=...,
objType=0x7fffeeea9d9d "BT", includeInvalidDefs=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:6644
#10 0x00007fffeeba0eb8 in NATableDB::get (this=0x7fffd10f9978, corrName=...,
bindWA=0x7fffe4632090, inTableDescStruct=0x0)
at ../optimizer/NATable.cpp:7622
#11 0x00007fffee91145a in BindWA::getNATable (this=0x7fffe4632090,
corrName=..., catmanCollectTableUsages=1, inTableDescStruct=0x0)
at ../optimizer/BindRelExpr.cpp:1446
#12 0x00007fffee92eb8e in Scan::bindNode (this=0x7fffc87d6a98,
bindWA=0x7fffe4632090) at ../optimizer/BindRelExpr.cpp:7277
#13 0x00007fffee901057 in RelExpr::bindChildren (this=0x7fffc87dbae0,
bindWA=0x7fffe4632090) at ../optimizer/BindRelExpr.cpp:2181
#14 0x00007fffee93bb5e in RelRoot::bindNode (this=0x7fffc87dbae0,
bindWA=0x7fffe4632090) at ../optimizer/BindRelExpr.cpp:5215
#15 0x00007ffff01b3493 in CmpMain::compile (this=0x7fffe4634420,
input_str=0x7fffc87f5378 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'VOLATILE_SCHEMA_MXID110000234042122832013723294670000000002' and object_n"...,
charset=15, queryExpr=@0x7fffe4634358, gen_code=0x7fffc87d47b8,
gen_code_len=0x7fffc87d47b0, heap=0x7fffc870ba50, phase=CmpMain::END,
fragmentDir=0x7fffe4634578, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe4634368, begTime=0x7fffe4634340, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2027
#16 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe4634420,
input_str=0x7fffc87f5378 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'VOLATILE_SCHEMA_MXID110000234042122832013723294670000000002' and object_n"...,
charset=15, queryExpr=@0x7fffe4634358, gen_code=0x7fffc87d47b8,
gen_code_len=0x7fffc87d47b0, heap=0x7fffc870ba50, phase=CmpMain::END,
fragmentDir=0x7fffe4634578, op=3004, useQueryCache=1,
cacheable=0x7fffe4634368, begTime=0x7fffe4634340, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#17 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe4634420, input=...,
gen_code=0x7fffc87d47b8, gen_code_len=0x7fffc87d47b0, heap=0x7fffc870ba50,
phase=CmpMain::END, fragmentDir=0x7fffe4634578, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#18 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffc87cbf98,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#19 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffd10f40e8,
data=0x7fffcb23f378 "\200", data_len=376, outHeap=0x7fffe3be60f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe4634b00,
gen_code_len=@0x7fffe4634b08, parserFlags=4358144, diagsArea=
0x7fffcb23f4f8) at ../arkcmp/CmpContext.cpp:687
#20 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffc870d118,
source=0x7fffcf3e5fe0 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'VOLATILE_SCHEMA_MXID110000234042122832013723294670000000002' and object_n"...,
diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=3820904688, charset=15, unpackTdbs=1, cliFlags=144)
at ../cli/Statement.cpp:1799
#21 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffc870d118,
source=0x7fffcf3e5fe0 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'VOLATILE_SCHEMA_MXID110000234042122832013723294670000000002' and object_n"...,
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:1390
#22 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf40b30,
statement_id=0xac54650, sql_source=0xaee0480, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffe4635ed0,
query_comp_stats_info=0x7fffe4634dd0, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x0, flags=0) at ../cli/Cli.cpp:5908
#23 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0xac54650,
sql_source=0xaee0480, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
query_cost_info=0x7fffe4635ed0, comp_stats_info=0x7fffe4634dd0,
uniqueStmtId=0x0, uniqueStmtIdLen=0x0, flags=0)
at ../cli/CliExtern.cpp:4955
#24 0x00007ffff371100b in ExeCliInterface::prepare (this=0x7fffe4638930,
stmtStr=<value optimized out>, module=<value optimized out>,
stmt=0xac54650, sql_src=0xaee0480, input_desc=0xa6d47a0,
output_desc=0xaf70f70, outputBuf=0x7fffe4638968, outputVarPtrList=0x0,
inputBuf=0x7fffe46389a0, inputVarPtrList=0x0, uniqueStmtId=0x0,
uniqueStmtIdLen=0x0, query_cost_info=0x0, comp_stats_info=0x0,
monitorThis=0) at ../executor/ExExeUtilCli.cpp:321
#25 0x00007ffff3712a0a in ExeCliInterface::fetchRowsPrologue (
this=0x7fffe4638930,
sqlStrBuf=0x7fffe4636070 "select object_uid, object_type, object_owner from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'VOLATILE_SCHEMA_MXID110000234042122832013723294670000000002' and object_n"...,
noExec=1, monitorThis=0, stmtName=0x0) at ../executor/ExExeUtilCli.cpp:1031
#26 0x00007ffff01bb492 in CmpSeabaseDDL::getObjectUIDandOwner (
this=0x7fffe4638f10, cliInterface=0x7fffe4638930,
catName=0x7fffe4639618 "TRAFODION", schName=<value optimized out>,
objName=0x7fffe4639688 "OBJECTS", inObjType=<value optimized out>,
outObjType=0x0, objectOwner=0x7fffe4638d8c, reportErrorNow=0)
at ../sqlcomp/CmpSeabaseDDLcommon.cpp:2537
#27 0x00007ffff01fc86d in CmpSeabaseDDL::getSeabaseUserTableDesc (
this=0x7fffe4638f10, catName=..., schName=..., objName=...,
objType=0x7fffeeea9d9d "BT", includeInvalidDefs=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:5952
#28 0x00007ffff0201266 in CmpSeabaseDDL::getSeabaseTableDesc (
this=0x7fffe4638f10, catName=..., schName=..., objName=...,
objType=<value optimized out>, includeInvalidDefs=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:6698
#29 0x00007fffeeba1295 in NATableDB::get (this=0x7fffcefe2928, corrName=...,
bindWA=0x7fffe463b6d0, inTableDescStruct=0x0)
at ../optimizer/NATable.cpp:7662
#30 0x00007fffee9119f0 in BindWA::getNATable (this=0x7fffe463b6d0,
corrName=..., catmanCollectTableUsages=1, inTableDescStruct=0x0)
at ../optimizer/BindRelExpr.cpp:1336
#31 0x00007fffee92eb8e in Scan::bindNode (this=0x7fffd13b5e00,
bindWA=0x7fffe463b6d0) at ../optimizer/BindRelExpr.cpp:7277
#32 0x00007fffee901057 in RelExpr::bindChildren (this=0x7fffd13bade8,
bindWA=0x7fffe463b6d0) at ../optimizer/BindRelExpr.cpp:2181
#33 0x00007fffee93bb5e in RelRoot::bindNode (this=0x7fffd13bade8,
bindWA=0x7fffe463b6d0) at ../optimizer/BindRelExpr.cpp:5215
#34 0x00007ffff01b3493 in CmpMain::compile (this=0x7fffe463da60,
input_str=0x7fffd13d2110 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCH2X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffe463d998, gen_code=0x7fffd13cc480,
gen_code_len=0x7fffd13cc478, heap=0x7fffe31d3cc0, phase=CmpMain::END,
fragmentDir=0x7fffe463dbb8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe463d9a8, begTime=0x7fffe463d980, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2027
#35 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe463da60,
input_str=0x7fffd13d2110 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCH2X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", charset=15,
queryExpr=@0x7fffe463d998, gen_code=0x7fffd13cc480,
gen_code_len=0x7fffd13cc478, heap=0x7fffe31d3cc0, phase=CmpMain::END,
fragmentDir=0x7fffe463dbb8, op=3004, useQueryCache=1,
cacheable=0x7fffe463d9a8, begTime=0x7fffe463d980, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#36 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe463da60, input=...,
gen_code=0x7fffd13cc480, gen_code_len=0x7fffd13cc478, heap=0x7fffe31d3cc0,
phase=CmpMain::END, fragmentDir=0x7fffe463dbb8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#37 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffd13a3fd8,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#38 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffcefdd098,
data=0x7fffc8707bf8 "\200", data_len=296, outHeap=0x7fffe3be60f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe463e140,
gen_code_len=@0x7fffe463e148, parserFlags=4358144,
diagsArea=0x7fffc8707d28) at ../arkcmp/CmpContext.cpp:687
#39 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffc870c3c0,
source=0x7fffc98a40a0 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCH2X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", diagsArea=...,
passed_gen_code=<value optimized out>, passed_gen_code_len=3820904688,
charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1799
#40 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffc870c3c0,
source=0x7fffc98a40a0 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCH2X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", 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:1390
#41 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf40b30,
statement_id=0x7fffc8c4dc18, sql_source=0x7fffc8c50380, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffe463f510,
query_comp_stats_info=0x7fffe463e410, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x0, flags=0) at ../cli/Cli.cpp:5908
#42 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0x7fffc8c4dc18,
sql_source=0x7fffc8c50380, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7fffe463f510,
comp_stats_info=0x7fffe463e410, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
flags=0) at ../cli/CliExtern.cpp:4955
#43 0x00007ffff371100b in ExeCliInterface::prepare (this=0x7fffe463fe60,
stmtStr=<value optimized out>, module=<value optimized out>,
stmt=0x7fffc8c4dc18, sql_src=0x7fffc8c50380, input_desc=0x7fffc8c43288,
output_desc=0x7fffc8c432c0, outputBuf=0x7fffe463fe98,
outputVarPtrList=0x0, inputBuf=0x7fffe463fed0, inputVarPtrList=0x0,
uniqueStmtId=0x0, uniqueStmtIdLen=0x0, query_cost_info=0x0,
comp_stats_info=0x0, monitorThis=0) at ../executor/ExExeUtilCli.cpp:321
#44 0x00007ffff3712a0a in ExeCliInterface::fetchRowsPrologue (
this=0x7fffe463fe60,
sqlStrBuf=0x7fffe463f690 "select object_uid from TRAFODION.\"_MD_\".OBJECTS where catalog_name = 'TRAFODION' and schema_name = 'G_TPCH2X' and object_name = 'SB_HISTOGRAMS' and object_type = 'BT'", noExec=1, monitorThis=0, stmtName=0x0)
at ../executor/ExExeUtilCli.cpp:1031
#45 0x00007fffeeb7d299 in lookupObjectUid (qualName=<value optimized out>,
objectType=<value optimized out>) at ../optimizer/NATable.cpp:6389
#46 0x00007fffeeb82046 in NATable::lookupObjectUid (this=0x7fffcffd4610)
at ../optimizer/NATable.cpp:6435
#47 0x00007fffee2f37bb in objectUid (this=0x7fffe4640c50,
generator=0x7fffe4642520) at ../optimizer/NATable.h:509
#48 HbaseAccess::codeGen (this=0x7fffe4640c50, generator=0x7fffe4642520)
at ../generator/GenRelScan.cpp:2509
#49 0x00007fffee2db475 in RelRoot::codeGen (this=0x7fffc8c19db0,
generator=0x7fffe4642520) at ../generator/GenRelMisc.cpp:1379
#50 0x00007fffee22604e in Generator::genCode (this=0x7fffe4642520,
source=0x7fffcfd3c9c8 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
expr_node=0x7fffc8c19db0) at ../generator/Generator.cpp:529
#51 0x00007ffff01b42ea in CmpMain::compile (this=0x7fffe4645590,
input_str=0x7fffcfd3c9c8 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
charset=15, queryExpr=@0x7fffe46454c8, gen_code=0x7fffcfc06c60,
gen_code_len=0x7fffcfc06c58, heap=0x7fffe3184d78, phase=CmpMain::END,
fragmentDir=0x7fffe46456e8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe46454d8, begTime=0x7fffe46454b0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2293
#52 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe4645590,
input_str=0x7fffcfd3c9c8 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
charset=15, queryExpr=@0x7fffe46454c8, gen_code=0x7fffcfc06c60,
gen_code_len=0x7fffcfc06c58, heap=0x7fffe3184d78, phase=CmpMain::END,
fragmentDir=0x7fffe46456e8, op=3004, useQueryCache=1,
cacheable=0x7fffe46454d8, begTime=0x7fffe46454b0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#53 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe4645590, input=...,
gen_code=0x7fffcfc06c60, gen_code_len=0x7fffcfc06c58, heap=0x7fffe3184d78,
phase=CmpMain::END, fragmentDir=0x7fffe46456e8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#54 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffcfd138d8,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#55 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffd05f0090,
data=0x7fffd0e35250 "\200", data_len=536, outHeap=0x7fffe3be60f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe4645c70,
gen_code_len=@0x7fffe4645c78, parserFlags=4227072,
diagsArea=0x7fffd0e35470) at ../arkcmp/CmpContext.cpp:687
#56 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffcf3e0dc0,
source=0x7fffd0e5f2c8 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
diagsArea=..., passed_gen_code=<value optimized out>,
passed_gen_code_len=3820904688, charset=15, unpackTdbs=1, cliFlags=144)
at ../cli/Statement.cpp:1799
#57 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffcf3e0dc0,
source=0x7fffd0e5f2c8 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
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:1390
#58 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf40b30,
statement_id=0x7fffcf31f8d0, sql_source=0x7fffd0d55688, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7fffe4647000,
query_comp_stats_info=0x7fffe4645f00, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0x0, flags=0) at ../cli/Cli.cpp:5908
#59 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0x7fffcf31f8d0,
sql_source=0x7fffd0d55688, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0x7fffe4647000,
comp_stats_info=0x7fffe4645f00, uniqueStmtId=0x0, uniqueStmtIdLen=0x0,
flags=0) at ../cli/CliExtern.cpp:4955
#60 0x00007fffefc5de20 in HSCursor::prepareQuery (this=0xa6c5240,
cliStr=0xaeea778 "SELECT HISTOGRAM_ID, COLUMN_NUMBER, COLCOUNT, INTERVAL_COUNT, ROWCOUNT, TOTAL_UEC, JULIANTIMESTAMP(STATS_TIME), LOW_VALUE, HIGH_VALUE, JULIANTIMESTAMP(READ_TIME), READ_COUNT, SAMPLE_SECS, COL_SECS, SA"...,
numParams=<value optimized out>, numResults=<value optimized out>)
at ../ustat/hs_cli.cpp:6263
#61 0x00007fffefcf7a8f in HSHistogrmCursor::open (this=0x7fffe4647200)
at ../ustat/hs_read.cpp:1944
#62 0x00007fffefcf9dd7 in readHistograms (tabDef=0x7fffd077e470,
fullQualName=..., histogramTableName=..., histintsTableName=...,
specialTable=<value optimized out>, type=<value optimized out>, colArray=
..., statsTime=@0x7fffcefd54f8, allFakeStat=@0x7fffe46484cc, preFetch=1,
fakeHistogram=0x7fffd0d554b8, emptyHistogram=0x7fffd0d55508,
smallSampleHistogram=0x7fffd0d55558, smallSampleSize=0x7fffd0d555a8,
colmap=0x7fffd0d55638, histogramRowCount=@0x7fffe4648368,
cs=0x7fffe4647b90, offset=0) at ../ustat/hs_read.cpp:1377
#63 0x00007fffefcfa92f in FetchHistograms (
qualifiedName=<value optimized out>, type=ExtendedQualName::NORMAL_TABLE,
colArray=..., colStatsList=..., isSQLMPTable=0, heap=0x7fffd0d55638,
histModTime=@0x7fffe46484c0, statsTime=@0x7fffcefd54f8,
allFakeStat=@0x7fffe46484cc, preFetch=1, createStatsSize=0)
at ../ustat/hs_read.cpp:1042
#64 0x00007fffeeb8f084 in HistogramCache::createColStatsList (
this=0x7fffe260b978, table=..., cachedHistograms=0x0)
at ../optimizer/NATable.cpp:587
#65 0x00007fffeeb8f495 in HistogramCache::getHistograms (this=0x7fffe260b978,
table=...) at ../optimizer/NATable.cpp:418
#66 0x00007fffeeb8f98e in NATable::getStatistics (this=0x7fffcefd50f8)
at ../optimizer/NATable.cpp:5537
#67 0x00007fffeee3274e in TableDesc::getTableColStats (this=0x7fffd17965a8)
at ../optimizer/TableDesc.cpp:382
#68 0x00007fffeec4a2e7 in tableColStats (this=0x7fffd17a5098,
normWAPtr=0x7fffe464b5f0) at ../optimizer/TableDesc.h:130
#69 Scan::synthLogProp (this=0x7fffd17a5098, normWAPtr=0x7fffe464b5f0)
at ../optimizer/OptLogRelExpr.cpp:5059
#70 0x00007fffeec45454 in RelExpr::synthLogProp (this=0x7fffd17a9498,
normWAPtr=0x7fffe464b5f0) at ../optimizer/OptLogRelExpr.cpp:618
#71 0x00007fffeec45eac in GenericUpdate::synthLogProp (this=0x7fffd17a949
normWAPtr=<value optimized out>) at ../optimizer/OptLogRelExpr.cpp:5445
#72 0x00007fffeec45454 in RelExpr::synthLogProp (this=0x7fffd17a9ff0,
normWAPtr=0x7fffe464b5f0) at ../optimizer/OptLogRelExpr.cpp:618
#73 0x00007fffeec45e3d in RelRoot::synthLogProp (this=0x7fffd17a9ff0,
normWAPtr=<value optimized out>) at ../optimizer/OptLogRelExpr.cpp:4640
#74 0x00007fffeebdb0db in RelRoot::normalizeNode (this=0x7fffd17a9ff0,
normWARef=...) at ../optimizer/NormRelExpr.cpp:7141
#75 0x00007ffff01b37ad in CmpMain::compile (this=0x7fffe464c980,
input_str=0x7fffd0f70ff8 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", charset=15,
queryExpr=@0x7fffe464c8b8, gen_code=0x7fffcf8deab8,
gen_code_len=0x7fffcf8deab0, heap=0x7fffe3174be8, phase=CmpMain::END,
fragmentDir=0x7fffe464cad8, op=3004, useQueryCache=<value optimized out>,
cacheable=0x7fffe464c8c8, begTime=0x7fffe464c8a0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2137
#76 0x00007ffff01b597c in CmpMain::sqlcomp (this=0x7fffe464c980,
input_str=0x7fffd0f70ff8 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", charset=15,
queryExpr=@0x7fffe464c8b8, gen_code=0x7fffcf8deab8,
gen_code_len=0x7fffcf8deab0, heap=0x7fffe3174be8, phase=CmpMain::END,
fragmentDir=0x7fffe464cad8, op=3004, useQueryCache=1,
cacheable=0x7fffe464c8c8, begTime=0x7fffe464c8a0, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1668
#77 0x00007ffff01b6b54 in CmpMain::sqlcomp (this=0x7fffe464c980, input=...,
gen_code=0x7fffcf8deab8, gen_code_len=0x7fffcf8deab0, heap=0x7fffe3174be8,
phase=CmpMain::END, fragmentDir=0x7fffe464cad8, op=3004)
at ../sqlcomp/CmpMain.cpp:807
#78 0x00007fffedfb37f8 in CmpStatement::process (this=0x7fffcf850bb8,
sqltext=<value optimized out>) at ../arkcmp/CmpStatement.cpp:488
#79 0x00007fffedfa81fe in CmpContext::compileDirect (this=0x7fffe25dd090,
data=0x7fffcf3f2838 "\200", data_len=232, outHeap=0x7fffe3be60f0,
charset=15, op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7fffe464d060,
gen_code_len=@0x7fffe464d068, parserFlags=4194304,
diagsArea=0x7fffcf3f2928) at ../arkcmp/CmpContext.cpp:687
#80 0x00007ffff49c8137 in CliStatement::prepare2 (this=0x7fffc7cdb438,
source=0x7fffc9885150 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", diagsArea=...,
passed_gen_code=<value optimized out>, passed_gen_code_len=3820904688,
charset=15, unpackTdbs=1, cliFlags=129) at ../cli/Statement.cpp:1799
#81 0x00007ffff49c8586 in CliStatement::prepare (this=0x7fffc7cdb438,
source=0x7fffc9885150 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", diagsArea=...,
passed_gen_code=<value optimized out>,
passed_gen_code_len=<value optimized out>, charset=<value optimized out>,
unpackTdbs=1, cliFlags=129) at ../cli/Statement.cpp:1390
#82 0x00007ffff4991ee4 in SQLCLI_Prepare2 (cliGlobals=0xf40b30,
statement_id=0xad475f8, sql_source=0x7fffe464d3a0, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0xad47828,
query_comp_stats_info=0xad47878, uniqueStmtId=<value optimized out>,
uniqueStmtIdLen=0xad4775c, flags=1) at ../cli/Cli.cpp:5908
#83 0x00007ffff49d3567 in SQL_EXEC_Prepare2 (statement_id=0xad475f8,
sql_source=0x7fffe464d3a0, gencode_ptr=0x0, gencode_len=0,
ret_gencode_len=0x0, query_cost_info=0xad47828, comp_stats_info=0xad47878,
uniqueStmtId=0xad47760 "", uniqueStmtIdLen=0xad4775c, flags=1)
at ../cli/CliExtern.cpp:4955
#84 0x00007ffff6e7a8e9 in SRVR::WSQL_EXEC_Prepare2 (statement_id=0xad475f8,
sql_source=<value optimized out>, gencode_ptr=<value optimized out>,
gencode_len=<value optimized out>, ret_gencode_len=<value optimized out>,
query_cost_info=<value optimized out>, comp_stats_info=0xad47878,
uniqueQueryId=0xad47760 "", uniqueQueryIdLen=0xad4775c, flags=1)
at SQLWrapper.cpp:800
#85 0x00007ffff6e6f285 in SRVR::PREPARE2 (pSrvrStmt=0xad46fe0,
isFromExecDirect=40) at sqlinterface.cpp:5016
#86 0x00007ffff6e9f6f0 in odbc_SQLSvc_Prepare2_sme_ (inputRowCnt=0,
sqlStmtType=8, stmtLabel=<value optimized out>,
sqlString=0xac87ba4 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", holdableCursor=0,
returnCode=0x7fffe464d8a8, sqlWarningOrErrorLength=0x7fffe464d8a4,
sqlWarningOrError=@0x7fffe464d880, sqlQueryType=0x7fffe464d89c,
stmtHandle=0x7fffe464d860, estimatedCost=0x7fffe464d898,
inputDescLength=0x7fffe464d890, inputDesc=@0x7fffe464d870,
outputDescLength=0x7fffe464d88c, outputDesc=@0x7fffe464d868,
isFromExecDirect=true) at srvrothers.cpp:926
#87 0x00000000004d20f9 in odbc_SQLSrvr_ExecDirect_ame_ (objtag_=0xa917460,
call_id_=0xa9174b8, dialogueId=355520603, stmtLabel=0xac87c16 "SQL_CUR_2",
cursorName=0x0, stmtExplainLabel=<value optimized out>, stmtType=0,
sqlStmtType=8,
sqlString=0xac87ba4 "upsert using load into lineitem select * from\ntrafodion.g_tpch2x.lineitem where l_orderkey <= 6001215", sqlAsyncEnable=0,
queryTimeout=0, inputRowCnt=0, txnID=0, holdableCursor=0)
at SrvrConnect.cpp:6991
#88 0x00000000004a1a36 in SQLEXECUTE_IOMessage (objtag_=0xa917460,
call_id_=0xa9174b8, operation_id=3012) at Interface/odbcs_srvr.cpp:1734
#89 0x00000000004a1ae4 in DISPATCH_TCPIPRequest (objtag_=0xa917460,
call_id_=0xa9174b8, operation_id=<value optimized out>)
at Interface/odbcs_srvr.cpp:1799
#90 0x0000000000432a02 in BUILD_TCPIP_REQUEST (pnode=0xa917460)
at ../Common/TCPIPSystemSrvr.cpp:603
#91 0x000000000043339d in PROCESS_TCPIP_REQUEST (pnode=0xa917460)
at ../Common/TCPIPSystemSrvr.cpp:581
#92 0x0000000000470ad6 in CNSKListenerSrvr::tcpip_listener (arg=0xde0f40)
at Interface/linux/Listener_srvr_ps.cpp:397
#93 0x00007ffff50329f0 in sb_thread_sthr_disp (pp_arg=0xf13020)
at threadl.cpp:253
#94 0x00007ffff4bf9851 in start_thread () from /lib64/libpthread.so.0
#95 0x00007ffff533590d in clone () from /lib64/libc.so.6
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)