View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005658 | SymmetricDS | Improvement | public | 2023-01-19 16:36 | 2023-01-19 22:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.22 | Fixed in Version | 3.12.22 | ||
| Summary | 0005658: Snapshot util too slow for large multi-tenant deployment | ||||
| Description | Getting 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. | ||||
| Tags | No tags attached. | ||||
| related to | 0004838 | closed | josh-a-hicks | New extension point that can be used while obtaining a list of tables for a given trigger configuration |
| related to | 0005659 | closed | elong | Snapshot util too slow for large multi-tenant deployment |
|
SymmetricDS: 3.12 a0cc5e3a 2023-01-19 21:06:14 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 | ||
| 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 |