Page MenuHomePhabricator

Pagelinks missing rows for blue links
Open, Needs TriagePublic

Description

fa:خانه امام جمعه is a disambiguation page with two blue links, yet https://quarry.wmflabs.org/query/15159 suggests there are no links out of that page. This is likely due to replication issues with the Labs DB, so I would like to ask for an investigation.

UPDATE: It was determined it is not a replication issue, and production DBs also did not show any pagelinks entries for this page. After a null edit, the pagelinks entries appeared.

Event Timeline

Huji created this task.Jan 1 2017, 4:18 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 1 2017, 4:18 PM
Huji added a comment.Jan 1 2017, 4:19 PM

PS: it used to be possible to connect to specific Labs DB instances using commands like mysql -h labsdb1001 fawiki (like T123985#1943926) but that does not work anymore. Can you please include the commands you run to connect to specific databases as part of your response to this task? (I will add them to the Wikitech wiki)

Krenair added a subscriber: Krenair.Jan 1 2017, 6:40 PM

Nope, production definitely matches I'm afraid:

mysql:wikiadmin@db1086 [fawiki]> select * from pagelinks where pl_from = 3466098;
Empty set (0.00 sec)

Several other production db servers concur.

PS: it used to be possible to connect to specific Labs DB instances using commands like mysql -h labsdb1001 fawiki (like T123985#1943926) but that does not work anymore. Can you please include the commands you run to connect to specific databases as part of your response to this task? (I will add them to the Wikitech wiki)

Ah, for that you're just missing the .eqiad.wmnet part of the hostname. Production hosts would usually search that by default so there'd be no problems (so if you found that in some docs it's not exactly wrong, depending on the context). You'll also need to use _p in the database name as labs users don't have permissions on the normal DBs.

Huji added a comment.Jan 1 2017, 9:21 PM

Nope, production definitely matches I'm afraid:

mysql:wikiadmin@db1086 [fawiki]> select * from pagelinks where pl_from = 3466098;
Empty set (0.00 sec)

Several other production db servers concur.

How can that be? We clearly see from the page itself that it has links to other page?

I agree it's strange, it's just not a replication inconsistency.

Huji added a comment.EditedJan 2 2017, 1:04 AM

Hmm. I just did a null edit on the page, and that fixed it. Note that the last change on that page was May 26, 2016 when it was moved from another title; moves generally don't have no impact on pagelinks (since page ID doesn't change).

It is really weird.

Huji renamed this task from Replication inconsistency to Pagelinks missing rows for blue links.Jan 2 2017, 1:06 AM
Huji edited projects, added MediaWiki-General; removed Cloud-VPS, Cloud-Services.
Huji updated the task description. (Show Details)
Krenair removed a project: DBA.Jan 2 2017, 1:28 AM