You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/05 18:05:26 UTC
[jira] [Updated] (TRAFODION-1469) OSIM create table step will hang
if the above compression option is present in the DDL.
[ https://issues.apache.org/jira/browse/TRAFODION-1469?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah updated TRAFODION-1469:
--------------------------------------
Assignee: Howard Qin
> 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
> Assignee: Howard Qin
>
> 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)