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 <https://wikimediafoundation.org/>