Last modified: 2014-05-12 04:42:28 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 T66411, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 64411 - Deploy pp_sortkey schema change to all wikis
Deploy pp_sortkey schema change to all wikis
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
wmf-deployment
All All
: Normal enhancement (vote)
: ---
Assigned To: Sean Pringle
: schema-change
Depends on:
Blocks: 58032
  Show dependency tree / graph
 
Reported: 2014-04-24 23:52 UTC by Chad H.
Modified: 2014-05-12 04:42 UTC (History)
0 users

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Chad H. 2014-04-24 23:52:46 UTC 
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.
Comment 1 Gerrit Notification Bot 2014-04-28 10:12:15 UTC 
Change 130055 had a related patch set uploaded by Aude:
Set $wgPagePropsHaveSortkey to false

https://gerrit.wikimedia.org/r/130055
Comment 2 Sean Pringle 2014-04-28 10:46:33 UTC 
Schema change applied to all wikis.
Comment 3 Sean Pringle 2014-04-28 10:59:28 UTC 
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?
Comment 4 Gerrit Notification Bot 2014-04-28 11:55:09 UTC 
Change 130055 abandoned by Aude:
Set $wgPagePropsHaveSortkey to false

Reason:
schema change is done

https://gerrit.wikimedia.org/r/130055
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links