Page MenuHomePhabricator

Data missing from labs replica of enwiki.imagelinks
Closed, DeclinedPublic

Description

On production

mysql:wikiadmin@db1080 [enwiki]> select * from imagelinks where il_to = 'Yevgeny_Kabanov.jpg';
+----------+---------------------+-------------------+
| il_from  | il_to               | il_from_namespace |
+----------+---------------------+-------------------+
| 50272052 | Yevgeny_Kabanov.jpg |                 0 |
+----------+---------------------+-------------------+
1 row in set (0.00 sec)

The same query on quarry/labs, gives no results

https://quarry.wmflabs.org/query/20709

Looks like data corruption or other replication issues

Event Timeline

Reedy created this task.Aug 4 2017, 9:01 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 4 2017, 9:01 PM
ShakespeareFan00 added a comment.EditedAug 4 2017, 9:03 PM

As originator of a prior query here https://quarry.wmflabs.org/query/20707

I can confirm this. Currently the query in 20707 is pared down to a minimal example. I was seeing a similar issue with a number of rows in the fuller query, not apparently having up-to-date or full information.

chasemp triaged this task as Medium priority.Aug 4 2017, 9:07 PM
chasemp added a subscriber: chasemp.

@Reedy, any difference if you hit the in-progress new labsdb cluster @ labsdb-web.eqiad.wmnet?

Reedy added a comment.Aug 4 2017, 9:13 PM

Yup, that replica seems good...

reedy@tools-bastion-03:~$ mysql --defaults-file=$HOME/replica.my.cnf --host labsdb-web.eqiad.wmnet
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 496559
Server version: 10.1.25-MariaDB MariaDB Server

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

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

MariaDB [(none)]> use enwiki_p;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [enwiki_p]> select * from imagelinks where il_to = 'Yevgeny_Kabanov.jpg';
+----------+---------------------+-------------------+
| il_from  | il_to               | il_from_namespace |
+----------+---------------------+-------------------+
| 50272052 | Yevgeny_Kabanov.jpg |                 0 |
+----------+---------------------+-------------------+
1 row in set (0.02 sec)

MariaDB [enwiki_p]>
Reedy added a comment.Aug 4 2017, 9:19 PM

Seems this is another case of T138967

bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Aug 7 2017, 5:29 AM
bd808 closed this task as Declined.Oct 18 2017, 2:17 AM
bd808 added a subscriber: bd808.

Use enwiki.{analytics,web}.db.svc.eqiad.wmflabs instead of enwiki.labsdb.

See also T142807: Migrate all users to new Wiki Replica cluster and decommission old hardware