View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010020 | Taler | exchange | public | 2025-05-26 09:04 | 2025-08-31 17:09 |
| 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 | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | git (master) | ||||
| Target Version | 1.0 stretch goals | Fixed in Version | 1.0 stretch goals | ||
| Summary | 0010020: kyc-decisions test causes DB error in exchange | ||||
| Description | Looks related to the 0010003 fix. | ||||
| Steps To Reproduce | $ taler-harness run-integrationtests kyc-decisions | ||||
| Additional Information | 2025-05-26T10:48:34.897725+0200 pq-1224890(GHPFTFATT4MPJ8N3ZT038E3MS0) ERROR Query `do_insert_aml_decision' failed with result: insert or update on table "wire_targets" violates foreign key constraint "wire_targets_fk_kyc_targets"/Key (h_normalized_payto)=(\x9490719bef2024d7207ac7534368b3efba63be0483806e00a0d9bd4e5502e5ed) is not present in table "kyc_targets"./ERROR: insert or update on table "wire_targets" violates foreign key constraint "wire_targets_fk_kyc_targets" DETAIL: Key (h_normalized_payto)=(\x9490719bef2024d7207ac7534368b3efba63be0483806e00a0d9bd4e5502e5ed) is not present in table "kyc_targets". CONTEXT: SQL statement "INSERT INTO wire_targets (wire_target_h_payto ,h_normalized_payto ,payto_uri ) VALUES ( in_h_full_payto ,in_h_normalized_payto ,in_payto_uri )" PL/pgSQL function exchange_do_insert_aml_decision(text,bytea,bytea,bigint,bigint,text,bytea,bytea,bigint,text,boolean,text,text,text,bytea,bytea,text,text[],text) line 77 at SQL statement /PGRES_FATAL_ERROR/ERROR: insert or update on table "wire_targets" violates foreign key constraint "wire_targets_fk_kyc_targets" DETAIL: Key (h_normalized_payto)=(\x9490719bef2024d7207ac7534368b3efba63be0483806e00a0d9bd4e5502e5ed) is not present in table "kyc_targets". CONTEXT: SQL statement "INSERT INTO wire_targets (wire_target_h_payto ,h_normalized_payto ,payto_uri ) VALUES ( in_h_full_payto ,in_h_normalized_payto ,in_payto_uri )" | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-05-26 09:04 | Florian Dold | New Issue | |
| 2025-05-26 09:05 | Florian Dold | Assigned To | => Christian Grothoff |
| 2025-05-26 09:05 | Florian Dold | Status | new => assigned |
| 2025-05-26 11:38 | Christian Grothoff | Status | assigned => informing |
| 2025-05-26 11:38 | Christian Grothoff | Resolution | open => fixed |
| 2025-05-26 11:38 | Christian Grothoff | Fixed in Version | => 1.0 stretch goals |
| 2025-05-26 11:38 | Christian Grothoff | Product Version | => git (master) |
| 2025-08-31 17:09 | Christian Grothoff | Status | informing => closed |