Umherirrender added a comment.
Technical done is the jobqueue when the `page_links_updated` timestamp is
higher than the start of the recursive link update for all the pages embedding
the template. Pages getting a update from another job queue run or the script
purge are deduplicated.
MariaDB [warwiki_p]> SELECT NOW() AS asof, COUNT(*) AS total,
SUM(page_links_updated < '20220301182633') AS backlog FROM page INNER JOIN
templatelinks ON page_id = tl_from WHERE tl_namespace = 10 AND tl_title =
'Wikidata_image';
+---------------------+---------+---------+
| asof | total | backlog |
+---------------------+---------+---------+
| 2022-03-02 18:43:21 | 1140205 | 778531 |
+---------------------+---------+---------+
1 row in set (1.05 sec)
MariaDB [warwiki_p]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect
LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM
wbc_entity_usage;
+---------------------+---------+------------+--------+
| asof | total | statements | others |
+---------------------+---------+------------+--------+
| 2022-03-02 18:43:25 | 3341964 | 1147314 | 765962 |
+---------------------+---------+------------+--------+
1 row in set (1.12 sec)
It starts 24 h back with 1118575 and is now at 765962 , 352613 within 24 h,
means that this needs another two days (and a bit more) to complete.
TASK DETAIL
https://phabricator.wikimedia.org/T296383
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: noarave, Umherirrender
Cc: Umherirrender, Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael,
Marostegui, alaa, Lucas_Werkmeister_WMDE, Lmlmljs, karapayneWMDE, Invadibot,
maantietaja, Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic,
QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude,
Addshore, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
