Page MenuHomePhabricator

Schema change for dropping page_restrictions.pr_user field on wmf sites
Closed, ResolvedPublic

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/445595/7/maintenance/archives/patch-drop-page_restrictions-pr_user.sql
  2. Where to run those changes: all
  3. When to run those changes: Any time, but must be done after deployment of 1.38.0-wmf13 is stable
  4. If the schema change is backwards compatible: No
  5. If the schema change has been tested already on some of the test/beta wikis: Yes. Beta cluster (Hopefully?)
  6. If the data should be made available on the cloud services replicas and/or dumps: The field was public and can be removed from clouds

The field was removed with T199377

Related Objects

Mentioned In
T199377: Consider removing page_restrictions.pr_user field from schema
Mentioned Here
P18709 dbctl commit (dc=all): 'Repooling after maintenance db1164 (T297191)'
P18706 dbctl commit (dc=all): 'Repooling after maintenance db1164 (T297191)'
P18705 dbctl commit (dc=all): 'Depooling db1164 (T297191)'
P18704 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T297191)'
P18701 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T297191)'
P18700 dbctl commit (dc=all): 'Depooling db1105:3311 (T297191)'
P18699 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T297191)'
P18696 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T297191)'
P18695 dbctl commit (dc=all): 'Depooling db1119 (T297191)'
P18694 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T297191)'
P18691 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T297191)'
P18690 dbctl commit (dc=all): 'Depooling db1106 (T297191)'
P18689 dbctl commit (dc=all): 'Repooling after maintenance db1184 (T297191)'
P18686 dbctl commit (dc=all): 'Repooling after maintenance db1184 (T297191)'
P18685 dbctl commit (dc=all): 'Depooling db1184 (T297191)'
P18684 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T297191)'
P18681 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T297191)'
P18680 dbctl commit (dc=all): 'Depooling db1099:3311 (T297191)'
P18676 dbctl commit (dc=all): 'Repooling after maintenance db1135 (T297191)'
P18675 dbctl commit (dc=all): 'Depooling db1135 (T297191)'
P18674 dbctl commit (dc=all): 'Repooling after maintenance db1134 (T297191)'
P18671 dbctl commit (dc=all): 'Repooling after maintenance db1134 (T297191)'
P18670 dbctl commit (dc=all): 'Depooling db1134 (T297191)'
P18669 dbctl commit (dc=all): 'Repooling after maintenance db1163 (T297191)'
P18666 dbctl commit (dc=all): 'Repooling after maintenance db1163 (T297191)'
P18665 dbctl commit (dc=all): 'Depooling db1163 (T297191)'
P18664 dbctl commit (dc=all): 'Repooling after maintenance db1128 (T297191)'
P18659 dbctl commit (dc=all): 'Repooling after maintenance db1128 (T297191)'
T299025: db1169 reimage/idrac failure
P18658 dbctl commit (dc=all): 'Depooling db1128 (T297191)'
P18650 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T297191)'
P18645 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T297191)'
P18643 dbctl commit (dc=all): 'Depooling db1175 (T297191)'
P18642 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T297191)'
P18638 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T297191)'
P18636 dbctl commit (dc=all): 'Depooling db1179 (T297191)'
P18635 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T297191)'
P18629 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T297191)'
P18628 dbctl commit (dc=all): 'Depooling db1166 (T297191)'
P18627 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T297191)'
P18624 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T297191)'
P18623 dbctl commit (dc=all): 'Depooling db1112 (T297191)'
P18622 dbctl commit (dc=all): 'Repooling after maintenance db1123 (T297191)'
P18619 dbctl commit (dc=all): 'Repooling after maintenance db1123 (T297191)'
P18618 dbctl commit (dc=all): 'Depooling db1123 (T297191)'
P18615 dbctl commit (dc=all): 'Repooling after maintenance db1148 (T297191)'
P18612 dbctl commit (dc=all): 'Repooling after maintenance db1148 (T297191)'
P18611 dbctl commit (dc=all): 'Depooling db1148 (T297191)'
P18610 dbctl commit (dc=all): 'Repooling after maintenance db1149 (T297191)'
P18607 dbctl commit (dc=all): 'Repooling after maintenance db1149 (T297191)'
P18606 dbctl commit (dc=all): 'Depooling db1149 (T297191)'
P18605 dbctl commit (dc=all): 'Repooling after maintenance db1160 (T297191)'
P18602 dbctl commit (dc=all): 'Repooling after maintenance db1160 (T297191)'
P18601 dbctl commit (dc=all): 'Depooling db1160 (T297191)'
P18600 dbctl commit (dc=all): 'Repooling after maintenance db1121 (T297191)'
P18597 dbctl commit (dc=all): 'Repooling after maintenance db1121 (T297191)'
P18596 dbctl commit (dc=all): 'Depooling db1121 (T297191)'
P18595 dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T297191)'
P18592 dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T297191)'
P18591 dbctl commit (dc=all): 'Depooling db1146:3314 (T297191)'
P18590 dbctl commit (dc=all): 'Repooling after maintenance db1143 (T297191)'
P18587 dbctl commit (dc=all): 'Repooling after maintenance db1143 (T297191)'
P18586 dbctl commit (dc=all): 'Depooling db1143 (T297191)'
P18585 dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T297191)'
P18582 dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T297191)'
P18580 dbctl commit (dc=all): 'Depooling db1144:3314 (T297191)'
P18579 dbctl commit (dc=all): 'Repooling after maintenance db1141 (T297191)'
P18576 dbctl commit (dc=all): 'Repooling after maintenance db1141 (T297191)'
P18575 dbctl commit (dc=all): 'Depooling db1141 (T297191)'
P18574 dbctl commit (dc=all): 'Repooling after maintenance db1142 (T297191)'
P18571 dbctl commit (dc=all): 'Repooling after maintenance db1142 (T297191)'
P18570 dbctl commit (dc=all): 'Depooling db1142 (T297191)'
P18569 dbctl commit (dc=all): 'Repooling after maintenance db1147 (T297191)'
P18565 dbctl commit (dc=all): 'Repooling after maintenance db1147 (T297191)'
P18564 dbctl commit (dc=all): 'Depooling db1147 (T297191)'
P18563 dbctl commit (dc=all): 'Repooling after maintenance db1181 (T297191)'
P18557 dbctl commit (dc=all): 'Repooling after maintenance db1181 (T297191)'
P18556 dbctl commit (dc=all): 'Depooling db1181 (T297191)'
P18555 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T297191)'
P18550 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T297191)'
P18549 dbctl commit (dc=all): 'Depooling db1158 (T297191)'
P18548 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T297191)'
P18545 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T297191)'
P18544 dbctl commit (dc=all): 'Depooling db1098:3317 (T297191)'
P18543 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T297191)'
P18538 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T297191)'
P18537 dbctl commit (dc=all): 'Depooling db1174 (T297191)'
P18536 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T297191)'
P18528 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T297191)'
P18527 dbctl commit (dc=all): 'Depooling db1170:3317 (T297191)'
P18526 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T297191)'
P18519 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T297191)'
P18517 dbctl commit (dc=all): 'Depooling db1127 (T297191)'
P18516 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T297191)'
P18507 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T297191)'
P18506 dbctl commit (dc=all): 'Depooling db1101:3317 (T297191)'
T138208: Connections to all db servers for wikidata as wikiadmin from snapshot, terbium
P18503 dbctl commit (dc=all): 'Depooling db1104 (T297191)'
P18502 dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T297191)'
P18499 dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T297191)'
P18497 dbctl commit (dc=all): 'Depooling db1144:3315 (T297191)'
P18496 dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T297191)'
P18493 dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T297191)'
P18492 dbctl commit (dc=all): 'Depooling db1113:3315 (T297191)'
P18491 dbctl commit (dc=all): 'Repooling after maintenance db1110 (T297191)'
P18487 dbctl commit (dc=all): 'Repooling after maintenance db1110 (T297191)'
P18486 dbctl commit (dc=all): 'Depooling db1110 (T297191)'
P18485 dbctl commit (dc=all): 'Repooling after maintenance db1100 (T297191)'
P18482 dbctl commit (dc=all): 'Repooling after maintenance db1100 (T297191)'
P18481 dbctl commit (dc=all): 'Depooling db1100 (T297191)'
P18480 dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T297191)'
P18476 dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T297191)'
P18475 dbctl commit (dc=all): 'Depooling db1096:3315 (T297191)'
P18474 dbctl commit (dc=all): 'Repooling after maintenance db1161 (T297191)'
P18470 dbctl commit (dc=all): 'Repooling after maintenance db1161 (T297191)'
P18469 dbctl commit (dc=all): 'Depooling db1161 (T297191)'
P18468 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T297191)'
P18464 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T297191)'
P18463 dbctl commit (dc=all): 'Depooling db1146:3312 (T297191)'
P18462 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T297191)'
P18458 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T297191)'
P18457 dbctl commit (dc=all): 'Depooling db1170:3312 (T297191)'
P18456 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T297191)'
P18453 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T297191)'
P18451 dbctl commit (dc=all): 'Depooling db1105:3312 (T297191)'
P18449 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T297191)'
P18444 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T297191)'
P18443 dbctl commit (dc=all): 'Depooling db1131 (T297191)'
P18442 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T297191)'
P18439 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T297191)'
P18438 dbctl commit (dc=all): 'Depooling db1165 (T297191)'
P18437 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T297191)'
P18434 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T297191)'
P18433 dbctl commit (dc=all): 'Depooling db1168 (T297191)'
P18432 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T297191)'
P18429 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T297191)'
P18428 dbctl commit (dc=all): 'Depooling db1180 (T297191)'
P18427 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T297191)'
P18424 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T297191)'
P18423 dbctl commit (dc=all): 'Depooling db1113:3316 (T297191)'
P18413 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T297191)'
P18410 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T297191)'
P18409 dbctl commit (dc=all): 'Depooling db1098:3316 (T297191)'
P18398 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T297191)'
P18395 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T297191)'
P18394 dbctl commit (dc=all): 'Depooling db1096:3316 (T297191)'
T199377: Consider removing page_restrictions.pr_user field from schema

Event Timeline

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

Mentioned in SAL (#wikimedia-operations) [2022-01-12T07:28:26Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1112 (T297191)', diff saved to https://phabricator.wikimedia.org/P18623 and previous config saved to /var/cache/conftool/dbconfig/20220112-072826-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T08:05:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T297191)', diff saved to https://phabricator.wikimedia.org/P18624 and previous config saved to /var/cache/conftool/dbconfig/20220112-080510-marostegui.json

Views recreated on s3 clouddb* hosts

Mentioned in SAL (#wikimedia-operations) [2022-01-12T08:50:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1112 (T297191)', diff saved to https://phabricator.wikimedia.org/P18627 and previous config saved to /var/cache/conftool/dbconfig/20220112-085024-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T09:09:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1166 (T297191)', diff saved to https://phabricator.wikimedia.org/P18628 and previous config saved to /var/cache/conftool/dbconfig/20220112-090959-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T10:10:19Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T297191)', diff saved to https://phabricator.wikimedia.org/P18629 and previous config saved to /var/cache/conftool/dbconfig/20220112-101018-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T10:55:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1166 (T297191)', diff saved to https://phabricator.wikimedia.org/P18635 and previous config saved to /var/cache/conftool/dbconfig/20220112-105532-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T10:55:40Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1179 (T297191)', diff saved to https://phabricator.wikimedia.org/P18636 and previous config saved to /var/cache/conftool/dbconfig/20220112-105540-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T11:05:08Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T297191)', diff saved to https://phabricator.wikimedia.org/P18638 and previous config saved to /var/cache/conftool/dbconfig/20220112-110508-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T11:50:24Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T297191)', diff saved to https://phabricator.wikimedia.org/P18642 and previous config saved to /var/cache/conftool/dbconfig/20220112-115024-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T11:50:32Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1175 (T297191)', diff saved to https://phabricator.wikimedia.org/P18643 and previous config saved to /var/cache/conftool/dbconfig/20220112-115031-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T12:00:01Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T297191)', diff saved to https://phabricator.wikimedia.org/P18645 and previous config saved to /var/cache/conftool/dbconfig/20220112-120000-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T12:45:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1175 (T297191)', diff saved to https://phabricator.wikimedia.org/P18650 and previous config saved to /var/cache/conftool/dbconfig/20220112-124514-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T13:46:20Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1128 (T297191)', diff saved to https://phabricator.wikimedia.org/P18658 and previous config saved to /var/cache/conftool/dbconfig/20220112-134620-marostegui.json

Started deployment on s1 - reminder that db1169 is down (T299025) and will need the schema change applied manually

Mentioned in SAL (#wikimedia-operations) [2022-01-12T13:47:27Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T297191)', diff saved to https://phabricator.wikimedia.org/P18659 and previous config saved to /var/cache/conftool/dbconfig/20220112-134727-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T14:32:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T297191)', diff saved to https://phabricator.wikimedia.org/P18664 and previous config saved to /var/cache/conftool/dbconfig/20220112-143241-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T14:32:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1163 (T297191)', diff saved to https://phabricator.wikimedia.org/P18665 and previous config saved to /var/cache/conftool/dbconfig/20220112-143258-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T14:36:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T297191)', diff saved to https://phabricator.wikimedia.org/P18666 and previous config saved to /var/cache/conftool/dbconfig/20220112-143606-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T15:21:21Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1163 (T297191)', diff saved to https://phabricator.wikimedia.org/P18669 and previous config saved to /var/cache/conftool/dbconfig/20220112-152121-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T15:21:33Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T297191)', diff saved to https://phabricator.wikimedia.org/P18670 and previous config saved to /var/cache/conftool/dbconfig/20220112-152133-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T15:22:41Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T297191)', diff saved to https://phabricator.wikimedia.org/P18671 and previous config saved to /var/cache/conftool/dbconfig/20220112-152240-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T16:07:55Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T297191)', diff saved to https://phabricator.wikimedia.org/P18674 and previous config saved to /var/cache/conftool/dbconfig/20220112-160755-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T16:08:03Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T297191)', diff saved to https://phabricator.wikimedia.org/P18675 and previous config saved to /var/cache/conftool/dbconfig/20220112-160802-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T16:09:10Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T297191)', diff saved to https://phabricator.wikimedia.org/P18676 and previous config saved to /var/cache/conftool/dbconfig/20220112-160910-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T16:54:36Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18680 and previous config saved to /var/cache/conftool/dbconfig/20220112-165434-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T16:55:42Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18681 and previous config saved to /var/cache/conftool/dbconfig/20220112-165542-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T17:40:56Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18684 and previous config saved to /var/cache/conftool/dbconfig/20220112-174056-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T17:41:04Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T297191)', diff saved to https://phabricator.wikimedia.org/P18685 and previous config saved to /var/cache/conftool/dbconfig/20220112-174103-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T17:42:11Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T297191)', diff saved to https://phabricator.wikimedia.org/P18686 and previous config saved to /var/cache/conftool/dbconfig/20220112-174211-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T18:27:25Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T297191)', diff saved to https://phabricator.wikimedia.org/P18689 and previous config saved to /var/cache/conftool/dbconfig/20220112-182725-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T18:28:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T297191)', diff saved to https://phabricator.wikimedia.org/P18690 and previous config saved to /var/cache/conftool/dbconfig/20220112-182806-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T18:29:14Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T297191)', diff saved to https://phabricator.wikimedia.org/P18691 and previous config saved to /var/cache/conftool/dbconfig/20220112-182913-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T19:14:28Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T297191)', diff saved to https://phabricator.wikimedia.org/P18694 and previous config saved to /var/cache/conftool/dbconfig/20220112-191428-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T19:14:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T297191)', diff saved to https://phabricator.wikimedia.org/P18695 and previous config saved to /var/cache/conftool/dbconfig/20220112-191436-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T19:22:45Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T297191)', diff saved to https://phabricator.wikimedia.org/P18696 and previous config saved to /var/cache/conftool/dbconfig/20220112-192244-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:07:59Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T297191)', diff saved to https://phabricator.wikimedia.org/P18699 and previous config saved to /var/cache/conftool/dbconfig/20220112-200759-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:08:07Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18700 and previous config saved to /var/cache/conftool/dbconfig/20220112-200806-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:11:15Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18701 and previous config saved to /var/cache/conftool/dbconfig/20220112-201114-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:56:29Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T297191)', diff saved to https://phabricator.wikimedia.org/P18704 and previous config saved to /var/cache/conftool/dbconfig/20220112-205629-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:56:37Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depooling db1164 (T297191)', diff saved to https://phabricator.wikimedia.org/P18705 and previous config saved to /var/cache/conftool/dbconfig/20220112-205636-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T20:57:44Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1164 (T297191)', diff saved to https://phabricator.wikimedia.org/P18706 and previous config saved to /var/cache/conftool/dbconfig/20220112-205744-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2022-01-12T21:42:58Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1164 (T297191)', diff saved to https://phabricator.wikimedia.org/P18709 and previous config saved to /var/cache/conftool/dbconfig/20220112-214258-marostegui.json

s1 replicas (including db1169) are done

Views recreated on s1 clouddb* hosts.

s8 deployment needs to be done manually, as right now there are dumps thread connected to all the s8 eqiad hosts so the script will not be able to advance:

db1178.eqiad.wmnet:3306
2367520963	wikiadmin	10.64.0.156:50602	wikidatawiki	Sleep	4		NULL	0.000
2367790498	wikiadmin	10.64.0.156:50808	wikidatawiki	Sleep	52		NULL	0.000
2367839053	wikiadmin	10.64.0.156:50868	wikidatawiki	Sleep	21		NULL	0.000
2367886157	wikiadmin	10.64.0.156:50944	wikidatawiki	Sleep	11		NULL	0.000
2367898478	wikiadmin	10.64.0.156:51004	wikidatawiki	Sleep	5		NULL	0.000
2367946148	wikiadmin	10.64.0.156:51112	wikidatawiki	Sleep	9		NULL	0.000
2367964115	wikiadmin	10.64.0.156:51136	wikidatawiki	Sleep	11		NULL	0.000
2367985433	wikiadmin	10.64.0.156:51172	wikidatawiki	Sleep	31		NULL	0.000
2368262205	wikiadmin	10.64.0.156:51256	wikidatawiki	Sleep	0		NULL	0.000
db1177.eqiad.wmnet:3306
3045009910	wikiadmin	10.64.0.156:32788	wikidatawiki	Sleep	59		NULL	0.000
3045023541	wikiadmin	10.64.0.156:32822	wikidatawiki	Sleep	57		NULL	0.000
3045053749	wikiadmin	10.64.0.156:32874	wikidatawiki	Sleep	4		NULL	0.000
3045064041	wikiadmin	10.64.0.156:32914	wikidatawiki	Sleep	8		NULL	0.000
3045089987	wikiadmin	10.64.0.156:32950	wikidatawiki	Sleep	1		NULL	0.000
3045095577	wikiadmin	10.64.0.156:32974	wikidatawiki	Sleep	457		NULL	0.000
3045109253	wikiadmin	10.64.0.156:33002	wikidatawiki	Sleep	0		NULL	0.000
3045119873	wikiadmin	10.64.0.156:33030	wikidatawiki	Sleep	94		NULL	0.000
3045121010	wikiadmin	10.64.0.156:33040	wikidatawiki	Sleep	22		NULL	0.000
3045152357	wikiadmin	10.64.0.156:33082	wikidatawiki	Sleep	0		NULL	0.000
3045577640	wikiadmin	10.64.0.156:33196	wikidatawiki	Sleep	35		NULL	0.000
db1172.eqiad.wmnet:3306
2088185998	wikiadmin	10.64.0.156:43628	wikidatawiki	Sleep	8		NULL	0.000
2088187935	wikiadmin	10.64.0.156:43638	wikidatawiki	Sleep	0		NULL	0.000
2088229649	wikiadmin	10.64.0.156:43726	wikidatawiki	Sleep	36		NULL	0.000
2088239729	wikiadmin	10.64.0.156:43774	wikidatawiki	Sleep	0		NULL	0.000
2088268619	wikiadmin	10.64.0.156:43864	wikidatawiki	Sleep	0		NULL	0.000
2088325425	wikiadmin	10.64.0.156:44008	wikidatawiki	Sleep	574		NULL	0.000
2088396353	wikiadmin	10.64.0.156:44018	wikidatawiki	Sleep	365		NULL	0.000
db1171.eqiad.wmnet:3318
db1167.eqiad.wmnet:3306
455720230	wikiadmin	10.64.0.156:43424	wikidatawiki	Sleep	3001		NULL	0.000
455720231	wikiadmin	10.64.0.156:43426	wikidatawiki	Sleep	3001		NULL	0.000
455720266	wikiadmin	10.64.0.156:43432	wikidatawiki	Sleep	3000		NULL	0.000
455720267	wikiadmin	10.64.0.156:43434	wikidatawiki	Sleep	3000		NULL	0.000
455720272	wikiadmin	10.64.0.156:43440	wikidatawiki	Sleep	3000		NULL	0.000
455720273	wikiadmin	10.64.0.156:43442	wikidatawiki	Sleep	3000		NULL	0.000
455720276	wikiadmin	10.64.0.156:43446	wikidatawiki	Sleep	3000		NULL	0.000
455720277	wikiadmin	10.64.0.156:43448	wikidatawiki	Sleep	3000		NULL	0.000
455720351	wikiadmin	10.64.0.156:43454	wikidatawiki	Sleep	2998		NULL	0.000
455720352	wikiadmin	10.64.0.156:43456	wikidatawiki	Sleep	2998		NULL	0.000
455720376	wikiadmin	10.64.0.156:43462	wikidatawiki	Sleep	2998		NULL	0.000
455720377	wikiadmin	10.64.0.156:43464	wikidatawiki	Sleep	2998		NULL	0.000
455720390	wikiadmin	10.64.0.156:43468	wikidatawiki	Sleep	2997		NULL	0.000
455720391	wikiadmin	10.64.0.156:43470	wikidatawiki	Sleep	2997		NULL	0.000
455720404	wikiadmin	10.64.0.156:43476	wikidatawiki	Sleep	2997		NULL	0.000
455720405	wikiadmin	10.64.0.156:43478	wikidatawiki	Sleep	2997		NULL	0.000
455720416	wikiadmin	10.64.0.156:43482	wikidatawiki	Sleep	2997		NULL	0.000
455720419	wikiadmin	10.64.0.156:43484	wikidatawiki	Sleep	2997		NULL	0.000
455720423	wikiadmin	10.64.0.156:43490	wikidatawiki	Sleep	2997		NULL	0.000
455720424	wikiadmin	10.64.0.156:43492	wikidatawiki	Sleep	2997		NULL	0.000
455720437	wikiadmin	10.64.0.156:43496	wikidatawiki	Sleep	2997		NULL	0.000
455720438	wikiadmin	10.64.0.156:43498	wikidatawiki	Sleep	2997		NULL	0.000
455720444	wikiadmin	10.64.0.156:43504	wikidatawiki	Sleep	2996		NULL	0.000
455720445	wikiadmin	10.64.0.156:43506	wikidatawiki	Sleep	2996		NULL	0.000
455720465	wikiadmin	10.64.0.156:43512	wikidatawiki	Sleep	2996		NULL	0.000
455720466	wikiadmin	10.64.0.156:43514	wikidatawiki	Sleep	2996		NULL	0.000
455720495	wikiadmin	10.64.0.156:43526	wikidatawiki	Sleep	2996		NULL	0.000
455720496	wikiadmin	10.64.0.156:43528	wikidatawiki	Sleep	2996		NULL	0.000
455720507	wikiadmin	10.64.0.156:43532	wikidatawiki	Sleep	2995		NULL	0.000
455720508	wikiadmin	10.64.0.156:43534	wikidatawiki	Sleep	2995		NULL	0.000
455720512	wikiadmin	10.64.0.156:43538	wikidatawiki	Sleep	2995		NULL	0.000
455720514	wikiadmin	10.64.0.156:43540	wikidatawiki	Sleep	2995		NULL	0.000
455720528	wikiadmin	10.64.0.156:43546	wikidatawiki	Sleep	2995		NULL	0.000
455720529	wikiadmin	10.64.0.156:43548	wikidatawiki	Sleep	2995		NULL	0.000
455720540	wikiadmin	10.64.0.156:43552	wikidatawiki	Sleep	2995		NULL	0.000
455720541	wikiadmin	10.64.0.156:43554	wikidatawiki	Sleep	2995		NULL	0.000
455720543	wikiadmin	10.64.0.156:43560	wikidatawiki	Sleep	2995		NULL	0.000
455720545	wikiadmin	10.64.0.156:43562	wikidatawiki	Sleep	2995		NULL	0.000
455720553	wikiadmin	10.64.0.156:43566	wikidatawiki	Sleep	2995		NULL	0.000
455720554	wikiadmin	10.64.0.156:43568	wikidatawiki	Sleep	2995		NULL	0.000
455720568	wikiadmin	10.64.0.156:43572	wikidatawiki	Sleep	2994		NULL	0.000
455720570	wikiadmin	10.64.0.156:43576	wikidatawiki	Sleep	2994		NULL	0.000
455720577	wikiadmin	10.64.0.156:43580	wikidatawiki	Sleep	2994		NULL	0.000
455720578	wikiadmin	10.64.0.156:43582	wikidatawiki	Sleep	2994		NULL	0.000
455720605	wikiadmin	10.64.0.156:43588	wikidatawiki	Sleep	2994		NULL	0.000
455720606	wikiadmin	10.64.0.156:43590	wikidatawiki	Sleep	2994		NULL	0.000
455720613	wikiadmin	10.64.0.156:43594	wikidatawiki	Sleep	2994		NULL	0.000
455720614	wikiadmin	10.64.0.156:43596	wikidatawiki	Sleep	2994		NULL	0.000
455720627	wikiadmin	10.64.0.156:43610	wikidatawiki	Sleep	2993		NULL	0.000
455720628	wikiadmin	10.64.0.156:43612	wikidatawiki	Sleep	2993		NULL	0.000
455720647	wikiadmin	10.64.0.156:43620	wikidatawiki	Sleep	2993		NULL	0.000
455720648	wikiadmin	10.64.0.156:43622	wikidatawiki	Sleep	2993		NULL	0.000
455796785	wikiadmin	10.64.16.16:55856	wikidatawiki	Sleep	0		NULL	0.000
455796819	wikiadmin	10.64.16.16:55894	wikidatawiki	Sleep	0		NULL	0.000
455796824	wikiadmin	10.64.16.16:55898	wikidatawiki	Sleep	0		NULL	0.000
455796840	wikiadmin	10.64.16.16:55930	wikidatawiki	Sleep	0		NULL	0.000
455796881	wikiadmin	10.64.16.16:55978	wikidatawiki	Sleep	0		NULL	0.000
455796901	wikiadmin	10.64.16.16:56012	wikidatawiki	Sleep	0		NULL	0.000
455797327	wikiadmin	10.64.16.16:56042	wikidatawiki	Sleep	0		NULL	0.000
455799507	wikiadmin	10.64.16.16:56088	wikidatawiki	Sleep	0		NULL	0.000
db1154.eqiad.wmnet:3318
db1126.eqiad.wmnet:3306
1327641935	wikiadmin	10.64.0.156:42162	wikidatawiki	Sleep	1		NULL	0.000
1327949355	wikiadmin	10.64.0.156:42452	wikidatawiki	Sleep	1		NULL	0.000
1327963606	wikiadmin	10.64.0.156:42490	wikidatawiki	Sleep	9		NULL	0.000
1328012695	wikiadmin	10.64.0.156:42602	wikidatawiki	Sleep	23		NULL	0.000
db1116.eqiad.wmnet:3318
db1114.eqiad.wmnet:3306
2765968284	wikiadmin	10.64.0.156:41922	wikidatawiki	Sleep	13		NULL	0.000
2766038368	wikiadmin	10.64.0.156:42002	wikidatawiki	Sleep	66		NULL	0.000
2766101402	wikiadmin	10.64.0.156:42048	wikidatawiki	Sleep	323		NULL	0.000
2766242835	wikiadmin	10.64.0.156:42116	wikidatawiki	Sleep	0		NULL	0.000
2766459814	wikiadmin	10.64.0.156:42550	wikidatawiki	Sleep	0		NULL	0.000
db1111.eqiad.wmnet:3306
3147662143	wikiadmin	10.64.0.156:38382	wikidatawiki	Sleep	435		NULL	0.000
3147735043	wikiadmin	10.64.0.156:38444	wikidatawiki	Sleep	0		NULL	0.000
3147842727	wikiadmin	10.64.0.156:38610	wikidatawiki	Sleep	2		NULL	0.000
3147851360	wikiadmin	10.64.0.156:38642	wikidatawiki	Sleep	3		NULL	0.000
3147899283	wikiadmin	10.64.0.156:38744	wikidatawiki	Sleep	4		NULL	0.000
db1109.eqiad.wmnet:3306
db1104.eqiad.wmnet:3306
3570393581	wikiadmin	10.64.0.156:57358	wikidatawiki	Sleep	15		NULL	0.000
3570599417	wikiadmin	10.64.0.156:57502	wikidatawiki	Sleep	437		NULL	0.000
3570738019	wikiadmin	10.64.0.156:57668	wikidatawiki	Sleep	2		NULL	0.000
3570803173	wikiadmin	10.64.0.156:57824	wikidatawiki	Sleep	455		NULL	0.000
3570829177	wikiadmin	10.64.0.156:57888	wikidatawiki	Sleep	41		NULL	0.000
db1101.eqiad.wmnet:3318
3158792082	wikiadmin	10.64.0.156:46916	wikidatawiki	Sleep	324		NULL	0.000
3158899405	wikiadmin	10.64.0.156:47050	wikidatawiki	Sleep	6		NULL	0.000
3159236580	wikiadmin	10.64.0.156:47498	wikidatawiki	Sleep	598		NULL	0.000
db1099.eqiad.wmnet:3318
3836702749	wikiadmin	10.64.0.156:48400	wikidatawiki	Sleep	70		NULL	0.000
3836936731	wikiadmin	10.64.0.156:48882	wikidatawiki	Sleep	0		NULL	0.000

s8 eqiad

  • dbstore1005
  • db1178
  • db1177
  • db1172
  • db1171
  • db1167
  • db1154
  • db1126
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • clouddb1021
  • clouddb1020
  • clouddb1016

Views recreated on s8 clouddb* hosts.

Marostegui updated the task description. (Show Details)

All done