View Issue Details

IDProjectCategoryView StatusLast Update
0008993Talermerchant backendpublic2024-07-25 22:11
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
PriorityimmediateSeverityblockReproducibilityhave not tried
Status closedResolutionfixed 
Target Version0.12Fixed in Version0.12 
Summary0008993: payment fails (DB migration missing?)
DescriptionJun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO Handling request (GET) for URL '/instances/blog/private/orders/2024.182-00WCT3RKKFK8E'
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO Processing order 2024.182-00WCT3RKKFK8E in phase 0
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO Processing order 2024.182-00WCT3RKKFK8E in phase 1
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) ERROR PQprepare (`SELECT contract_terms,order_serial,claim_token,paid,wired,(session_id=$3) AS session_matches,choice_index FROM merchant_contract_terms WHERE order_id=$2 AND merchant_serial= (SELECT merchant_serial FROM merchant_instances WHERE merchant_id=$1)' as `lookup_contract_terms3') failed with error: ERROR: column "choice_index" does not exist
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: LINE 1: ...ken,paid,wired,(session_id=$3) AS session_matches,choice_ind...
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: ^
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) ERROR Assertion failed at pg_lookup_contract_terms3.c:83.
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO lookup_contract_terms (2024.182-00WCT3RKKFK8E) returned -2
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO Processing order 2024.182-00WCT3RKKFK8E in phase 12
Jun 30 14:10:48 0ce7b76130e8 taler-merchant-httpd[8871]: (N1S7QBDRAVR3RAGWRDQHH9CSK0) INFO Request for `/instances/blog/private/orders/2024.182-00WCT3RKKFK8E' completed with HTTP status 500 (0)
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Florian Dold

2024-06-30 14:28

manager   ~0022770

Actually the migration is not missing, but do to a bad merge, it was added afterwards into an old migration patch file that has already been applied. Very bad!

Issue History

Date ModifiedUsernameFieldChange
2024-06-30 14:14Florian DoldNew Issue
2024-06-30 14:14Florian DoldStatusnew => assigned
2024-06-30 14:14Florian DoldAssigned To => Christian Grothoff
2024-06-30 14:28Florian DoldNote Added: 0022770
2024-07-02 04:13Florian DoldStatusassigned => informing
2024-07-02 04:13Florian DoldResolutionopen => fixed
2024-07-25 22:11Christian GrothoffFixed in Version => 0.12
2024-07-25 22:11Christian GrothoffStatusinforming => closed
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend