View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005127 | Taler | merchant backend | public | 2017-08-25 15:39 | 2024-01-12 13:04 |
| 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 | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | git (master) | ||||
| Target Version | 0.4 | Fixed in Version | 0.4 | ||
| Summary | 0005127: merchant stops working when postgres upgrades | ||||
| Description | See logs below. Looks like the merchant doesn't re-connect to the DB when there's an error. Interestingly this only showed on test, not on demo. Maybe someone manually restarted demo? Or this only happens due to newer code? | ||||
| Additional Information | Aug 25 16:50:26-390251 taler-merchant-httpd-2898 DEBUG inserting contract_terms: order_id: 16:50:26-BE1AEF237C35E000, merchant_pub: RQ6KBZ4N, h_contract_terms: NGA8GDGT. Aug 25 16:50:26-390296 pq-2898 ERROR Failed to execute `CREATE TABLE IF NOT EXISTS merchant_contract_terms (order_id VARCHAR NOT NULL,merchant_pub BYTEA NOT NULL,contract_terms BYTEA NOT NULL,h_contract_terms BYTEA NOT NULL,timestamp INT8 NOT NULL,row_id BIGSERIAL UNIQUE,paid BYTEA NOT NULL ,PRIMARY KEY (order_id, merchant_pub),UNIQUE (h_contract_terms, merchant_pub));': (null)/(null)//PGRES_FATAL_ERROR/no connection to the server Aug 25 16:50:26-390308 taler-merchant-httpd-2898 ERROR Assertion failed at plugin_merchantdb_postgres.c:473. Aug 25 16:50:26-390316 taler-merchant-httpd-2898 ERROR Assertion failed at plugin_merchantdb_postgres.c:500. Aug 25 16:50:26-390344 pq-2898 DEBUG Executing prepared SQL statement `insert_contract_terms' Aug 25 16:50:26-390355 taler-merchant-httpd-2898 ERROR Assertion failed at pq_eval.c:73. | ||||
| Tags | No tags attached. | ||||
| Well, if the above happens *during* Postgres restart, that is normal an expected, as while the DB is gone we do expect to get failures from trying to access it. But it should recover once the DB is back. Git 4cfe3ac..f795e36 fixes a (related?) bug in the handling of such errors, where /pay would not execute the usually required number of retries. | |
| Ah, indeed found that a call to "GNUNET_PQ_connect_with_cfg (pg->cfg," was also missing in check_connection(). Fixed in 58bcfc40d82ceddf5db759ccd8de0ebf6b48e49c | |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-08-25 15:39 | Florian Dold | New Issue | |
| 2017-08-25 15:39 | Florian Dold | Status | new => assigned |
| 2017-08-25 15:39 | Florian Dold | Assigned To | => Christian Grothoff |
| 2017-08-27 07:11 | Christian Grothoff | Product Version | => git (master) |
| 2017-08-27 07:11 | Christian Grothoff | Target Version | => 0.4 |
| 2017-08-31 12:01 | Christian Grothoff | Note Added: 0012400 | |
| 2017-08-31 12:05 | Christian Grothoff | Note Added: 0012401 | |
| 2017-08-31 12:08 | Christian Grothoff | Status | assigned => informing |
| 2017-08-31 12:08 | Christian Grothoff | Resolution | open => fixed |
| 2017-08-31 12:08 | Christian Grothoff | Fixed in Version | => 0.4 |
| 2017-10-18 13:42 | Christian Grothoff | Status | informing => closed |
| 2021-09-02 16:22 | Christian Grothoff | ||
| 2024-01-12 13:04 | Christian Grothoff | Category | merchant backend API (C) => mechant backend |
| 2025-03-22 13:09 | Christian Grothoff | Category | mechant backend => merchant backend |