View Issue Details

IDProjectCategoryView StatusLast Update
0003606SymmetricDSImprovementpublic2018-06-21 19:16
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.9.9 
Target Version3.9.9Fixed in Version3.9.9 
Summary0003606: H2 lost data from restart or power failure
DescriptionH2 uses caching for performance, which delays flushing to disk. This is a known documented issue explained here:

The recommendation is to set the WRITE DELAY to 0 and execute CHECKPOINT SYNC after a commit. This will help make the database more durable. We can put the WRITE DELAY on the default database URL during setup. On each commit() for a JdbcSqlTransaction, we can execute CHECKPOINT SYNC.
TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 d0916bef

2018-06-18 13:40:55


Details Diff
0003606: H2 lost data from restart or power failure Affected Issues
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/h2/ Diff File
add - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/h2/ Diff File

Issue History

Date Modified Username Field Change
2018-06-18 17:37 elong New Issue
2018-06-18 17:37 elong Status new => assigned
2018-06-18 17:37 elong Assigned To => elong
2018-06-18 17:42 elong Status assigned => resolved
2018-06-18 17:42 elong Resolution open => fixed
2018-06-18 17:42 elong Fixed in Version => 3.9.9
2018-06-18 18:00 admin Changeset attached => SymmetricDS 3.9 d0916bef
2018-06-21 19:16 admin Status resolved => closed