View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0009122 | Taler | exchange | public | 2024-08-23 23:58 | 2024-08-28 23:31 |
| Reporter | sebasjm | Assigned To | Christian Grothoff | ||
| Priority | normal | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | fixed | ||
| Product Version | git (master) | ||||
| Target Version | 0.13 | Fixed in Version | 0.13 | ||
| Summary | 0009122: sql error after an aml program fails [2h] | ||||
| Description | I get this error after some error in the aml program script i'm unable to recover the kyc process of the account LOG Aug 23 18:13:18 T480s taler-exchange-httpd[513600]: (HFZ7A1FMTT4TKX8T4CEWVANF2M) ERROR Statement lookup_pending_legitimization returned more than one result, but there must be at most one when using GNUNET_PQ_eval_prepared_singleton_select Aug 23 18:13:18 T480s taler-exchange-httpd[513600]: (HFZ7A1FMTT4TKX8T4CEWVANF2M) ERROR Assertion failed at pq_eval.c:234. Aug 23 18:13:18 T480s taler-exchange-httpd[513600]: (HFZ7A1FMTT4TKX8T4CEWVANF2M) ERROR Assertion failed at taler-exchange-httpd_kyc-upload.c:479. | ||||
| Tags | No tags attached. | ||||
| related to | 0009104 | closed | Christian Grothoff | problems with the integration between kyc challenger and exchange [2h] |
|
|
Can you please attach a dump of your exchange database? |
|
|
Suspicion: there are *two* entries in legitimization_processes with the same legitimization_measure_serial_id. Then the first left join has two results, and the 2nd left join returns two sets of attributes, and we return both and thus two results. |
|
|
Question: why do we even NEED the encrypted attributes here? |
|
|
the kyc-start endpoint immediately discards them => if we keep this, split the endpoint into two. |
|
|
kyc-upload needs them for an idempotency check. But it has a measure index, which could be used to disambiguate the query and ensure a unique result! => split the DB API in two, one that takes an additional measure index for the query, and a 2nd that doesn't return the attributes. |
|
|
Should be fixed in 79f312df..c98b47d1 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-08-23 23:58 | sebasjm | New Issue | |
| 2024-08-23 23:58 | sebasjm | Status | new => assigned |
| 2024-08-23 23:58 | sebasjm | Assigned To | => Christian Grothoff |
| 2024-08-24 09:34 | Christian Grothoff | Target Version | git (master) => 0.13 |
| 2024-08-24 10:33 | Christian Grothoff | Note Added: 0023042 | |
| 2024-08-24 10:36 | Christian Grothoff | Note Added: 0023043 | |
| 2024-08-24 10:36 | Christian Grothoff | Note Added: 0023044 | |
| 2024-08-24 10:38 | Christian Grothoff | Note Added: 0023045 | |
| 2024-08-24 10:39 | Christian Grothoff | Note Added: 0023046 | |
| 2024-08-24 10:39 | Christian Grothoff | Summary | sql error after an aml program fails => sql error after an aml program fails [2h] |
| 2024-08-24 10:41 | Christian Grothoff | Relationship added | related to 0009104 |
| 2024-08-24 14:50 | Christian Grothoff | Status | assigned => resolved |
| 2024-08-24 14:50 | Christian Grothoff | Resolution | open => fixed |
| 2024-08-24 14:50 | Christian Grothoff | Fixed in Version | => 0.13 |
| 2024-08-24 14:50 | Christian Grothoff | Note Added: 0023048 | |
| 2024-08-28 23:31 | Christian Grothoff | Status | resolved => closed |
