View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004648 | SymmetricDS | Bug | public | 2020-11-20 00:41 | 2021-01-11 13:47 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.5 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004648: 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 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-11-20 00:41 | elong | New Issue | |
| 2020-11-20 00:41 | elong | Status | new => assigned |
| 2020-11-20 00:41 | elong | Assigned To | => elong |
| 2020-11-20 00:41 | elong | Tag Attached: conflict manager | |
| 2020-11-20 00:41 | elong | Issue generated from: 0004647 | |
| 2020-11-20 00:41 | elong | Relationship added | related to 0004647 |
| 2020-11-20 00:41 | elong | Status | assigned => resolved |
| 2020-11-20 00:41 | elong | Resolution | open => fixed |
| 2020-11-20 00:41 | elong | Fixed in Version | => 3.12.6 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |