View Issue Details

IDProjectCategoryView StatusLast Update
0004095SymmetricDSImprovementpublic2019-09-27 17:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.11.0 
Target Version3.11.0Fixed in Version3.11.0 
Summary0004095: Unrouted count should check current sequence instead of running max(data_id)
DescriptionThe 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.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 bef58b20

2019-09-23 09:12:28

admin

Details Diff
0004095: Unrouted count should check current sequence instead of running
max(data_id)

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

admin

Details Diff
0004095: Unrouted count should check current sequence instead of running
max(data_id)

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

admin

Details Diff
0004095: remove old data gap detector to fix possible NPE
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

Issue History

Date Modified Username Field Change
2019-09-23 09:11 elong New Issue
2019-09-23 09:11 elong Status new => assigned
2019-09-23 09:11 elong Assigned To => elong
2019-09-23 10:26 elong Status assigned => resolved
2019-09-23 10:26 elong Resolution open => fixed
2019-09-23 10:26 elong Fixed in Version => 3.11.0
2019-09-27 17:00 admin Changeset attached => SymmetricDS 3.11 db1638c9
2019-09-27 17:00 admin Changeset attached => SymmetricDS 3.11 51f0b5a7
2019-09-27 17:00 admin Changeset attached => SymmetricDS 3.11 bef58b20