View Issue Details

IDProjectCategoryView StatusLast Update
0010857Talermerchant backendpublic2026-01-07 21:14
Reportersebasjm Assigned Tooec  
PrioritynormalSeveritycrashReproducibilityalways
Status assignedResolutionopen 
Product Versiongit (master) 
Target Version1.4 
Summary0010857: getting pots failed
Descriptionmerchant=# 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"
}

TagsNo tags attached.

Activities

Christian Grothoff

2026-01-07 21:14

manager   ~0027209

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...

Issue History

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