View Issue Details

IDProjectCategoryView StatusLast Update
0003606SymmetricDSImprovementpublic2018-06-21 15:16
ReporterelongAssigned Toelong 
Prioritynormal 
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:

http://www.h2database.com/html/advanced.html

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.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 d0916bef

2018-06-18 13:40:55

admin

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

Issue History

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