View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008997 | Taler | mechant backend | public | 2024-06-30 23:13 | 2024-07-26 00:11 |
| Reporter | Florian Dold | Assigned To | Florian Dold | ||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Target Version | 0.12 | Fixed in Version | 0.12 | ||
| Summary | 0008997: merchant pos endpoint broken | ||||
| Description | $ taler-harness run-integrationtests merchant-categories { "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." } | ||||
| Additional Information | 2024-06-30T23:12:48.497479+0200 taler-merchant-httpd-544784(T52DRSYV9F5CJKAMY8XHKQ786R) INFO Handling request (GET) for URL '/private/pos' 2024-06-30T23:12:48.498486+0200 pq-544784(T52DRSYV9F5CJKAMY8XHKQ786R) ERROR PQprepare (`SELECT description,description_i18n,unit,price,taxes,total_stock,total_sold,total_lost,image,merchant_inventory.address,next_restock,minimum_age,product_id,product_serial FROM merchant_inventory JOIN merchant_instances USING (merchant_serial),LATERAL ( SELECT ARRAY ( SELECT mpc.category_serial FROM merchant_product_categories mpc WHERE mpc.product_serial = mi.product_serial ) AS category_array ) t WHERE merchant_instances.merchant_id=$1' as `lookup_all_products') failed with error: ERROR: missing FROM-clause entry for table "mi" LINE 1: ...ct_categories mpc WHERE mpc.product_serial = mi.product... ^ 2024-06-30T23:12:48.498848+0200 taler-merchant-httpd-544784(T52DRSYV9F5CJKAMY8XHKQ786R) ERROR Assertion failed at pg_lookup_all_products.c:155. 2024-06-30T23:12:48.498896+0200 taler-merchant-httpd-544784(T52DRSYV9F5CJKAMY8XHKQ786R) ERROR Assertion failed at taler-merchant-httpd_private-get-pos.c:130. 2024-06-30T23:12:48.499062+0200 taler-merchant-httpd-544784(T52DRSYV9F5CJKAMY8XHKQ786R) INFO Request for `/private/pos' completed with HTTP status 500 (0) 2024-06-30T23:12:48.502013+0200 taler-merchant-httpd-544784 INFO Executing PQ command `UNLISTEN XN0RW6KT8Y9MK75YM85SC7GTA6SC5W91FXWDQP0ZB42GY3E52DZH0' 2024-06-30T23:12:48.502320+0200 taler-merchant-httpd-544784 INFO Executing PQ command `UNLISTEN XW9K15VBEKGDMCMN31SKH75KVXND1GTW5MW7WME4CMPQ0X9ECWTR0' 2024-06-30T23:12:48.502491+0200 taler-merchant-httpd-544784 INFO Stopping PQ event scheduler job 2024-06-30T23:12:48.502549+0200 taler-merchant-httpd-544784 INFO Releasing trusted exchange http://localhost:8081/ (-1) | ||||
| Tags | No tags attached. | ||||
|
|
commit e4991a240859eb202967e6863abeb63e3dec5721 (HEAD -> master, tag: v0.11.9-dev.1, origin/master, origin/HEAD) Author: Florian Dold <florian@dold.me> Date: Mon Jul 1 00:21:06 2024 +0200 fix SQL reference error |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-06-30 23:13 | Florian Dold | New Issue | |
| 2024-06-30 23:13 | Florian Dold | Status | new => assigned |
| 2024-06-30 23:13 | Florian Dold | Assigned To | => sebasjm |
| 2024-06-30 23:14 | Florian Dold | Assigned To | sebasjm => Christian Grothoff |
| 2024-06-30 23:14 | Florian Dold | Priority | normal => urgent |
| 2024-06-30 23:14 | Florian Dold | Severity | minor => major |
| 2024-06-30 23:14 | Florian Dold | Category | merchant backoffice SPA => mechant backend |
| 2024-06-30 23:14 | Florian Dold | Target Version | => 0.12 |
| 2024-07-01 00:27 | Florian Dold | Assigned To | Christian Grothoff => Florian Dold |
| 2024-07-01 00:27 | Florian Dold | Status | assigned => resolved |
| 2024-07-01 00:27 | Florian Dold | Resolution | open => fixed |
| 2024-07-01 00:27 | Florian Dold | Note Added: 0022772 | |
| 2024-07-26 00:11 | Christian Grothoff | Fixed in Version | => 0.12 |
| 2024-07-26 00:11 | Christian Grothoff | Status | resolved => closed |
