[TRAFODION-230] LP Bug: 1308749 - Update statistics sees errors 9214/9215/20123/4222

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.8 (pre-incubation)
• Component/s: sql-cmp
• External issue URL: https://bugs.launchpad.net/bugs/1308749
• Assignee: Unassigned
• Reporter: Weishiun Tsai
• Created: 22/Jul/15 18:14
• Updated: 21/Aug/15 06:48
• Resolved: 21/Aug/15 06:48

Description

When running update statistics on the following table, it returns errors 9214/9215/20123/4222. This is pretty reproducible right now on the beta build v39140 installed on the cluster centos-mapr1. To produce this problem will require the QA g_tpcds1x global tables to be created first.

>>create table sb_customer
+>(
+>c_customer_sk integer not null,
+>c_customer_id char(16) not null,
+>c_current_cdemo_sk integer ,
+>c_current_hdemo_sk integer ,
+>c_current_addr_sk integer ,
+>c_first_shipto_date_sk integer ,
+>c_first_sales_date_sk integer ,
+>c_salutation char(10) ,
+>c_first_name char(20) not null,
+>c_last_name char(30) not null,
+>c_preferred_cust_flag char(1) ,
+>c_birth_day integer ,
+>c_birth_month integer ,
+>c_birth_year integer ,
+>c_birth_country varchar(20) ,
+>c_login char(13) ,
+>c_email_address char(50) ,
+>c_last_review_date char(10) ,
+>primary key (c_customer_sk, c_last_name, c_first_name)
+>);

— SQL operation complete.
>>
>>upsert using load into sb_customer (select * from trafodion.g_tpcds1x.customer where c_customer_sk is not null and c_last_name is not null and c_first_name is not null);

— 94760 row(s) inserted.
>>
>>select count from trafodion.g_tpcds1x.customer;

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

100000

— 1 row(s) selected.
>>select count from sb_customer;

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

94760

— 1 row(s) selected.
>>
>>update statistics for table sb_customer on every column, (C_CUSTOMER_SK, C_LAST_NAME, C_BIRTH_DAY) sample;

• • • ERROR[9214] Object TRAFODION.PUBLIC_ACCESS_SCHEMA.SQLMX_37187003981691445_1397679531_607967 could not be created.

• • • ERROR[20123] A user-defined transaction has been started. This DDL operation cannot be performed.

• • • ERROR[9215] UPDATE STATISTICS encountered an internal error (from TRAFODION.PUBLIC_ACCESS_SCHEMA.SQLMX_37187003981691445_1397679531_607967, with return value=). Details: ."

• • • ERROR[4222] The ALTER feature is not supported in this software version.

• • • ERROR[8822] The statement was not prepared.

— SQL operation failed with errors.