View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003606 | SymmetricDS | Improvement | public | 2018-06-18 17:37 | 2018-06-21 19:16 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.9 | ||||
| Target Version | 3.9.9 | Fixed in Version | 3.9.9 | ||
| Summary | 0003606: H2 lost data from restart or power failure | ||||
| Description | H2 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 d0916bef 2018-06-18 13:40:55 Details Diff |
0003606: H2 lost data from restart or power failure |
Affected Issues 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 | ||
| 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 |