Derby
  1. Derby
  2. DERBY-5638

intermittent test failure in test_05_ClobNegative when running full largedata._Suite; LobLimitsTestjava.sql.SQLException: Table/View 'BLOBTBL' already exists in Schema 'APP'.

    Details

    • Urgency:
      Normal
    • Bug behavior facts:
      Regression Test Failure

      Description

      I've seen the following failure when running the largedata suite:

      (emb)largedata.Derby5624Test.testDERBY_5624 used 518403 ms .
      (emb)largedata.LobLimitsTest.test_01_Blob used 2422 ms .
      (emb)largedata.LobLimitsTest.test_02_BlobNegative used 31 ms .
      (emb)largedata.LobLimitsTest.test_03_Clob1 used 2375 ms .
      (emb)largedata.LobLimitsTest.test_04_Clob2 used 3234 ms .
      (emb)largedata.LobLimitsTest.test_05_ClobNegative used 516 ms .
      (net)largedata.LobLimitsTest.test_01_Blob used 5360 ms .
      (net)largedata.LobLimitsTest.test_02_BlobNegative used 32 ms .
      (net)largedata.LobLimitsTest.test_03_Clob1 used 2078 ms .
      (net)largedata.LobLimitsTest.test_04_Clob2 used 2390 ms .
      (net)largedata.LobLimitsTest.test_05_ClobNegative used 938 ms .
      (emb)largedata.LobLimitsTest.test_01_Blob used 9188238 ms .
      (emb)largedata.LobLimitsTest.test_02_BlobNegative used 109 ms .
      (emb)largedata.LobLimitsTest.test_03_Clob1 used 8116714 ms .
      (emb)largedata.LobLimitsTest.test_04_Clob2 used 2164002 ms .
      (emb)largedata.LobLimitsTest.test_05_ClobNegative used 685745 ms E
      Time: 22,320.138
      There was 1 error:
      1) LobLimitsTestjava.sql.SQLException: Table/View 'BLOBTBL' already exists in Schema 'APP'.
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.Statement.execute(Unknown Source)
      at org.apache.derbyTesting.functionTests.tests.largedata.LobLimitsTest.setupTables(LobLimitsTest.java:107)
      at org.apache.derbyTesting.functionTests.tests.largedata.LobLimitsTest$1.decorateSQL(LobLimitsTest.java:141)
      at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.setUp(CleanDatabaseTestSetup.java:112)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:20)
      at junit.extensions.TestSetup.run(TestSetup.java:25)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
      at junit.extensions.TestSetup.run(TestSetup.java:25)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
      at junit.extensions.TestSetup.run(TestSetup.java:25)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
      at junit.extensions.TestSetup.run(TestSetup.java:25)
      Caused by: org.apache.derby.client.am.SqlException: Table/View 'BLOBTBL' already exists in Schema 'APP'.
      at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
      at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
      at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
      at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
      at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
      at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
      at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
      at org.apache.derby.client.am.Statement.executeX(Unknown Source)
      ... 26 more

      Unfortunately, when this happens, there seems to be no 'fail' directory created. The derby.log in the system directory looks very innocent (just some start up and shutting down of the database), and the serverConsoleOutput.log only has the typical 'failed to find db 'wombat' messages'.

      Note, when this happens, the suite exits, so that instead of the expected 20 (or 21 on windows, see DERBY-5624 for reason for skipping on Linux default installs with 1024 max open files) we only get 15 (or 16) tests run - if the test doesn't fail it goes on to run the last 5 fixtures again for network server.

      1. derbyFailed.log
        164 kB
        Mamta A. Satoor
      2. derbyPass.log
        188 kB
        Mamta A. Satoor
      3. DERBY5638_patch1_diff.txt
        1 kB
        Mamta A. Satoor
      4. derbyWithRollbackInTest_05.log
        178 kB
        Mamta A. Satoor
      5. runallWithPrintlnTrace.out
        19 kB
        Mamta A. Satoor
      6. DERBY5638_patch2_diff.txt
        3 kB
        Mamta A. Satoor
      7. runallForSuccessfulLargeDataRun.out
        1 kB
        Mamta A. Satoor
      8. CompleteRunallWithPrintlnTrace.out
        26 kB
        Mamta A. Satoor
      9. derbyallFailWithPrintlnTrace.log
        164 kB
        Mamta A. Satoor

        Issue Links

          Activity

          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12655549 ] Default workflow, editable Closed status [ 12802127 ]
          Kathey Marsden made changes -
          Fix Version/s 10.8.3.0 [ 12323456 ]
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Myrna van Lunteren made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Assignee Myrna van Lunteren [ myrna ] Mamta A. Satoor [ mamtas ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Labels derby_triage10_9 derby_backport_reject_10_7 derby_triage10_9
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.3 [ 12318540 ]
          Myrna van Lunteren made changes -
          Assignee Mamta A. Satoor [ mamtas ] Myrna van Lunteren [ myrna ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-5923 [ DERBY-5923 ]
          Mamta A. Satoor made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Mamta A. Satoor made changes -
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Mamta A. Satoor made changes -
          Labels derby_triage10_9
          Urgency Normal [ 10052 ]
          Mamta A. Satoor made changes -
          Attachment derbyallFailWithPrintlnTrace.log [ 12517803 ]
          Mamta A. Satoor made changes -
          Attachment CompleteRunallWithPrintlnTrace.out [ 12517789 ]
          Mamta A. Satoor made changes -
          Attachment runallForSuccessfulLargeDataRun.out [ 12517780 ]
          Mamta A. Satoor made changes -
          Attachment runallWithPrintlnTrace.out [ 12517778 ]
          Attachment DERBY5638_patch2_diff.txt [ 12517779 ]
          Mamta A. Satoor made changes -
          Assignee Mamta A. Satoor [ mamtas ]
          Mamta A. Satoor made changes -
          Attachment derbyWithRollbackInTest_05.log [ 12517756 ]
          Mamta A. Satoor made changes -
          Attachment DERBY5638_patch1_diff.txt [ 12517637 ]
          Mamta A. Satoor made changes -
          Field Original Value New Value
          Attachment derbyFailed.log [ 12517575 ]
          Attachment derbyPass.log [ 12517576 ]
          Myrna van Lunteren created issue -

            People

            • Assignee:
              Mamta A. Satoor
              Reporter:
              Myrna van Lunteren
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development