View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004095 | SymmetricDS | Improvement | public | 2019-09-23 13:11 | 2019-11-15 14:04 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.0 | ||||
| Target Version | 3.11.0 | Fixed in Version | 3.11.0 | ||
| Summary | 0004095: Unrouted count should check current sequence instead of running max(data_id) | ||||
| Description | The system checks the unrouted count of data periodically, which runs a max(data_id) from sym_data. This query can be expensive on some systems with large tables, or systems that can't use the index (Firebird indexes are stored ascending). Instead, we can ask the sequence on the table what its current value is. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.11 bef58b20 2019-09-23 09:12:28 Details Diff |
0004095: Unrouted count should check current sequence instead of running max(data_id) |
Affected Issues 0004095 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/firebird/FirebirdSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/interbase/InterbaseSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/ISymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java | Diff File | ||
|
SymmetricDS: 3.11 51f0b5a7 2019-09-23 10:26:14 Details Diff |
0004095: Unrouted count should check current sequence instead of running max(data_id) |
Affected Issues 0004095 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapDetector.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapFastDetector.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
|
SymmetricDS: 3.11 db1638c9 2019-09-23 13:00:49 Details Diff |
0004095: remove old data gap detector to fix possible NPE |
Affected Issues 0004095 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-09-23 13:11 | elong | New Issue | |
| 2019-09-23 13:11 | elong | Status | new => assigned |
| 2019-09-23 13:11 | elong | Assigned To | => elong |
| 2019-09-23 14:26 | elong | Status | assigned => resolved |
| 2019-09-23 14:26 | elong | Resolution | open => fixed |
| 2019-09-23 14:26 | elong | Fixed in Version | => 3.11.0 |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 db1638c9 |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 51f0b5a7 |
| 2019-09-27 21:00 | admin | Changeset attached | => SymmetricDS 3.11 bef58b20 |
| 2019-11-15 14:04 | admin | Status | resolved => closed |