View Issue Details

IDProjectCategoryView StatusLast Update
0005658SymmetricDSImprovementpublic2023-01-19 22:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.0 
Target Version3.12.22Fixed in Version3.12.22 
Summary0005658: Snapshot util too slow for large multi-tenant deployment
DescriptionGetting a support snapshot file from a large multi-tenant system takes too long because it tries to extract the table definition for every table for every node. A multi-tenant system will use a table name with the $(targetExternalId) variable that expands to include every table, like node1$table, node2$table, and node3$table. The ITableResolver that expands the variable and looks up the table definitions uses a trick to cache the first occurrence of the table, since all nodes use the same table definition. Similarly, the support snapshot should only extract the first table definition when $(targetExtenalId) is being used.
TagsNo tags attached.

Relationships

related to 0004838 closedjosh-a-hicks New extension point that can be used while obtaining a list of tables for a given trigger configuration 
related to 0005659 closedelong Snapshot util too slow for large multi-tenant deployment 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 a0cc5e3a

2023-01-19 21:06:14

admin

Details Diff
0005658: Snaphot util too slow for large multi-tenant deployment Affected Issues
0005658
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/util/SnapshotUtil.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2023-01-19 16:36 elong New Issue
2023-01-19 16:36 elong Status new => assigned
2023-01-19 16:36 elong Assigned To => elong
2023-01-19 16:36 elong Relationship added related to 0004838
2023-01-19 21:07 elong Status assigned => resolved
2023-01-19 21:07 elong Resolution open => fixed
2023-01-19 21:07 elong Fixed in Version => 3.12.22
2023-01-19 21:16 elong Summary Snaphot util too slow for large multi-tenant deployment => Snapshot util too slow for large multi-tenant deployment
2023-01-19 21:16 elong Issue cloned: 0005659
2023-01-19 21:16 elong Relationship added related to 0005659
2023-01-19 22:00 admin Changeset attached => SymmetricDS 3.12 a0cc5e3a
2023-02-15 20:25 admin Status resolved => closed