Page MenuHomePhabricator

enwiki_p replica corruption
Closed, ResolvedPublic


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

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;




1 row in set (0.01 sec)

MariaDB [enwiki_p]> select @@hostname;





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)