Page MenuHomePhabricator

Drop ep_articles_course_id index
Closed, ResolvedPublic

Description

See T180161

The ep_articles_course_id index should be dropped from all wikis running EducationProgram

'wmgUseEducationProgram' => [
	'default' => false,
	'arwiki' => true, // T59729
	'cawiki' => true, // T73381
	'cswiki' => true, // T56223
	'dewikiversity' => true,
	'elwiki' => true, // T58771
	'enwiki' => true,
	'enwikinews' => true, // T55984
	'eswiki' => true, // T56826
	'fawiki' => true,
	'frwikisource' => true, // T105853
	'hewiki' => true, // T50848
	'hewiktionary' => true, // T89393
	'itwikiversity' => true, // T162692
	'lvwiki' => true, // T89898
	'mkwiki' => true, // T50262
	'nlwiki' => true, // T52574
	'ptwiki' => true, // T54870
	'ruwiki' => true, // T89588
	'srwiki' => true, // T110619
	'svwiki' => true, // T51009
	'test2wiki' => true,
	'ukwiki' => true, // T66143
],

The table is present on the following masters:

s1

  • enwiki

s2

  • cswiki
  • nlwiki
  • ptwiki
  • svwiki

s3

  • dewikiversity
  • elwiki
  • enwikinews
  • frwikisource
  • hewiktionary
  • itwikiversity
  • lvwiki
  • mkwiki
  • sewiki
  • srwiki
  • test2wiki
  • legalteamwiki

s6

  • ruwiki

s7

  • arwiki
  • cawiki
  • eswiki
  • fawiki
  • hewiki
  • ukwiki

Event Timeline

Reedy created this task.Nov 9 2017, 8:25 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 9 2017, 8:25 PM
Marostegui added a subscriber: Marostegui.EditedNov 9 2017, 8:28 PM

Do you have a list of wikis?
Cheers!

Reedy updated the task description. (Show Details)Nov 9 2017, 8:29 PM
Restricted Application added a subscriber: Base. · View Herald TranscriptNov 9 2017, 8:29 PM
demon added a subscriber: demon.Nov 9 2017, 8:30 PM

As a start:

'wmgUseEducationProgram' => [
        'default' => false,
        'arwiki' => true, // T59729
        'cawiki' => true, // T73381
        'cswiki' => true, // T56223
        'dewikiversity' => true,
        'elwiki' => true, // T58771
        'enwiki' => true,
        'enwikinews' => true, // T55984
        'eswiki' => true, // T56826
        'fawiki' => true,
        'frwikisource' => true, // T105853
        'hewiki' => true, // T50848
        'hewiktionary' => true, // T89393
        'itwikiversity' => true, // T162692
        'lvwiki' => true, // T89898
        'mkwiki' => true, // T50262
        'nlwiki' => true, // T52574
        'ptwiki' => true, // T54870
        'ruwiki' => true, // T89588
        'srwiki' => true, // T110619
        'svwiki' => true, // T51009
        'test2wiki' => true,
        'ukwiki' => true, // T66143
],

There might be a few others that used to use it and now don't, but at least these will have it.

Reedy triaged this task as Low priority.Nov 9 2017, 9:47 PM
Marostegui moved this task from Triage to Backlog on the DBA board.Nov 10 2017, 7:06 AM
Marostegui updated the task description. (Show Details)Nov 10 2017, 7:46 AM
Marostegui updated the task description. (Show Details)Nov 10 2017, 7:58 AM
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)Nov 10 2017, 8:01 AM
Marostegui updated the task description. (Show Details)
Marostegui closed this task as Resolved.Nov 10 2017, 8:03 AM
Marostegui claimed this task.
Marostegui updated the task description. (Show Details)

The tables were super small, so I went ahead and drop the index.