View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005945 | SymmetricDS Pro | New Feature | public | 2023-08-07 13:08 | 2023-10-03 23:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.0 | Fixed in Version | 3.15.0 | ||
| Summary | 0005945: Compare and repair with remote nodes | ||||
| Description | Run comparison of all or selected tables between a source and target node over the transport protocol. Allow the request to be scheduled for the future and it can come from either source or target node through a request table. Comparison should use levels of table, chunk, and row to find differences. The user may request a fast comparison that only checks that row counts or table checksums match. Chunking would divide the table up into a smaller number of rows to find which chunks differ, as a way to reduce the number of rows that need to be transported for comparison. Row level would transport the row by row checksums. The comparison should work on a busy system that is undergoing changes. If a repair is requested, the target is brought into sync with the needed inserts, updates, and deletes. | ||||
| Tags | data sync | ||||
| related to | 0005195 | closed | pmarzullo | SymmetricDS | Table content verification |
| related to | 0000027 | resolved | chenson | SymmetricDS | Provide feature to validate that data is in sync |
| related to | 0000174 | closed | elong | SymmetricDS | Node synchronization verification |
| related to | 0005982 | resolved | cquamme | SymmetricDS Pro | Compare and Repair Screen |
|
SymmetricDS: 3.15 9c9867e8 2023-08-07 13:13:22 Details Diff |
0005945: compare and repair dev checkin |
Affected Issues 0005945 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/Constants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/TableConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/NodeCommunication.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/ProcessType.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ConfigurationChangedDataRouter.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ClusterConstants.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataLoaderService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IOutgoingBatchService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataLoaderService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/SequenceService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/SequenceServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TransformService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/ITransportManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/http/HttpTransportManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/internal/InternalTransportManager.java | Diff File | ||
| mod - symmetric-core/src/test/java/org/jumpmind/symmetric/transport/MockTransportManager.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/TransformTable.java | Diff File | ||
| mod - symmetric-server/src/main/java/org/jumpmind/symmetric/web/ServerSymmetricEngine.java | Diff File | ||
|
SymmetricDS: 3.15 3c043524 2023-08-07 13:13:41 Details Diff |
0005945: compare and repair dev checkin |
Affected Issues 0005945 |
|
| add - symmetric-server/src/main/java/org/jumpmind/symmetric/web/IServerSymmetricEngineLifecycle.java | Diff File | ||
|
SymmetricDS: 3.15 d9cff2de 2023-08-08 17:56:34 Details Diff |
0005945: compare and repair dev checkin |
Affected Issues 0005945 |
|
| add - symmetric-core/src/main/java/org/jumpmind/symmetric/ext/IBatchStagingExtension.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/io/stage/BatchStagingManager.java | Diff File | ||
|
SymmetricDS: 3.15 4f931584 2023-09-07 17:41:19 Details Diff |
0005945: support compare and repair http, use of dyna SQL |
Affected Issues 0005945 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/AbstractOfflineDetectorService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java | Diff File | ||
| add - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/ServiceNotReadyException.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/http/HttpIncomingTransport.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/transport/http/HttpOutgoingTransport.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/web/WebConstants.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/h2/H2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatement.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/sql/DmlStatementOptions.java | Diff File | ||
| mod - symmetric-util/src/main/java/org/jumpmind/util/FormatUtils.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-08-07 13:08 | elong | New Issue | |
| 2023-08-07 13:08 | elong | Status | new => assigned |
| 2023-08-07 13:08 | elong | Assigned To | => elong |
| 2023-08-07 13:08 | elong | Tag Attached: data sync | |
| 2023-08-07 13:09 | elong | Relationship added | related to 0005195 |
| 2023-08-07 13:09 | elong | Relationship added | related to 0000027 |
| 2023-08-07 13:10 | elong | Relationship added | related to 0000174 |
| 2023-09-07 19:18 | elong | Status | assigned => resolved |
| 2023-09-07 19:18 | elong | Resolution | open => fixed |
| 2023-09-07 19:18 | elong | Fixed in Version | => 3.15.0 |
| 2023-09-18 15:42 | cquamme | Relationship added | related to 0005982 |
| 2023-10-01 23:46 | admin | Status | resolved => closed |
| 2023-10-03 23:00 | admin | Changeset attached | => SymmetricDS 3.15 4f931584 |
| 2023-10-03 23:00 | admin | Changeset attached | => SymmetricDS 3.15 d9cff2de |
| 2023-10-03 23:00 | admin | Changeset attached | => SymmetricDS 3.15 3c043524 |
| 2023-10-03 23:00 | admin | Changeset attached | => SymmetricDS 3.15 9c9867e8 |