Derby
  1. Derby
  2. DERBY-5108

Intermittent failure in AutomaticIndexStatisticsTest.testShutdownWhileScanningThenDelete on Windows

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Blocker Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: Services
    • Labels:
      None
    • Environment:
      Windows platforms.
    • Urgency:
      Normal
    • Bug behavior facts:
      Regression, Regression Test Failure

      Description

      The test AutomaticIndexStatisticsTest.testShutdownWhileScanningThenDelete fails intermittently on Windows platforms because the test is unable to delete a database directory.
      Even after several retries and sleeps (the formula should be (attempt -1) * 2000, resulting in a total sleep time of 12 seconds), the conglomerate system\singleUse\copyShutdown\seg0\c481.dat cannot be deleted.

      For instance from http://dbtg.foundry.sun.com/derby/test/Daily/jvm1.6/testing/testlog/w2003/1078855-suitesAll_diff.txt :
      (truncated paths)
      testShutdownWhileScanningThenDelete <assertDirectoryDeleted> attempt 1 left 3 files/dirs behind: 0=system\singleUse\copyShutdown\seg0\c481.dat 1=system\singleUse\copyShutdown\seg0 2=system\singleUse\copyShutdown
      <assertDirectoryDeleted> attempt 2 left 3 files/dirs behind: 0=system\singleUse\copyShutdown\seg0\c481.dat 1=system\singleUse\copyShutdown\seg0 2=system\singleUse\copyShutdown
      <assertDirectoryDeleted> attempt 3 left 3 files/dirs behind: 0=system\singleUse\copyShutdown\seg0\c481.dat 1=system\singleUse\copyShutdown\seg0 2=system\singleUse\copyShutdown
      <assertDirectoryDeleted> attempt 4 left 3 files/dirs behind: 0=system\singleUse\copyShutdown\seg0\c481.dat 1=system\singleUse\copyShutdown\seg0 2=system\singleUse\copyShutdown
      used 205814 ms F.

      Maybe the database isn't shut down, or some specific timing of events causes a file to be reopened when it shouldn't have been (i.e. after the database shutdown has been initiated).

      1. waitOnShutdown.diff
        3 kB
        Knut Anders Hatlen
      2. javacore.20110309.125807.4048.0001.txt
        323 kB
        Mike Matrigali
      3. derby-5108-3a-istat_log_abort.diff
        1 kB
        Kristian Waagan
      4. derby-5108-2a-early_istats_shutdown_broad.diff
        3 kB
        Kristian Waagan
      5. derby-5108-2.diff
        1.0 kB
        Dag H. Wanvik
      6. derby-5108-1a-early_istats_shutdown.diff
        2 kB
        Kristian Waagan

        Issue Links

          Activity

          Kristian Waagan created issue -
          Kristian Waagan made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4915 [ DERBY-4915 ]
          Kristian Waagan made changes -
          Link This issue is related to DERBY-5026 [ DERBY-5026 ]
          Mike Matrigali made changes -
          Attachment javacore.20110309.125807.4048.0001.txt [ 12473202 ]
          Myrna van Lunteren made changes -
          Link This issue is related to DERBY-5123 [ DERBY-5123 ]
          Mike Matrigali made changes -
          Assignee Mike Matrigali [ mikem ]
          Mike Matrigali made changes -
          Bug behavior facts [Regression Test Failure] [Regression, Regression Test Failure]
          Priority Major [ 3 ] Blocker [ 1 ]
          Rick Hillegas made changes -
          Urgency Blocker
          Rick Hillegas made changes -
          Link This issue is related to DERBY-5131 [ DERBY-5131 ]
          Knut Anders Hatlen made changes -
          Attachment waitOnShutdown.diff [ 12473569 ]
          Rick Hillegas made changes -
          Urgency Blocker Normal
          Mike Matrigali made changes -
          Assignee Mike Matrigali [ mikem ]
          Dag H. Wanvik made changes -
          Attachment derby-5108-2.diff [ 12473929 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Patch Available]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Affects Version/s 10.8.1.0 [ 12315561 ]
          Rick Hillegas made changes -
          Affects Version/s 10.8.1.1 [ 12316356 ]
          Affects Version/s 10.8.1.2 [ 12316362 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Kristian Waagan made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Kristian Waagan made changes -
          Kristian Waagan made changes -
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Issue & fix info [Patch Available]
          Kristian Waagan made changes -
          Attachment derby-5108-3a-istat_log_abort.diff [ 12481795 ]
          Kristian Waagan made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kristian Waagan made changes -
          Fix Version/s 10.8.1.5 [ 12316676 ]
          Kristian Waagan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Myrna van Lunteren made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Myrna van Lunteren made changes -
          Component/s Services [ 11415 ]
          Component/s Test [ 11413 ]
          Myrna van Lunteren made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.2 [ 12317968 ]
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Gavin made changes -
          Workflow jira [ 12601062 ] Default workflow, editable Closed status [ 12801079 ]

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Kristian Waagan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development