db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-4393) lang.SequenceTest fails w/ "Sequence 'ALPHA_SEQ' already exists." on phoneME/cvm
Date Tue, 06 Oct 2009 13:53:31 GMT

    [ 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.


Mime
View raw message