You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:18:25 UTC
[jira] [Created] (TRAFODION-846) LP Bug: 1404442 - Random create
schema failures due to inaccessible _MD_ tables
Alice Chen created TRAFODION-846:
------------------------------------
Summary: LP Bug: 1404442 - Random create schema failures due to inaccessible _MD_ tables
Key: TRAFODION-846
URL: https://issues.apache.org/jira/browse/TRAFODION-846
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Weishiun Tsai
Assignee: Roberta Marton
Priority: Blocker
Fix For: 1.0 (pre-incubation)
We are seeing a large number of random create schema failures. The statement would return error 8841 and 4082 complaining that a table in “_MD_” is inaccessible. Generally the table mentioned in the error message is either the OBJECTS table or the OBJECTS_UNIQ_IDX table.
This obviously is related to the recent check-in of the ANSI schema support, with which the create schema statement becomes a ‘real thing’. On the v1218 build (the first daily build that has the ANSI schema support), the QA regression tests saw a large number of such error. This is definitely a test stopper for QA. Once a create schema statement fails, all tests afterwards using that particular schema would naturally fail as well.
Here are some examples of the failures seen in one run:
------------
SQL>drop schema trafodion.arkcase_arkt1199 cascade;
*** ERROR[1003] Schema TRAFODION.ARKCASE_ARKT1199 does not exist. [2014-12-19 00:29:05]
SQL>create schema trafodion.arkcase_arkt1199;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 00:29:06]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 00:29:06]
------------
SQL>drop schema trafodion.arkcase_arkt1371 cascade;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 00:31:13]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-19 00:31:13]
*** ERROR[1003] Schema TRAFODION.ARKCASE_ARKT1371 does not exist. [2014-12-19 00:31:13]
SQL>create schema trafodion.arkcase_arkt1371;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 00:31:13]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-19 00:31:13]
------------
SQL>drop schema trafodion.arkcase_datarith cascade;
*** ERROR[1003] Schema TRAFODION.ARKCASE_DATARITH does not exist. [2014-12-19 01:09:19]
SQL>create schema trafodion.arkcase_datarith;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 01:09:20]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 01:09:20]
------------
SQL>drop schema trafodion.bmo_ssdovf2 cascade;
*** ERROR[1003] Schema TRAFODION.BMO_SSDOVF2 does not exist. [2014-12-19 01:47:03]
SQL>create schema trafodion.bmo_ssdovf2;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 01:47:05]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 01:47:05]
------------
SQL>drop schema trafodion.compiler_explain cascade;
*** ERROR[1003] Schema TRAFODION.COMPILER_EXPLAIN does not exist. [2014-12-19 01:55:19]
SQL>create schema trafodion.compiler_explain;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 01:55:20]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 01:55:20]
------------
SQL>drop schema trafodion.compiler_smf4 cascade;
*** ERROR[1003] Schema TRAFODION.COMPILER_SMF4 does not exist. [2014-12-19 18:05:19]
SQL>create schema trafodion.compiler_smf4;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 18:05:21]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 18:05:21]
------------
SQL>drop schema trafodion.datamining_rotate cascade;
*** ERROR[1003] Schema TRAFODION.DATAMINING_ROTATE does not exist. [2014-12-19 20:54:18]
SQL>create schema trafodion.datamining_rotate;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 20:54:20]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 20:54:20]
------------
SQL>drop schema trafodion.ddl_tab007 cascade;
*** ERROR[1003] Schema TRAFODION.DDL_TAB007 does not exist. [2014-12-19 22:17:38]
SQL>create schema trafodion.ddl_tab007;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 22:17:39]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 22:17:39]
------------
SQL>drop schema trafodion.features_niz cascade;
*** ERROR[1003] Schema TRAFODION.FEATURES_NIZ does not exist. [2014-12-19 23:06:09]
SQL>control query default limit_max_numeric_precision reset;
--- SQL operation complete.
SQL>create schema trafodion.features_niz;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 23:06:10]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 23:06:10]
------------
SQL>drop schema trafodion.fullouterjoins_test_sql3 cascade;
*** ERROR[1003] Schema TRAFODION.FULLOUTERJOINS_TEST_SQL3 does not exist. [2014-12-19 23:27:05]
SQL>create schema trafodion.fullouterjoins_test_sql3;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-19 23:27:06]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-19 23:27:06]
------------
SQL>drop schema trafodion.groupby_grpby006 cascade;
*** ERROR[1003] Schema TRAFODION.GROUPBY_GRPBY006 does not exist. [2014-12-20 00:35:05]
SQL>create schema trafodion.groupby_grpby006;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 00:35:06]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 00:35:06]
------------
SQL>drop schema trafodion.groupby_grpby007 cascade;
*** ERROR[1003] Schema TRAFODION.GROUPBY_GRPBY007 does not exist. [2014-12-20 00:35:11]
SQL>create schema trafodion.groupby_grpby007;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 00:35:12]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 00:35:12]
------------
SQL>drop schema trafodion.groupby_grpby009 cascade;
*** ERROR[1003] Schema TRAFODION.GROUPBY_GRPBY009 does not exist. [2014-12-20 00:35:30]
SQL>create schema trafodion.groupby_grpby009;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 00:35:31]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 00:35:31]
------------
SQL>drop schema trafodion.purgedata_purgedata182 cascade;
*** ERROR[1003] Schema TRAFODION.PURGEDATA_PURGEDATA182 does not exist. [2014-12-20 01:40:12]
SQL>create schema trafodion.purgedata_purgedata182;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 01:40:13]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 01:40:13]
------------
SQL>drop schema trafodion.purgedata_purgedata30 cascade;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 02:23:00]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 02:23:00]
*** ERROR[1003] Schema TRAFODION.PURGEDATA_PURGEDATA30 does not exist. [2014-12-20 02:23:00]
SQL>create schema trafodion.purgedata_purgedata30;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 02:23:00]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 02:23:00]
------------
SQL>drop schema trafodion.purgedata_purgedata32 cascade;
*** ERROR[1003] Schema TRAFODION.PURGEDATA_PURGEDATA32 does not exist. [2014-12-20 02:24:35]
SQL>create schema trafodion.purgedata_purgedata32;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 02:24:36]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 02:24:36]
------------
SQL>drop schema trafodion.showddl_ddl04 cascade;
*** ERROR[1003] Schema TRAFODION.SHOWDDL_DDL04 does not exist. [2014-12-20 03:27:27]
SQL>create schema trafodion.showddl_ddl04;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 03:27:28]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 03:27:28]
------------
SQL>create schema trafodion.spj_spj;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 03:42:31]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS_UNIQ_IDX does not exist or is inaccessible. [2014-12-20 03:42:31]
------------
SQL>drop schema trafodion.volatile_table_volt7 cascade;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 04:15:13]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 04:15:13]
*** ERROR[1003] Schema TRAFODION.VOLATILE_TABLE_VOLT7 does not exist. [2014-12-20 04:15:13]
SQL>create schema trafodion.volatile_table_volt7;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 04:15:13]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 04:15:13]
------------
SQL>drop schema trafodion.volatile_table_volt9 cascade;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 04:20:03]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 04:20:03]
*** ERROR[1003] Schema TRAFODION.VOLATILE_TABLE_VOLT9 does not exist. [2014-12-20 04:20:03]
SQL>create schema trafodion.volatile_table_volt9;
*** ERROR[8841] User application committed or aborted a transaction started by SQL. This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-12-20 04:20:03]
*** ERROR[4082] Object TRAFODION."_MD_".OBJECTS does not exist or is inaccessible. [2014-12-20 04:20:03]
------------
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)