Duplicate transaction not settling correctly (also should probably reverse it)
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	Eileenmcnaughton
	Dec 17 2025, 4:12 AM

Description

https://civicrm.wikimedia.org/civicrm/admin/search#/create/Contribution?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22receive_date%22,%22contact_id.sort_name%22,%22total_amount%22,%22financial_type_id:label%22,%22contribution_status_id:label%22,%22contribution_extra.backend_processor_txn_id%22,%22contribution_extra.gateway_txn_id%22,%22trxn_id%22,%22invoice_id%22,%22contribution_extra.source_type%22,%22contribution_settlement.settlement_batch_reference%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22contact_id%22,%22%3D%22,%2269250764%22%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5D,%22having%22:%5B%5D%7D

I found a handful of probables like this - I will try to manually clean up & then retry the audit

We rolled out a fix on 12 Dec and the one that I found pre-cedes that. This is the relevant patch

https://gerrit.wikimedia.org/r/c/1216566

Note the underlying Smashpig allows for 2 sort values to be passed - so far I *think* 1 is enough to prevent conflict but need to keep an eye on that

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Find original details from contribution for chargeback, refund, reversals	wikimedia/fundraising/crm	master	+30 -4
	Keep refund_reversal date, do not let recurring contaminate it	wikimedia/fundraising/crm	master	+6 -5

Customize query in gerrit

Related Objects

Mentioned In: T414520: Fundraising Sprint Y Priorities

Event Timeline

Eileenmcnaughton created this task.Dec 17 2025, 4:12 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 17 2025, 4:12 AM

The ones I found

SELECT count(*) as c, backend_processor_txn_id FROM wmf_contribution_extra WHERE backend_processor_tx
n_id IS NOT NULL AND backend_processor_txn_id <> '' AND gateway ='gravy' GROUP BY backend_processor_txn_id HAVING c > 1;

c	backend_processor_txn_id
2	6Y000841YR5584729
2	BZR78QXLWJRLDC69
2	C8X96PNXLJ6TJM35
2	CCLRX4SGCS6BLX25
2	DHN52N2W6FKD7K69
2	DM73X5223569GZ99
2	F62NMTHN5GD63735
2	H6D5ZTD4J88T4F69
2	HP3LNTJTXPCWMD35
2	JHT5VBP6LHDR5569
2	K632M6ZGCS6BLX25
2	LFJL6N6XJNZSK569
2	LKJ94K3RFBH7D869
2	NL2FHXM5RSLH63B9
2	NM7LVMRSGVKC42B9
2	P8BK7H37RSLH63B9
2	PM895WLVPKQ3H7B9
2	PR9WFJL8SDZBSX25
2	QLG6PKD5V3QPQMB9
2	R4KFR3WHZ6FMPS99
2	RMQ78QG4NXWSZC35
2	S69PRLVZVJRLDC69
2	TNH6C49KQN4RMDB9
2	TTP4HDRCM5PKNLB9
2	V8CPP9VQ3F9T5T25
2	W5J23CBQ3F9T5T25
2	XPSHQ5W23569GZ99
2	Z7N9MLWXLM5BKJ69
2	Z9JCJCR98T5SDNB9

+---+--------------------------+
29 rows in set (18.753 sec)

Eileenmcnaughton updated the task description. (Show Details)Dec 17 2025, 4:15 AM

6 of the above were templates (cleared) & I cleared the original one manually

New query excludes chargeback reversals

SELECT count(*) as c, GROUP_CONCAT(contact_id), backend_processor_txn_id FROM wmf_contribution_extra x INNER JOIN civicrm_contribution c ON x.entity_id = c.id WHERE backend_processor_txn_id IS NOT NULL AND backend_processor_txn_id <> '' AND gateway ='gravy' AND trxn_id NOT LIKE 'chargeback_re%' GROUP BY backend_processor_txn_id HAVING c > 1;

I've fixed the ones recent enough to be in the pending table - which should be enough

c |contact_ids | backend_processor_txn_id |comment

2	12769425	CCLRX4SGCS6BLX25	back in Aug
2	40300849	DM73X5223569GZ99	Back in Sep
2	68758038	H6D5ZTD4J88T4F69	Oct - fixed
2	25110915	JHT5VBP6LHDR5569	Sep
2	10318928	K632M6ZGCS6BLX25	Aug - noted in DR slack channel as larger amount
2	50133189	PR9WFJL8SDZBSX25	Aug
2	39852746	R4KFR3WHZ6FMPS99	Sep
2	68344192	TNH6C49KQN4RMDB9	aug
2	36241250	TTP4HDRCM5PKNLB9	fixed
2	68360720	V8CPP9VQ3F9T5T25	Sep
2	5104115	W5J23CBQ3F9T5T25	Sep
2	30882616	XPSHQ5W23569GZ99	Sep - fixed
2	66464263	Z7N9MLWXLM5BKJ69	Apr

Change #1219532 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Keep refund_reversal date, do not let recurring contaminate it

https://gerrit.wikimedia.org/r/1219532

gerritbot added a project: Patch-For-Review.Dec 18 2025, 8:30 AM

Change #1219532 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Keep refund_reversal date, do not let recurring contaminate it

https://gerrit.wikimedia.org/r/1219532

Maintenance_bot removed a project: Patch-For-Review.Dec 18 2025, 10:31 PM

Change #1220051 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Find original details from contribution for chargeback, refund, reversals

https://gerrit.wikimedia.org/r/1220051

gerritbot added a project: Patch-For-Review.Dec 22 2025, 6:15 AM

Change #1220051 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Find original details from contribution for chargeback, refund, reversals

https://gerrit.wikimedia.org/r/1220051

Maintenance_bot removed a project: Patch-For-Review.Dec 22 2025, 8:30 PM

AKanji-WMF moved this task from Triage to Current Sprint on the Fundraising-Backlog board.Dec 22 2025, 9:25 PM

AKanji-WMF added a project: Fundraising Sprint: Yabba Dabba Stew.

Damilare moved this task from Backlog to Done on the Fundraising Sprint: Yabba Dabba Stew board.Jan 5 2026, 9:00 PM

XenoRyet closed this task as Resolved.Jan 12 2026, 8:40 PM

XenoRyet set Final Story Points to 4.

Damilare mentioned this in T414520: Fundraising Sprint Y Priorities.Jan 13 2026, 6:55 PM

Duplicate transaction not settling correctly (also should probably reverse it)Closed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Duplicate transaction not settling correctly (also should probably reverse it)
Closed, ResolvedPublic
Actions