View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003454 | SymmetricDS | Bug | public | 2018-02-23 19:40 | 2018-03-12 12:26 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.27 | ||||
| Target Version | 3.9.5 | Fixed in Version | 3.9.5 | ||
| Summary | 0003454: Purge of stranded data_events on PostgreSQL is too slow | ||||
| Description | Purge of stranded data_events on PostgreSQL is too slow. It queries sym_data_event for batch_id not in a subselect from sym_outgoing_batch, and the query doesn't seem to return when the tables get large enough. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.9 f97048d9 2018-02-23 14:40:53 Details Diff |
0003454: Purge of stranded data_events on PostgreSQL is too slow |
Affected Issues 0003454 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
|
SymmetricDS: 3.8 d9e3554a 2018-03-01 12:45:31 Details Diff |
0003454: Purge of stranded data_events on PostgreSQL is too slow |
Affected Issues 0003454 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
|
SymmetricDS: 3.9 ac70c3d8 2018-03-01 16:32:50 Details Diff |
0003454: Purge of stranded data_events on PostgreSQL is too slow |
Affected Issues 0003454 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-02-23 19:40 | elong | New Issue | |
| 2018-02-23 19:40 | elong | Status | new => assigned |
| 2018-02-23 19:40 | elong | Assigned To | => elong |
| 2018-02-23 19:40 | elong | Relationship added | related to 0003453 |
| 2018-02-23 19:43 | elong | Status | assigned => resolved |
| 2018-02-23 19:43 | elong | Resolution | open => fixed |
| 2018-02-23 19:43 | elong | Fixed in Version | => 3.9.5 |
| 2018-02-23 20:00 | admin | Changeset attached | => SymmetricDS 3.9 f97048d9 |
| 2018-03-01 18:00 | admin | Changeset attached | => SymmetricDS 3.8 d9e3554a |
| 2018-03-01 22:00 | admin | Changeset attached | => SymmetricDS 3.9 ac70c3d8 |
| 2018-03-12 12:26 | chenson | Status | resolved => closed |