View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005484 | Taler | auditor | public | 2018-11-26 10:43 | 2021-09-02 16:14 |
| Reporter | Marcello Stanisci | 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 | high | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | git (master) | ||||
| Target Version | 0.6 | Fixed in Version | 0.6 | ||
| Summary | 0005484: Database crash - foreign key "violation". | ||||
| Description | This happens even after a reset of both exchanges and auditor tables. Nov 26 11:29:22-200535 taler-auditor-4692 DEBUG Analyzing coins * First analysis using this auditor, starting audit from scratch Nov 26 11:29:22-204455 pq-4692 ERROR Query `auditor_balance_summary_insert' failed with result: insert or update on table "auditor_balance_summary" violates foreign key constraint "master_pub_ref"/Key (master_pub)=(\xdd46afd1d5bab825721e46767e266f17e04243090114d7727a3cd287f16d05f9) is not present in table "auditor_exchanges"./ERROR: insert or update on table "auditor_balance_summary" violates foreign key constraint "master_pub_ref" DETAIL: Key (master_pub)=(\xdd46afd1d5bab825721e46767e266f17e04243090114d7727a3cd287f16d05f9) is not present in table "auditor_exchanges". /PGRES_FATAL_ERROR/ERROR: insert or update on table "auditor_balance_summary" violates foreign key constraint "master_pub_ref" DETAIL: Key (master_pub)=(\xdd46afd1d5bab825721e46767e266f17e04243090114d7727a3cd287f16d05f9) is not present in table "auditor_exchanges". | ||||
| Steps To Reproduce | just run: $ taler-auditor. | ||||
| Additional Information | Heppens locally on my machine. | ||||
| Tags | No tags attached. | ||||
| Could just get this error on Tripwire too. | |
| Ok, admittedly the error message ought to be improved, but I think you get this because you did not use taler-auditor-exchange first (or not correctly). Basically, the DB complains that the exchange's master public key isn't yet in the table. Leave this bug open for me to fix the UX, but running taler-auditor-exchange should unblock you. | |
| It did :-) | |
| Nicer error message added in 3ed5db97..feec0d49 | |
| Fix committed to master branch. | |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-11-26 10:43 | Marcello Stanisci | New Issue | |
| 2018-11-26 10:43 | Marcello Stanisci | Status | new => assigned |
| 2018-11-26 10:43 | Marcello Stanisci | Assigned To | => Christian Grothoff |
| 2018-11-26 10:46 | Marcello Stanisci | Steps to Reproduce Updated | |
| 2018-11-26 10:46 | Marcello Stanisci | Additional Information Updated | |
| 2018-11-30 21:05 | Marcello Stanisci | Note Added: 0013375 | |
| 2018-12-01 16:10 | Christian Grothoff | Note Added: 0013376 | |
| 2018-12-04 15:00 | Marcello Stanisci | Relationship added | child of 0005461 |
| 2018-12-04 15:03 | Marcello Stanisci | Note Added: 0013385 | |
| 2018-12-07 17:44 | Marcello Stanisci | Relationship deleted | child of 0005461 |
| 2019-01-08 18:11 | Christian Grothoff | Note Added: 0013449 | |
| 2019-01-08 18:11 | Christian Grothoff | Status | assigned => informing |
| 2019-01-08 18:11 | Christian Grothoff | Resolution | open => fixed |
| 2019-01-08 18:11 | Christian Grothoff | Fixed in Version | => 0.6 |
| 2019-01-08 18:11 | Christian Grothoff | Product Version | => git (master) |
| 2019-01-08 18:11 | Christian Grothoff | Target Version | => 0.6 |
| 2019-12-20 18:12 | Christian Grothoff | Status | informing => closed |
| 2021-09-02 16:13 | Christian Grothoff | ||
| 2021-09-02 16:14 | Christian Grothoff | Note Added: 0018279 |