Page MenuHomePhabricator

Deploy pp_sortkey schema change to all wikis
Closed, ResolvedPublic

Description

The schema change can be found at https://gerrit.wikimedia.org/r/#/c/122349/5/maintenance/archives/patch-pp_sortkey.sql, reproduced here as well:

ALTER TABLE /*_*/page_props
ADD pp_sortkey float DEFAULT NULL;

CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page
ON /*_*/page_props ( pp_propname, pp_sortkey, pp_page );

This is hidden behind a feature flag so there's no rush to have this done before a set deployment.


Version: wmf-deployment
Severity: enhancement

Details

Reference
bz64411

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 3:20 AM
bzimport set Reference to bz64411.
demon created this task.Apr 24 2014, 11:52 PM

Change 130055 had a related patch set uploaded by Aude:
Set $wgPagePropsHaveSortkey to false

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

Schema change applied to all wikis.

Strictly speaking the bug is complete, however the linked patch set is unmerged and possibly still needed until the field is prepopulated by a batch job?

Change 130055 abandoned by Aude:
Set $wgPagePropsHaveSortkey to false

Reason:
schema change is done

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