Sandhya Sundaresan created TRAFODION-2735:
---------------------------------------------
Summary: LOB: Drop table/schema returns 8616 error but the drop
statement can't be retried
Key: TRAFODION-2735
URL: https://issues.apache.org/jira/browse/TRAFODION-2735
Project: Apache Trafodion
Issue Type: Bug
Components: dtm, sql-exe
Affects Versions: 2.2-incubating
Environment: May need to run 2 streams to see the effect of this. But
see how we handle the 8616 error with LOB objects may be a good place to start.
Reporter: Sandhya Sundaresan
With the DDL in TRX feature when a DDL returns the 8616 error, the statement
is generally rolled back and it can be retried until it succeeds. This,
however, is not the case for a table/schema with LOB columns. Drop a table or
schema with internal LOB tables would often returns the 8616 error, and on the
next retry, returns the 1031 or 1073 error with no further explanation. This is
likely caused by the 8616 error not handling the internal LOB tables correctly.
At that moment, using cleanup to clean up the tables and the schema becomes the
only option.
This is often seen when SQL regression is run with multiple streams. It is
causing a huge problem for running LOB tests since once a table/schema is not
dropped cleanly, all tests afterwards get messed up.
Here are some of such failures seen on the AdvEnt2.2 1010 build:
SQL>drop table mytable cascade;
*** ERROR[8616] A conflict was detected during commit processing. Transaction
has been aborted. [2016-10-12 12:53:54]
SQL>drop table mytable cascade;
*** ERROR[1031] Object TRAFODION.FEATURES_LOB.MYTABLE could not be dropped.
[2016-10-12 12:54:01]
SQL>drop table mytable1 cascade;
*** ERROR[8616] A conflict was detected during commit processing. Transaction
has been aborted. [2016-10-12 13:20:20]
SQL>drop table mytable1 cascade;
*** ERROR[1031] Object TRAFODION.FEATURES_LOB.MYTABLE1 could not be dropped.
[2016-10-12 13:20:37]
*** MISMATCH *** expecting: '--- SQL operation complete.'
SQL>drop schema trafodion.features_lob_TEST007 cascade;
*** ERROR[8616] A conflict was detected during commit processing. Transaction
has been aborted. [2016-10-12 12:59:48]
SQL>drop schema trafodion.features_lob_TEST007 cascade;
*** ERROR[1031] Object TRAFODION.FEATURES_LOB_TEST007.MYTABLE could not be
dropped. [2016-10-12 13:00:01]
*** ERROR[1073] Schema TRAFODION.FEATURES_LOB_TEST007 was partially dropped,
call CLEANUP SCHEMA to remove remaining entries. [2016-10-12 13:00:01]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
