From the enwiki master:

mysql:wikiadmin@db1052 [enwiki]> select tl_namespace, tl_title from page join templatelinks on tl_from = page_id where page_namespace = 1 and page_title = 'Buddy_Baker' and tl_namespace = 10 and tl_title = 'BLP';
Empty set (0.00 sec)

db1055 returns empty set, but the three labsdb hosts all give the result shown in the task description. I was wondering about db1069 (the host between db1055 and labsdbs in the replication tree), but it looks like only ops can connect there.

This task seems to be very similar to T106470.

I checked the checksums, and this table was checked/fixed on 10th August. The fact that this happened again, but only on db1069 and bellow means that the filtering done for privacy is not replication-safe. I will check the table again, and fix all the errors I can find, but this will happen again until we can substitute the filtering for something else and/or we can switch to ROW-based replication.

This should be fixed now, but I am performing another checksum just to be sure.

MariaDB [enwiki_p]> select tl_namespace, tl_title from page join templatelinks on tl_from = page_id where page_namespace = 1 and page_title = 'Buddy_Baker' and tl_namespace = 10 and tl_title = 'BLP';
Empty set (0.00 sec)

This looks much better now. Thanks!

Do the other tables need to be checked as well? pagelinks, categorylinks, etc.?