Derby
  1. Derby
  2. DERBY-5691

Document that Write Caching must be disabled to avoid possible database corruption

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      High Value Fix, Workaround attached
    • Bug behavior facts:
      Data corruption

      Description

      Suggestion that we document a recommendation that Windows Write Caching be disabled on machines using Derby.

      The following article warns about Write Caching on Windows as a possbile source of database corruption:
      http://support.microsoft.com/kb/281672
      It is possible that this could be the cause of some unexplained Derby corruptions identified after power failure of other system interupt.

      Links explaining how to disable Write Caching:
      Win 2K: http://support.microsoft.com/kb/259716
      Win 2008: http://support.microsoft.com/kb/324805

      From the Windows 2008 article:
      With some third-party programs, disk write caching has to be turned on or off. Additionally, turning disk write caching on may increase operating system performance; however, it may also result in the loss of information if a power failure, equipment failure, or software failure occurs. This article describes how to turn disk write caching on or off.

      1. DERBY-5691-6.stat
        0.0 kB
        Kim Haase
      2. DERBY-5691-6.diff
        1 kB
        Kim Haase
      3. DERBY-5691-5.zip
        9 kB
        Kim Haase
      4. DERBY-5691-5.diff
        8 kB
        Kim Haase
      5. DERBY-5691-4.zip
        9 kB
        Kim Haase
      6. DERBY-5691-4.diff
        8 kB
        Kim Haase
      7. DERBY-5691-3.zip
        9 kB
        Kim Haase
      8. DERBY-5691-3.diff
        8 kB
        Kim Haase
      9. DERBY-5691-2.zip
        9 kB
        Kim Haase
      10. DERBY-5691-2.stat
        0.2 kB
        Kim Haase
      11. DERBY-5691-2.diff
        8 kB
        Kim Haase
      12. DERBY-5691.zip
        5 kB
        Kim Haase
      13. DERBY-5691.stat
        0.1 kB
        Kim Haase
      14. DERBY-5691.diff
        5 kB
        Kim Haase
      15. cadmindbintegrity.html
        7 kB
        Kim Haase

        Activity

        Gavin made changes -
        Workflow jira [ 12662645 ] Default workflow, editable Closed status [ 12802145 ]
        Kathey Marsden made changes -
        Fix Version/s 10.8.3.0 [ 12323456 ]
        Fix Version/s 10.8.2.3 [ 12318540 ]
        Kim Haase made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kim Haase made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Issue & fix info High Value Fix,Patch Available,Workaround attached [ 10422, 10102, 10427 ] High Value Fix,Workaround attached [ 10422, 10427 ]
        Resolution Fixed [ 1 ]
        Kim Haase made changes -
        Issue & fix info High Value Fix,Workaround attached [ 10422, 10427 ] High Value Fix,Patch Available,Workaround attached [ 10422, 10102, 10427 ]
        Kim Haase made changes -
        Attachment DERBY-5691-6.diff [ 12528637 ]
        Attachment DERBY-5691-6.stat [ 12528638 ]
        Attachment cadmindbintegrity.html [ 12528639 ]
        Kim Haase made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Kim Haase made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Issue & fix info High Value Fix,Patch Available,Workaround attached [ 10422, 10102, 10427 ] High Value Fix,Workaround attached [ 10422, 10427 ]
        Fix Version/s 10.8.2.3 [ 12318540 ]
        Fix Version/s 10.9.0.0 [ 12316344 ]
        Resolution Fixed [ 1 ]
        Kim Haase made changes -
        Attachment DERBY-5691-5.diff [ 12528437 ]
        Attachment DERBY-5691-5.zip [ 12528438 ]
        Kim Haase made changes -
        Attachment DERBY-5691-4.diff [ 12528089 ]
        Attachment DERBY-5691-4.zip [ 12528090 ]
        Kim Haase made changes -
        Attachment DERBY-5691-3.diff [ 12525887 ]
        Attachment DERBY-5691-3.zip [ 12525888 ]
        Kim Haase made changes -
        Attachment DERBY-5691-2.diff [ 12524867 ]
        Attachment DERBY-5691-2.stat [ 12524868 ]
        Attachment DERBY-5691-2.zip [ 12524869 ]
        Kim Haase made changes -
        Issue & fix info Workaround attached,High Value Fix [ 10427,10422 ] High Value Fix,Patch Available,Workaround attached [ 10422,10102,10427 ]
        Kim Haase made changes -
        Attachment DERBY-5691.diff [ 12523377 ]
        Attachment DERBY-5691.stat [ 12523378 ]
        Attachment DERBY-5691.zip [ 12523379 ]
        Kim Haase made changes -
        Assignee Kim Haase [ chaase3 ]
        Kathey Marsden made changes -
        Field Original Value New Value
        Summary Recommend disabling Write Caching for on Windows Document that Write Caching must be disabled to avoid possible database corruption
        Stan Bradbury created issue -

          People

          • Assignee:
            Kim Haase
            Reporter:
            Stan Bradbury
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development