Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
10.6.1.0
-
None
-
Regression Test Failure
Description
Seen since 2009-09-03. Possibly related to DERBY-4284 / svn 811009?
See e.g. http://dbtg.foundry.sun.com/derby/test/Daily/javaME/testing/testlog/ubuntu/820325-suitesAll_diff.txt
20) testCreateWithSchemaDropWithNoSchema(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'ALPHA_SEQ' already exists.
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.SequenceTest.testCreateWithSchemaDropWithNoSchema(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 sun.misc.CVM.runMain(Unknown Source)
Caused by: ERROR X0Y68: Sequence 'ALPHA_SEQ' already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.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)
... 55 more
21) testCreateWithSchemaSpecifiedCreateTrue(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'ALPHA_SEQ' already exists.
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.SequenceTest.testCreateWithSchemaSpecifiedCreateTrue(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 sun.misc.CVM.runMain(Unknown Source)
Caused by: ERROR X0Y68: Sequence 'ALPHA_SEQ' already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.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)
... 55 more
22) testCreateWithSchemaSpecified(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'ALPHA_SEQ' already exists.
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.SequenceTest.testCreateWithSchemaSpecified(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 sun.misc.CVM.runMain(Unknown Source)
Caused by: ERROR X0Y68: Sequence 'ALPHA_SEQ' already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.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)
... 55 more
23) testImplicitSchemaCreation(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'ALPHA_SEQ' already exists.
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.SequenceTest.testImplicitSchemaCreation(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 sun.misc.CVM.runMain(Unknown Source)
Caused by: ERROR X0Y68: Sequence 'ALPHA_SEQ' already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.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)
... 55 more
24) testDropSequence(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'MYSEQ1' already exists.
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.SequenceTest.testDropSequence(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 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 junit.extensions.TestDecorator.basicRun(Unknown Source)
at junit.extensions.TestSetup$1.protect(Unknown Source)
at junit.extensions.TestSetup.run(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 sun.misc.CVM.runMain(Unknown Source)
Caused by: ERROR X0Y68: Sequence 'MYSEQ1' already exists.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.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)
... 55 more
Attachments
Attachments
Issue Links
- is related to
-
DERBY-712 Support for sequences
- Closed