Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5691

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

    XMLWordPrintableJSON

Details

    • Normal
    • High Value Fix, Workaround attached
    • 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
          Camilla Haase
        2. DERBY-5691-6.stat
          0.0 kB
          Camilla Haase
        3. DERBY-5691-6.diff
          1 kB
          Camilla Haase
        4. DERBY-5691-5.zip
          9 kB
          Camilla Haase
        5. DERBY-5691-5.diff
          8 kB
          Camilla Haase
        6. DERBY-5691-4.zip
          9 kB
          Camilla Haase
        7. DERBY-5691-4.diff
          8 kB
          Camilla Haase
        8. DERBY-5691-3.zip
          9 kB
          Camilla Haase
        9. DERBY-5691-3.diff
          8 kB
          Camilla Haase
        10. DERBY-5691-2.zip
          9 kB
          Camilla Haase
        11. DERBY-5691-2.stat
          0.2 kB
          Camilla Haase
        12. DERBY-5691-2.diff
          8 kB
          Camilla Haase
        13. DERBY-5691.zip
          5 kB
          Camilla Haase
        14. DERBY-5691.stat
          0.1 kB
          Camilla Haase
        15. DERBY-5691.diff
          5 kB
          Camilla Haase

        Activity

          People

            chaase3 Camilla Haase
            stan Sun Seng David Tan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: