Following T326387: Deploy PageAssessments to Chinese Wikipedia and T328224: Deploy PageAssessments to Nepali Wikipedia, the maintain-views script needs to be ran so that the associated tables with MediaWiki-extensions-PageAssessments are made available on the Toolforge replicas.
According to the docs, this is handled by the Data Engineering team.
@lbowmaker Any chance we could get an estimate on when you think this task can be fulfilled? My naive understanding is that it's as simple as running a single command, no? There's no urgency per se, except for that Chinese and Nepali Wikipedians can't take advantage of the many external tools that use PageAssessments until the replicas are updated. Thanks for you for your time!
Mentioned in SAL (#wikimedia-operations) [2023-05-05T16:06:28Z] <btullis@cumin1001> Added views for new wiki: zhwiki T334041
Mentioned in SAL (#wikimedia-operations) [2023-05-05T16:35:51Z] <btullis@cumin1001> Added views for new wiki: newiki T334041
@MusikAnimal - Apologies for the delay in carrying out this task.
I believe that it the work is complete now, for both wikis mentioned.
I can now get to both the zhwiki_p and the newiki_p databases from toolforge.
btullis@tools-sgebastion-10:~$ sql zhwiki_p "select * from page limit 2" +---------+----------------+------------------------------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | page_id | page_namespace | page_title | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang | +---------+----------------+------------------------------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | 1 | 4 | Upload_log | 0 | 0 | 0.830117897903657 | 20230209074236 | 20230209074257 | 64790853 | 1170 | wikitext | NULL | | 2 | 4 | 删除纪录/档案馆/2004年3月 | 0 | 0 | 0.142423143743 | 20230209074236 | 20230209074250 | 68072637 | 253824 | wikitext | NULL | +---------+----------------+------------------------------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+
btullis@tools-sgebastion-10:~$ sql newiki_p "select * from page limit 2" +---------+----------------+---------------------------------+------------------+-------------+------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | page_id | page_namespace | page_title | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang | +---------+----------------+---------------------------------+------------------+-------------+------------------+----------------+--------------------+-------------+----------+--------------------+-----------+ | 1 | 0 | मुख्य_पृष्ठ | 0 | 0 | 0.724423813505 | 20230501081621 | 20230501082310 | 1101874 | 1373 | wikitext | NULL | | 13 | 8 | Help | 0 | 0 | 0.33909291805615 | 20230221025157 | 20230221025157 | 119176 | 18 | wikitext | NULL | +---------+----------------+---------------------------------+------------------+-------------+------------------+----------------+--------------------+-------------+----------+--------------------+-----------+
I'll resolve this ticket, but please do let me know if anything seems amiss.