View Issue Details

IDProjectCategoryView StatusLast Update
0010682Talermerchant backendpublic2025-11-28 16:41
ReporterBohdan Assigned ToBohdan  
PriorityimmediateSeverityblockReproducibilityalways
Status assignedResolutionopen 
Product Version1.2 
Target Versiongit (master) 
Summary0010682: Well I did a shitty job, and migration from previous to new version doesn't work :)
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.

Relationships

child of 0010630 assignedvecirex Set my.taler-ops.ch live 

Activities

vecirex

2025-11-28 16:03

manager   ~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?

Issue History

Date Modified Username Field Change
2025-11-28 15:23 Bohdan New Issue
2025-11-28 15:23 Bohdan Status new => assigned
2025-11-28 15:23 Bohdan Assigned To => Bohdan
2025-11-28 16:03 vecirex Note Added: 0026659
2025-11-28 16:41 vecirex Relationship added child of 0010630