Uploaded image for project: '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.

        Attachments

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

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: