View Issue Details

IDProjectCategoryView StatusLast Update
0009429Talerexchangepublic2024-12-29 08:37
ReporterChristian Grothoff 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
PrioritynormalSeveritycrashReproducibilityhave not tried
Status closedResolutionno change required 
Platformi7OSDebian GNU/LinuxOS Versionsqueeze
Product Versiongit (master) 
Target Version1.0Fixed in Version1.0 
Summary0009429: accepting ToS in KYC SPA causes exchange internal error
DescriptionDec 29 09:17:22 spec taler-exchange-httpd[3707354]: (TJ3BSCDWJQT8PC3PSPB49NC9D0) ERROR Assertion failed at taler-exchange-httpd_common_kyc.c:331.
Dec 29 09:17:22 spec taler-exchange-httpd[3707354]: (TJ3BSCDWJQT8PC3PSPB49NC9D0) INFO Stored encrypted KYC process #1 attributes: -2
Dec 29 09:17:22 spec taler-exchange-httpd[3707354]: (TJ3BSCDWJQT8PC3PSPB49NC9D0) ERROR Assertion failed at taler-exchange-httpd_kyc-upload.c:606.
Dec 29 09:17:22 spec taler-exchange-httpd[3707354]: (TJ3BSCDWJQT8PC3PSPB49NC9D0) INFO Request for `/kyc-upload/WSJFM620CZYPZPVV748WYK7TEHYV1WJXWXX5E83Y94ET5J8SRJK0-0-7' completed with HTTP status 500 (0)
^C
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Christian Grothoff

2024-12-29 08:25

manager   ~0023920

(TJ3BSCDWJQT8PC3PSPB49NC9D0) INFO Inserting KYC attributes, wake up on XH3VDQ7FY2F8Y5W3XWMP0T5QS8>
: (TJ3BSCDWJQT8PC3PSPB49NC9D0) ERROR Query `persist_kyc_attributes' failed with result: null value >
: DETAIL: Failing row contains (1, \x6f719b2dbe80443ae1a28bcca7a35880749174378e062556d1d2ee3c05fd4>
: CONTEXT: SQL statement "INSERT INTO kyc_attributes
: (h_payto
: ,collection_time
: ,expiration_time
: ,encrypted_attributes
: ,legitimization_serial
: ) VALUES
: (in_h_payto
: ,in_collection_time_ts
: ,in_expiration_time_ts
: ,in_enc_attributes
: ,in_process_row)"

Christian Grothoff

2024-12-29 08:26

manager   ~0023921

null value in column "trigger_outcome_serial" violates not-null

Christian Grothoff

2024-12-29 08:28

manager   ~0023922

Strange, that column ought not exist:

CREATE FUNCTION alter_table_kyc_attributes7(
  IN partition_suffix TEXT DEFAULT NULL
)
RETURNS VOID
LANGUAGE plpgsql
AS $$
DECLARE
  table_name TEXT DEFAULT 'kyc_attributes';
BEGIN
  PERFORM create_partitioned_table(
    'ALTER TABLE %I'
    ' DROP COLUMN trigger_outcome_serial'
    ';'
    ,table_name
    ,''
    ,partition_suffix
  );
END $$;

Christian Grothoff

2024-12-29 08:31

manager   ~0023923

The plot thickens:

 select * from exchange.exchange_tables where version='exchange-0007';

fails to show the alter on kyc_attributes7!

Christian Grothoff

2024-12-29 08:37

manager   ~0023924

Outdated DB schema, exchange-0007 was run on some non-release version before...

Issue History

Date ModifiedUsernameFieldChange
2024-12-29 08:18Christian GrothoffNew Issue
2024-12-29 08:18Christian GrothoffStatusnew => assigned
2024-12-29 08:18Christian GrothoffAssigned To => Christian Grothoff
2024-12-29 08:25Christian GrothoffNote Added: 0023920
2024-12-29 08:26Christian GrothoffNote Added: 0023921
2024-12-29 08:28Christian GrothoffNote Added: 0023922
2024-12-29 08:31Christian GrothoffNote Added: 0023923
2024-12-29 08:37Christian GrothoffStatusassigned => informing
2024-12-29 08:37Christian GrothoffResolutionopen => no change required
2024-12-29 08:37Christian GrothoffFixed in Version => 1.0
2024-12-29 08:37Christian GrothoffNote Added: 0023924
2024-12-29 08:37Christian GrothoffStatusinforming => closed