View Issue Details

IDProjectCategoryView StatusLast Update
0008645Talerlibeufin-nexuspublic2024-04-15 19:32
ReporterAntoine A Assigned ToAntoine A 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 
Target Version0.10Fixed in Version0.10 
Summary0008645: FIx cashin idempotency when conversion is enabled
DescriptionThe netzbon deployment encountered an error I've seen twice before where ingesting the same incoming EBICS transaction a second time triggers a unique conflict on the talerable_incoming_transactions table in the database.
I didn't trigger this error in regular libeufin-nexus tests because the SQL query used ON CONFLICT to handle this problem correctly and efficiently. However, when conversion is enabled, a trigger is set BEFORE insertion and therefore before the ON CONFLICT check... As this trigger is not idempotent, we need to check idempotency before inserting a row.
I've also added a test case for this in the integration test suite.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Antoine A

2024-03-15 15:06

manager   ~0021936

Fixed in e121d549fcc02efe00350ab4fe01a22220d9f149

Issue History

Date ModifiedUsernameFieldChange
2024-03-15 15:05Antoine ANew Issue
2024-03-15 15:05Antoine AStatusnew => assigned
2024-03-15 15:05Antoine AAssigned To => Antoine A
2024-03-15 15:06Antoine ATarget Version => 0.10
2024-03-15 15:06Antoine AStatusassigned => informing
2024-03-15 15:06Antoine AResolutionopen => fixed
2024-03-15 15:06Antoine ANote Added: 0021936
2024-04-09 11:11Christian GrothoffFixed in Version => 0.10
2024-04-15 19:32Christian GrothoffStatusinforming => closed