db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5279) test5DeleteBeforeTriggerNoReferencingClause fails in nightly testing
Date Tue, 21 Jun 2011 16:11:47 GMT

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

Mike Matrigali commented on DERBY-5279:
---------------------------------------

The test failed again after putting in the new diagnostics.  I see it is fails with a lock
timeout.

http://dbtg.foundry.sun.com/derby/test/tinderbox_10.3_16/jvm1.6/testing/testlog/SunOS-5.10_i86pc-i386/1136736-org.apache.derbyTesting.functionTests.suites.All_diff.txt

There were 2 failures:
1) test5DeleteBeforeTriggerNoReferencingClause(org.apache.derbyTesting.functionTests.tests.memory.TriggerTests)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<4[2Y55]> but was:<4[0XL1]>
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:651)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:700)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:832)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:813)
	at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.basicSetup(TriggerTests.java:245)
	at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.test5DeleteBeforeTriggerNoReferencingClause(TriggerTests.java:1231)
	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.SQLTransactionRollbackException: A lock could not be obtained within the
time requested
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:88)
	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.executeUpdate(EmbedStatement.java:176)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:830)
	... 34 more
Caused by: java.sql.SQLException: A lock could not be obtained within the time requested
	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)
	... 43 more
Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:280)
	at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:602)
	at org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
	at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
	at org.apache.derby.impl.store.raw.xact.ContainerLocking3.lockContainer(ContainerLocking3.java:64)
	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(BaseContainerHandle.java:809)
	at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:632)
	at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:572)
	at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1300)
	at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(OpenConglomerate.java:863)
	at org.apache.derby.impl.store.access.heap.Heap.open(Heap.java:686)
	at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java:486)
	at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java:1327)
	at org.apache.derby.impl.sql.execute.DDLConstantAction.lockTableForDDL(DDLConstantAction.java:135)
	at org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:164)
	at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
	... 37 more
2) test5UpdateAfterTriggerNoReferencingClause(org.apache.derbyTesting.functionTests.tests.memory.TriggerTests)junit.framework.ComparisonFailure:
Unexpected SQL state. expected:<4[2Y55]> but was:<4[0XL1]>
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:651)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:700)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:832)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:813)
	at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.basicSetup(TriggerTests.java:245)
	at org.apache.derbyTesting.functionTests.tests.memory.TriggerTests.test5UpdateAfterTriggerNoReferencingClause(TriggerTests.java:1246)
	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.SQLTransactionRollbackException: A lock could not be obtained within the
time requested
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:88)
	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.executeUpdate(EmbedStatement.java:176)
	at org.apache.derbyTesting.junit.BaseJDBCTestCase.dropTable(BaseJDBCTestCase.java:830)
	... 34 more
Caused by: java.sql.SQLException: A lock could not be obtained within the time requested
	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)
	... 43 more
Caused by: ERROR 40XL1: A lock could not be obtained within the time requested
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:280)
	at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(ConcurrentLockSet.java:602)
	at org.apache.derby.impl.services.locks.AbstractPool.lockObject(AbstractPool.java:117)
	at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(ConcurrentPool.java:28)
	at org.apache.derby.impl.store.raw.xact.ContainerLocking3.lockContainer(ContainerLocking3.java:64)
	at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(BaseContainerHandle.java:809)
	at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:632)
	at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:572)
	at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1300)
	at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(OpenConglomerate.java:863)
	at org.apache.derby.impl.store.access.heap.Heap.open(Heap.java:686)
	at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java:486)
	at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java:1327)
	at org.apache.derby.impl.sql.execute.DDLConstantAction.lockTableForDDL(DDLConstantAction.java:135)
	at org.apache.derby.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:164)
	at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:370)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1203)
	... 37 more



> 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
>            Assignee: Mamta A. Satoor
>
> 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