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
Show replies by date