You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Andreas Resch (JIRA)" <ji...@apache.org> on 2014/08/28 15:56:09 UTC

[jira] [Comment Edited] (DERBY-6718) Database corruption

    [ https://issues.apache.org/jira/browse/DERBY-6718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14113735#comment-14113735 ] 

Andreas Resch edited comment on DERBY-6718 at 8/28/14 1:54 PM:
---------------------------------------------------------------

Hi Rick, thanks for the fast response and the link to the other task. 
I will try this but after reading the task i have one more question.

You write in DERBY-6425 :
> [...] We do not recommend running Derby with the write-cache enabled. 
> In that situation, Derby has no guarantee that the data it wrote actually made 
> it to disk. Going forward, you should always run Derby with the write-cache disabled [...]

As i know the write cache is enabled by default on windows client and server systems. We have a lot of applications with derby running at many differnt sites. I'am afraid to tell all of them to turn the write cache off? Is this also necessary with other dbms systems like SQLServer, Oracle or DB2? 

update:
Seems like these system also recommend this except special designed cache controls for database disks.


was (Author: antimaterie):
Hi Rick, thanks for the fast response and the link to the other task. 
I will try this but after reading the task i have one more question.

You write in DERBY-6425 :
> [...] We do not recommend running Derby with the write-cache enabled. 
> In that situation, Derby has no guarantee that the data it wrote actually made 
> it to disk. Going forward, you should always run Derby with the write-cache disabled [...]

As i know the write cache is enabled by default on windows client and server systems. We have a lot of applications with derby running at many differnt sites. I'am afraid to tell all of them to turn the write cache off? Is this also necessary with other dbms systems like SQLServer, Oracle or DB2?

> Database corruption
> -------------------
>
>                 Key: DERBY-6718
>                 URL: https://issues.apache.org/jira/browse/DERBY-6718
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.9.1.0
>         Environment: Apache Derby: 10.9.1.0 (1344872), java.version=1.6.0_17 
>            Reporter: Andreas Resch
>         Attachments: derby-6718-obfuscated.log
>
>




--
This message was sent by Atlassian JIRA
(v6.2#6252)