Page MenuHomePhabricator

Phantom entries in "Quarry" query and or labs replica of enwiki db
Closed, DuplicatePublic

Description

I recently ran a query against the WMFlabs servers databases - https://quarry.wmflabs.org/query/6052

which produced some 'phantom' results that could not be found through the English Wikipedia UI, suggesting that they had been deleted, or that something had become mis-linked.

A disscussion on #wikimedia-operations suggested that any deleted file should have shown up in the replicated copies of the enwiki database concerned.

From the IRC chat -
"07:45, 31 March 2016 Closedmouth (talk | contribs) deleted page File:BIT central teaching building panorama.jpg (F7: Violates non-free content criterion #1) " yet this item still appears listed in the query results.

Can someone look into this?

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 1 2016, 10:08 PM

Additonal (from IRC):

'Krenair "select * from page where page_id in (49959270, 37396818, 49954143, 49949181, 47935756, 49954287, 49956079, 48731525, 2093268);" returns 9 rows on labsdb1001's enwiki_p, but only 1 row on db2034's enwiki '

ShakespeareFan00 renamed this task from Phantom entries in "Quarry" query.... to Phantom entries in "Quarry" queru and or labs replica of enwiki db.Aug 1 2016, 10:14 PM
ShakespeareFan00 renamed this task from Phantom entries in "Quarry" queru and or labs replica of enwiki db to Phantom entries in "Quarry" query and or labs replica of enwiki db.