View Issue Details

IDProjectCategoryView StatusLast Update
0003990Talerexchangepublic2024-01-12 14:05
ReporterChristian Grothoff Assigned ToChristian Grothoff  
PrioritynormalSeverityblockReproducibilityN/A
Status closedResolutionfixed 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.0Fixed in Version0.0 
Summary0003990: should retry failed transactions with 40000-level error codes
Descriptionhttp://www.postgresql.org/docs/9.3/static/errcodes-appendix.html

documents that 40000-level error codes indicate transaction failures due to concurrent activities of other transactions. 40001 and 40P01 seem to be relevant for us, not sure what 40003 even is yet.

For 40001 and 40P01, the mint should re-try (a few times) internally before giving up and returning an internal error (as it does right now on 1st failure).
Additional InformationOn deadlocks:

http://stackoverflow.com/questions/10245560/deadlocks-in-postgresql-when-running-update

How to query error code:
http://www.postgresql.org/message-id/20041203014115.GA5451@winnie.fuhr.org

TagsNo tags attached.

Activities

Christian Grothoff

2015-09-21 14:37

manager   ~0009654

Implemented in 70c28e5..93a84d5

Issue History

Date Modified Username Field Change
2015-09-21 13:35 Christian Grothoff New Issue
2015-09-21 13:35 Christian Grothoff Status new => assigned
2015-09-21 13:35 Christian Grothoff Assigned To => Christian Grothoff
2015-09-21 14:37 Christian Grothoff Note Added: 0009654
2015-09-21 14:37 Christian Grothoff Status assigned => resolved
2015-09-21 14:37 Christian Grothoff Fixed in Version => 0.0
2015-09-21 14:37 Christian Grothoff Resolution open => fixed
2015-09-21 15:55 Christian Grothoff Status resolved => closed
2016-02-18 15:44 Christian Grothoff Category mint Postgres DB backend => exchange Postgres DB backend
2024-01-12 14:05 Christian Grothoff Category exchange Postgres DB backend => exchange