View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004687 | SymmetricDS | Bug | public | 2020-12-07 17:38 | 2021-01-11 13:47 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.0 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004687: Postgres conflict when unique index uses primary key index | ||||
| Description | On Postgres, when encountering a unique key (UK) violation, if the the UK uses the primary key (PK) index as its index, then the error does not resolve automatically. | ||||
| Steps To Reproduce | To reproduce, create a primary key with multiple columns, then create a unique index on a subset of those columns. Setup data sync to insert a row with a duplicate unique key. | ||||
| Tags | conflict manager | ||||
|
SymmetricDS: 3.12 6262eac5 2020-12-07 17:43:55 Details Diff |
0004687: Postgres conflict when unique index uses primary key index |
Affected Issues 0004687 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractDatabaseWriterConflictResolver.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java | Diff File | ||
|
SymmetricDS: 3.12 3c019483 2020-12-11 16:21:44 Details Diff |
0004687: Postgres conflict when unique index uses primary key index |
Affected Issues 0004687 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/AbstractDatabaseWriterConflictResolver.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriterConflictResolver.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-07 17:38 | elong | New Issue | |
| 2020-12-07 17:38 | elong | Status | new => assigned |
| 2020-12-07 17:38 | elong | Assigned To | => elong |
| 2020-12-07 17:38 | elong | Tag Attached: conflict manager | |
| 2020-12-07 17:44 | elong | Status | assigned => resolved |
| 2020-12-07 17:44 | elong | Resolution | open => fixed |
| 2020-12-07 17:44 | elong | Fixed in Version | => 3.12.6 |
| 2020-12-07 18:00 | admin | Changeset attached | => SymmetricDS 3.12 6262eac5 |
| 2020-12-11 17:00 | admin | Changeset attached | => SymmetricDS 3.12 3c019483 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |