View Issue Details

IDProjectCategoryView StatusLast Update
0004647SymmetricDSBugpublic2020-11-20 01:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.11.13 
Target Version3.11.14Fixed in Version3.11.14 
Summary0004647: Postgres Conflict Resolution blocks when trying to resolve
DescriptionPostgres 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.
Tagsconflict manager

Relationships

related to 0004609 closedpmarzullo Postgres Conflict Resolution fails to resolve 
related to 0004648 resolvedelong Postgres Conflict Resolution blocks when trying to resolve 

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 efa3c337

2020-11-20 00:39:28

admin

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

admin

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

Issue History

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