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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2011/03/09 13:28:59 UTC

[jira] Updated: (DERBY-5116) SequenceTest fails with "Sequence 'MYSEQ1' already exists"

     [ https://issues.apache.org/jira/browse/DERBY-5116?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Knut Anders Hatlen updated DERBY-5116:
--------------------------------------

    Attachment: derby-5116-1a.diff

Three test cases create a sequence named MYSEQ1, but only two of them drop the sequence when they're finished.

The attached patch makes the third test case drop the sequence too, so that the other test cases won't fail if this one happens to run first.

> SequenceTest fails with "Sequence 'MYSEQ1' already exists"
> ----------------------------------------------------------
>
>                 Key: DERBY-5116
>                 URL: https://issues.apache.org/jira/browse/DERBY-5116
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.8.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>         Attachments: derby-5116-1a.diff
>
>
> SequenceTest fails intermittently on Java 7. Seems to be dependent on the order in which the test cases run.
> Example from the nightly tests:
> http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.7/testing/testlog/lin/1078515-suitesAll_diff.txt
> 1) test_02_DropSequence(org.apache.derbyTesting.functionTests.tests.lang.SequenceTest)java.sql.SQLException: Sequence 'MYSEQ1' already exists.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.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.test_02_DropSequence(SequenceTest.java:81)

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira