Page MenuHomePhabricator
Create Task
Maniphest T86415

Adding externallinks.el_from_namespace on wmf databases
Closed, ResolvedPublic
Actions

Description

With https://gerrit.wikimedia.org/r/#/c/163470/ there should be a new column on the externallinks table which is called el_from_namespace. Please add the new column to production to allow merging of that patch set in the future.

This is the first step for merge of that patch set. After the column is added the patch set can be merged.
After merge and deployment on all wikis the maintenance script "populateBacklinkNamespace.php --tables externallinks" needs to be run.
After the run on all wikis the config $wgUseExternallinksNamespaceDBField can be set to true (in mediawiki/core or in operations/mediawiki-config).

Related Objects
Search...

Event Timeline

Umherirrender created this task.Jan 10 2015, 8:52 AM
Umherirrender raised the priority of this task from to Needs Triage.
Umherirrender updated the task description. (Show Details)
Umherirrender added projects: Wikimedia-General-or-Unknown, Schema-change.
Umherirrender added subscribers: Umherirrender, Springle, greg.
Aklapper triaged this task as Medium priority.Jan 12 2015, 1:51 PM
Springle claimed this task.Jan 13 2015, 7:09 AM
Springle set Security to None.
greg removed a subscriber: greg.Jan 13 2015, 4:25 PM
Springle added a comment.Mar 3 2015, 1:51 PM

This has been started. No ETA yet.

Aklapper added a comment.Apr 13 2015, 10:53 AM
In T86415#1081840, @Springle wrote:

This has been started. No ETA yet.

@Springle: Any vague ETA, now that five weeks have passed?

Glaisher added a subscriber: Glaisher.Apr 14 2015, 11:16 AM
Springle added a comment.Apr 22 2015, 4:31 AM

The schema change is now complete.

Springle added a comment.Apr 22 2015, 4:32 AM

The other steps in this task probably deserve their own tasks, or else reassigning this one...

Umherirrender closed this task as Resolved.Apr 22 2015, 2:53 PM

Thanks for the schema change. I will open new task(s) as needed. First the patch set needs merging and deployment.

Krenair reopened this task as Open.Aug 15 2015, 2:47 AM
Krenair added a subscriber: Krenair.

This is not done. The column does not exist on labswiki.

Krenair added a parent task: T12593: Make namespace filter in Special:Linksearch efficient enough for wgMiserMode.Aug 15 2015, 2:49 AM
Umherirrender added a comment.Aug 15 2015, 7:28 AM

labswiki will run updater after pull of the last changes from master and than the column will be there.

Only production needs manual database changes, because there are some big databases in there.

Krenair added a comment.Aug 15 2015, 9:17 AM
In T86415#1542204, @Umherirrender wrote:

labswiki will run updater after pull of the last changes from master and than the column will be there.

Only production needs manual database changes, because there are some big databases in there.

labswiki is part of the normal production deployment system. I don't think we run update.php there.

Umherirrender added a comment.Aug 15 2015, 9:24 AM
In T86415#1542235, @Krenair wrote:
In T86415#1542204, @Umherirrender wrote:

labswiki will run updater after pull of the last changes from master and than the column will be there.

Only production needs manual database changes, because there are some big databases in there.

labswiki is part of the normal production deployment system. I don't think we run update.php there.

Okay, that I was not aware of. I was assuming the same behaviour like beta wikis (http://de.wikipedia.beta.wmflabs.org).

@Springle can you have a look? Thanks.

Krenair closed this task as Resolved.Aug 15 2015, 6:17 PM
Krenair added a subscriber: jcrespo.

Checked with @jcrespo, it's just 26k rows and on wikitech (no replication or major traffic to worry about), so no problem, done.

Umherirrender mentioned this in T114117: Drop externallinks.el_from_namespace on wmf databases.Sep 29 2015, 2:51 PM
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL