View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005675 | SymmetricDS | Improvement | public | 2023-01-31 20:40 | 2023-02-08 18:00 |
| Reporter | cquamme | Assigned To | cquamme | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Target Version | 3.14.5 | Fixed in Version | 3.14.5 | ||
| Summary | 0005675: Bidirectional sync causes need for trigger to be re-built on target side if table does not exist | ||||
| Description | If you set up bi-directional sync for a table and the table does not exist on the target side, then the trigger will be broken (correctly). However, once you send an initial load with a create table to the target side, the table will then exist on the target side, so the trigger can be rebuilt successfully. Rather than have the user manually rebuild this trigger, we can resync the triggers after an initial load with a create, and this will rebuild the trigger automatically. | ||||
| Steps To Reproduce | 1. Set up a postgres source and target node 2. Create a table on the source node that does not exist on the target node 3. Use the add table wizard to create a bidirectional sync on the table between the source and target node 4. Trigger will be broken on the target side 5. Send an initial load with a create table from source to target 6. Trigger will still be broken on target side, but can be rebuilt now because the table exists on the target side | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.14 385f8e85 2023-01-31 20:44:20 Details Diff |
0005675: Bidirectional sync causes need for trigger to be re-built on target side if table does not exist |
Affected Issues 0005675 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/ConfigurationChangedDatabaseWriterFilter.java | Diff File | ||
|
SymmetricDS: 3.14 36291ed5 2023-02-08 17:37:24 Details Diff |
0005675: sync triggers was being called twice |
Affected Issues 0005675 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/ConfigurationChangedDatabaseWriterFilter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-01-31 20:40 | cquamme | New Issue | |
| 2023-01-31 20:40 | cquamme | Status | new => assigned |
| 2023-01-31 20:40 | cquamme | Assigned To | => cquamme |
| 2023-01-31 20:44 | cquamme | Status | assigned => resolved |
| 2023-01-31 20:44 | cquamme | Resolution | open => fixed |
| 2023-01-31 21:00 | cquamme | Changeset attached | => SymmetricDS 3.14 385f8e85 |
| 2023-02-08 18:00 | admin | Changeset attached | => SymmetricDS 3.14 36291ed5 |
| 2023-02-15 20:26 | admin | Status | resolved => closed |