Every now and then, the time it takes from a change being made on Wikidata to it being injected to a subscribed wiki's Recent Changes lags more than 1 hour, while it is usually a matter of seconds. See the Change Dispatching Grafana Dashboard
Since that seems to be an occasionally recurring issue that is only partially under our control, it seems good to have some playbook that describes in detail steps to take to determine the cause of a given instance of high lag. The target audience would be somewhat experienced developers, but that are only slightly familiar with Wikimedia infrastructure (so that the steps are easy to follow in the heat of the moment).
https://wikitech.wikimedia.org/wiki/WMDE/Wikidata/Alerts#Change_Dispatching
https://wikitech.wikimedia.org/wiki/WMDE/Wikidata/Dispatching
Recent instances of this issue:
- 2022-07-12: https://mattermost.wikimedia.de/swe/pl/xucxapkaa7f4pdz833tdfoej4a
- 2022-05-10: https://mattermost.wikimedia.de/swe/pl/r8qww1zdjjbtteyt9owqegspiw (this is the one with the db queries)
- 2022-04-27: https://mattermost.wikimedia.de/swe/pl/xeokoifq3tnyuf3bgxaf14uu6h
Open questions:
- should that playbook / flow chart be public or not? (if it should be public, then the wiki tech articles linked above would seem to be a good place to put it)