Add af_actor/afh_actor fields to wmf wikis
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	matej_suchanek
	Mar 28 2023, 11:08 AM

Description

ALTERs to run:
- https://gerrit.wikimedia.org/g/mediawiki/extensions/AbuseFilter/+/290dd70bb2064400eb04c084111073df2237de05/db_patches/mysql/patch-add-af_actor.sql
- https://gerrit.wikimedia.org/g/mediawiki/extensions/AbuseFilter/+/290dd70bb2064400eb04c084111073df2237de05/db_patches/mysql/patch-add-afh_actor.sql
Where to run those changes: all.dblist
When to run those changes: At any time
If the schema change is backwards compatible: Yes.
If the schema change has been tested already on some of the test/beta wikis: Not yet.
If the data should be made available on the labs replicas and/or dumps: The legacy fields were publicly available, so should probably be the new fields.

NOTE: Small and medium-sized wikis and some others read from abuse_filter on metawiki, too.

Progress:

Details

	Subject	Repo	Branch	Lines +/-
	Add add_af_actor_T333332.py	operations/software/schema-changes	master	+47 -0

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Open	None	T25135 blocking user is not updated after rename
Open	None	T28816 RenameUser should log out target user to prevent unwanted recreation of old username
Stalled	None	T27377 Update username in AbuseFilter interface when user is renamed using Renameuser
Open	None	T189574 Improve AbuseFilter database schema to reduce duplication
Open	None	T265189 Fix indices on abuse_filter_history
Open	None	T188180 Read from and write to `actor` table in AbuseFilter
Resolved	Ladsgroup	T333332 Add af_actor/afh_actor fields to wmf wikis

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

Mentioned in SAL (#wikimedia-operations) [2023-04-18T20:25:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1144:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47131 and previous config saved to /var/cache/conftool/dbconfig/20230418-202554-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Apr 18 2023, 8:26 PM

Mentioned in SAL (#wikimedia-operations) [2023-04-18T20:28:34Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47132 and previous config saved to /var/cache/conftool/dbconfig/20230418-202833-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T21:13:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47136 and previous config saved to /var/cache/conftool/dbconfig/20230418-211354-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T21:15:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1161 (T333332)', diff saved to https://phabricator.wikimedia.org/P47137 and previous config saved to /var/cache/conftool/dbconfig/20230418-211529-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T21:18:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T333332)', diff saved to https://phabricator.wikimedia.org/P47138 and previous config saved to /var/cache/conftool/dbconfig/20230418-211808-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:03:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1161 (T333332)', diff saved to https://phabricator.wikimedia.org/P47141 and previous config saved to /var/cache/conftool/dbconfig/20230418-220327-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:03:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1183 (T333332)', diff saved to https://phabricator.wikimedia.org/P47142 and previous config saved to /var/cache/conftool/dbconfig/20230418-220350-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:06:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1183 (T333332)', diff saved to https://phabricator.wikimedia.org/P47143 and previous config saved to /var/cache/conftool/dbconfig/20230418-220629-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:52:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1183 (T333332)', diff saved to https://phabricator.wikimedia.org/P47146 and previous config saved to /var/cache/conftool/dbconfig/20230418-225148-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:52:23Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1185 (T333332)', diff saved to https://phabricator.wikimedia.org/P47147 and previous config saved to /var/cache/conftool/dbconfig/20230418-225211-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T22:54:50Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1185 (T333332)', diff saved to https://phabricator.wikimedia.org/P47148 and previous config saved to /var/cache/conftool/dbconfig/20230418-225449-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T23:40:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1185 (T333332)', diff saved to https://phabricator.wikimedia.org/P47151 and previous config saved to /var/cache/conftool/dbconfig/20230418-234008-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T23:40:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1200 (T333332)', diff saved to https://phabricator.wikimedia.org/P47152 and previous config saved to /var/cache/conftool/dbconfig/20230418-234032-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-18T23:44:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1200 (T333332)', diff saved to https://phabricator.wikimedia.org/P47153 and previous config saved to /var/cache/conftool/dbconfig/20230418-234410-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T00:29:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1200 (T333332)', diff saved to https://phabricator.wikimedia.org/P47156 and previous config saved to /var/cache/conftool/dbconfig/20230419-002929-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T00:29:53Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1210 (T333332)', diff saved to https://phabricator.wikimedia.org/P47157 and previous config saved to /var/cache/conftool/dbconfig/20230419-002952-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T00:32:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1210 (T333332)', diff saved to https://phabricator.wikimedia.org/P47158 and previous config saved to /var/cache/conftool/dbconfig/20230419-003235-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T01:17:54Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1210 (T333332)', diff saved to https://phabricator.wikimedia.org/P47161 and previous config saved to /var/cache/conftool/dbconfig/20230419-011754-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T01:21:15Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2111 (T333332)', diff saved to https://phabricator.wikimedia.org/P47162 and previous config saved to /var/cache/conftool/dbconfig/20230419-012114-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T01:25:10Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2111 (T333332)', diff saved to https://phabricator.wikimedia.org/P47163 and previous config saved to /var/cache/conftool/dbconfig/20230419-012509-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T02:10:29Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2111 (T333332)', diff saved to https://phabricator.wikimedia.org/P47166 and previous config saved to /var/cache/conftool/dbconfig/20230419-021028-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T02:10:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2123 (T333332)', diff saved to https://phabricator.wikimedia.org/P47167 and previous config saved to /var/cache/conftool/dbconfig/20230419-021051-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T02:16:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2123 (T333332)', diff saved to https://phabricator.wikimedia.org/P47168 and previous config saved to /var/cache/conftool/dbconfig/20230419-021646-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:02:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2123 (T333332)', diff saved to https://phabricator.wikimedia.org/P47172 and previous config saved to /var/cache/conftool/dbconfig/20230419-030205-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:02:35Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2128 (T333332)', diff saved to https://phabricator.wikimedia.org/P47173 and previous config saved to /var/cache/conftool/dbconfig/20230419-030234-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:05:31Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T333332)', diff saved to https://phabricator.wikimedia.org/P47174 and previous config saved to /var/cache/conftool/dbconfig/20230419-030530-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:50:49Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2128 (T333332)', diff saved to https://phabricator.wikimedia.org/P47177 and previous config saved to /var/cache/conftool/dbconfig/20230419-035048-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:51:13Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2137:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47178 and previous config saved to /var/cache/conftool/dbconfig/20230419-035112-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T03:55:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2137:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47180 and previous config saved to /var/cache/conftool/dbconfig/20230419-035507-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T04:40:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2137:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47183 and previous config saved to /var/cache/conftool/dbconfig/20230419-044027-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T04:40:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2157 (T333332)', diff saved to https://phabricator.wikimedia.org/P47184 and previous config saved to /var/cache/conftool/dbconfig/20230419-044050-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T04:44:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T333332)', diff saved to https://phabricator.wikimedia.org/P47185 and previous config saved to /var/cache/conftool/dbconfig/20230419-044445-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T05:30:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2157 (T333332)', diff saved to https://phabricator.wikimedia.org/P47188 and previous config saved to /var/cache/conftool/dbconfig/20230419-053003-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T05:30:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2171:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47189 and previous config saved to /var/cache/conftool/dbconfig/20230419-053027-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T05:34:25Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47190 and previous config saved to /var/cache/conftool/dbconfig/20230419-053425-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T06:19:44Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2171:3315 (T333332)', diff saved to https://phabricator.wikimedia.org/P47195 and previous config saved to /var/cache/conftool/dbconfig/20230419-061944-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T06:20:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db2178 (T333332)', diff saved to https://phabricator.wikimedia.org/P47196 and previous config saved to /var/cache/conftool/dbconfig/20230419-062007-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T06:24:01Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T333332)', diff saved to https://phabricator.wikimedia.org/P47201 and previous config saved to /var/cache/conftool/dbconfig/20230419-062401-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T07:09:20Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db2178 (T333332)', diff saved to https://phabricator.wikimedia.org/P47211 and previous config saved to /var/cache/conftool/dbconfig/20230419-070920-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Apr 19 2023, 9:35 AM

Mentioned in SAL (#wikimedia-operations) [2023-04-19T09:48:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1177 (T333332)', diff saved to https://phabricator.wikimedia.org/P47249 and previous config saved to /var/cache/conftool/dbconfig/20230419-094836-ladsgroup.json

Mentioned in SAL (#wikimedia-operations) [2023-04-19T09:50:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T333332)', diff saved to https://phabricator.wikimedia.org/P47250 and previous config saved to /var/cache/conftool/dbconfig/20230419-095044-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Apr 19 2023, 10:03 AM

Ladsgroup updated the task description. (Show Details)

Ladsgroup updated the task description. (Show Details)Apr 19 2023, 10:07 AM

Ladsgroup updated the task description. (Show Details)

Mentioned in SAL (#wikimedia-operations) [2023-04-19T10:36:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1177 (T333332)', diff saved to https://phabricator.wikimedia.org/P47260 and previous config saved to /var/cache/conftool/dbconfig/20230419-103603-ladsgroup.json