[jira] [Created] (TRAFODION-798) LP Bug: 1396801 - Drop schema cascade returns error 20123 complaining about user-defined transaction

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-798:
------------------------------------

             Summary: LP Bug: 1396801 - Drop schema cascade returns error 20123 complaining about user-defined transaction
                 Key: TRAFODION-798
                 URL: https://issues.apache.org/jira/browse/TRAFODION-798
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


The QA regression tests have run into this problem several times.  Drop schema cascade would returns error 20123 complaining that a user-defined transaction has been started.  When this occurred, any statements run after that would continue to see this error until a new trafci session is started.

There is no certain way to reproduce this problem, but it does occur every now and then to cause test failures.  This bug report is created to document this problem.  Some analysis needs to do be done from the implementation of drop schema cascade to see what could have caused this problem to happen.

Here are two occurrences seen on the v1125_0830 build:

fullouterjoins/fullouterjoins:
SQL>drop schema trafodion.fullouterjoins_test_sql8 cascade;
*** ERROR[20123] A user-defined transaction has been started. This DDL operation cannot be performed. [2014-11-26 09:24:53]

dmls_rollback/r23fix:
SQL>drop schema trafodion.dmls_rollback_r23fix cascade;
*** ERROR[20123] A user-defined transaction has been started. This DDL operation cannot be performed. [2014-11-26 08:24:50]



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