View Issue Details

IDProjectCategoryView StatusLast Update
0006605Talermerchant backendpublic2021-08-24 14:23
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.8Fixed in Version0.8 
Summary0006605: taler-merchant-dbinit -r doesn't work
DescriptionLooks like this somehow first tries to read the current database with the current schema.
Steps To Reproduce$ taler-merchant-dbinit -r
Sep 13 20:49:47-075508 pq-4100070 ERROR PQprepare (`SELECT contract_terms,claim_token,h_post_data FROM merchant_orders WHERE merchant_orders.merchant_serial= (SELECT merchant_serial FROM merchant_instances WHERE merchant_id=$1) AND merchant_orders.order_id=$2' as `lookup_order') failed with error: ERROR: column "h_post_data" does not exist
LINE 1: SELECT contract_terms,claim_token,h_post_data FROM merchant_...
                                          ^

Failed to initialize database plugin.
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2020-09-13 21:12

manager   ~0016968

Is this on a fresh DB? Like the wallet, we didn't implement migration from older DBs.

Florian Dold

2020-09-14 05:16

manager   ~0016969

It's on an existing DB, but since taler-merchant-dbinit is being called with the *reset* flag (-r), I would expect it to not care about migrations!

(Otherwise, there's no point in --reset and we should just remove it!)

Christian Grothoff

2020-09-14 07:07

manager   ~0016970

Fixed in b9e87dd..5466b94

Issue History

Date ModifiedUsernameFieldChange
2020-09-13 18:57Florian DoldNew Issue
2020-09-13 18:57Florian DoldStatusnew => assigned
2020-09-13 18:57Florian DoldAssigned To => Christian Grothoff
2020-09-13 21:12Christian GrothoffNote Added: 0016968
2020-09-13 21:14Christian GrothoffAssigned ToChristian Grothoff => Florian Dold
2020-09-13 21:14Christian GrothoffStatusassigned => feedback
2020-09-14 05:16Florian DoldNote Added: 0016969
2020-09-14 07:07Christian GrothoffAssigned ToFlorian Dold => Christian Grothoff
2020-09-14 07:07Christian GrothoffStatusfeedback => informing
2020-09-14 07:07Christian GrothoffResolutionopen => fixed
2020-09-14 07:07Christian GrothoffFixed in Version => 0.8
2020-09-14 07:07Christian GrothoffNote Added: 0016970
2020-09-14 07:07Christian GrothoffTarget Version0.8.1 => 0.8
2021-08-24 14:23Christian GrothoffStatusinforming => closed
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend