Page MenuHomePhabricator

Add a primary key to l10n_cache
Closed, ResolvedPublic

Description

Patch: https://gerrit.wikimedia.org/r/#/c/318553/22/maintenance/archives/patch-l10n_cache-primary-key.sql

DELETE FROM /*$wgDBprefix*/l10n_cache; -- Or truncate- truncate is faster but it has metadata locking issues
ALTER TABLE /*$wgDBprefix*/l10n_cache DROP KEY /*i*/lc_lang_key, ADD PRIMARY KEY(lc_lang, lc_key)

All wikis. Nice to have, but not urgent (but should be easy). It may be already done on some wikis: T146591#3139282

Truncation done at: T150306

Schema change progress:

Details

SubjectRepoBranchLines +/-
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+7 -7
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+2 -2
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+1 -1
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+5 -5
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+3 -3
operations/mediawiki-configmaster+4 -4
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+6 -6
operations/mediawiki-configmaster+2 -2
mediawiki/coremaster+28 -2
mediawiki/coremaster+55 -0
Show related patches Customize query in gerrit

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes

s1 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • dbstore1001
  • dbstore1002
  • db1124
  • db1080
  • db1083
  • db1089
  • db1119
  • db1067
  • db1106
  • db1099
  • db1114
  • db1105
  • db1052

Mentioned in SAL (#wikimedia-operations) [2018-07-09T06:12:05Z] <marostegui> Deploy schema change on dbstore1001:s1 - T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-09T06:30:31Z] <marostegui> Deploy schema change on dbstore1002:s1 - T146591 T197891 T196379

Change 444490 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1089

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

Change 444490 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1089

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T06:54:12Z] <marostegui> Deploy schema change on db1089 - T146591 T197891 T196379

Change 444492 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1119

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

Change 444492 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1119

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T07:18:48Z] <marostegui> Deploy schema change on db1119 - T146591 T197891 T196379

Change 444494 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1067

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

Change 444494 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1067

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T07:40:54Z] <marostegui> Deploy schema change on db1067 T146591 T197891 T196379

Change 444496 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1099:3311

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

Change 444496 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1099:3311

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T07:54:07Z] <marostegui> Deploy schema change on db1099:3311 T146591 T197891 T196379

Change 444498 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1105:3311

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

Change 444498 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1105:3311

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T08:08:26Z] <marostegui> Deploy schema change on db1105:3311 T146591 T197891 T196379

Change 444500 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1106

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

Change 444500 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1106

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T08:26:28Z] <marostegui> Deploy schema change on db1106 with replication, this will generate lag on labs hosts for s1 T146591 T197891 T196379

Change 444502 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1083

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

Change 444502 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1083

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

Change 444564 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1114

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

Change 444564 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1114

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T13:11:42Z] <marostegui> Deploy schema change on db1114 T146591 T197891 T196379

Change 444582 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1080

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

Change 444582 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1080

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

Mentioned in SAL (#wikimedia-operations) [2018-07-09T13:25:58Z] <marostegui> Deploy schema change on db1080 T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-09T13:32:03Z] <marostegui> Deploy schema change on s4 codfw master (db2051) this will generate lag on s4 codfw T146591 T197891 T196379

s4 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • db1125
  • dbstore1002
  • db1081
  • db1084
  • db1091
  • db1097
  • db1103
  • db1121
  • db1068

Mentioned in SAL (#wikimedia-operations) [2018-07-10T04:28:57Z] <marostegui> Deploy schema change on s1 primary master (db1052) T146591 T197891 T196379

Change 444781 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1084

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

Change 444781 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1084

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

Change 444784 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1097:3314

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

Change 444784 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1097:3314

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

Mentioned in SAL (#wikimedia-operations) [2018-07-10T05:03:59Z] <marostegui> Deploy schema change on db1097:3314 T146591 T197891 T196379

Change 444787 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1103:3314

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

Change 444787 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1103:3314

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

Mentioned in SAL (#wikimedia-operations) [2018-07-10T05:16:41Z] <marostegui> Deploy schema change on db1103:3314 T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-10T05:21:08Z] <marostegui> Deploy schema change on db1121 with replication, this will generate lag on s4 labs hosts T146591 T197891 T196379

Change 444790 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1081

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

Change 444790 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1081

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

Change 444792 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1091

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

Change 444792 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1091

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

Mentioned in SAL (#wikimedia-operations) [2018-07-10T05:39:59Z] <marostegui> Deploy schema change on s4 primary master (db1068) T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-10T06:02:16Z] <marostegui> Deploy schema change on codfw s8 master (db2045) with replication, this will generate lag on s8 codfw T146591 T197891 T196379

s8 eqiad progress

  • dbstore1002
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • db1109
  • db1104
  • db1124
  • db1101
  • db1099
  • db1092
  • db1087
  • db1071

Mentioned in SAL (#wikimedia-operations) [2018-07-10T06:06:35Z] <marostegui> Deploy schema change on dbstore1002:s8 T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-10T06:17:43Z] <marostegui> Deploy schema change on s8 primary master (db1071) T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-10T06:23:50Z] <marostegui> Deploy schema change on codfw s7 master (db2040) with replication, this will generate lag on s7 codfw T146591 T197891 T196379

s7 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1125
  • db1101
  • db1098
  • db1094
  • db1090
  • db1086
  • db1079
  • db1062

Change 445067 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1094

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

Change 445067 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1094

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

Change 445069 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1079

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

Change 445069 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1079

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

Mentioned in SAL (#wikimedia-operations) [2018-07-11T05:31:13Z] <marostegui> Deploy schema change on db1079 with replication, this will generate lag on s7 labs hosts T146591 T197891 T196379

Change 445075 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1086

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

Change 445075 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1086

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

Mentioned in SAL (#wikimedia-operations) [2018-07-11T06:26:25Z] <marostegui> Deploy schema change on db1062 (s7 primary master) T146591 T197891 T196379

Mentioned in SAL (#wikimedia-operations) [2018-07-11T06:40:55Z] <marostegui> Deploy schema change on s3 codfw master (db2043) with replication, this will generate lag on s3 codfw T146591 T197891 T196379

s3 eqiad progress

  • labsdb1009
  • labsdb1010
  • labsdb1011
  • dbstore1002
  • db1124
  • db1077
  • db1078
  • db1123
  • db1075

Mentioned in SAL (#wikimedia-operations) [2018-07-11T07:15:40Z] <marostegui> Deploy schema change on dbstore1002:s3 T146591 T197891 T196379

Change 445083 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1078

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

Change 445083 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1078

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

Change 445092 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1077

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

Change 445092 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1077

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

Mentioned in SAL (#wikimedia-operations) [2018-07-11T08:13:55Z] <marostegui> Deploy schema change on db1077 with replication, this will generate lag on s3 labs hosts T146591 T197891 T196379

Change 445337 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/mediawiki-config@master] db-eqiad.php: Depool db1123

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

Change 445337 merged by jenkins-bot:
[operations/mediawiki-config@master] db-eqiad.php: Depool db1123

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

Mentioned in SAL (#wikimedia-operations) [2018-07-12T05:00:04Z] <marostegui> Deploy schema change on db1075 (s3 primary master)/script unload irssinotifier T146591 T197891 T196379

Marostegui updated the task description. (Show Details)

All done