View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0010613 | Taler | exchange | public | 2025-11-14 21:16 | 2025-11-15 00:37 |
| Reporter | Florian Dold | Assigned To | Christian Grothoff | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Product Version | 1.0 | ||||
| Target Version | 1.2 | Fixed in Version | 1.2 | ||
| Summary | 0010613: exchange produces HTTP 500 and sql error log when inserting KYC attributes in decision | ||||
| Description | See summary. | ||||
| Steps To Reproduce | $ taler-harness run-integrationtests kyc-decision-events | ||||
| Additional Information | (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Handling request (POST) for URL '/aml/5BH5VPN2V3F8ZKHHM7QCSF5Z87ZS2FB2X5KE608X5SC9276DX47G/decision' (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Handling request (POST) for URL '/aml/5BH5VPN2V3F8ZKHHM7QCSF5Z87ZS2FB2X5KE608X5SC9276DX47G/decision' (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Handling request (POST) for URL '/aml/5BH5VPN2V3F8ZKHHM7QCSF5Z87ZS2FB2X5KE608X5SC9276DX47G/decision' (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Parsed KYC rule 0 for 2 with threshold TESTKUDOS:10 (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Parsed KYC rule 1 for 1 with threshold TESTKUDOS:0 (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Running prepared statement `gnunet_pq_get_oid_by_name' on 0xcc6a570 (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Executing prepared SQL statement `gnunet_pq_get_oid_by_name' (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Execution of prepared SQL statement `gnunet_pq_get_oid_by_name' finished (PGRES_TUPLES_OK) (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Preparing SQL statement `SELECT out_invalid_officer,out_account_unknown,out_last_date,out_legitimization_measure_serial_id,out_is_wallet FROM exchange_do_insert_aml_decision($1,$2,$3,$4,$5,$6::TEXT::JSONB,$7,$8,$9,$10::TEXT::JSONB,$11,$12,$13::TEXT::JSONB,$14,$15,$16,$17,$18,$19);' as `do_insert_aml_decision' (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Running prepared statement `do_insert_aml_decision' on 0xcc6a570 (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Executing prepared SQL statement `do_insert_aml_decision' (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG Execution of prepared SQL statement `do_insert_aml_decision' finished (PGRES_FATAL_ERROR) (Q8MF44NEPP4QW8T6PW5DTPDPJG) ERROR Query `do_insert_aml_decision' failed with result: column "ini" does not exist/(null)/ERROR: column "ini" does not exist LINE 1: (ini-event = 'ACCOUNT_OPEN') ^ QUERY: (ini-event = 'ACCOUNT_OPEN') CONTEXT: PL/pgSQL function exchange_do_insert_aml_decision(text,bytea,bytea,bigint,bigint,jsonb,bytea,bytea,bigint,jsonb,boolean,text,jsonb,text,bytea,bytea,text,text[],text) line 223 at IF /PGRES_FATAL_ERROR/ERROR: column "ini" does not exist LINE 1: (ini-event = 'ACCOUNT_OPEN') ^ QUERY: (ini-event = 'ACCOUNT_OPEN') CONTEXT: PL/pgSQL function exchange_do_insert_aml_decision(text,bytea,bytea,bigint,bigint,jsonb,bytea,bytea,bigint,jsonb,boolean,text,jsonb,text,bytea,bytea,text,text[],text) line 223 at IF (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG PG poll job active (Q8MF44NEPP4QW8T6PW5DTPDPJG) DEBUG PG poll job finishes after 0 events (Q8MF44NEPP4QW8T6PW5DTPDPJG) ERROR Assertion failed at taler-exchange-httpd_aml-decision.c:423. (Q8MF44NEPP4QW8T6PW5DTPDPJG) INFO Request for `/aml/5BH5VPN2V3F8ZKHHM7QCSF5Z87ZS2FB2X5KE608X5SC9276DX47G/decision' completed with HTTP status 500 (0) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-11-14 21:16 | Florian Dold | New Issue | |
| 2025-11-15 00:37 | Christian Grothoff | Changeset attached | => exchange master 23056797 |
| 2025-11-15 00:37 | Christian Grothoff | Note Added: 0026453 | |
| 2025-11-15 00:37 | Christian Grothoff | Assigned To | => Christian Grothoff |
| 2025-11-15 00:37 | Christian Grothoff | Status | new => resolved |
| 2025-11-15 00:37 | Christian Grothoff | Resolution | open => fixed |
| 2025-11-15 00:37 | Christian Grothoff | Product Version | => 1.0 |
| 2025-11-15 00:37 | Christian Grothoff | Fixed in Version | => 1.2 |
