Qifan Chen created TRAFODION-1469:
-------------------------------------
Summary: OSIM create table step will hang if the above compression
option is present in the DDL.
Key: TRAFODION-1469
URL: https://issues.apache.org/jira/browse/TRAFODION-1469
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Qifan Chen
OSIM create table step will hang if the above compression option is present in
the DDL.
This happens on workstations.
Just wonder if we can detect this situation (option present, but no compression
library installed), remove the option and give an warning at the end.
Table creation should not hang.
SALT USING 16 PARTITIONS
ON ("cliente_CIC", "operacion_identificacionOperacion")
DIVISION BY (DATE_PART('YEARMONTH',"fechaOrigen")
NAMED AS ("_DIVISION_1_"))
ATTRIBUTES ALIGNED FORMAT
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF'
COMPRESSION = 'SNAPPY'
)
The stack leads to the hung.
#0 CmpSeabaseDDL::createSeabaseTable2 (this=0x7ffffffe9510, cliInterface=...,
createTableNode=0x7fffd64dbfe8, currCatName=..., currSchName=...,
isCompound=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:2108
#1 0x00007ffff07cb2a6 in CmpSeabaseDDL::createSeabaseTable
(this=0x7ffffffe9510,
createTableNode=0x7fffd64dbfe8, currCatName=..., currSchName=...,
isCompound=0)
at ../sqlcomp/CmpSeabaseDDLtable.cpp:2232
#2 0x00007ffff07848f3 in CmpSeabaseDDL::executeSeabaseDDL
(this=0x7ffffffe9510,
ddlExpr=0x7fffd64dd138, ddlNode=0x7fffd64dbfe8, currCatName=...,
currSchName=...,
dws=0x0) at ../sqlcomp/CmpSeabaseDDLcommon.cpp:8253
#3 0x00007ffff539afa6 in CmpStatement::process (this=0x7fffd64bc960,
statement=...)
at ../arkcmp/CmpStatement.cpp:921
#4 0x00007ffff538a37b in CmpContext::compileDirect (this=0x7fffd65fb090,
data=0x7fffe82116a8 "\200", data_len=5952, outHeap=0x7fffe8c5e138,
charset=15,
op=CmpMessageObj::PROCESSDDL, gen_code=@0x7ffffffe9e98,
gen_code_len=@0x7ffffffe9e94,
parserFlags=163840,
parentQid=0x7fffe821fab8
"MXID11000002073212307447893771717000000000206U3333300_64_64",
parentQidLen=59, diagsArea=0x7fffe821fc68) at ../arkcmp/CmpContext.cpp:874
#5 0x00007ffff4722224 in ExDDLTcb::work (this=0x7fffe81f1358) at
../executor/ex_ddl.cpp:281
#6 0x00007ffff4741a77 in ex_tcb::sWork (tcb=0x7fffe81f1358) at
../executor/ex_tcb.h:103
#7 0x00007ffff48b8793 in ExSubtask::work (this=0x7fffe81f2250)
at ../executor/ExScheduler.cpp:754
#8 0x00007ffff48b7b56 in ExScheduler::work (this=0x7fffe81f0f98,
prevWaitTime=0)
at ../executor/ExScheduler.cpp:331
#9 0x00007ffff4799132 in ex_root_tcb::execute (this=0x7fffe81f22d0,
cliGlobals=0xb9f5d0,
glob=0x7fffe821f630, input_desc=0x7fffe822be68, diagsArea=@0x7ffffffeb4d0,
reExecute=0)
at ../executor/ex_root.cpp:1058
#10 0x00007ffff5e1b76f in CliStatement::execute (this=0x7fffe82089e0,
cliGlobals=0xb9f5d0,
input_desc=0x7fffe822be68, diagsArea=...,
execute_state=CliStatement::INITIAL_STATE_,
fixupOnly=0, cliflags=0) at ../cli/Statement.cpp:4525
#11 0x00007ffff5da1bf4 in SQLCLI_PerformTasks(CliGlobals *, ULng32, SQLSTMT_ID
*, SQLDESC_ID *, SQLDESC_ID *, Lng32, Lng32, typedef __va_list_tag
__va_list_tag *, SQLCLI_PTR_PAIRS *, SQLCLI_PTR_PAIRS *) (cliGlobals=0xb9f5d0,
tasks=4882, statement_id=0x7fffd6849298,
input_descriptor=0x7fffd6849308, output_descriptor=0x0,
num_input_ptr_pairs=0,
num_output_ptr_pairs=0, ap=0x7ffffffebac0, input_ptr_pairs=0x0,
output_ptr_pairs=0x0)
at ../cli/Cli.cpp:3297
#12 0x00007ffff5da2565 in SQLCLI_Exec(CliGlobals *, SQLSTMT_ID *, SQLDESC_ID *,
Lng32, typedef __va_list_tag __va_list_tag *, SQLCLI_PTR_PAIRS *)
(cliGlobals=0xb9f5d0,
statement_id=0x7fffd6849298, input_descriptor=0x7fffd6849308,
num_ptr_pairs=0,
ap=0x7ffffffebac0, ptr_pairs=0x0) at ../cli/Cli.cpp:3544
#13 0x00007ffff5e309f8 in SQL_EXEC_Exec (statement_id=0x7fffd6849298,
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
