View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010857 | Taler | merchant backend | public | 2026-01-07 20:58 | 2026-01-07 21:14 |
| Reporter | sebasjm | Assigned To | oec | ||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | git (master) | ||||
| Target Version | 1.4 | ||||
| Summary | 0010857: getting pots failed | ||||
| Description | merchant=# select * from merchant.merchant_money_pots; money_pot_serial | merchant_serial | money_pot_name | money_pot_description | pot_totals ------------------+-----------------+----------------+-----------------------+------------ 1 | 1 | zxc | zxc | {} Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) INFO Handling request (GET) for URL '/private/pots' Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Running prepared statement `select_login_token' on 0x5b339a1eda10 Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Executing prepared SQL statement `select_login_token' Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Execution of prepared SQL statement `select_login_token' finished (PGRES_TUP> Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Running prepared statement `lookup_money_pots_desc' on 0x5b339a1eda10 Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Executing prepared SQL statement `lookup_money_pots_desc' Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) DEBUG Execution of prepared SQL statement `lookup_money_pots_desc' finished (PGRES> Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Assertion failed at pq_result_helper.c:1184. Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Failed to extract field `pot_totals' Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Assertion failed at ../src/lib/pq/pq.c:194. Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Assertion failed at pg_select_money_pots.c:94. Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Assertion failed at pg_select_money_pots.c:171. Jan 07 16:18:15 taler-merchant-httpd[321260]: (FHZWDFCGX829MJZMJ4BDV6FFS0) ERROR Assertion failed at taler-merchant-httpd_private-get-pots.c:115. $ curl 'https://merchant.taler/private/pots?limit=-5' { "code": 53, "hint": "The service failed to fetch information from its database. The system administrator should check that the database is running and review the service logs.", "detail": "select_money_pots" } | ||||
| Tags | No tags attached. | ||||
|
|
Looks like a problem with the PQ array function, likely in case the array length is zero. Oezguer: could you please look at that assertion? You know the Postgresql array fun best... |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2026-01-07 20:58 | sebasjm | New Issue | |
| 2026-01-07 20:58 | sebasjm | Status | new => assigned |
| 2026-01-07 20:58 | sebasjm | Assigned To | => Christian Grothoff |
| 2026-01-07 21:14 | Christian Grothoff | Note Added: 0027209 | |
| 2026-01-07 21:14 | Christian Grothoff | Assigned To | Christian Grothoff => oec |