View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004647 | SymmetricDS | Bug | public | 2020-11-20 00:38 | 2021-11-04 14:58 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.13 | ||||
| Target Version | 3.11.14 | Fixed in Version | 3.11.14 | ||
| Summary | 0004647: Postgres Conflict Resolution blocks when trying to resolve | ||||
| Description | Postgres Conflict Resolution can become blocked when trying to resolve an "insert on conflict do nothing" that affected 0 rows. The resolution uses a separate connection to attempt the insert without "on conflict do nothing" to determine the exception without rolling back the batch. If rows in the same batch are referenced with foreign keys by the inserted row, then the two inserts will block each other. The socket timeout from the JDBC URL is eventually reached after 5 minutes, and the resolver will attempt an update instead. | ||||
| Tags | conflict manager | ||||
|
SymmetricDS: 3.11 efa3c337 2020-11-20 00:39:28 Details Diff |
0004647: Postgres Conflict Resolution blocks when trying to resolve |
Affected Issues 0004647 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
|
SymmetricDS: 3.12 70e50367 2020-11-20 00:39:28 Details Diff |
0004647: Postgres Conflict Resolution blocks when trying to resolve |
Affected Issues 0004647 |
|
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-11-20 00:38 | elong | New Issue | |
| 2020-11-20 00:38 | elong | Status | new => assigned |
| 2020-11-20 00:38 | elong | Assigned To | => elong |
| 2020-11-20 00:38 | elong | Tag Attached: conflict manager | |
| 2020-11-20 00:38 | elong | Relationship added | related to 0004609 |
| 2020-11-20 00:40 | elong | Status | assigned => resolved |
| 2020-11-20 00:40 | elong | Resolution | open => fixed |
| 2020-11-20 00:40 | elong | Fixed in Version | => 3.11.14 |
| 2020-11-20 00:41 | elong | Issue cloned: 0004648 | |
| 2020-11-20 00:41 | elong | Relationship added | related to 0004648 |
| 2020-11-20 01:00 | admin | Changeset attached | => SymmetricDS 3.11 efa3c337 |
| 2020-11-20 01:00 | admin | Changeset attached | => SymmetricDS 3.12 70e50367 |
| 2021-11-04 14:58 | admin | Status | resolved => closed |