You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 00:14:46 UTC
[jira] [Closed] (TRAFODION-239) LP Bug: 1312847 - upsert crashes
sqlci on rhel-cdh1 with a 11M rows table
[ https://issues.apache.org/jira/browse/TRAFODION-239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-239.
----------------------------------
Resolution: Fixed
Assignee: (was: Apache Trafodion)
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1312847 - upsert crashes sqlci on rhel-cdh1 with a 11M rows table
> -------------------------------------------------------------------------
>
> Key: TRAFODION-239
> URL: https://issues.apache.org/jira/browse/TRAFODION-239
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Priority: Blocker
> Fix For: 1.0 (pre-incubation)
>
>
> Currently, this upsert statement crashes sqlci on rehl-cdh1, a 4-node cluster. It does the same thing when using trafci. On trafci, it would start to get ‘problem_with_server_read’ messages, which is a sign that the connection has been killed.
> There is no core generated in either situation. When sqlci crashed, there was a DUMPENVS file generated. The file is attached in this case.
> g_tpch2x.lineitem is part of QA global tables. This table is salted with 12 partitions.
> rhel-cdh1 is currently installed with the datalake v39549 debug build.
> Here is the output from trafci
> SQL>upsert using load into lineitem (select * from trafodion.g_tpch2x.lineitem);
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> *** ERROR[1] The message id: problem_with_server_read
> *** ERROR[1] The message id: header_not_long_enough
> Here is the output of the sqlci. Sqlci is killed after the upsert statement.
> [trafodion@rhel-cdh1 scripts]$ sqlci | cat
> Trafodion Conversational Interface 0.7.0
> (c) Copyright 2014 Hewlett-Packard Development Company, LP.
> >>set schema mysch;
> --- SQL operation complete.
> >>select count(*) from trafodion.g_tpch2x.lineitem;
> (EXPR)
> --------------------
> 11997996
> --- 1 row(s) selected.
> >>showddl trafodion.g_tpch2x.lineitem;
> CREATE TABLE TRAFODION.G_TPCH2X.LINEITEM
> (
> L_ORDERKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_PARTKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_SUPPKEY INT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_LINENUMBER INT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_QUANTITY NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , L_EXTENDEDPRICE NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , L_DISCOUNT NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , L_TAX NUMERIC(12, 2) NO DEFAULT NOT NULL NOT
> DROPPABLE
> , L_RETURNFLAG CHAR(1) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_LINESTATUS CHAR(1) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_SHIPDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
> , L_COMMITDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
> , L_RECEIPTDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
> , L_SHIPINSTRUCT CHAR(25) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_SHIPMODE CHAR(10) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> , L_COMMENT VARCHAR(44) CHARACTER SET ISO88591 COLLATE
> DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
> )
> STORE BY (L_ORDERKEY ASC, L_LINENUMBER ASC)
> ;
> --- SQL operation complete.
> >>create table lineitem like trafodion.g_tpch2x.lineitem with constraints with partitions;
> --- SQL operation complete.
> >>upsert using load into lineitem (select * from trafodion.g_tpch2x.lineitem);
> Assigned to LaunchPad User khaled Bouaziz
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)