View Issue Details

IDProjectCategoryView StatusLast Update
0009429Talerexchangepublic2024-12-29 09:37
ReporterChristian Grothoff Assigned ToChristian Grothoff  
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.

Activities

Christian Grothoff

2024-12-29 09: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 09:26

manager   ~0023921

null value in column "trigger_outcome_serial" violates not-null

Christian Grothoff

2024-12-29 09: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 09: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 09:37

manager   ~0023924

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

Issue History

Date Modified Username Field Change
2024-12-29 09:18 Christian Grothoff New Issue
2024-12-29 09:18 Christian Grothoff Status new => assigned
2024-12-29 09:18 Christian Grothoff Assigned To => Christian Grothoff
2024-12-29 09:25 Christian Grothoff Note Added: 0023920
2024-12-29 09:26 Christian Grothoff Note Added: 0023921
2024-12-29 09:28 Christian Grothoff Note Added: 0023922
2024-12-29 09:31 Christian Grothoff Note Added: 0023923
2024-12-29 09:37 Christian Grothoff Status assigned => resolved
2024-12-29 09:37 Christian Grothoff Resolution open => no change required
2024-12-29 09:37 Christian Grothoff Fixed in Version => 1.0
2024-12-29 09:37 Christian Grothoff Note Added: 0023924
2024-12-29 09:37 Christian Grothoff Status resolved => closed