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

Assigned To

None

Authored By

	Reedy
	Aug 4 2017, 9:01 PM

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

Related Objects
Search...

Status	Assigned	Task
Resolved	jcrespo	T50930 Database replication problems - production and labs (tracking)
Declined	jcrespo	T150767 Wikireplica service for tools and labs - issues and missing available views (tracking)
Resolved	jcrespo	T138967 Labs database replica drift
Declined	None	T172567 Data missing from labs replica of enwiki.imagelinks

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

Reedy added a subscriber: ShakespeareFan00.Aug 4 2017, 9:01 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.

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

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]>

Seems this is another case of T138967

bd808 added a parent task: T138967: Labs database replica drift.Aug 7 2017, 5:23 AM

bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Aug 7 2017, 5:29 AM

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

Data missing from labs replica of enwiki.imagelinksClosed, DeclinedPublicActions

Description

Related ObjectsSearch...

Event Timeline

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

Related Objects
Search...