MariaDB [enwiki_p]> select * from linktarget where lt_namespace=10 and lt_title="19th_Avenue/M_Ocean_View_Project"; Empty set (0.003 sec)
Here's the same query against a production replica:
wikiadmin2023@db1196.eqiad.wmnet(enwiki)> select * from linktarget where lt_namespace=10 and lt_title="19th_Avenue/M_Ocean_View_Project"; +--------+--------------+----------------------------------+ | lt_id | lt_namespace | lt_title | +--------+--------------+----------------------------------+ | 747361 | 10 | 19th_Avenue/M_Ocean_View_Project | +--------+--------------+----------------------------------+ 1 row in set (0.031 sec)
The page in question is here: https://en.wikipedia.org/wiki/Template:19th_Avenue/M_Ocean_View_Project
In the query that I'm debugging there's like 150 other missing rows, but I'm only looking at a small section of the template namespace, so it could be more widespread.
I started digging into this because of weird issues related to a database report (https://en.wikipedia.org/wiki/Wikipedia_talk:Database_reports#Wikipedia:Database_reports/Uncategorized_templates_missed_its_weekly_update) in which results were dramatically changing day-by-day, which suggests that one replica fell out of sync or something, but if I read puppet correctly, there's only one backing server for analytics (clouddb1017) and one for web (clouddb1013), so it wouldn't be that...but regardless, there's still a discrepancy between the replica and production.