View Issue Details

IDProjectCategoryView StatusLast Update
0004234SymmetricDSImprovementpublic2020-01-23 15:42
ReporterelongAssigned Toelong 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.4Fixed in Version3.11.4 
Summary0004234: Upgrade of sym_data_event is slow
DescriptionWhen upgrading to 3.11, the sym_data_event table is altered to remove the router_id column. Before the alter occurs, it removes rows that are duplicate for the same batch_id and data_id. The routine runs too slowly because it tries to remove unrouted batches where the node_id is -1. Instead, it should query for duplicate rows and remove them using JDBC batch mode and committing periodically for performance.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 e43bc3b7

2020-01-07 08:40:23

admin

Details Diff
0004234: Upgrade of sym_data_event is slow
0004234
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java Diff File

Issue History

Date Modified Username Field Change
2020-01-07 08:34 elong New Issue
2020-01-07 08:34 elong Status new => assigned
2020-01-07 08:34 elong Assigned To => elong
2020-01-07 08:41 elong Status assigned => resolved
2020-01-07 08:41 elong Resolution open => fixed
2020-01-07 08:41 elong Fixed in Version => 3.11.4
2020-01-07 09:00 admin Changeset attached => SymmetricDS 3.11 e43bc3b7
2020-01-23 15:42 admin Status resolved => closed