Page MenuHomePhabricator
Create Task
Maniphest T404846

Suggested Investigations: SuggestedInvestigationsCaseLookupService uses the wrong database connection
Closed, ResolvedPublic0.1 Estimated Story PointsBUG REPORT
Actions

Description

SuggestedInvestigationsCaseLookupService uses the wrong database connection, so currently fails on production to create cases

Steps to replicate the issue
  1. Define a CheckUser-SuggestedInvestigations signal
  2. Meet the conditions to trigger the signal to match

What happens?:
No new case is shown in Special:SuggestedInvestigations and a DB error is shown in the logs

What should have happened instead?:
The new case should have been shown in Special:SuggestedInvestigations

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Use correct DB domain in SuggestedInvestigationsCaseLookupServiceDreamy Jazzmediawiki/extensions/CheckUsermaster+2 -1
Use correct DB domain in SuggestedInvestigationsCaseLookupServiceDreamy Jazzmediawiki/extensions/CheckUserwmf/1.45.0-wmf.19+2 -1
Customize query in gerrit

Event Timeline

Dreamy_Jazz created this task.Sep 17 2025, 11:38 AM
Restricted Application added a project: Trust and Safety Product Team. · View Herald TranscriptSep 17 2025, 11:38 AM
Restricted Application added a subscriber: Aklapper. · View Herald Transcript
Dreamy_Jazz added projects: OKR-Work, WE4.2 Anti-abuse.Sep 17 2025, 11:38 AM
Dreamy_Jazz claimed this task.Sep 17 2025, 11:43 AM
Dreamy_Jazz moved this task from Priority Backlog to In Progress on the Trust and Safety Product Sprint (Sprint Dadar Gulung (September 8 - September 26)) board.
Dreamy_Jazz set the point value for this task to 0.1.
gerritbot added a comment.Sep 17 2025, 11:50 AM

Change #1189139 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Use correct DB domain in SuggestedInvestigationsCaseLookupService

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

gerritbot added a project: Patch-For-Review.Sep 17 2025, 11:50 AM
Dreamy_Jazz triaged this task as High priority.Sep 17 2025, 11:50 AM
Dreamy_Jazz moved this task from In Progress to Needs Review on the Trust and Safety Product Sprint (Sprint Dadar Gulung (September 8 - September 26)) board.
gerritbot added a comment.Sep 17 2025, 11:58 AM

Change #1189141 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@wmf/1.45.0-wmf.19] Use correct DB domain in SuggestedInvestigationsCaseLookupService

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

Dreamy_Jazz closed this task as Resolved.Sep 17 2025, 12:05 PM
Dreamy_Jazz moved this task from Needs Review to Done on the Trust and Safety Product Sprint (Sprint Dadar Gulung (September 8 - September 26)) board.

Thanks for the quick merge

gerritbot added a comment.Sep 17 2025, 12:11 PM

Change #1189141 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@wmf/1.45.0-wmf.19] Use correct DB domain in SuggestedInvestigationsCaseLookupService

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

Stashbot added a comment.Sep 17 2025, 12:11 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-17T12:11:35Z] <dreamyjazz@deploy1003> Started scap sync-world: Backport for [[gerrit:1189141|Use correct DB domain in SuggestedInvestigationsCaseLookupService (T404846)]]

gerritbot added a comment.Sep 17 2025, 12:11 PM

Change #1189139 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] Use correct DB domain in SuggestedInvestigationsCaseLookupService

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

Stashbot added a comment.Sep 17 2025, 12:17 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-17T12:17:22Z] <dreamyjazz@deploy1003> dreamyjazz: Backport for [[gerrit:1189141|Use correct DB domain in SuggestedInvestigationsCaseLookupService (T404846)]] synced to the testservers (see https://wikitech.wikimedia.org/wiki/Mwdebug). Changes can now be verified there.

Stashbot added a comment.Sep 17 2025, 12:25 PM

Mentioned in SAL (#wikimedia-operations) [2025-09-17T12:25:13Z] <dreamyjazz@deploy1003> Finished scap sync-world: Backport for [[gerrit:1189141|Use correct DB domain in SuggestedInvestigationsCaseLookupService (T404846)]] (duration: 13m 37s)

Maintenance_bot removed a project: Patch-For-Review.Sep 17 2025, 12:31 PM
ReleaseTaggerBot added a project: MW-1.45-notes (1.45.0-wmf.20; 2025-09-23).Sep 17 2025, 1:07 PM
Dreamy_Jazz moved this task from Backlog to Done on the CheckUser-SuggestedInvestigations board.Sep 17 2025, 4:52 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits