[DERBY-5279] test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.3.1
• Fix Version/s: 10.3.3.1
• Component/s: Test

Environment

failing in posted 10.3 tinderbox on sun jvm:
org.apache.derbyTesting.functionTests.suites.All diff -------------------------------------------------------------
------------------ Java Information ------------------
Java Version: 1.6.0_18
Java Vendor: Sun Microsystems Inc.
Java home: /usr/local/java/jdk1.6.0_18/jre
Java classpath: /home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derby.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyclient.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbytools.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbynet.jar:/home/os136789/Apache/TinderBox-10.3/db2jcc/lib/db2jcc.jar:/home/os136789/Apache/TinderBox-10.3/db2jcc/lib/db2jcc_license_c.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyTesting.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyrun.jar:/home/os136789/Apache/TinderBox-10.3/10.3/tools/java/jakarta-oro-2.0.8.jar:/home/os136789/Apache/TinderBox-10.3/10.3/tools/java/junit.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_de_DE.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_es.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_fr.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_it.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_ja_JP.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_ko_KR.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_pt_BR.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_zh_CN.jar:/home/os136789/Apache/TinderBox-10.3/10.3/jars/insane/derbyLocale_zh_TW.jar:/usr/local/share/java/xalan/serializer.jar:/usr/local/share/java/xalan/xalan.jar:/usr/local/share/java/xalan/xercesImpl.jar:/usr/local/share/java/xalan/xml-apis.jar:/usr/local/share/java/xalan/xsltc.jar
OS name: SunOS
OS architecture: x86
OS version: 5.10
Java user name: os136789
Java user home: /home/os136789
Java user dir: /export/home/tmp/os136789/testingDerbyTinderBox-10.3/SunOS-5.10_i86pc-i386/org.apache.derbyTesting.functionTests.suites.All
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/export/home/tmp/os136789/10.3/jars/insane/derby.jar] 10.3.3.1 - (1055890)
[/export/home/tmp/os136789/10.3/jars/insane/derbytools.jar] 10.3.3.1 - (1055890)
[/export/home/tmp/os136789/10.3/jars/insane/derbynet.jar] 10.3.3.1 - (1055890)
[/export/home/tmp/os136789/10.3/jars/insane/derbyclient.jar] 10.3.3.1 - (1055890)
[/home/os136789/Apache/TinderBox_Derby/db2jcc/lib/db2jcc.jar] 2.4 - (17)
[/home/os136789/Apache/TinderBox_Derby/db2jcc/lib/db2jcc_license_c.jar] 2.4 - (17)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.3.3.1 - (1055890)
Found support for locale: [de_DE]
version: 10.3.3.1 - (1055890)
Found support for locale: [es]
version: 10.3.3.1 - (1055890)
Found support for locale: [fr]
version: 10.3.3.1 - (1055890)
Found support for locale: [hu]
version: 10.3.3.1 - (1055890)
Found support for locale: [it]
version: 10.3.3.1 - (1055890)
Found support for locale: [ja_JP]
version: 10.3.3.1 - (1055890)
Found support for locale: [ko_KR]
version: 10.3.3.1 - (1055890)
Found support for locale: [pl]
version: 10.3.3.1 - (1055890)
Found support for locale: [pt_BR]
version: 10.3.3.1 - (1055890)
Found support for locale: [ru]
version: 10.3.3.1 - (1055890)
Found support for locale: [zh_CN]
version: 10.3.3.1 - (1055890)
Found support for locale: [zh_TW]
version: 10.3.3.1 - (1055890)
------------------------------------------------------

• Bug behavior facts: Regression Test Failure
• Assignee: Mamta A. Satoor
• Reporter: Mike Matrigali
• Created: 15/Jun/11 17:43
• Updated: 19/Jun/13 17:19
• Resolved: 04/Sep/12 16:35

Description

The following has failed in a number of tinderbox runs, but not always. For example it has failed as reported in:
http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1055890-org.apache.derbyTesting.functionTests.suites.All_diff.txt
But not fail in the subsequent run:
http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1056412-derbyall_diff.txt
But then fails again in the most recent run:
http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1135825-org.apache.derbyTesting.functionTests.suites.All_diff.txt
There was 1 error:
1) test5DeleteBeforeTriggerNoReferencingClause(org.apache.derbyTesting.functionTests.tests.memory.TriggerTests)java.sql.SQLException: Table/View 'TABLE1' already exists in Schema 'APP'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:202)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1593)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1294)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:596)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:528)
at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.basicSetup(TriggerTests.java:267)
at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.test5DeleteBeforeTriggerNoReferencingClause(TriggerTests.java:1221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:99)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
Caused by: java.sql.SQLException: Table/View 'TABLE1' already exists in Schema 'APP'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:135)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
... 41 more
Caused by: ERROR X0Y32: Table/View 'TABLE1' already exists in Schema 'APP'.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:371)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(DataDictionaryImpl.java:1683)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:1674)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(DataDictionaryImpl.java:1653)
at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(CreateTableConstantAction.java:238)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
... 35 more