View Issue Details

IDProjectCategoryView StatusLast Update
0005716Talerexchangepublic2021-09-02 16:14
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 Version0.5 
Target Version0.6Fixed in Version0.6 
Summary0005716: exchange fails with cryptic error message if DB role is not a superuser
DescriptionThe following error message we get from postgres isn't very intuitive:

ERROR Failed to execute `LOAD 'auto_explain';': access to library "auto_explain" is not allowed/(null)/ERROR: access to library "auto_explain" is not allowed

This happens because only superusers can use the auto explain feature. Maybe we should detect this at run-time and skip this gracefully instead of dying with such a cryptic error message.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2019-05-09 10:56

manager   ~0014383

Fixed in 105555b4..39263a48.

Btw, did you see the comment on AUTO_EXPLAIN:

/**
 * Set to 1 to enable Postgres auto_explain module. This will
 * slow down things a _lot_, but also provide extensive logging
 * in the Postgres database logger for performance analysis.
 */

This was set to "1". Did you turn it off while running the final benchmarks? ;-)

Christian Grothoff

2021-09-02 16:14

manager   ~0018277

Fix committed to master branch.

Issue History

Date ModifiedUsernameFieldChange
2019-05-08 05:13Florian DoldNew Issue
2019-05-08 05:13Florian DoldStatusnew => assigned
2019-05-08 05:13Florian DoldAssigned To => Christian Grothoff
2019-05-09 10:56Christian GrothoffStatusassigned => informing
2019-05-09 10:56Christian GrothoffResolutionopen => fixed
2019-05-09 10:56Christian GrothoffFixed in Version => 0.6
2019-05-09 10:56Christian GrothoffNote Added: 0014383
2019-05-09 10:56Christian GrothoffProduct Version => 0.5
2019-05-09 10:56Christian GrothoffTarget Version => 0.6
2019-05-09 10:56Christian GrothoffAdditional Information Updated
2019-12-20 18:12Christian GrothoffStatusinforming => closed
2021-09-02 16:13Christian Grothoff
2021-09-02 16:14Christian GrothoffNote Added: 0018277