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
_______________________________________________
Cloud mailing list -- cloud@lists.wikimedia.org
List information: 
https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/

Reply via email to