Page MenuHomePhabricator

enwiki_p replica corruption
Closed, ResolvedPublic

Description

There is a disparity between the pagelinks table on enwiki_p on labsdb1001 and the same on live.

The query in the transcript below should return no rows, per https://en.wikipedia.org/w/index.php?title=Special%3AWhatLinksHere&target=South-Africa&namespace=0


tb@tools-bastion-03:~$ become tb-dev
tools.tb-dev@tools-bastion-03:~$ sql enwiki
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 32283889
Server version: 10.0.15-MariaDB Source distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [enwiki_p]> select page_title from page inner join pagelinks on page_id = pl_from where pl_namespace = 0 and pl_title = 'South-Africa' and page_namespace = 0;
+-------------------+

page_title

+-------------------+

William_Robertson

+-------------------+
1 row in set (0.01 sec)

MariaDB [enwiki_p]> select @@hostname;
+------------+

@@hostname

+------------+

labsdb1001

+------------+

1 row in set (0.00 sec)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript
jcrespo claimed this task.
jcrespo added a subscriber: jcrespo.
MariaDB [enwiki]> SELECT * FROM pagelinks where pl_from = 1993506 and pl_title = 'South-Africa';
Empty set (0.00 sec)