You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ole Solberg (JIRA)" <ji...@apache.org> on 2009/10/01 13:34:23 UTC

[jira] Created: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
--------------------------------------------------------------------------------

                 Key: DERBY-4393
                 URL: https://issues.apache.org/jira/browse/DERBY-4393
             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-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


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg reassigned DERBY-4393:
----------------------------------

    Assignee: Ole Solberg

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kathey Marsden updated DERBY-4393:
----------------------------------

    Fix Version/s: 10.6.0.0

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Issue & fix info:   (was: [Patch Available])

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Attachment: DERBY-4393_4.diff.txt

DERBY-4393_4.diff.txt replaces DERBY-4393_3.diff.txt.
Still has the cleanup logic in the testcase, but uses a more "symmetric" approach.
I found creating a tearDown difficult for this suite - but I may be missing something.

The 'new CleanDatabaseTestSetup(suite) { ... }' idiom is already used so after the suite is done everything should be clean, even if some testcase in the suite does not behave well.


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Attachment: DERBY-4393_2.diff.txt

DERBY-4393_2.diff.txt replaces DERBY-4393_1.diff.txt:
adding cleanup in  'testDuplicateCreationFailure()'.

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12761431#action_12761431 ] 

Dag H. Wanvik commented on DERBY-4393:
--------------------------------------

It seems the success of this test is dependent on the order of the fixtures:

testDropOtherSchemaSequence faisl to drop alpha.alpha_seq, so if that fixture is run *before*
testCreateWithSchemaDropWithNoSchema, the latter would fail as seen.


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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-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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762442#action_12762442 ] 

Dag H. Wanvik commented on DERBY-4393:
--------------------------------------

I like the idiom of the 

new CleanDatabaseTestSetup(suite) {
            /**
             * Creates the tables used in the test cases.
             * @exception SQLException if a database error occurs
             */
            protected void decorateSQL(Statement s) throws SQLException {
                  // DDL
            }
        }

since, then the cleanup is automatic after each fixture and no convention is needed.

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Issue & fix info: [Patch Available]

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg closed DERBY-4393.
------------------------------


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762185#action_12762185 ] 

Rick Hillegas commented on DERBY-4393:
--------------------------------------

This is a familiar problem on the phoneME platform, where the tests run in the opposite order that they run on other VMs. When I write test cases, I tackle this problem by putting some unique identifier in the name of the test case and then incorporating that identifier into the names of all the schema objects referenced by the test case. This is a simple way to guarantee that the object names won't collide if the tests run in a different order.

So for instance, the first test case would look like this:

    public void test_01_CreateSequence() throws SQLException {
        Statement s = createStatement();
        s.executeUpdate("CREATE SEQUENCE mySeq_01");
    }

An alternative solution would be to put some logic in the tearDown() method to destroy the schemas created by the test cases.

I don't recommend putting cleanup logic in the test cases themselves. That approach is brittle because a test case can fail before it gets to its cleanup logic. The previous two approaches don't have this problem.


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg resolved DERBY-4393.
--------------------------------

    Resolution: Fixed

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762986#action_12762986 ] 

Ole Solberg commented on DERBY-4393:
------------------------------------

DERBY-4393_4.diff.txt committed to trunk as revision 822641.

> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt, DERBY-4393_4.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Attachment: DERBY-4393_1.diff.txt

Partial patch. Cleanup (drop) for "CREATE SEQUENCE alpha_seq".
Does NOT fix the *failure* in SequenceTest on phoneME/cvm:
There was 1 failure:
1) testCreateOtherSchemaSequence(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<4250[7]> but was:<4250[8]>


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Ole Solberg (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ole Solberg updated DERBY-4393:
-------------------------------

    Attachment: DERBY-4393_3.diff.txt

DERBY-4393_3.diff.txt replaces DERBY-4393_2.diff.txt.

This patch also fixes the 
'1) testCreateOtherSchemaSequence(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)junit.framework.ComparisonFailure: Unexpected SQL state. expected:<4250[7]> but was:<4250[8]> '
problem by forcing the 'ALPHA' schema to be created/existing when testCreateOtherSchemaSequence is run.


> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Issue Comment Edited: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm

Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12762442#action_12762442 ] 

Dag H. Wanvik edited comment on DERBY-4393 at 10/6/09 6:53 AM:
---------------------------------------------------------------

I like the idiom of the 

new CleanDatabaseTestSetup(suite) {
            /**
             * Creates the tables used in the test cases.
             * @exception SQLException if a database error occurs
             */
            protected void decorateSQL(Statement s) throws SQLException {
                  // DDL
            }
        }

since, then the cleanup is automatic after each fixture and no convention is needed.

* Edited 2009-10-06: Correction: The cleanup happens only after the _entire test_ has been run, so it does not solve the problem of the test cases inside one test messing up for each other. Another option is to set autocommit off and then never commit inside a test case. The teardown method will roll back any changes made (Knut's suggestion, thx). *

      was (Author: dagw):
    I like the idiom of the 

new CleanDatabaseTestSetup(suite) {
            /**
             * Creates the tables used in the test cases.
             * @exception SQLException if a database error occurs
             */
            protected void decorateSQL(Statement s) throws SQLException {
                  // DDL
            }
        }

since, then the cleanup is automatic after each fixture and no convention is needed.
  
> lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-4393
>                 URL: https://issues.apache.org/jira/browse/DERBY-4393
>             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
>            Assignee: Ole Solberg
>         Attachments: DERBY-4393_1.diff.txt, DERBY-4393_2.diff.txt, DERBY-4393_3.diff.txt
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.