Last modified: 2014-10-23 06:30:14 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T73176, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 71176 - Discrepancy between enwiki_p.pagelinks on labs and production
Discrepancy between enwiki_p.pagelinks on labs and production
Status: UNCONFIRMED
Product: Wikimedia Labs
Classification: Unclassified
General (Other open bugs)
unspecified
All All
: Unprioritized major
: ---
Assigned To: Sean Pringle
:
Depends on:
Blocks: labs-replication
  Show dependency treegraph
 
Reported: 2014-09-23 14:45 UTC by tb
Modified: 2014-10-23 06:30 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description tb 2014-09-23 14:45:59 UTC
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_from  | pl_namespace | pl_title                      | pl_from_namespace |
+----------+--------------+-------------------------------+-------------------+
| 20357059 |            0 | And_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
Comment 1 Sean Pringle 2014-10-23 06:28:04 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links