db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5279) test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
Date Thu, 16 Jun 2011 18:56:47 GMT

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

Mamta A. Satoor commented on DERBY-5279:
----------------------------------------

Knut, what a coincidence. I am just getting ready to checkin the changes where while dropping
the table, we only ignore table not found error and pass the rest of the errors to the test
so the failure exception will show us what kind of error drop table received. For some reason,
we backported this change all the way to 10.4 but not to 10.3

> 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