[jira] [Created] (TRAFODION-204) LP Bug: 1297400 - create index hangs on a table with 10K rows

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-204:
------------------------------------

             Summary: LP Bug: 1297400 - create index hangs on a table with 10K rows
                 Key: TRAFODION-204
                 URL: https://issues.apache.org/jira/browse/TRAFODION-204
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Anoop Sharma
            Priority: Blocker


Create index often hangs on a larger table.  It also makes sqlci (or mxosrvr if run from Trafci) hogging both the CUP cycle and the memory.  This problem right now is fairly reproducible with the following sequence of statements on centos-mapr1, which runs the beta 0.7.0 RC1 build.  The table here is actually fairly small with only 10K rows.

SQL>create table t01tab (
+>a int not null, b int, c int,
+>d char(10), e char(10), f char(10)
+>) store by (a);

--- SQL operation complete.

SQL>insert into t01tab values (1,10,100,'d1','e1','f1');

--- 1 row(s) inserted.

SQL>create table t01tabA (
+>a int not null, b int, c int,
+>d char(10), e char(10), f char(10),
+>v1 int not null,
+>v2 int not null,
+>v3 int not null,
+>v4 int not null,
+>v5 int not null
+>) store by (a, v1, v2, v3, v4, v5);

--- SQL operation complete.

SQL>insert into t01tabA (
+>select * from t01tab
+>transpose 0,1,2,3,4,5,6,7,8,9 as v1
+>transpose 10,11,12,13,14,15,16,17,18,19 as v2
+>transpose 0,100,200,300,400,500,600,700,800,900 as v3
+>transpose 30,31,32,33,34,35,36,37,38,39 as v4
+>transpose 10 as v5
+>);

--- 10000 row(s) inserted.

SQL>select count(*) from t01tabA;

(EXPR)
--------------------
               10000

--- 1 row(s) selected.

SQL>create index mindexA on t01tabA (a);



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)