View Issue Details

IDProjectCategoryView StatusLast Update
0005321Talerexchangepublic2019-12-20 18:12
ReporterFlorian Dold Assigned ToChristian Grothoff Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Versiongit (master) 
Target Version0.6Fixed in Version0.6 
Summary0005321: investigate database problems in wirewatch
DescriptionRight now wirewatch logs some scary warning about failed transactions. Either we don't treat this soft error properly as a soft error, or we do treat is as a soft error and retry, but then we probably shouldn't log a "scary" message with PGRES_FATAL_ERROR.

We should also try to figure out why this conflict happened, and if we can do anything to reduce the chance of it happening (i.e. use some index instead of linear scan etc.)
Additional InformationApr 03 20:06:06-888222 pq-13913 INFO Query `reserve_create' failed with
result: could not serialize access due to read/write dependencies among
transactions/Reason code: Canceled on identification as a pivot, during
write./ERROR: could not serialize access due to read/write dependencies
among transactions
DETAIL: Reason code: Canceled on identification as a pivot, during write.
HINT: The transaction might succeed if retried.
/PGRES_FATAL_ERROR/ERROR: could not serialize access due to read/write
dependencies among transactions
DETAIL: Reason code: Canceled on identification as a pivot, during write.
HINT: The transaction might succeed if retried.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2018-08-18 11:35

manager   ~0013221

Went manually over exchange (all tools) and merchant backend fixing all cases where rollback was missing. Merchant: c993c0d..04692ee, exchange: 14908b78155aade720a58c15be502bb317cea540 (harmless).

Issue History

Date ModifiedUsernameFieldChange
2018-04-10 19:35Florian DoldNew Issue
2018-04-10 19:35Florian DoldStatusnew => assigned
2018-04-10 19:35Florian DoldAssigned To => Christian Grothoff
2018-08-18 11:35Christian GrothoffStatusassigned => informing
2018-08-18 11:35Christian GrothoffResolutionopen => fixed
2018-08-18 11:35Christian GrothoffFixed in Version => 0.6
2018-08-18 11:35Christian GrothoffNote Added: 0013221
2018-08-18 11:35Christian GrothoffProduct Version => git (master)
2018-08-18 11:35Christian GrothoffTarget Version => 0.6
2018-08-18 11:35Christian GrothoffAdditional Information Updated
2019-12-20 18:12Christian GrothoffStatusinforming => closed