View Issue Details

IDProjectCategoryView StatusLast Update
0010156Talerexchangepublic2025-08-31 17:10
ReporterFlorian Dold Assigned ToFlorian Dold 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
PriorityhighSeveritymajorReproducibilityhave not tried
Status closedResolutionfixed 
Target Version1.0 stretch goalsFixed in Version1.0 stretch goals 
Summary0010156: harness test kyc-decision-events fails with SQL error
Descriptiontaler-harness run-integrationtests kyc-decision-events
Additional Information2025-07-07T23:07:04.715639+0200 pq-233541(112YMKWA49QCGKEV6R3ZXWS1PM) DEBUG Preparing SQL statement `SELECT event_type AS name,COUNT(*) AS value FROM kyc_events WHERE event_type IN $1 AND event_timestamp >= $2 AND event_timestamp < $3 GROUP BY event_type;' as `select_aml_statistics'
2025-07-07T23:07:04.715698+0200 pq-233541(112YMKWA49QCGKEV6R3ZXWS1PM) ERROR PQprepare (`SELECT event_type AS name,COUNT(*) AS value FROM kyc_events WHERE event_type IN $1 AND event_timestamp >= $2 AND event_timestamp < $3 GROUP BY event_type;' as `select_aml_statistics') failed with error: ERROR: syntax error at or near "$1"
LINE 1: ...T(*) AS value FROM kyc_events WHERE event_type IN $1 AND e...
                                                             ^

TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2025-07-07 23:07

manager   ~0025440

I fixed the SQL error, but the test still fails :-(

Christian Grothoff

2025-07-07 23:07

manager   ~0025441

Note that the API changed, I suspect you're expecting the old output syntax?

Florian Dold

2025-07-08 12:35

manager   ~0025445

Test passes again after adapting the test to the new response.

Issue History

Date ModifiedUsernameFieldChange
2025-07-07 21:08Florian DoldNew Issue
2025-07-07 21:08Florian DoldAssigned To => Florian Dold
2025-07-07 21:08Florian DoldStatusnew => assigned
2025-07-07 21:08Florian DoldAssigned ToFlorian Dold => Christian Grothoff
2025-07-07 21:09Florian DoldPrioritynormal => high
2025-07-07 21:09Florian DoldSeverityminor => major
2025-07-07 21:09Florian DoldTarget Version => 1.0 stretch goals
2025-07-07 23:07Christian GrothoffNote Added: 0025440
2025-07-07 23:07Christian GrothoffAssigned ToChristian Grothoff => Florian Dold
2025-07-07 23:07Christian GrothoffStatusassigned => feedback
2025-07-07 23:07Christian GrothoffNote Added: 0025441
2025-07-08 12:35Florian DoldStatusfeedback => informing
2025-07-08 12:35Florian DoldResolutionopen => fixed
2025-07-08 12:35Florian DoldNote Added: 0025445
2025-08-31 17:09Christian GrothoffStatusinforming => closed
2025-08-31 17:10Christian GrothoffFixed in Version => 1.0 stretch goals