View Issue Details

IDProjectCategoryView StatusLast Update
0010682Talermerchant backendpublic2025-12-05 05:36
ReporterBohdan Assigned ToBohdan 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
PriorityimmediateSeverityblockReproducibilityalways
Status closedResolutionfixed 
Product Version1.2 
Target Version1.3Fixed in Version1.3 
Summary0010682: Within specific versions, merchant can be not upgraded automatically (from v1.1.0 or earlier to 1.2.0+)
Description2025-11-28 14:14:36.320 UTC [73909] taler-merchant-httpd@taler-merchant ERROR: function encode(jsonb, unknown) does not exist at character 167
2025-11-28 14:14:36.320 UTC [73909] taler-merchant-httpd@taler-merchant HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2025-11-28 14:14:36.320 UTC [73909] taler-merchant-httpd@taler-merchant QUERY: resolved_body := replace_placeholder(resolved_body,
                                                 'old_description_i18n',
                                                 encode(OLD.description_i18n,
                                                        'escape'))
2025-11-28 14:14:36.320 UTC [73909] taler-merchant-httpd@taler-merchant CONTEXT: PL/pgSQL function handle_inventory_changes() line 117 at assignment
2025-11-28 14:14:36.320 UTC [73909] taler-merchant-httpd@taler-merchant STATEMENT: UPDATE merchant_inventory
       SET image_hash = CASE
                          WHEN (image IS NULL) OR (image = '')
                          THEN NULL
                          ELSE encode(
                                 digest(
                                   convert_to(image, 'UTF8'),
                                   'sha256'
                                 ),
                                 'hex'
                               )
                        END;
root@debian-instalation-tutorial:~# taler-merchant-httpd --version
taler-merchant-httpd v1.2.2-git-ad2aa9a

The good thing is that I figured out that migration from the old to the new version really works, that bug can be closed, but some fallback to the old version if the migration fails might be a good thing to have
Steps To ReproduceIDK, have my database, and run taler-merchant-dbconfig and it fails...
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Relationships

child of 0010630 closedvecirex Set my.taler-ops.ch live [done in principle by this morning: still solving deps; work parallelized] 

Activities

vecirex

2025-11-28 15:03

administrator   ~0026659

Uh, ty for takinkg care!

Question, before I break my installation:

This would affect migration only from v1.2.1 to v1.2.2, both from trixie-testing, or (likely, I guess) also from older versions (like 1.2.0 and before) to v1.2.2?

Bohdan

2025-11-28 18:04

developer   ~0026671

This affects only the merchants that are upgrading from less or 1.1.0 to 1.2.0

vecirex

2025-12-05 05:36

administrator   ~0026750

Definitely fixed in newest released v1.2.3: ty & closing.

Issue History

Date ModifiedUsernameFieldChange
2025-11-28 14:23BohdanNew Issue
2025-11-28 14:23BohdanStatusnew => assigned
2025-11-28 14:23BohdanAssigned To => Bohdan
2025-11-28 15:03vecirexNote Added: 0026659
2025-11-28 15:41vecirexRelationship addedchild of 0010630
2025-11-28 17:38Christian GrothoffTarget Versiongit (master) => 1.3
2025-11-28 18:04BohdanNote Added: 0026671
2025-11-28 18:06BohdanSummaryWell I did a shitty job, and migration from previous to new version doesn't work :) => Within specific versions, merchant can be not upgraded automatically
2025-11-28 18:07BohdanSummaryWithin specific versions, merchant can be not upgraded automatically => Within specific versions, merchant can be not upgraded automatically (>=v1.1.0 to 1.2.0+)
2025-11-28 18:08BohdanSummaryWithin specific versions, merchant can be not upgraded automatically (>=v1.1.0 to 1.2.0+) => Within specific versions, merchant can be not upgraded automatically (from v1.1.0 or earlier to 1.2.0+)
2025-11-28 19:20BohdanStatusassigned => informing
2025-11-28 19:20BohdanResolutionopen => fixed
2025-11-28 19:20BohdanFixed in Version => 1.2
2025-11-28 19:34Christian GrothoffFixed in Version1.2 => 1.3
2025-12-05 05:36vecirexStatusinforming => closed
2025-12-05 05:36vecirexNote Added: 0026750