Derby
  1. Derby
  2. DERBY-5119

testQualifiers(org.apache.derbyTesting.functionTests.tests.store.AccessTest)java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.1.2
    • Component/s: Test
    • Labels:
      None
    • Environment:
      IBM 1.6 Windows 2011-03-08
       10.8.0.1 alpha - (1079643)
    • Bug behavior facts:
      Regression Test Failure

      Description

      1) testQualifiers(org.apache.derbyTesting.functionTests.tests.store.AccessTest)java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'.
      at java.lang.Throwable.<init>(Throwable.java:80)
      at java.sql.SQLException.<init>(SQLException.java:153)
      at java.sql.SQLException.<init>(SQLException.java:176)
      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.store.AccessTest.testQualifiers(AccessTest.java:1807)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
      at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:112)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:16)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:23)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:51)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
      at junit.extensions.TestSetup.run(TestSetup.java:16)
      Caused by: java.sql.SQLException: Table/View 'FOO' already exists in Schema 'APP'.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      ... 47 more
      Caused by: ERROR X0Y32: Table/View 'FOO' already exists in Schema 'APP'.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.duplicateDescriptorException(Unknown Source)
      at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.addDescriptor(Unknown Source)
      at org.apache.derby.impl.sql.execute.CreateTableConstantAction.executeConstantAction(Unknown Source)
      at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      ... 41 more

      Note this was followed by another failure DERBY-4550. Not sure if the failure to create the table might have impacted that test.

        Issue Links

          Activity

          Hide
          Rick Hillegas added a comment -

          Linking this to an already resolved bug, DERBY-4523. Do you have a log of the order in which the test cases executed? The test seems to assume that cases will execute in the order that they appear in the source file, but JUnit does not guarantee this. This kind of error sometimes flags an instability in the order of test cases.

          Show
          Rick Hillegas added a comment - Linking this to an already resolved bug, DERBY-4523 . Do you have a log of the order in which the test cases executed? The test seems to assume that cases will execute in the order that they appear in the source file, but JUnit does not guarantee this. This kind of error sometimes flags an instability in the order of test cases.
          Hide
          Kathey Marsden added a comment - - edited

          In this test most fixtures create and later drop the table foo. If any of the prior fixtures fail. On this day testCaseCS4595B_NonUniqueIndex DERBY-4540, then the subsequent fixture will fail trying to create table foo.

          I think I will just add to the teardown method to drop foo if it exists, so the fixtures don't impact each other.

          Show
          Kathey Marsden added a comment - - edited In this test most fixtures create and later drop the table foo. If any of the prior fixtures fail. On this day testCaseCS4595B_NonUniqueIndex DERBY-4540 , then the subsequent fixture will fail trying to create table foo. I think I will just add to the teardown method to drop foo if it exists, so the fixtures don't impact each other.
          Hide
          Knut Anders Hatlen added a comment -

          [bulk update] Close all resolved issues that haven't been updated for more than one year.

          Show
          Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.

            People

            • Assignee:
              Unassigned
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development