View Issue Details

IDProjectCategoryView StatusLast Update
0006452Talerexchangepublic2020-08-02 23:32
ReporterFlorian DoldAssigned To 
PrioritynormalSeveritymajorReproducibilityrandom
Status acknowledgedResolutionopen 
Product Version 
Target VersionFixed in Version 
Summary0006452: exchange livelocks with only small number of concurrent requests
DescriptionSee the attached logs, specifically async scope IDs

DVGVWZGJMQSMTKBZ2PM0AS0ZHR

and

QVBSQHWV58JKX98G9DS6966KCG.

During 150 milliseconds (!), pretty much the only thing that happens is these two transactions trampling on each other's feet!
TagsNo tags attached.

Activities

Florian Dold

2020-07-31 19:36

manager  

logs-exchange-2020-07-31.tar.gz (370,347 bytes)

Christian Grothoff

2020-08-02 23:31

manager   ~0016543

I still think this is because the exchange's database is so tiny, that page-level locks are too coarse. Disabling parallelism in Postgres seems to fix it pretty well for now, and might be a good answer as parallelism right now won't help anyway -- and once it would, the database will be large enough for the page-level locks to not conflict.

Issue History

Date Modified Username Field Change
2020-07-31 19:36 Florian Dold New Issue
2020-07-31 19:36 Florian Dold Status new => assigned
2020-07-31 19:36 Florian Dold Assigned To => Christian Grothoff
2020-07-31 19:36 Florian Dold File Added: logs-exchange-2020-07-31.tar.gz
2020-08-02 23:30 Christian Grothoff Target Version 0.8 =>
2020-08-02 23:30 Christian Grothoff Description Updated View Revisions
2020-08-02 23:31 Christian Grothoff Note Added: 0016543
2020-08-02 23:32 Christian Grothoff Assigned To Christian Grothoff =>
2020-08-02 23:32 Christian Grothoff Status assigned => acknowledged