View Issue Details

IDProjectCategoryView StatusLast Update
0009751Talerexchangepublic2025-04-17 16:04
Reportersebasjm Assigned ToChristian Grothoff  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version1.0 
Target Versiongit (master) 
Summary0009751: exchange error on kyccheck
Description$ taler-merchant-kyccheck --version
taler-merchant-kyccheck v0.14.8-git-bd4c47a9


$ taler-exchange-httpd --version
taler-exchange-httpd v0.14.16-git-3dbc7f97d

Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Handling request (GET) for URL '/kyc-check/0761WFZM8402TM157TM9EXT6CM8GZRJGKE5F5XQPBJ0XWG756AJG'
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Checking KYC status for normalized payto hash 0761WFZM8402TM157TM9EXT6CM8GZRJGKE5F5XQPBJ0XWG756AJG
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Long polling for target 1 with timeout 29 m
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Starting DB event listening
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Executing PQ command `LISTEN XXGJFM2YMQNKZ9FRB9X385HP1SNYGRFHGARE3Q9P7HDC7R3DPAP00'
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) DEBUG Adding task 0x5f9d4452d170
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Looking up KYC requirements for account V1VFTM9N
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) DEBUG Preparing SQL statement `SELECT out_account_pub AS account_pub,out_reserve_pub AS reserve_pub,out_access_token AS access_token,out_jrules AS jrules,out_not_found AS not_found,out_aml_review AS aml_review,out_kyc_required AS kyc_required,out_rule_gen AS rule_gen FROM exchange_do_lookup_kyc_requirement_by_row ($1);' as `lookup_kyc_requirement_by_row'
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) ERROR PQprepare (`SELECT out_account_pub AS account_pub,out_reserve_pub AS reserve_pub,out_access_token AS access_token,out_jrules AS jrules,out_not_found AS not_found,out_aml_review AS aml_review,out_kyc_required AS kyc_required,out_rule_gen AS rule_gen FROM exchange_do_lookup_kyc_requirement_by_row ($1);' as `lookup_kyc_requirement_by_row') failed with error: ERROR: column "out_rule_gen" does not exist
Apr 17 10:38:19 taler-exchange-httpd[9654]: LINE 1: ...ew AS aml_review,out_kyc_required AS kyc_required,out_rule_g...
Apr 17 10:38:19 taler-exchange-httpd[9654] ^
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) ERROR Assertion failed at pg_lookup_kyc_requirement_by_row.c:94.
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) ERROR Assertion failed at taler-exchange-httpd_kyc-check.c:319.
Apr 17 10:38:19 taler-exchange-httpd[9654]: (PFZWY9X4XNAPHRCV8Y05STQG5R) INFO Cancelling DB event listening
TagsNo tags attached.

Activities

sebasjm

2025-04-17 16:03

developer   ~0024590

I dropped the db and started again and seems fixed.

Issue History

Date Modified Username Field Change
2025-04-17 15:44 sebasjm New Issue
2025-04-17 15:44 sebasjm Status new => assigned
2025-04-17 15:44 sebasjm Assigned To => Christian Grothoff
2025-04-17 16:03 sebasjm Note Added: 0024590
2025-04-17 16:04 sebasjm Status assigned => resolved
2025-04-17 16:04 sebasjm Resolution open => fixed