[ https://issues.apache.org/jira/browse/DERBY-4392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761434#action_12761434 ]
Dag H. Wanvik commented on DERBY-4392: -------------------------------------- I think fixture execution order is the issue here too, as in DERBY-4393. > "Table/View / Constraint already exists in Schema 'APP'" in > lang.CheckConstraintTest on phoneME/cvm > --------------------------------------------------------------------------------------------------- > > Key: DERBY-4392 > URL: https://issues.apache.org/jira/browse/DERBY-4392 > Project: Derby > Issue Type: Bug > Components: Test > Affects Versions: 10.6.0.0 > Environment: OS: > Linux .... 32bits > Linux 2.6.22-14-generic #1 SMP Sun Oct 14 23:05:12 GMT 2007 GNU/Linux > JVM: > Product: phoneME Advanced (phoneme_advanced_mr2-b116) > Profile: Foundation Profile Specification 1.1 > JVM: CVM phoneme_advanced_mr2-b116 (interpreter loop) > Reporter: Ole Solberg > > Seen since 2009-07-03. Possibly related to DERVY-4248 / svn 796893? > See e.g. > http://dbtg.foundry.sun.com/derby/test/Daily/javaME/testing/testlog/ubuntu/820325-suitesAll_diff.txt > 1) > testPositionalUpdate(org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest)java.sql.SQLException: > Table/View 'T1' already exists in Schema 'APP'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown > Source) > at > org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest.testPositionalUpdate(Unknown > Source) > at org.apache.derbyTesting.junit.BaseTestCase.runBare(Unknown Source) > at junit.extensions.TestDecorator.basicRun(Unknown Source) > at junit.extensions.TestSetup$1.protect(Unknown Source) > at junit.extensions.TestSetup.run(Unknown Source) > at org.apache.derbyTesting.junit.BaseTestSetup.run(Unknown Source) > at sun.misc.CVM.runMain(Unknown Source) > Caused by: ERROR X0Y32: Table/View 'T1' already exists in Schema 'APP'. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown > Source) > at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) > at > org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown > Source) > ... 32 more > 2) > testCheckConstraints(org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest)java.sql.SQLException: > Constraint 'ASDF' already exists in Schema 'APP'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown > Source) > at > org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest.testCheckConstraints(Unknown > Source) > at org.apache.derbyTesting.junit.BaseTestCase.runBare(Unknown Source) > at junit.extensions.TestDecorator.basicRun(Unknown Source) > at junit.extensions.TestSetup$1.protect(Unknown Source) > at junit.extensions.TestSetup.run(Unknown Source) > at org.apache.derbyTesting.junit.BaseTestSetup.run(Unknown Source) > at sun.misc.CVM.runMain(Unknown Source) > Caused by: ERROR X0Y32: Constraint 'ASDF' already exists in Schema 'APP'. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addConstraintDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.execute.CreateConstraintConstantAction.executeConstantAction(Unknown > Source) > at > org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown > Source) > at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) > at > org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown > Source) > ... 32 more > 3) > testNotAllowedInCheckConstraints(org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest)java.sql.SQLException: > Table/View 'T1' already exists in Schema 'APP'. > at > org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown > Source) > at > org.apache.derbyTesting.functionTests.tests.lang.CheckConstraintTest.testNotAllowedInCheckConstraints(Unknown > Source) > at org.apache.derbyTesting.junit.BaseTestCase.runBare(Unknown Source) > at junit.extensions.TestDecorator.basicRun(Unknown Source) > at junit.extensions.TestSetup$1.protect(Unknown Source) > at junit.extensions.TestSetup.run(Unknown Source) > at org.apache.derbyTesting.junit.BaseTestSetup.run(Unknown Source) > at sun.misc.CVM.runMain(Unknown Source) > Caused by: ERROR X0Y32: Table/View 'T1' already exists in Schema 'APP'. > at org.apache.derby.iapi.error.StandardException.newException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown > Source) > at > org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown > Source) > at > org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown > Source) > at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source) > at > org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown > Source) > ... 32 more -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.