View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011513 | Taler | merchant backend | public | 2026-06-11 18:25 | 2026-06-12 16:35 |
| Reporter | vecirex | Assigned To | vecirex | ||
| Priority | urgent | Severity | block | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Summary | 0011513: Check DB restore w/ backup from merchant v1.6.2; then upgrade to merchant v1.6.4 | ||||
| Description | An issue introduced in taler-merchant v1.6.3 rel to Garbage Collection, was tested to make instances inaccessible: should be fixed in taler-merchant v1.6.4; testing herewith. | ||||
| Tags | No tags attached. | ||||
|
|
Steps for restore (radical, but clean approach: only suited if the system's psql installation solely used for taler-merchant; nothing else; restore file to be a backup file from pg_dumpall):SQL_RESTORE_FILE=/root/backups/postgres-backup-1781051251.sql systemctl stop postgresql systemctl stop taler-merchant.target ps -axw | grep taler # only grep itself to be catched; if pg_dropcluster 17 main --stop # using postgresql v17 pg_createcluster 17 main systemctl start postgresql sudo -u postgres psql --echo-all -f $SQL_RESTORE_FILE postgres # -> no errors sudo -u postgres psql -l # taler-merchant DB should be visible, w/ user taler-merchant-httpd as user |
|
|
Restore works fine; noticeable is that a minimal DB grows from around 4MB to 13MB (as of pg_dumpall sql dumps) due to the new (more clearly separated) schemes w/ every instance having its own: that is, things go from joins to iterations, as what concerns global views. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2026-06-11 18:25 | vecirex | New Issue | |
| 2026-06-11 18:26 | vecirex | Assigned To | => vecirex |
| 2026-06-11 18:26 | vecirex | Status | new => assigned |
| 2026-06-11 18:29 | vecirex | Relationship added | child of 0011511 |
| 2026-06-11 18:29 | vecirex | Relationship replaced | parent of 0011511 |
| 2026-06-11 18:30 | vecirex | Relationship replaced | child of 0011511 |
| 2026-06-11 20:21 | vecirex | Note Added: 0028867 | |
| 2026-06-11 20:21 | vecirex | Note Edited: 0028867 | |
| 2026-06-11 20:22 | vecirex | Note Edited: 0028867 | |
| 2026-06-11 20:30 | vecirex | Note Edited: 0028867 | |
| 2026-06-11 21:09 | vecirex | Note Edited: 0028867 | |
| 2026-06-11 21:09 | vecirex | Note Edited: 0028867 | |
| 2026-06-12 16:35 | vecirex | Status | assigned => closed |
| 2026-06-12 16:35 | vecirex | Resolution | open => fixed |
| 2026-06-12 16:35 | vecirex | Note Added: 0028874 |
