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

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall resolved TRAFODION-1678.
---------------------------------------------
    Resolution: Fixed

Fixed by https://github.com/apache/incubator-trafodion/pull/214, merged today.

> 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)