View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011500 | Taler | merchant backend | public | 2026-06-10 14:16 | 2026-06-10 15:09 |
| Reporter | Florian Dold | Assigned To | Christian Grothoff | Resolution deadline | |
| Implementer | Reviewer | ||||
| Release signed by | Deployed by | ||||
| Verifier | Communicator | ||||
| Data protection authority notification required | No | ||||
| CSIRT notification required | No | ||||
| Estimated effort (hours) | Actual effort (hours) | 0 | |||
| Fast-track | No | ||||
| Work package | none | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | informing | Resolution | fixed | ||
| Target Version | 1.6 | Fixed in Version | 1.6 | ||
| Summary | 0011500: merchant GC fails with SQL error | ||||
| Description | $ sudo -u taler-merchant-httpd taler-merchant-dbinit --gc 2026-06-10T14:13:13.591097+0000 pq-66923 ERROR Query `run_gc' failed with result: column "merchant_serial" does not exist/(null)/ERROR: column "merchant_serial" does not exist LINE 1: SELECT DISTINCT merchant_serial ^ QUERY: SELECT DISTINCT merchant_serial FROM merchant_statistic_counter_event CONTEXT: PL/pgSQL function merchant_statistic_amount_gc() line 20 at FOR over SELECT rows SQL statement "CALL merchant_statistic_amount_gc ()" PL/pgSQL function merchant_do_gc(bigint) line 14 at CALL /PGRES_FATAL_ERROR/ERROR: column "merchant_serial" does not exist LINE 1: SELECT DISTINCT merchant_serial ^ QUERY: SELECT DISTINCT merchant_serial FROM merchant_statistic_counter_event CONTEXT: PL/pgSQL function merchant_statistic_amount_gc() line 20 at FOR over SELECT rows SQL statement "CALL merchant_statistic_amount_gc ()" PL/pgSQL function merchant_do_gc(bigint) line 14 at CALL 2026-06-10T14:13:13.591425+0000 taler-merchant-dbinit-66923 ERROR Failed to garbage collect database | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2026-06-10 14:16 | Florian Dold | New Issue | |
| 2026-06-10 14:32 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2026-06-10 14:32 | Christian Grothoff | Status | new => assigned |
| 2026-06-10 14:55 | Christian Grothoff | Note Added: 0028840 | |
| 2026-06-10 15:09 | Christian Grothoff | Status | assigned => informing |
| 2026-06-10 15:09 | Christian Grothoff | Resolution | open => fixed |
| 2026-06-10 15:09 | Christian Grothoff | Fixed in Version | => 1.6 |