View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006991 | Taler | exchange | public | 2021-08-13 11:10 | 2021-09-02 16:14 |
| 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.8 | Fixed in Version | 0.8 | ||
| Summary | 0006991: exchange gives non-actionable error message regarding SQL | ||||
| Description | This is currently happening on taler-test@gv when calling taler-deployment-prepare after deleting the database: Aug 13 13:05:41-054427 taler-exchange-dbinit-3577276 WARNING Could not run PSQL on file /home/taler-test/local/share/taler//sql/exchange/drop0000.sql: 1 | ||||
| Tags | No tags attached. | ||||
| Happens after this: $ dropdb talertest $ createdb talertest $ taler-exchange-dbinit -r | |
| Well, resetting a fresh DB is "wrong". Before, we logged: $ taler-exchange-dbinit -r -L INFO Aug 18 10:20:16-314294 taler-exchange-dbinit-7167 INFO Failed to prepare statement to check patch level. Likely versioning schema does not exist yet, loading patch level 0000! Aug 18 10:20:16-314356 taler-exchange-dbinit-7167 INFO Applying SQL file `/home/grothoff/share/taler//sql/exchange/drop0000.sql' on database postgres:///taler Aug 18 10:20:16-366811 taler-exchange-dbinit-7167 WARNING Could not run PSQL on file /home/grothoff/share/taler//sql/exchange/drop0000.sql: 1 Aug 18 10:20:16-366847 taler-exchange-dbinit-7167 ERROR Failed to run SQL logic to setup database versioning logic Aug 18 10:20:16-366893 taler-exchange-dbinit-7167 WARNING Could not drop tables as requested. Either database was not yet initialized, or permission denied. Consult the logs. Will still try to create new tables. Aug 18 10:20:16-369497 taler-exchange-dbinit-7167 INFO Failed to prepare statement to check patch level. Likely versioning schema does not exist yet, loading patch level 0000! Aug 18 10:20:16-369536 taler-exchange-dbinit-7167 INFO Applying SQL file `/home/grothoff/share/taler//sql/exchange/exchange-0000.sql' on database postgres:///taler Aug 18 10:20:16-436602 taler-exchange-dbinit-7167 INFO Loading SQL resources from `/home/grothoff/share/taler//sql/exchange/exchange-' Aug 18 10:20:16-437464 taler-exchange-dbinit-7167 INFO Applying SQL file `/home/grothoff/share/taler//sql/exchange/exchange-0001.sql' on database postgres:///taler Aug 18 10:20:16-546966 taler-exchange-dbinit-7167 INFO Applying SQL file `/home/grothoff/share/taler//sql/exchange/exchange-0002.sql' on database postgres:///taler I've changed it so that the ERROR is now a WARNING, and the "Could not drop tables as requested" is now an ERROR. | |
| Fix committed to master branch. | |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-08-13 11:10 | Florian Dold | New Issue | |
| 2021-08-13 11:10 | Florian Dold | Status | new => assigned |
| 2021-08-13 11:10 | Florian Dold | Assigned To | => Christian Grothoff |
| 2021-08-13 11:14 | Florian Dold | Category | mechant backend => exchange |
| 2021-08-13 11:14 | Florian Dold | Summary | mechant backend gives non-actionable error message regarding SQL => exchange backend gives non-actionable error message regarding SQL |
| 2021-08-13 11:14 | Florian Dold | Summary | exchange backend gives non-actionable error message regarding SQL => exchange gives non-actionable error message regarding SQL |
| 2021-08-13 12:10 | Florian Dold | Note Added: 0018111 | |
| 2021-08-18 08:30 | Christian Grothoff | Note Added: 0018116 | |
| 2021-08-18 08:30 | Christian Grothoff | Status | assigned => informing |
| 2021-08-18 08:30 | Christian Grothoff | Resolution | open => fixed |
| 2021-08-18 08:30 | Christian Grothoff | Fixed in Version | => 0.9 |
| 2021-08-18 08:30 | Christian Grothoff | Product Version | => git (master) |
| 2021-08-18 08:30 | Christian Grothoff | Target Version | => 0.9 |
| 2021-08-23 14:23 | Christian Grothoff | Fixed in Version | 0.9 => 0.8 |
| 2021-08-23 14:23 | Christian Grothoff | Target Version | 0.9 => 0.8 |
| 2021-08-24 14:22 | Christian Grothoff | Status | informing => closed |
| 2021-09-02 16:13 | Christian Grothoff | ||
| 2021-09-02 16:14 | Christian Grothoff | Note Added: 0018218 |