Page MenuHomePhabricator

Drop thread.thread_root_2 indexes
Closed, ResolvedPublic

Description

Wikis that have LiquidThreads enabled, or had it previously (have the thread table) should be checked for the thread_root_2 index, and it dropped if it exists.

It duplicates a default index

ALTER TABLE /*_*/thread DROP INDEX /*i*/thread_root_2;

See T180163 for the LQT bug

Table exists on:

s2

  • enwiktionary (index not present)

s3

  • enwikinews (index not present)
  • fiwikimedia
  • liquidthreads_labswikimedia (index not present)
  • mediawikiwiki (index not present)
  • ptwikibooks
  • officewiki (index not present)
  • strategywiki (index not present)
  • sewikimedia
  • svwikisource
  • test2wiki
  • testwiki (index not present)
  • wikimania2010wiki (index not present)
  • wikimania2011wiki (index not present)

s7

  • huwiki (index not present)

Event Timeline

Reedy triaged this task as Lowest priority.Nov 9 2017, 8:20 PM

Wikis that have it enabled in some way or another

'wmgUseLiquidThreads' => [
//
// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
// Do not enable this on new wikis.
// !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
//
	'default' => false,
	'testwiki' => true, // Expanding out to testwiki -- Andrew 2009-10-13
	'enwikinews' => true, // Per T23956 -- Andrew 2009-02-09
	'enwiktionary' => true, // T25417 -- ariel 2010-16-05
	'huwiki' => true, // T24909 -- Andrew 2010-09-06
	'ptwikibooks' => true, // T26143 -- Andrew 2010-08-16
	'strategywiki' => true, // Philippe says it's cool -- Andrew 2009-10-13
	'svwikisource' => true, // T25220 -- Andrew 2010-08-28
	'test2wiki' => true,
	'wikimania2010wiki' => true, // Erik requested, by mail
],

'wmgLiquidThreadsFrozen' => [
	// Preserve access to LQT namespaces after removing the extension
	'default' => false,
	'mediawikiwiki' => true,
	'officewiki' => true, // replaced with Flow 2014-11-25
	'sewikimedia' => true, // T106302, T114277
	'fiwikimedia' => true,
],

Change 390316 had a related patch set uploaded (by Reedy; owner: Reedy):
[mediawiki/extensions/LiquidThreads@master] Drop thread.thread_root_2 index if it exists

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

Marostegui claimed this task.
Marostegui updated the task description. (Show Details)
Marostegui updated the task description. (Show Details)

Small tables - all dropped.