View Issue Details

IDProjectCategoryView StatusLast Update
0004657Talermerchant backendpublic2018-01-30 07:36
ReporterMarcello Stanisci Assigned ToMarcello Stanisci 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
PrioritynormalSeverityminorReproducibilityunable to reproduce
Status closedResolutionfixed 
Product Version0.0 
Target Version0.2Fixed in Version0.2 
Summary0004657: /track/* bad logs
DescriptionThe merchant BE shows a few bad looking logs, like the following:

1.
Sep 14 14:22:01-916149 taler-merchant-httpd-21475 ERROR Assertion failed at taler-merchant-httpd_track-transaction.c:721

2.
Sep 14 10:51:36-956523 taler-merchant-httpd-21475 ERROR Assertion failed at plugin_merchantdb_postgres.c:470.
Sep 14 10:51:36-956556 taler-merchant-httpd-21475 ERROR Database failure: ERROR: duplicate key value violates unique constraint "merchant_transfers_pkey"
DETAIL: Key (transaction_id, coin_pub)=(1017845521133909, \x670ad419769ae8c1a78abac318e6004a93ce55aef303928a26940dad4910b28a) already exists.

Sep 14 10:51:36-956573 taler-merchant-httpd-21475 ERROR Failed to persist coin to wire transfer mapping in DB

1. happens on /track/transaction (always), 2. on /track/transfer (not always).
Steps To ReproduceGo to shop.test.taler.net/track and try to track your transfers/transactions
TagsNo tags attached.

Required notifications

Address or linkRemarkAdded byNotifiedActions

Activities

Marcello Stanisci

2016-09-15 08:14

reporter   ~0011117

Gotten the following as well:

3. 'Failed to store coin-to-transfer mapping in DB'

Marcello Stanisci

2016-09-16 13:41

reporter   ~0011120

Not able to manually reproduce it after erasing the DB. Some bogus data may have corrupted things. Try on test cases ..

Marcello Stanisci

2016-10-11 15:21

reporter   ~0011295

Could not reproduce

Marcello Stanisci

2016-10-11 20:01

reporter   ~0011310

Again, but still not reproduced (affects 52e82c8e9)

Oct 11 21:37:47-300742 taler-merchant-httpd-826 ERROR Assertion failed at plugin_merchantdb_postgres.c:486.
Oct 11 21:37:47-300784 taler-merchant-httpd-826 ERROR Database failure: ERROR: duplicate key value violates unique constraint "merchant
_transfers_pkey"
DETAIL: Key (transaction_id, coin_pub)=(678634139771024, \x8ad1369621c472ae02c3aeb7f230b1b6d375a3d6e0e8f13b9982246147e3f5a5) already ex
ists.

Christian Grothoff

2016-10-14 13:18

manager   ~0011324

Not sure if fixed, Marcello will monitor to see if this is still an issue.

Christian Grothoff

2016-10-27 21:00

manager   ~0011395

Marcello ponders whether d50060c..8814b79 might have fixed this.

Marcello Stanisci

2016-11-30 14:03

reporter   ~0011556

Reappeared.

Nov 30 14:57:12-705657 taler-merchant-httpd-13121 ERROR Failed to store coin-to-transfer mapping in DB
Nov 30 14:57:12-705665 taler-merchant-httpd-13121 DEBUG Executing prepared SQL statement `insert_transfer'
Nov 30 14:57:12-705914 taler-merchant-httpd-13121 ERROR Assertion failed at plugin_merchantdb_postgres.c:516.
Nov 30 14:57:12-705935 taler-merchant-httpd-13121 ERROR Database failure: ERROR: duplicate key value violates unique constraint "merchant_transfers_pkey"
DETAIL: Key (transaction_id, coin_pub)=(509850176400709, \x183c8c8fd70a2d7ddd7ae127cd70325837c38a09fce3d9923732d8eb56a3ad01) already exists.

Nov 30 14:57:12-705944 taler-merchant-httpd-13121 ERROR Failed to store coin-to-transfer mapping in DB
Nov 30 14:57:12-705990 taler-merchant-httpd-13121 INFO Handling request for URL `/track/transaction'

Marcello Stanisci

2016-11-30 14:04

reporter   ~0011557

It doesn't seem to crash things though, so not (?) demo-killer.

Marcello Stanisci

2016-12-08 16:25

reporter   ~0011584

Likely to be gone with 1a273fd.

Christian Grothoff

2018-01-30 07:36

manager   ~0012838

Please file new report if this comes back.

Issue History

Date ModifiedUsernameFieldChange
2016-09-14 13:38Marcello StanisciNew Issue
2016-09-14 13:38Marcello StanisciStatusnew => assigned
2016-09-14 13:38Marcello StanisciAssigned To => Marcello Stanisci
2016-09-14 13:38Marcello StanisciPrioritynormal => high
2016-09-15 08:14Marcello StanisciNote Added: 0011117
2016-09-16 13:41Marcello StanisciNote Added: 0011120
2016-09-22 13:19Marcello StanisciReproducibilityhave not tried => unable to reproduce
2016-09-26 11:55Christian GrothoffProduct Version => 0.0
2016-09-26 11:55Christian GrothoffTarget Version => 0.1
2016-09-27 20:29Christian GrothoffTarget Version0.1 => 0.2
2016-10-11 15:21Marcello StanisciNote Added: 0011295
2016-10-11 15:21Marcello StanisciAssigned ToMarcello Stanisci =>
2016-10-11 15:21Marcello StanisciStatusassigned => feedback
2016-10-11 15:22Marcello StanisciPriorityhigh => low
2016-10-11 20:01Marcello StanisciNote Added: 0011310
2016-10-11 20:01Marcello StanisciStatusfeedback => new
2016-10-11 20:01Marcello StanisciPrioritylow => normal
2016-10-11 20:01Marcello StanisciStatusnew => acknowledged
2016-10-14 13:18Christian GrothoffNote Added: 0011324
2016-10-14 13:18Christian GrothoffAssigned To => Marcello Stanisci
2016-10-14 13:18Christian GrothoffStatusacknowledged => feedback
2016-10-27 21:00Christian GrothoffNote Added: 0011395
2016-11-19 11:56Christian GrothoffStatusfeedback => informing
2016-11-19 11:56Christian GrothoffResolutionopen => fixed
2016-11-19 11:56Christian GrothoffFixed in Version => 0.2
2016-11-20 02:26Christian GrothoffStatusinforming => closed
2016-11-30 14:02Marcello StanisciStatusclosed => feedback
2016-11-30 14:02Marcello StanisciResolutionfixed => reopened
2016-11-30 14:03Marcello StanisciNote Added: 0011556
2016-11-30 14:04Marcello StanisciNote Added: 0011557
2016-12-02 16:00Marcello StanisciStatusfeedback => implementing
2016-12-02 16:00Marcello StanisciStatusimplementing => assigned
2016-12-07 13:26Marcello StanisciPrioritynormal => high
2016-12-08 16:25Marcello StanisciStatusassigned => feedback
2016-12-08 16:25Marcello StanisciNote Added: 0011584
2016-12-08 16:26Marcello StanisciPriorityhigh => normal
2018-01-30 07:36Christian GrothoffStatusfeedback => closed
2018-01-30 07:36Christian GrothoffResolutionreopened => fixed
2018-01-30 07:36Christian GrothoffNote Added: 0012838
2025-03-22 13:09Christian GrothoffCategorymechant backend => merchant backend