View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011529 | Taler | merchant backend | public | 2026-06-17 15:07 | 2026-06-19 14:46 |
| Reporter | vecirex | Assigned To | vecirex | ||
| Priority | urgent | Severity | block | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Target Version | 1.6 | ||||
| Summary | 0011529: Upgrade to taler-merchant v1.6.5 (test) might break prior installations: SQL migration to DB scheme v36 fails | ||||
| Description | Tested by upgrading from v1.5.16, cf. 0011518. TL;DR: taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ taler-merchant-dbinit 2026-06-17T12:59:08.256681+0000 taler-merchant-dbinit-786 WARNING Could not run PSQL on file /usr/share/taler-merchant/sql/merchant-0036.sql: psql exit code was 3 2026-06-17T12:59:08.256743+0000 taler-merchant-dbinit-786 ERROR Failed to load SQL statements from `merchant-*' 2026-06-17T12:59:08.256774+0000 taler-merchant-dbinit-786 ERROR Failed to initialize tables taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ | ||||
| Tags | No tags attached. | ||||
|
|
Could you please produce either the postgresql logs and/or the output of manually running merchant-0036.sql via the "psql" command and the respective database? That should help diagnose this quickly. |
|
|
I will have to recheck how to properly reproduce, as after running taler-merchant-dbconfig (user: root) also taler-merchant-dbinit (user: taler-merchant-httpd) stays quiet; as expected, DB in place is now bigger and migration certainly went smooth as scripts using the new scheme run through (as on stage, also on the new DB scheme running taler-merchant v1.6.5):taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ taler-merchant-httpd --version taler-merchant-httpd v1.6.5 taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ taler-merchant-dbinit taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ ./check_merchant-health.sh === Taler Merchant Health Check === [OK] Socket exists: /var/run/taler-merchant/httpd/merchant-http.sock [OK] Merchant-HTTPD is listening on the socket [OK] Process taler-merchant-httpd is running [OK] Nginx master process is running === ALL CHECKS PASSED === taler-merchant-httpd@1b0bd36dc346:/usr/local/bin$ ls -lh /var/taler-backups/* -rw-r--r-- 1 taler-merchant-httpd www-data 2.1M Nov 18 2025 /var/taler-backups/20251118--taler-merchant-db.sql [...] -rw-r--r-- 1 taler-merchant-httpd www-data 2.9M Jun 17 12:45 /var/taler-backups/taler-merchant-20260617_1245.sql -rw-r--r-- 1 taler-merchant-httpd www-data 6.8M Jun 19 12:23 /var/taler-backups/taler-merchant-20260619_1223.sql |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2026-06-17 15:07 | vecirex | New Issue | |
| 2026-06-17 15:12 | vecirex | Summary | Upgrade to taler-merchant v1.6.5 might break prior installations: SQL migration to DB scheme v36 fails => Upgrade to taler-merchant v1.6.5 (test) might break prior installations: SQL migration to DB scheme v36 fails |
| 2026-06-19 09:06 | Christian Grothoff | Note Added: 0028939 | |
| 2026-06-19 09:06 | Christian Grothoff | Assigned To | => vecirex |
| 2026-06-19 09:06 | Christian Grothoff | Status | new => feedback |
| 2026-06-19 09:06 | Christian Grothoff | Target Version | => 1.6 |
| 2026-06-19 14:43 | vecirex | Note Added: 0028942 | |
| 2026-06-19 14:46 | vecirex | Status | feedback => assigned |
