View Issue Details

IDProjectCategoryView StatusLast Update
0009751Talerexchangepublic2025-05-10 02:10
Reportersebasjm Assigned ToChristian Grothoff Resolution deadline
ImplementerReviewer 
Release signed byDeployed by 
VerifierCommunicator 
Data protection authority notification requiredNo  
CSIRT notification requiredNo  
Estimated effort (hours)Actual effort (hours)0 
Fast-trackNo
Work packagenone
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Versiongit (master) 
Target Version1.0Fixed in Version1.0 
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.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

sebasjm

2025-04-17 14:03

developer   ~0024590

I dropped the db and started again and seems fixed.

Issue History

Date ModifiedUsernameFieldChange
2025-04-17 13:44sebasjmNew Issue
2025-04-17 13:44sebasjmStatusnew => assigned
2025-04-17 13:44sebasjmAssigned To => Christian Grothoff
2025-04-17 14:03sebasjmNote Added: 0024590
2025-04-17 14:04sebasjmStatusassigned => informing
2025-04-17 14:04sebasjmResolutionopen => fixed
2025-05-04 21:19Christian GrothoffProduct Version1.0 => git (master)
2025-05-04 21:19Christian GrothoffFixed in Version => 1.0
2025-05-04 21:19Christian GrothoffTarget Versiongit (master) => 1.0
2025-05-10 02:10Christian GrothoffStatusinforming => closed