Hi, You can ignore this message if your tools do not query abuse filter tables in Wiki Replicas.

In case you missed the announcement in Tech News https://meta.wikimedia.org/wiki/Tech/News/2024/16, I'm letting you know about the upcoming removal of four fields from two database tables.

The fields "af_user" and "af_user_text" of the "abuse_filter" table and "afh_user" and "afh_user_text" of the "abuse_filter_history" table are being removed in favor of the new "af_actor" and "afh_actor" fields, respectively. The new fields are already in sync with the legacy ones and available for read operations.

If you run queries involving those fields, you have to update them. The queries will now be structured the same way as, e.g., queries with "rev_actor" of the "revision" table (i.e., by JOIN'ing the new fields with "actor.actor_id"). There are examples of minimalistic migration of each field in the Phabricator task https://phabricator.wikimedia.org/T361996 that tracks the migration.

No deadline has been proposed for the removal, but it will probably have been done by the end of May unless someone asks for more time.

Thanks, Matěj Suchánek