db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5279) test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
Date Thu, 16 Jun 2011 08:15:49 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13050278#comment-13050278
] 

Knut Anders Hatlen commented on DERBY-5279:
-------------------------------------------

This sounds similar to the problems we saw in this test after DERBY-4874. TriggerTests.basicSetup()
ignores all exceptions thrown by DROP TABLE statements on the assumption that they indicate
that the table already exists. In DERBY-4874 one of the statements failed because of a lock
timeout (lock conflict with the post-commit thread), so the table actually existed, and the
CREATE TABLE statement failed.

To investigate this, you may want to make basicSetup() on the 10.3 branch report unexpected
exceptions from the DROP TABLE statements (on trunk we use a helper method in BaseJDBCTestCase
for this), and if the problem is a lock timeout, check what the lock timeout is when the test
is running (tests running earlier may have lowered the timeout without restoring it).

> test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
> --------------------------------------------------------------------
>
>                 Key: DERBY-5279
>                 URL: https://issues.apache.org/jira/browse/DERBY-5279
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.3.3.1
>         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)
> ------------------------------------------------------
>            Reporter: Mike Matrigali
>
> 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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message