You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2015/12/07 18:51:10 UTC
[jira] [Created] (TRAFODION-1678) Some statements cause DROP SCHEMA
to fail with DTM error 97
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)