View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003508 | SymmetricDS Pro | Improvement | public | 2018-03-28 22:58 | 2018-06-07 14:23 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.7 | Fixed in Version | 3.9.7 | ||
| Summary | 0003508: Purge should use nolock dirty reads for min max range | ||||
| Description | The PurgeService gets a range (min, max) of IDs for runtime tables (data, outgoing_batch) in order to determine the number of deletes to run. On a very busy system, the query can timeout, which loses an entire run of the purge until the next day. Another day of data that needs purged makes the query more likely to timeout again. We should use the sqlTemplateDirty that uses an isolation level that won't lock the table, cause contention, and it is more likely to return results. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 b71340b1 2018-03-28 19:00:53 Details Diff |
0003508: Purge should use nolock dirty reads for min max range |
Affected Issues 0003508 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
|
SymmetricDS: 3.9 82bac7e2 2018-03-30 09:29:02 Details Diff |
0003508: Purge should use nolock dirty reads for min max range |
Affected Issues 0003508 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDatabasePlatform.java | Diff File | ||
|
SymmetricDS: 3.9 54674a6c 2018-03-30 10:36:01 Details Diff |
0003508: Purge should use nolock dirty reads for min max range |
Affected Issues 0003508 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-03-28 22:58 | elong | New Issue | |
| 2018-03-28 22:58 | elong | Status | new => assigned |
| 2018-03-28 22:58 | elong | Assigned To | => elong |
| 2018-03-29 00:00 | admin | Changeset attached | => SymmetricDS 3.9 b71340b1 |
| 2018-03-30 14:00 | admin | Changeset attached | => SymmetricDS 3.9 82bac7e2 |
| 2018-03-30 14:36 | elong | Status | assigned => resolved |
| 2018-03-30 14:36 | elong | Resolution | open => fixed |
| 2018-03-30 14:36 | elong | Fixed in Version | => 3.9.7 |
| 2018-03-30 15:00 | admin | Changeset attached | => SymmetricDS 3.9 54674a6c |
| 2018-06-07 14:23 | admin | Status | resolved => closed |