Page MenuHomePhabricator

Discrepancy between enwiki_p.pagelinks on labs and production
Closed, ResolvedPublic

Description

Intention:
Was tracking down a problem with one of my tool-labs tools and found a discrepancy in the enwiki_p database.

Steps to Reproduce:
tools.tb-dev@tools-login:~$ sql enwiki;
MariaDB [enwiki_p]> select * from pagelinks where pl_namespace = 0 and pl_title = 'And_Now_The_Screaming_Starts!';

Actual Results:
+----------+--------------+-------------------------------+-------------------+

pl_frompl_namespacepl_titlepl_from_namespace

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

203570590And_Now_The_Screaming_Starts!0

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

Expected Results:
Was expecting the query above to return no records.

This does not seem to match production - see https://en.wikipedia.org/wiki/Special:WhatLinksHere/And_Now_The_Screaming_Starts!

Reproducible: Always


Version: unspecified
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=72226
https://bugzilla.wikimedia.org/show_bug.cgi?id=71084

Details

Reference
bz71176

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:49 AM
bzimport set Reference to bz71176.

Sync in progress. Cause is not yet confirmed, with https://mariadb.atlassian.net/browse/MDEV-6551 a possibility.

Very interested to hear if anyone observes this with recent (<1week) data.

jcrespo moved this task from Triage to Backlog on the DBA board.
jcrespo raised the priority of this task from Low to Needs Triage.Jun 18 2015, 10:22 AM
jcrespo subscribed.

Test case cannot be reproduced anymore.