David Wayne Birdsall created TRAFODION-2635:
-----------------------------------------------
Summary: Core on select count(*) using hbase cell access on a
salted Trafodion table
Key: TRAFODION-2635
URL: https://issues.apache.org/jira/browse/TRAFODION-2635
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.2-incubating
Environment: All
Reporter: David Wayne Birdsall
Assignee: David Wayne Birdsall
The following sqlci script demonstrates the problem:
set schema sch;
create table t1
( a int not null, b int, primary key (a) )
salt using 4 partitions;
prepare s1 from select count(*) from hbase."_CELL_"."TRAFODION.SCH.T1";
When doing the prepare, sqlci cores. The stack trace is as follows:
(gdb) bt
#0 0x00007f2c6036a625 in raise () from /lib64/libc.so.6
#1 0x00007f2c6036bd8d in abort () from /lib64/libc.so.6
#2 0x00007f2c62145165 in ?? ()
from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#3 0x00007f2c622b985f in ?? ()
from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#4 0x00007f2c62149d02 in JVM_handle_linux_signal ()
from /usr/lib/jvm/java-1.7.0-openjdk.x86_64/jre/lib/amd64/server/libjvm.so
#5 <signal handler called>
#6 0x00000000004028ba in folly::fbstring_core<char>::category (this=0x10)
at ../export/FBString.h:1001
#7 0x0000000000402890 in folly::fbstring_core<char>::size (this=0x10)
at ../export/FBString.h:803
#8 0x000000000040285c in folly::basic_fbstring<char, std::char_traits<char>,
std::allocator<char>, folly::fbstring_core<char> >::size (this=0x10)
at ../export/FBString.h:1388
#9 0x00007f2c5fd92318 in folly::basic_fbstring<char, std::char_traits<char>,
std::allocator<char>, folly::fbstring_core<char> >::find (this=0x10,
needle=0x7f2c5898d71e "_ISO88591", pos=0, nsize=9)
at ../export/FBString.h:1960
#10 0x00007f2c5fd8f899 in NAString::index (this=0x0,
pattern=0x7f2c5898d71e "_ISO88591", plen=9, startIndex=0,
cmp=NAString::exact) at ../export/NAStringDef.cpp:316
#11 0x00007f2c629e89ac in NAString::index (this=0x0,
s=0x7f2c5898d71e "_ISO88591", i=0, cmp=NAString::exact)
at ../export/NAStringDef.h:581
#12 0x00007f2c588174e8 in ValueIdList::computeEncodedKey (this=0x7f2c3c5886c0,
tDesc=0x7f2c3e4dffd8, isMaxKey=0, encodedKeyBuffer=@0x7ffd8cf4cc80,
keyBufLen=@0x7ffd8cf4cc7c) at ../optimizer/ValueDesc.cpp:6802
#13 0x00007f2c5861df90 in
RangePartitioningFunction::computeNumOfActivePartitions (this=0x7f2c3e4e3300,
skey=0x7f2c3c5885b8, tDesc=0x7f2c3e4dffd8)
at ../optimizer/PartFunc.cpp:5110
#14 0x00007f2c586a7d16 in FileScan::FileScan (this=0x7f2c3c587a10,
tableName=..., tableDescPtr=0x7f2c3e4dffd8, indexDescPtr=0x7f2c3e4e17e0,
isReverseScan=0, baseCardinality=@0x7ffd8cf4cf3c, accessOpts=...,
groupAttributesPtr=0x7f2c3e4bd508, selectionPredicates=..., disjuncts=...,
generatedCCPreds=..., otype=REL_HBASE_ACCESS)
at ../optimizer/RelExpr.cpp:9671
#15 0x00007f2c586a9fe2 in HbaseAccess::HbaseAccess (this=0x7f2c3c587a10,
corrName=..., tableDesc=0x7f2c3e4dffd8, idx=0x7f2c3e4e17e0,
isReverseScan=0, baseCardinality=@0x7ffd8cf4cf3c, accessOptions=...,
groupAttributesPtr=0x7f2c3e4bd508, selectionPredicates=..., disjuncts=...,
generatedCCPreds=..., otype=REL_HBASE_ACCESS, oHeap=0x7f2c3e4d4b90)
at ../optimizer/RelExpr.cpp:10139
#16 0x00007f2c5837b897 in createAndInsertHbaseScan (idesc=0x7f2c3e4e17e0, bef=
0x7f2c3e4bcd70, memory=@0x7ffd8cf4d460, disjunctsPtr=0x7f2c3c586ef8,
generatedCCPreds=..., oc=SAME_ORDER, ixMdamFlag=MDAM_OFF)
at ../optimizer/ImplRule.cpp:1083
#17 0x00007f2c5837ba99 in createAndInsertScan (idesc=0x7f2c3e4e17e0,
bef=0x7f2c3e4bcd70, memory=@0x7ffd8cf4d460, disjunctsPtr=0x7f2c3c586ef8,
generatedCCPreds=..., oc=SAME_ORDER, ixMdamFlag=MDAM_OFF, isHbase=1)
at ../optimizer/ImplRule.cpp:1122
#18 0x00007f2c5837c0d0 in generateScanSubstitutes (before=0x7f2c3e4bcd70,
context=0x7f2c3c5877e8, memory=@0x7ffd8cf4d460, isHbase=1)
at ../optimizer/ImplRule.cpp:1257
#19 0x00007f2c5837d677 in HbaseScanRule::nextSubstitute (this=0x7f2c4d888d68,
before=0x7f2c3e4bcd70, context=0x7f2c3c5877e8, memory=@0x7ffd8cf4d460)
at ../optimizer/ImplRule.cpp:1662
#20 0x00007f2c587c2251 in ApplyRuleTask::perform (this=0x7f2c3c586920,
taskId=11) at ../optimizer/tasks.cpp:1188
#21 0x00007f2c5857d06d in QueryOptimizerDriver::optimizeAPassHelper (
this=0x7ffd8cf519b0, context=0x7f2c3c583c08) at ../optimizer/opt.cpp:7084
#22 0x00007f2c5857cc00 in QueryOptimizerDriver::optimizeAPass (
this=0x7ffd8cf519b0, context=0x7f2c3c583c08) at ../optimizer/opt.cpp:7017
#23 0x00007f2c5857c824 in QueryOptimizerDriver::doPass2PerhapsPass1 (
this=0x7ffd8cf519b0, relExpr=0x7f2c3e4bd868, context=0x7f2c3c583c08,
original=0x7f2c3c57c530) at ../optimizer/opt.cpp:6944
#24 0x00007f2c5857b80c in RelExpr::optimize2 (this=0x7f2c3e4bd868)
at ../optimizer/opt.cpp:6640
#25 0x00007f2c585a5b6c in RelExpr::optimizeNode (this=0x7f2c3e4bd868)
at ../optimizer/OptLogRelExpr.cpp:76
#26 0x00007f2c5a09cf27 in CmpMain::compile (this=0x7ffd8cf55370,
input_str=0x7f2c3e4c3148 "select count(*) from
hbase.\"_CELL_\".\"TRAFODION.SCH.T1\";", charset=15, queryExpr=@0x7ffd8cf55258,
gen_code=0x7f2c3e4d6f10,
gen_code_len=0x7f2c3e4d6f08, heap=0x7f2c630e26d0, phase=CmpMain::END,
fragmentDir=0x7ffd8cf554c0, op=3004, useQueryCache=CmpMain::NORMAL,
cacheable=0x7ffd8cf55244, begTime=0x7ffd8cf55260, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:2319
#27 0x00007f2c5a09ad05 in CmpMain::sqlcomp (this=0x7ffd8cf55370,
input_str=0x7f2c3e4c3148 "select count(*) from
hbase.\"_CELL_\".\"TRAFODION.SCH.T1\";", charset=15, queryExpr=@0x7ffd8cf55258,
gen_code=0x7f2c3e4d6f10,
gen_code_len=0x7f2c3e4d6f08, heap=0x7f2c630e26d0, phase=CmpMain::END,
fragmentDir=0x7ffd8cf554c0, op=3004, useQueryCache=CmpMain::NORMAL,
cacheable=0x7ffd8cf55244, begTime=0x7ffd8cf55260, shouldLog=0)
at ../sqlcomp/CmpMain.cpp:1701
#28 0x00007f2c5a0985f5 in CmpMain::sqlcomp (this=0x7ffd8cf55370, input=...,
gen_code=0x7f2c3e4d6f10, gen_code_len=0x7f2c3e4d6f08, heap=0x7f2c630e26d0,
phase=CmpMain::END, fragmentDir=0x7ffd8cf554c0, op=3004,
useQueryCache=CmpMain::NORMAL) at ../sqlcomp/CmpMain.cpp:817
#29 0x00007f2c5f5fbae0 in CmpStatement::process (this=0x7f2c3e4c2fb8,
sqltext=...) at ../arkcmp/CmpStatement.cpp:507
#30 0x00007f2c5f5eb0b1 in CmpContext::compileDirect (this=0x7f2c4d852090,
---Type <return> to continue, or q <return> to quit---
data=0x7f2c630ef5e8 "p", data_len=168, outHeap=0x7f2c631510b8, charset=15,
op=CmpMessageObj::SQLTEXT_COMPILE, gen_code=@0x7ffd8cf55a00,
gen_code_len=@0x7ffd8cf55a0c, parserFlags=0, parentQid=0x0,
parentQidLen=0, diagsArea=0x7f2c630ef698) at ../arkcmp/CmpContext.cpp:906
#31 0x00007f2c600a6435 in CliStatement::prepare2 (this=0x7f2c630e1f30,
source=0x7f2c631242c8 "select count(*) from
hbase.\"_CELL_\".\"TRAFODION.SCH.T1\";", diagsArea=..., passed_gen_code=0x0,
passed_gen_code_len=0,
charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1752
#32 0x00007f2c600a54e4 in CliStatement::prepare (this=0x7f2c630e1f30,
source=0x7f2c631242c8 "select count(*) from
hbase.\"_CELL_\".\"TRAFODION.SCH.T1\";", diagsArea=..., passed_gen_code=0x0,
passed_gen_code_len=0,
charset=15, unpackTdbs=1, cliFlags=144) at ../cli/Statement.cpp:1405
#33 0x00007f2c60025960 in SQLCLI_Prepare2 (cliGlobals=0x1939b70,
statement_id=0x41ca5d0, sql_source=0x5491ff0, gencode_ptr=0x0,
gencode_len=0, ret_gencode_len=0x0, query_cost_info=0x7ffd8cf57090,
query_comp_stats_info=0x7ffd8cf55e00, uniqueStmtId=0x7ffd8cf56f00 " ",
uniqueStmtIdLen=0x7ffd8cf57150, flags=128) at ../cli/Cli.cpp:5840
#34 0x00007f2c600c535a in SQL_EXEC_Prepare2 (statement_id=0x41ca5d0,
sql_source=0x5491ff0, gencode_ptr=0x0, gencode_len=0, ret_gencode_len=0x0,
query_cost_info=0x7ffd8cf57090, comp_stats_info=0x7ffd8cf55e00,
uniqueStmtId=0x7ffd8cf56f00 " ", uniqueStmtIdLen=0x7ffd8cf57150,
flags=128) at ../cli/CliExtern.cpp:5132
#35 0x00007f2c629eb806 in SqlCmd::do_prepare (sqlci_env=0x1922240,
prep_stmt=0x486b8e0,
sqlStmt=0x486bc00 "select count(*) from
hbase.\"_CELL_\".\"TRAFODION.SCH.T1\";", resetLastExecStmt=1, rsIndex=0,
prepcode=0x0, statisticsType=0x0)
at ../sqlci/SqlCmd.cpp:998
#36 0x00007f2c629f19e8 in Prepare::process (this=0x44648d0,
sqlci_env=0x1922240) at ../sqlci/SqlCmd.cpp:3066
#37 0x00007f2c629d1e44 in Obey::process (this=0x5467b20, sqlci_env=0x1922240)
at ../sqlci/Obey.cpp:267
#38 0x00007f2c629db008 in SqlciEnv::executeCommands (this=0x1922240,
input_stmt=@0x7ffd8cf57448) at ../sqlci/SqlciEnv.cpp:841
#39 0x00007f2c629da749 in SqlciEnv::run (this=0x1922240)
at ../sqlci/SqlciEnv.cpp:650
#40 0x00000000004026d8 in main (argc=1, argv=0x7ffd8cf57608)
at ../bin/SqlciMain.cpp:328
(gdb)
The problem is that ValueIdList::computeEncodedKey attempts to dereference a
null pointer.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
