Page MenuHomePhabricator

[[d:Q8497800]] is still in wb_items_per_site table even though it's been deleted and can't be undeleted properly
Closed, ResolvedPublic

Description

(show/hide) 05:11, 28 March 2013 Legoktm (talk | contribs | block) deleted page Q8497800 (Falls under one of the exclusion criteria) (view/restore)

mysql> select * from wb_items_per_site where ips_item_id=8497800;
+------------+-------------+-------------+-----------------------+

ips_row_idips_item_idips_site_idips_site_page

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

731366338497800enwikiUser:Jimbo Wales
731366348497800zhwikiUser:Jimbo Wales
731366358497800jawiki利用者:Jimbo Wales

+------------+-------------+-------------+-----------------------+
3 rows in set (0.01 sec)

This means it keeps showing up on [[d:Wikidata:Database reports/User pages]] even though it's been taken care of.

Reedy confirmed that this is still present on the real database, and not just a Toolserver issue.


Version: unspecified
Severity: normal
Whiteboard: u=dev c=backend p=0

Details

Reference
bz48112

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:40 AM
bzimport set Reference to bz48112.
bzimport added a subscriber: Unknown Object (MLST).

Looking into this, I'll also add that it's also there on the Wikimedia Labs database.

I've just decided to undelete then re-delete the item in question, but an undeletion attempt gave me "Error undeleting page".
However, the confusing and more troubling thing is that, although I got that error (and of course, the page wasn't logged as being undeleted), it seems to have been, at least partially, undeleted. There is no content, and it still shows the box with the deletion log entry, but the "other tabs" (View history, delete, protect) have re-appeared. Also, the history page is blank, as in it looks like a normal history page, just with no versions (it doesn't even give the "There is no edit history for this page." message). I've left things as-is for now.

Raising importance to major, something is seriously wrong here.

  • Bug 55378 has been marked as a duplicate of this bug. ***

I've deleted these entries when I did manual fixing for bug 71914.

See https://bugzilla.wikimedia.org/show_bug.cgi?id=71914#c10