Page MenuHomePhabricator

Create a maintenance script to rebuild the wb_items_per_site table
Closed, ResolvedPublic

Description

Create a maintenance script which allows us to rebuild the wb_items_per_site table for a given list of items. This is needed to resolve inconsistencies between the wb_items_per_site table and the actual json stored (eg. bug 48112).


Version: unspecified
Severity: normal
Whiteboard: u=dev c=backend p=8 s=2014-04-23

Details

Reference
bz59870

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:33 AM
bzimport set Reference to bz59870.
bzimport added a subscriber: Unknown Object (MLST).

The script could also:
a) delete all orphan entries (from partially deleted items)
b) rebuild entries for entities not changed since some data (or last changed between two given dates)

Proposal by Daniel: Make a script that makes null edits on all items. And then find out how slow it is.

Change 125725 had a related patch set uploaded by Hoo man:
Implement a rebuildItemsPerSite maintenance script

https://gerrit.wikimedia.org/r/125725

Change 125725 merged by jenkins-bot:
Implement a rebuildItemsPerSite maintenance script

https://gerrit.wikimedia.org/r/125725