View Issue Details

IDProjectCategoryView StatusLast Update
0005492Talermerchant backendpublic2021-08-24 14:23
ReporterChristian Grothoff 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
PrioritynormalSeveritymajorReproducibilityhave not tried
Status closedResolutionunable to reproduce 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version0.8Fixed in Version0.8 
Summary0005492: database inconsistency results in internal server error (2501/2705?)
DescriptionMarcello suggests some "some discrepancy exists between db tables".

The DB was reset, the backup is in demo-blue "talerdemo_db_dump.sql". To be investigated.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2019-01-10 13:12

manager   ~0013451

Changing category, as the generated errors point to the merchant backend, not the exchange.

Christian Grothoff

2019-01-10 14:25

manager   ~0013452

529cf92..828cd52 cleans up the /proposal logic improving error messages and proposal generation (nicer style), but also fixing a previously improperly done (lack of transaction scope) pre-flight test for an already existing order. Now the constraint check is simply done by relying on the DB constraint, and then we just run the 'get_order' to confirm that the hard error was indeed the constraint violation and not something else. So in the common case the result should be much faster, and we properly use the transactions now.

It is _not_ clear that this was the bug, though.

Christian Grothoff

2019-01-10 14:34

manager   ~0013453

84d4c87..9b683b2 improves logging in case this bug reappears.

Christian Grothoff

2019-01-10 14:35

manager   ~0013454

Unassigning, as I am not sure how to reproduce (loaded the DB, but would need a matching frontend setup to generate failing transactions). Hopefully the new logging will help diagnose this if this is still an issue.

Christian Grothoff

2020-08-28 22:01

manager   ~0016794

Merchant backend and database schema have changed completely. No point in even trying to reproduce this issue at this point.

Issue History

Date ModifiedUsernameFieldChange
2018-11-29 12:44Christian GrothoffNew Issue
2018-11-29 12:44Christian GrothoffStatusnew => assigned
2018-11-29 12:44Christian GrothoffAssigned To => Christian Grothoff
2019-01-08 18:12Christian GrothoffPrioritynormal => urgent
2019-01-10 13:12Christian GrothoffCategoryexchange => mechant backend
2019-01-10 13:12Christian GrothoffNote Added: 0013451
2019-01-10 14:25Christian GrothoffNote Added: 0013452
2019-01-10 14:34Christian GrothoffNote Added: 0013453
2019-01-10 14:35Christian GrothoffAssigned ToChristian Grothoff =>
2019-01-10 14:35Christian GrothoffPriorityurgent => normal
2019-01-10 14:35Christian GrothoffNote Added: 0013454
2019-01-10 14:36Christian GrothoffStatusassigned => feedback
2020-08-28 22:01Christian GrothoffAssigned To => Christian Grothoff
2020-08-28 22:01Christian GrothoffStatusfeedback => informing
2020-08-28 22:01Christian GrothoffResolutionopen => unable to reproduce
2020-08-28 22:01Christian GrothoffFixed in Version => 0.8
2020-08-28 22:01Christian GrothoffNote Added: 0016794
2020-08-28 22:01Christian GrothoffTarget Version => 0.8
2021-08-24 14:23Christian GrothoffStatusinforming => closed
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend