Hello,

(If you don't query revision_actor_temp table, feel free to ignore this email)

We will remove revision_actor_temp in two weeks, this table was only built for temporary use inside mediawiki.

Cloud replicas provide a view that you can query the revision table directly and instead of joining the revision table with revision_actor_temp, you can simply get the value of rev_actor field.

We have finally backfilled the value of rev_actor in production and that can be used directly (thus we will remove the view soon).

If you query this table in your tools, reports, etc. You need to change it ASAP. Hopefully this should make your queries much simpler. Keep in mind a similar work will happen on revision_comment_temp table in the future.

You can follow the work in https://phabricator.wikimedia.org/T275246

Best

--

Amir Sarabadani (he/him) Staff Database Architect Wikimedia Foundation