[
https://issues.apache.org/jira/browse/TRAFODION-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15049362#comment-15049362
]
ASF GitHub Bot commented on TRAFODION-1678:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/214
> 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)
