Page MenuHomePhabricator
Create Task
Maniphest T86338

Dropping page.page_counter on wmf databases
Closed, ResolvedPublic
Actions

Description

https://gerrit.wikimedia.org/r/#/c/167655/ drops the page.page_counter column which sould also be dropped in production.
ALTER to run: ALTER TABLE /*_*/page DROP COLUMN page_counter;

Progress:

s1

s2

s3

s4

s5

s6

s7

s8

wikitech

  • eqiad
  • codfw

Details

SubjectRepoBranchLines +/-
db-eqiad.php: Depool db1080operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1114operations/mediawiki-configmaster+2 -2
dbproxy1010: Depool labsdb1011operations/puppetproduction+2 -2
db-eqiad.php: Depool db1083operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1106operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1105:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1089operations/mediawiki-configmaster+1 -1
db-eqiad.php: Depool db1119operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1099:3311operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1078operations/mediawiki-configmaster+1 -1
dbproxy1010: Depool labsdb1011operations/puppetproduction+2 -2
dbproxy1010: Depool labsdb1010operations/puppetproduction+2 -2
db-eqiad.php: Depool db1077operations/mediawiki-configmaster+7 -7
db-eqiad.php: Depool db1123operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1094operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1101:3317operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1090:3317operations/mediawiki-configmaster+5 -5
dbproxy1010: Depool labsdb1011operations/puppetproduction+2 -2
db-eqiad.php: Depool db1079operations/mediawiki-configmaster+5 -5
dbproxy1010: Depool labsdb1010operations/puppetproduction+2 -2
db-eqiad.php: Depool db1086operations/mediawiki-configmaster+2 -2
db-eqiad.php: Depool db1098operations/mediawiki-configmaster+12 -12
dbproxy1010: Depool labsdb1011operations/puppetproduction+2 -2
db-eqiad.php: Depool db1087operations/mediawiki-configmaster+7 -7
dbproxy1010: Depool labsdb1010operations/puppetproduction+2 -2
db-eqiad.php: Depool db1092operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1104operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1109operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1101:3318operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1099:3318operations/mediawiki-configmaster+6 -6
dbproxy1010: Depool labsdb1010operations/puppetproduction+2 -2
db-eqiad.php: Depool db1121operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1091operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1103:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1081operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1084operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1097:3314operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1110operations/mediawiki-configmaster+3 -3
db-eqiad.php: Depool db1100operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1113:3315operations/mediawiki-configmaster+8 -8
db-eqiad.php: Depool db1082operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1097:3315operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1096:3315operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1074operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1122operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1076operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1105:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1090:3312operations/mediawiki-configmaster+5 -5
db-eqiad.php: Depool db1103:3312operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1085operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1113:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1096:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1098:3316operations/mediawiki-configmaster+6 -6
db-eqiad.php: Depool db1093operations/mediawiki-configmaster+4 -4
db-eqiad.php: Depool db1088operations/mediawiki-configmaster+3 -3
Show related patches Customize query in gerrit

Related Objects
Search...

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Dec 13 2018, 8:45 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-13T08:45:44Z] <marostegui> Deploy schema change on db1090:3317 T86338 T202167

Stashbot added a comment.Dec 13 2018, 9:34 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-13T09:34:50Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1090:3317 T86338 T202167 (duration: 00m 51s)

gerritbot added a comment.Dec 13 2018, 9:54 AM

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

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

gerritbot added a comment.Dec 13 2018, 9:58 AM

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

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

Stashbot added a comment.Dec 13 2018, 9:59 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-13T09:59:56Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1101:3317 T86338 T202167 (duration: 00m 51s)

Stashbot added a comment.Dec 13 2018, 10:44 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-13T10:44:24Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1101:3317 T86338 T202167 (duration: 00m 51s)

gerritbot added a comment.Dec 14 2018, 5:50 AM

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

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

gerritbot added a comment.Dec 14 2018, 5:54 AM

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

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

Stashbot added a comment.Dec 14 2018, 5:55 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T05:55:08Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1094 T86338 T202167 (duration: 00m 47s)

Stashbot added a comment.Dec 14 2018, 6:10 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:10:19Z] <marostegui> Deployed schema change on db1094 T86338 T202167

Stashbot added a comment.Dec 14 2018, 6:14 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:14:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1094 T86338 T202167 (duration: 00m 44s)

Stashbot added a comment.Dec 14 2018, 6:14 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:14:20Z] <marostegui> Deploy schema change on db1062 (s7 primary master) T86338 T202167

Marostegui updated the task description. (Show Details)Dec 14 2018, 6:41 AM
Marostegui updated the task description. (Show Details)
Stashbot added a comment.Dec 14 2018, 6:53 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:53:45Z] <marostegui> Deploy schema change on db2043 (s3 codfw master) - this will generate lag on s3 codfw T86338 T20216

Stashbot added a comment.Dec 14 2018, 6:54 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T06:54:26Z] <marostegui> Deploy schema change on db2043 (s3 codfw master) - this will generate lag on s3 codfw T86338 T202167

Marostegui updated the task description. (Show Details)Dec 14 2018, 7:34 AM
Marostegui added a comment.EditedDec 14 2018, 7:41 AM

s3 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • db1124
  • db1123
  • db1095
  • db1078
  • db1077
  • db1075
Stashbot added a comment.Dec 14 2018, 7:59 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T07:58:59Z] <marostegui> Deploy schema change on dbstore1002:s3 T86338 T202167

Stashbot added a comment.Dec 14 2018, 9:33 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-14T09:33:47Z] <marostegui> Deploy schema change on db1095:3313 T86338 T202167

Marostegui updated the task description. (Show Details)Dec 14 2018, 10:22 AM
gerritbot added a comment.Dec 17 2018, 6:24 AM

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

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

gerritbot added a comment.Dec 17 2018, 6:25 AM

Change 480006 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy1010: Depool labsdb1010

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

gerritbot added a comment.Dec 17 2018, 6:27 AM

Change 480006 merged by Marostegui:
[operations/puppet@production] dbproxy1010: Depool labsdb1010

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

gerritbot added a comment.Dec 17 2018, 6:27 AM

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

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

Stashbot added a comment.Dec 17 2018, 6:28 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T06:28:00Z] <marostegui> Depool labsdb1010 - T86338

Stashbot added a comment.Dec 17 2018, 6:28 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T06:28:21Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1123 T86338 T202167 (duration: 00m 46s)

Stashbot added a comment.Dec 17 2018, 8:15 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:15:57Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1123 T86338 T202167 (duration: 00m 45s)

gerritbot added a comment.Dec 17 2018, 8:18 AM

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

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

gerritbot added a comment.Dec 17 2018, 8:20 AM

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

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

Stashbot added a comment.Dec 17 2018, 8:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:21:44Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1077 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Dec 17 2018, 8:21 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:21:52Z] <marostegui> Deploy schema change on db1077 with replication (lag will be generated on labsdb:s3) T86338 T202167

Stashbot added a comment.Dec 17 2018, 8:47 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T08:47:13Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1077 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Dec 17 2018, 9:04 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T09:04:24Z] <marostegui> Repool labsdb1010 - T86338

gerritbot added a comment.Dec 17 2018, 9:06 AM

Change 480031 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy1010: Depool labsdb1011

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

gerritbot added a comment.Dec 17 2018, 9:07 AM

Change 480031 merged by Marostegui:
[operations/puppet@production] dbproxy1010: Depool labsdb1011

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

Stashbot added a comment.Dec 17 2018, 9:08 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T09:08:52Z] <marostegui> Depool labsdb1011 - T86338

Stashbot added a comment.Dec 17 2018, 10:18 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-17T10:18:52Z] <marostegui> Repool labsdb1011 - T86338

gerritbot added a comment.Dec 18 2018, 6:03 AM

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

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

gerritbot added a comment.Dec 18 2018, 6:05 AM

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

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

Stashbot added a comment.Dec 18 2018, 6:07 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-18T06:07:07Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1078 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Dec 18 2018, 6:07 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-18T06:07:11Z] <marostegui> Deploy schema change on db1078 T86338 T202167

Stashbot added a comment.Dec 18 2018, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-18T07:49:10Z] <marostegui> Deploy schema change on db1075 (s3 master) T86338 T202167

Stashbot added a comment.Dec 18 2018, 7:49 AM

Mentioned in SAL (#wikimedia-operations) [2018-12-18T07:49:39Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1078 T86338 T202167 (duration: 00m 45s)

Marostegui updated the task description. (Show Details)Dec 18 2018, 9:23 AM
Stashbot added a comment.Jan 2 2019, 7:01 AM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T07:00:59Z] <marostegui> Deploy schema change on s1 codfw master (lag will be generated on s1 codfw) - T202167 T86338

Marostegui updated the task description. (Show Details)Jan 2 2019, 7:52 AM
Marostegui added a comment.EditedJan 2 2019, 8:12 AM

s1 eqiad progress

  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1002
  • dbstore1001
  • db1124
  • db1119
  • db1114
  • db1106
  • db1105
  • db1099
  • db1089
  • db1083
  • db1080
  • db1067
Marostegui updated the task description. (Show Details)Jan 2 2019, 9:15 AM
gerritbot added a comment.Jan 2 2019, 11:20 AM

Change 481842 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/481842

gerritbot added a comment.Jan 2 2019, 11:22 AM

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

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

Stashbot added a comment.Jan 2 2019, 11:23 AM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T11:23:42Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1099:3311 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Jan 2 2019, 11:24 AM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T11:24:37Z] <marostegui> Deploy schema change on db1099:3311 - T86338 T202167

Stashbot added a comment.Jan 2 2019, 1:01 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:01:12Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1099:3311 T86338 T202167 (duration: 00m 47s)

gerritbot added a comment.Jan 2 2019, 1:02 PM

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

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

gerritbot added a comment.Jan 2 2019, 1:04 PM

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

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

Stashbot added a comment.Jan 2 2019, 1:05 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:05:48Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1119 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Jan 2 2019, 1:06 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:06:47Z] <marostegui> Deploy schema change on db1119 - T86338 T202167

Stashbot added a comment.Jan 2 2019, 1:30 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-02T13:30:41Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1119 T86338 T202167 (duration: 00m 44s)

gerritbot added a comment.Jan 8 2019, 3:52 PM

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

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

gerritbot added a comment.Jan 8 2019, 3:55 PM

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

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

Stashbot added a comment.Jan 8 2019, 3:56 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T15:56:16Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1089 T86338 T202167 (duration: 00m 45s)

Stashbot added a comment.Jan 8 2019, 3:59 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T15:59:55Z] <marostegui> Deploy schema change on db1089 T86338 T202167

Stashbot added a comment.Jan 8 2019, 4:29 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:29:14Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1089 T86338 T202167 (duration: 00m 45s)

gerritbot added a comment.Jan 8 2019, 4:50 PM

Change 482839 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/482839

gerritbot added a comment.Jan 8 2019, 4:53 PM

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

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

Stashbot added a comment.Jan 8 2019, 4:54 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:54:53Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1105:3311 T86338 T202167 (duration: 00m 44s)

Stashbot added a comment.Jan 8 2019, 4:54 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T16:54:58Z] <marostegui> Deploy schema change on db1105:3311 T86338 T202167

Stashbot added a comment.Jan 8 2019, 6:28 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-08T18:28:45Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1105:3311 T86338 T202167 (duration: 00m 45s)

gerritbot added a comment.Jan 9 2019, 3:06 PM

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

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

gerritbot added a comment.Jan 9 2019, 3:08 PM

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

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

Stashbot added a comment.Jan 9 2019, 3:10 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:10:02Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1106 T86338 T202167 (duration: 00m 52s)

Stashbot added a comment.Jan 9 2019, 3:10 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:10:08Z] <marostegui> Deploy schema change on db1106 (sanitarium s1 master) with replication, lag will be generated on s1 labs - T86338 T202167

Stashbot added a comment.Jan 9 2019, 3:34 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T15:34:56Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1106 T86338 T202167 (duration: 00m 51s)

gerritbot added a comment.Jan 9 2019, 4:24 PM

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

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

gerritbot added a comment.Jan 9 2019, 4:28 PM

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

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

Stashbot added a comment.Jan 9 2019, 4:29 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T16:29:15Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1083 T86338 T202167 (duration: 00m 53s)

Stashbot added a comment.Jan 9 2019, 4:29 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T16:29:34Z] <marostegui> Deploy schema change on db1083 - T86338 T202167

Stashbot added a comment.Jan 9 2019, 5:05 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T17:05:28Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1083 T86338 T202167 (duration: 00m 52s)

gerritbot added a comment.Jan 9 2019, 5:26 PM

Change 483190 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] dbproxy1010: Depool labsdb1011

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

gerritbot added a comment.Jan 9 2019, 5:27 PM

Change 483190 merged by Marostegui:
[operations/puppet@production] dbproxy1010: Depool labsdb1011

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

Stashbot added a comment.Jan 9 2019, 5:28 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-09T17:28:03Z] <marostegui> Reload haproxy on dbproxy1010 to depool labsdb1011 - T86338

gerritbot added a comment.Jan 10 2019, 2:27 PM

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

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

gerritbot added a comment.Jan 10 2019, 2:31 PM

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

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

Stashbot added a comment.Jan 10 2019, 2:33 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:33:05Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1114 T86338 T202167 (duration: 00m 53s)

Stashbot added a comment.Jan 10 2019, 2:33 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:33:12Z] <marostegui> Deploy schema change on db1114 - T86338 T202167

Stashbot added a comment.Jan 10 2019, 2:55 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:55:42Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1114 T86338 T202167 (duration: 00m 52s)

gerritbot added a comment.Jan 10 2019, 2:55 PM

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

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

gerritbot added a comment.Jan 10 2019, 2:58 PM

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

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

Stashbot added a comment.Jan 10 2019, 2:59 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:59:14Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Depool db1080 T86338 T202167 (duration: 00m 52s)

Stashbot added a comment.Jan 10 2019, 2:59 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T14:59:18Z] <marostegui> Deploy schema change on db1080 - T86338 T202167

Stashbot added a comment.Jan 10 2019, 3:26 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T15:26:05Z] <marostegui@deploy1001> Synchronized wmf-config/db-eqiad.php: Repool db1080 T86338 T202167 (duration: 00m 49s)

Stashbot added a comment.Jan 10 2019, 3:27 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T15:27:01Z] <marostegui> Deploy schema change on db1067 (s1 master) - T86338 T202167

Stashbot added a comment.Jan 10 2019, 3:56 PM

Mentioned in SAL (#wikimedia-operations) [2019-01-10T15:56:12Z] <marostegui> Deploy schema change on db1068 (s4 master) - T86338

Marostegui updated the task description. (Show Details)Jan 10 2019, 3:57 PM
Marostegui closed this task as Resolved.Jan 10 2019, 5:10 PM
In T86338#4812696, @Marostegui wrote:

db1068 (s4 master) has too much concurrency on the page table to be able to alter it live (metada locking issues)

This finally went thru after a second attempt.

root@cumin1001:/home/marostegui# mysql.py -hdb1068 -e "show create table commonswiki.page\G"
*************************** 1. row ***************************
       Table: page
Create Table: CREATE TABLE `page` (
  `page_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `page_namespace` int(11) NOT NULL DEFAULT '0',
  `page_title` varbinary(255) NOT NULL DEFAULT '',
  `page_restrictions` tinyblob NOT NULL,
  `page_is_redirect` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `page_is_new` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `page_random` double unsigned NOT NULL DEFAULT '0',
  `page_touched` varbinary(14) NOT NULL DEFAULT '',
  `page_links_updated` varbinary(14) DEFAULT NULL,
  `page_latest` int(8) unsigned NOT NULL DEFAULT '0',
  `page_len` int(8) unsigned NOT NULL DEFAULT '0',
  `page_no_title_convert` tinyint(1) NOT NULL DEFAULT '0',
  `page_content_model` varbinary(32) DEFAULT NULL,
  `page_lang` varbinary(35) DEFAULT NULL,
  PRIMARY KEY (`page_id`),
  UNIQUE KEY `name_title` (`page_namespace`,`page_title`),
  KEY `page_random` (`page_random`),
  KEY `page_len` (`page_len`),
  KEY `page_redirect_namespace_len` (`page_is_redirect`,`page_namespace`,`page_len`)
) ENGINE=InnoDB AUTO_INCREMENT=75740131 DEFAULT CHARSET=binary

So this is all done!

Marostegui updated the task description. (Show Details)Jan 10 2019, 5:10 PM
Umherirrender removed a project: Patch-For-Review.Jul 13 2022, 8:04 PM
Maintenance_bot moved this task from In progress to Done on the DBA board.Jul 13 2022, 8:29 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and 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 · Credits