Sanitize nl_subscriptions table
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	FCeratto-WMF
	Jul 10 2025, 11:27 AM

Description

(see related alert emails)

Details

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	sanitize-wiki: Support sections other than s5	operations/cookbooks	master	+8 -3

Customize query in gerrit

Event Timeline

FCeratto-WMF created this task.Jul 10 2025, 11:27 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 10 2025, 11:27 AM

Restarting MariaDB instances on sanitarium host[s] db1154.eqiad.wmnet

Restarting sanitarium instance db1154.eqiad.wmnet (s8)

Restarting sanitarium instance db1154.eqiad.wmnet (s5)

Restarting sanitarium instance db1154.eqiad.wmnet (x3)

Restarting sanitarium instance db1154.eqiad.wmnet (s3)

Restarting sanitarium instance db1154.eqiad.wmnet (s1)

Restarting MariaDB instances on sanitarium host[s] db1154.eqiad.wmnet: completed

FCeratto-WMF changed the task status from Open to In Progress.Jul 10 2025, 11:46 AM

FCeratto-WMF triaged this task as High priority.

Change #1167895 had a related patch set uploaded (by Federico Ceratto; author: Federico Ceratto):

[operations/cookbooks@master] sanitize-wiki: Support sections other than s5

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

gerritbot added a project: Patch-For-Review.Jul 10 2025, 3:59 PM

The table has been removed on the 4 hosts involved. Tested with:
ssh <hostname> -t "sudo mysql -S /run/mysqld/mysqld.s3.sock -e \"SELECT count(*) FROM information_schema.tables WHERE table_name = 'nl_subscriptions' \" "

Thank you!

Thank you! It was caused by https://gerrit.wikimedia.org/r/c/operations/puppet/+/1167252 which I need to write a documentation on what to do when adding tables to table catalog

Change #1167895 merged by Federico Ceratto: