View Issue Details

IDProjectCategoryView StatusLast Update
0004648SymmetricDSBugpublic2021-01-11 13:47
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.5 
Target Version3.12.6Fixed in Version3.12.6 
Summary0004648: 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 0004647 closedelong Postgres Conflict Resolution blocks when trying to resolve 

Activities

There are no notes attached to this issue.

Issue History

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