[jira] [Created] (TRAFODION-1678) Some statements cause DROP SCHEMA to fail with DTM error 97

[David Wayne Birdsall (JIRA)]

David Wayne Birdsall created TRAFODION-1678:
-----------------------------------------------

             Summary: Some statements cause DROP SCHEMA to fail with DTM error 
97
                 Key: TRAFODION-1678
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1678
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
    Affects Versions: 1.3-incubating
            Reporter: David Wayne Birdsall
            Assignee: David Wayne Birdsall
             Fix For: 2.0-incubating


The following script succeeds in sqlci, however in Trafci, the last two DROP 
SCHEMA statements fail with DTM error 97:

log mytest.log clear;

create schema myschema_1;
set schema myschema_1;
create table mytable (a int, b int);
-- update statistics for table mytable on every column;
showcontrol all;
drop schema myschema_1 cascade;

create schema myschema_2;
set schema myschema_2;
create table mytable (a int, b int);
update statistics for table mytable on every column;
-- showcontrol all;
drop schema myschema_2 cascade;

create schema myschema_3;
set schema myschema_3;
create table mytable (a int, b int);
update statistics for table mytable on every column;
showcontrol all;
drop schema myschema_3 cascade;

create schema myschema_4;
set schema myschema_4;
create table mytable (a int, b int);
update statistics for table mytable on every column;
showtransaction;
drop schema myschema_4 cascade;

exit;

Here is an example of the failing DROP SCHEMA statement taken from a Trafci log:

SQL>drop schema myschema_3 cascade;

*** ERROR[8606] Transaction subsystem TMF returned error 97 on a commit 
transaction. [2015-09-22 17:39:06]

The "drop schema myschema_4 cascade" fails similarly.





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