Page MenuHomePhabricator
Create Task
Maniphest T297191

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

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

Details

SubjectRepoBranchLines +/-
Fix sqoop page_restriction schemaanalytics/refinerymaster+0 -1
drop_pr_user_T297191.py: Schema change to drop pr_useroperations/software/schema-changesmaster+36 -0
Customize query in gerrit

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
Stashbot added a comment.Jan 12 2022, 8:50 AM

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

Stashbot added a comment.Jan 12 2022, 9:10 AM

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

Stashbot added a comment.Jan 12 2022, 10:10 AM

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

Stashbot added a comment.Jan 12 2022, 10:55 AM

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

Stashbot added a comment.Jan 12 2022, 10:55 AM

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

Stashbot added a comment.Jan 12 2022, 11:05 AM

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

Stashbot added a comment.Jan 12 2022, 11:50 AM

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

Stashbot added a comment.Jan 12 2022, 11:50 AM

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

Stashbot added a comment.Jan 12 2022, 12:00 PM

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

Stashbot added a comment.Jan 12 2022, 12:45 PM

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

Marostegui added a comment.Jan 12 2022, 1:33 PM

s3 replicas done

Marostegui added a comment.Jan 12 2022, 1:44 PM

s3 master done

Marostegui updated the task description. (Show Details)Jan 12 2022, 1:44 PM
Stashbot added a comment.Jan 12 2022, 1:46 PM

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

Marostegui added a comment.Jan 12 2022, 1:46 PM

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

Marostegui updated the task description. (Show Details)Jan 12 2022, 1:47 PM
Stashbot added a comment.Jan 12 2022, 1:47 PM

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

Stashbot added a comment.Jan 12 2022, 2:32 PM

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

Stashbot added a comment.Jan 12 2022, 2:33 PM

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

Stashbot added a comment.Jan 12 2022, 2:36 PM

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

Stashbot added a comment.Jan 12 2022, 3:21 PM

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

Stashbot added a comment.Jan 12 2022, 3:21 PM

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

Stashbot added a comment.Jan 12 2022, 3:22 PM

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

Stashbot added a comment.Jan 12 2022, 4:07 PM

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

Stashbot added a comment.Jan 12 2022, 4:08 PM

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

Stashbot added a comment.Jan 12 2022, 4:09 PM

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

Stashbot added a comment.Jan 12 2022, 4:54 PM

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

Stashbot added a comment.Jan 12 2022, 4:55 PM

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

Stashbot added a comment.Jan 12 2022, 5:40 PM

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

Stashbot added a comment.Jan 12 2022, 5:41 PM

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

Stashbot added a comment.Jan 12 2022, 5:42 PM

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

Stashbot added a comment.Jan 12 2022, 6:27 PM

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

Stashbot added a comment.Jan 12 2022, 6:28 PM

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

Stashbot added a comment.Jan 12 2022, 6:29 PM

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

Stashbot added a comment.Jan 12 2022, 7:14 PM

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

Stashbot added a comment.Jan 12 2022, 7:14 PM

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

Stashbot added a comment.Jan 12 2022, 7:22 PM

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

Stashbot added a comment.Jan 12 2022, 8:08 PM

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

Stashbot added a comment.Jan 12 2022, 8:08 PM

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

Stashbot added a comment.Jan 12 2022, 8:11 PM

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

Stashbot added a comment.Jan 12 2022, 8:56 PM

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

Stashbot added a comment.Jan 12 2022, 8:56 PM

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

Stashbot added a comment.Jan 12 2022, 8:57 PM

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

Stashbot added a comment.Jan 12 2022, 9:42 PM

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

Marostegui added a comment.Jan 13 2022, 5:55 AM

s1 replicas (including db1169) are done

Marostegui added a comment.Jan 13 2022, 5:56 AM

s1 master done

Marostegui updated the task description. (Show Details)Jan 13 2022, 5:56 AM

Views recreated on s1 clouddb* hosts.

Marostegui added a comment.Jan 13 2022, 5:59 AM

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
Marostegui updated the task description. (Show Details)Jan 13 2022, 6:02 AM
Marostegui added a comment.Jan 13 2022, 6:08 AM

s8 eqiad

  • dbstore1005
  • db1178
  • db1177
  • db1172
  • db1171
  • db1167
  • db1154
  • db1126
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • clouddb1021
  • clouddb1020
  • clouddb1016
Marostegui added a comment.Jan 13 2022, 6:09 AM

Views recreated on s8 clouddb* hosts.

Marostegui closed this task as Resolved.Jan 13 2022, 6:09 AM
Marostegui updated the task description. (Show Details)

All done

Marostegui updated the task description. (Show Details)Jan 13 2022, 6:23 AM
gerritbot added a comment.Feb 1 2022, 10:20 AM

Change 758798 had a related patch set uploaded (by Joal; author: Joal):

[analytics/refinery@master] Fix sqoop page_restriction schema

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

gerritbot added a project: Patch-For-Review.Feb 1 2022, 10:20 AM
gerritbot added a comment.Feb 1 2022, 2:16 PM

Change 758798 merged by Ottomata:

[analytics/refinery@master] Fix sqoop page_restriction schema

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

Maintenance_bot removed a project: Patch-For-Review.Feb 1 2022, 3:10 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