Page MenuHomePhabricator
Create Task
Maniphest T309311

Make user_editcount unsigned in production
Closed, ResolvedPublic
Actions

Description

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/785123/8/maintenance/archives/patch-user-user_editcount.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: beta cluster is running with the new schema
  6. if the data should be made available on the labs replicas and/or dumps: no change of the existing rules

Context: T305340: Make user_editcount field unsigned

Progress:

  • s1: Done
  • s2: Done
  • s3: Done
  • s4
  • s5: Done
  • s6: Done
  • s7: Done
  • s8: Done
  • labtestwiki

Details

SubjectRepoBranchLines +/-
Add change_user_editcount_to_unsigned_T309311.pyoperations/software/schema-changesmaster+42 -0
Customize query in gerrit

Related Objects

Mentioned In
T314369: Switchover s8 master (db1104 -> db1109)
T301312: Switchover s1 master (db1118 -> db1163)
T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis
T312863: Schema change to change primary key of templatelinks
T310011: Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis
T298560: Fix mismatching field type of revision.rev_timestamp on wmf wikis
T314368: Switchover s2 master (db1162 -> db1122)
T303603: Add actor and comment columns to cu_changes
T60674: Drop page.page_restrictions column from Wikimedia wikis
T298555: Fix mismatching field type of logging.log_timestamp on wmf wikis
rSCHCHb14ba303c9e4: Add change_user_editcount_to_unsigned_T309311.py
T305340: Make user_editcount field unsigned
Mentioned Here
T314369: Switchover s8 master (db1104 -> db1109)
T301312: Switchover s1 master (db1118 -> db1163)
T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis
T60674: Drop page.page_restrictions column from Wikimedia wikis
T298555: Fix mismatching field type of logging.log_timestamp on wmf wikis
T298560: Fix mismatching field type of revision.rev_timestamp on wmf wikis
T303603: Add actor and comment columns to cu_changes
T310011: Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis
T312863: Schema change to change primary key of templatelinks
T314368: Switchover s2 master (db1162 -> db1122)
P32352 dbctl commit (dc=all): 'Depool db1162 (T314368 T298555 T312863 T310011 T309311 T60674 T298560 T303603 T310485)'
P30753 dbctl commit (dc=all): 'Repooling after maintenance db1118 (T309311)'
P30750 dbctl commit (dc=all): 'Repooling after maintenance db1118 (T309311)'
P30749 dbctl commit (dc=all): 'Depooling db1118 (T309311)'
P30748 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T309311)'
P30745 dbctl commit (dc=all): 'Repooling after maintenance db1119 (T309311)'
P30744 dbctl commit (dc=all): 'Depooling db1119 (T309311)'
P30743 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T309311)'
P30740 dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T309311)'
P30739 dbctl commit (dc=all): 'Depooling db1099:3311 (T309311)'
P30738 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T309311)'
P30735 dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T309311)'
P30734 dbctl commit (dc=all): 'Depooling db1105:3311 (T309311)'
P30733 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T309311)'
P30730 dbctl commit (dc=all): 'Repooling after maintenance db1106 (T309311)'
P30729 dbctl commit (dc=all): 'Depooling db1106 (T309311)'
P30728 dbctl commit (dc=all): 'Repooling after maintenance db1134 (T309311)'
P30725 dbctl commit (dc=all): 'Repooling after maintenance db1134 (T309311)'
P30723 dbctl commit (dc=all): 'Depooling db1134 (T309311)'
P30722 dbctl commit (dc=all): 'Repooling after maintenance db1135 (T309311)'
P30721 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)'
P30716 dbctl commit (dc=all): 'Repooling after maintenance db1135 (T309311)'
P30715 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)'
P30714 dbctl commit (dc=all): 'Depooling db1172 (T309311)'
P30713 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)'
P30710 dbctl commit (dc=all): 'Depooling db1135 (T309311)'
P30709 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)'
P30708 dbctl commit (dc=all): 'Depooling db1179 (T309311)'
P30696 dbctl commit (dc=all): 'Repooling after maintenance db1169 (T309311)'
P30693 dbctl commit (dc=all): 'Repooling after maintenance db1169 (T309311)'
P30692 dbctl commit (dc=all): 'Depooling db1169 (T309311)'
P30691 dbctl commit (dc=all): 'Repooling after maintenance db1132 (T309311)'
P30688 dbctl commit (dc=all): 'Repooling after maintenance db1132 (T309311)'
P30683 dbctl commit (dc=all): 'Depooling db1132 (T309311)'
P30682 dbctl commit (dc=all): 'Repooling after maintenance db1184 (T309311)'
P30678 dbctl commit (dc=all): 'Repooling after maintenance db1184 (T309311)'
P30676 dbctl commit (dc=all): 'Depooling db1184 (T309311)'
P30673 dbctl commit (dc=all): 'Repooling after maintenance db1128 (T309311)'
P30666 dbctl commit (dc=all): 'Repooling after maintenance db1128 (T309311)'
P30661 dbctl commit (dc=all): 'Depooling db1128 (T309311)'
P30621 dbctl commit (dc=all): 'Repooling after maintenance db1149 (T309311)'
P30617 dbctl commit (dc=all): 'Repooling after maintenance db1149 (T309311)'
P30615 dbctl commit (dc=all): 'Depooling db1149 (T309311)'
P30613 dbctl commit (dc=all): 'Repooling after maintenance db1143 (T309311)'
P30607 dbctl commit (dc=all): 'Repooling after maintenance db1143 (T309311)'
P30606 dbctl commit (dc=all): 'Depooling db1143 (T309311)'
P30569 dbctl commit (dc=all): 'Repooling after maintenance db1141 (T309311)'
P30557 dbctl commit (dc=all): 'Repooling after maintenance db1141 (T309311)'
P30555 dbctl commit (dc=all): 'Depooling db1141 (T309311)'
P30554 dbctl commit (dc=all): 'Repooling after maintenance db1138 (T309311)'
P30542 dbctl commit (dc=all): 'Repooling after maintenance db1138 (T309311)'
P30529 dbctl commit (dc=all): 'Depooling db1138 (T309311)'
P30528 dbctl commit (dc=all): 'Repooling after maintenance db1142 (T309311)'
P30515 dbctl commit (dc=all): 'Repooling after maintenance db1142 (T309311)'
P30512 dbctl commit (dc=all): 'Depooling db1142 (T309311)'
P30508 dbctl commit (dc=all): 'Repooling after maintenance db1121 (T309311)'
P30491 dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T309311)'
P30488 dbctl commit (dc=all): 'Repooling after maintenance db1144:3314 (T309311)'
P30487 dbctl commit (dc=all): 'Depooling db1144:3314 (T309311)'
P30486 dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T309311)'
P30483 dbctl commit (dc=all): 'Repooling after maintenance db1146:3314 (T309311)'
P30482 dbctl commit (dc=all): 'Depooling db1146:3314 (T309311)'
P30481 dbctl commit (dc=all): 'Repooling after maintenance db1147 (T309311)'
P30478 dbctl commit (dc=all): 'Repooling after maintenance db1147 (T309311)'
P30477 dbctl commit (dc=all): 'Depooling db1147 (T309311)'
P30476 dbctl commit (dc=all): 'Repooling after maintenance db1148 (T309311)'
P30473 dbctl commit (dc=all): 'Repooling after maintenance db1148 (T309311)'
P30472 dbctl commit (dc=all): 'Depooling db1148 (T309311)'
P29292 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T309311)'
P29286 dbctl commit (dc=all): 'Repooling after maintenance db1174 (T309311)'
P29284 dbctl commit (dc=all): 'Depooling db1174 (T309311)'
P29283 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T309311)'
P29276 dbctl commit (dc=all): 'Repooling after maintenance db1098:3317 (T309311)'
P29273 dbctl commit (dc=all): 'Depooling db1098:3317 (T309311)'
P29269 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T309311)'
P29264 dbctl commit (dc=all): 'Repooling after maintenance db1101:3317 (T309311)'
P29258 dbctl commit (dc=all): 'Depooling db1101:3317 (T309311)'
P29254 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T309311)'
P29248 dbctl commit (dc=all): 'Repooling after maintenance db1158 (T309311)'
P29246 dbctl commit (dc=all): 'Depooling db1158 (T309311)'
P29245 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T309311)'
P29240 dbctl commit (dc=all): 'Repooling after maintenance db1170:3317 (T309311)'
P29232 dbctl commit (dc=all): 'Depooling db1170:3317 (T309311)'
P29231 dbctl commit (dc=all): 'Repooling after maintenance db1136 (T309311)'
P29218 dbctl commit (dc=all): 'Repooling after maintenance db1136 (T309311)'
P29215 dbctl commit (dc=all): 'Depooling db1136 (T309311)'
P29208 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T309311)'
P29198 dbctl commit (dc=all): 'Repooling after maintenance db1127 (T309311)'
P29193 dbctl commit (dc=all): 'Depooling db1127 (T309311)'
P29075 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T309311)'
P29061 dbctl commit (dc=all): 'Repooling after maintenance db1109 (T309311)'
P29060 dbctl commit (dc=all): 'Depooling db1109 (T309311)'
P29059 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T309311)'
P29048 dbctl commit (dc=all): 'Repooling after maintenance db1101:3318 (T309311)'
P29046 dbctl commit (dc=all): 'Depooling db1101:3318 (T309311)'
P29043 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T309311)'
P29031 dbctl commit (dc=all): 'Repooling after maintenance db1099:3318 (T309311)'
P29029 dbctl commit (dc=all): 'Depooling db1099:3318 (T309311)'
P29028 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T309311)'
P29012 dbctl commit (dc=all): 'Repooling after maintenance db1114 (T309311)'
P29009 dbctl commit (dc=all): 'Depooling db1114 (T309311)'
P29008 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T309311)'
P28993 dbctl commit (dc=all): 'Repooling after maintenance db1126 (T309311)'
P28990 dbctl commit (dc=all): 'Depooling db1126 (T309311)'
P28989 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T309311)'
P28971 dbctl commit (dc=all): 'Repooling after maintenance db1178 (T309311)'
P28969 dbctl commit (dc=all): 'Depooling db1178 (T309311)'
P28968 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T309311)'
P28953 dbctl commit (dc=all): 'Repooling after maintenance db1167 (T309311)'
P28945 dbctl commit (dc=all): 'Depooling db1167 (T309311)'
P28944 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T309311)'
P28934 dbctl commit (dc=all): 'Repooling after maintenance db1177 (T309311)'
P28932 dbctl commit (dc=all): 'Depooling db1177 (T309311)'
P28931 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)'
P28922 dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)'
P28915 dbctl commit (dc=all): 'Depooling db1172 (T309311)'
P28874 dbctl commit (dc=all): 'Repooling after maintenance db1157 (T309311)'
P28868 dbctl commit (dc=all): 'Repooling after maintenance db1157 (T309311)'
P28867 dbctl commit (dc=all): 'Depooling db1157 (T309311)'
P28866 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T309311)'
P28857 dbctl commit (dc=all): 'Repooling after maintenance db1112 (T309311)'
P28851 dbctl commit (dc=all): 'Depooling db1112 (T309311)'
P28850 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)'
P28844 dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)'
P28841 dbctl commit (dc=all): 'Repooling after maintenance db1130 (T309311)'
P28831 dbctl commit (dc=all): 'Repooling after maintenance db1130 (T309311)'
P28830 dbctl commit (dc=all): 'Depooling db1179 (T309311)'
P28828 dbctl commit (dc=all): 'Depooling db1130 (T309311)'
P28827 dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T309311)'
P28816 dbctl commit (dc=all): 'Repooling after maintenance db1096:3315 (T309311)'
P28815 dbctl commit (dc=all): 'Depooling db1096:3315 (T309311)'
P28813 dbctl commit (dc=all): 'Repooling after maintenance db1161 (T309311)'
P28809 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T309311)'
P28804 dbctl commit (dc=all): 'Repooling after maintenance db1161 (T309311)'
P28802 dbctl commit (dc=all): 'Depooling db1161 (T309311)'
P28801 dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T309311)'
P28797 dbctl commit (dc=all): 'Repooling after maintenance db1175 (T309311)'
P28790 dbctl commit (dc=all): 'Depooling db1175 (T309311)'
P28789 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T309311)'
P28785 dbctl commit (dc=all): 'Repooling after maintenance db1144:3315 (T309311)'
P28781 dbctl commit (dc=all): 'Depooling db1144:3315 (T309311)'
P28780 dbctl commit (dc=all): 'Repooling after maintenance db1110 (T309311)'
P28771 dbctl commit (dc=all): 'Repooling after maintenance db1166 (T309311)'
P28767 dbctl commit (dc=all): 'Repooling after maintenance db1110 (T309311)'
P28766 dbctl commit (dc=all): 'Depooling db1166 (T309311)'
P28764 dbctl commit (dc=all): 'Depooling db1110 (T309311)'
P28763 dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T309311)'
P28759 dbctl commit (dc=all): 'Repooling after maintenance db1113:3315 (T309311)'
P28757 dbctl commit (dc=all): 'Depooling db1113:3315 (T309311)'
P28751 dbctl commit (dc=all): 'Repooling after maintenance db1156 (T309311)'
P28745 dbctl commit (dc=all): 'Repooling after maintenance db1156 (T309311)'
P28743 dbctl commit (dc=all): 'Depooling db1156 (T309311)'
P28742 dbctl commit (dc=all): 'Repooling after maintenance db1122 (T309311)'
P28738 dbctl commit (dc=all): 'Repooling after maintenance db1122 (T309311)'
P28737 dbctl commit (dc=all): 'Depooling db1122 (T309311)'
P28736 dbctl commit (dc=all): 'Repooling after maintenance db1129 (T309311)'
P28733 dbctl commit (dc=all): 'Repooling after maintenance db1129 (T309311)'
P28732 dbctl commit (dc=all): 'Depooling db1129 (T309311)'
P28731 dbctl commit (dc=all): 'Repooling after maintenance db1182 (T309311)'
P28727 dbctl commit (dc=all): 'Repooling after maintenance db1182 (T309311)'
P28726 dbctl commit (dc=all): 'Depooling db1182 (T309311)'
P28725 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T309311)'
P28724 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T309311)'
P28717 dbctl commit (dc=all): 'Repooling after maintenance db1105:3312 (T309311)'
P28715 dbctl commit (dc=all): 'Repooling after maintenance db1168 (T309311)'
P28714 dbctl commit (dc=all): 'Depooling db1168 (T309311)'
P28713 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T309311)'
P28711 dbctl commit (dc=all): 'Depooling db1105:3312 (T309311)'
P28710 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T309311)'
P28705 dbctl commit (dc=all): 'Repooling after maintenance db1180 (T309311)'
P28704 dbctl commit (dc=all): 'Depooling db1180 (T309311)'
P28703 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T309311)'
P28702 dbctl commit (dc=all): 'Repooling after maintenance db1146:3312 (T309311)'
P28699 dbctl commit (dc=all): 'Repooling after maintenance db1165 (T309311)'
P28697 dbctl commit (dc=all): 'Depooling db1165 (T309311)'
P28696 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T309311)'
P28695 dbctl commit (dc=all): 'Depooling db1146:3312 (T309311)'
P28694 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T309311)'
P28686 dbctl commit (dc=all): 'Repooling after maintenance db1096:3316 (T309311)'
P28683 dbctl commit (dc=all): 'Repooling after maintenance db1170:3312 (T309311)'
P28682 dbctl commit (dc=all): 'Depooling db1096:3316 (T309311)'
P28679 dbctl commit (dc=all): 'Depooling db1170:3312 (T309311)'
P28678 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T309311)'
P28670 dbctl commit (dc=all): 'Repooling after maintenance db1098:3316 (T309311)'
P28666 dbctl commit (dc=all): 'Depooling db1098:3316 (T309311)'
P28665 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T309311)'
P28656 dbctl commit (dc=all): 'Repooling after maintenance db1113:3316 (T309311)'
P28654 dbctl commit (dc=all): 'Depooling db1113:3316 (T309311)'
P28653 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T309311)'
P28647 dbctl commit (dc=all): 'Repooling after maintenance db1131 (T309311)'
T305340: Make user_editcount field unsigned
P28645 dbctl commit (dc=all): 'Depooling db1131 (T309311)'
T298557: Fix mismatching field type of page.page_touched on wmf wikis

Event Timeline

There are a very large number of changes, so older changes are hidden. Show Older Changes
Stashbot added a comment.Jun 30 2022, 2:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T14:34:40Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T309311)', diff saved to https://phabricator.wikimedia.org/P30666 and previous config saved to /var/cache/conftool/dbconfig/20220630-143436-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 3:19 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T15:19:51Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1128 (T309311)', diff saved to https://phabricator.wikimedia.org/P30673 and previous config saved to /var/cache/conftool/dbconfig/20220630-151951-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 4:08 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T16:08:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1184 (T309311)', diff saved to https://phabricator.wikimedia.org/P30676 and previous config saved to /var/cache/conftool/dbconfig/20220630-160831-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 5:00 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T17:00:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T309311)', diff saved to https://phabricator.wikimedia.org/P30678 and previous config saved to /var/cache/conftool/dbconfig/20220630-170016-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 5:45 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T17:45:33Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1184 (T309311)', diff saved to https://phabricator.wikimedia.org/P30682 and previous config saved to /var/cache/conftool/dbconfig/20220630-174532-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 5:46 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T17:46:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1132 (T309311)', diff saved to https://phabricator.wikimedia.org/P30683 and previous config saved to /var/cache/conftool/dbconfig/20220630-174603-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 6:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T18:47:08Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T309311)', diff saved to https://phabricator.wikimedia.org/P30688 and previous config saved to /var/cache/conftool/dbconfig/20220630-184708-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 7:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T19:32:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1132 (T309311)', diff saved to https://phabricator.wikimedia.org/P30691 and previous config saved to /var/cache/conftool/dbconfig/20220630-193223-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 7:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T19:32:55Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1169 (T309311)', diff saved to https://phabricator.wikimedia.org/P30692 and previous config saved to /var/cache/conftool/dbconfig/20220630-193254-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 8:40 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T20:40:43Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T309311)', diff saved to https://phabricator.wikimedia.org/P30693 and previous config saved to /var/cache/conftool/dbconfig/20220630-204043-ladsgroup.json

Stashbot added a comment.Jun 30 2022, 9:25 PM

Mentioned in SAL (#wikimedia-operations) [2022-06-30T21:25:58Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1169 (T309311)', diff saved to https://phabricator.wikimedia.org/P30696 and previous config saved to /var/cache/conftool/dbconfig/20220630-212558-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 9:49 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T09:49:27Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1179 (T309311)', diff saved to https://phabricator.wikimedia.org/P30708 and previous config saved to /var/cache/conftool/dbconfig/20220701-094927-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 10:16 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T10:16:03Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)', diff saved to https://phabricator.wikimedia.org/P30709 and previous config saved to /var/cache/conftool/dbconfig/20220701-101602-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 10:28 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T10:28:11Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1135 (T309311)', diff saved to https://phabricator.wikimedia.org/P30710 and previous config saved to /var/cache/conftool/dbconfig/20220701-102810-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:01 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T11:01:18Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1179 (T309311)', diff saved to https://phabricator.wikimedia.org/P30713 and previous config saved to /var/cache/conftool/dbconfig/20220701-110117-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:02 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T11:02:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1172 (T309311)', diff saved to https://phabricator.wikimedia.org/P30714 and previous config saved to /var/cache/conftool/dbconfig/20220701-110204-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:09 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T11:08:59Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)', diff saved to https://phabricator.wikimedia.org/P30715 and previous config saved to /var/cache/conftool/dbconfig/20220701-110859-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:21 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T11:21:22Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T309311)', diff saved to https://phabricator.wikimedia.org/P30716 and previous config saved to /var/cache/conftool/dbconfig/20220701-112121-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:54 AM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T11:54:14Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1172 (T309311)', diff saved to https://phabricator.wikimedia.org/P30721 and previous config saved to /var/cache/conftool/dbconfig/20220701-115414-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 12:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T12:06:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1135 (T309311)', diff saved to https://phabricator.wikimedia.org/P30722 and previous config saved to /var/cache/conftool/dbconfig/20220701-120636-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 12:06 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T12:06:57Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1134 (T309311)', diff saved to https://phabricator.wikimedia.org/P30723 and previous config saved to /var/cache/conftool/dbconfig/20220701-120657-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 1:13 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T13:13:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T309311)', diff saved to https://phabricator.wikimedia.org/P30725 and previous config saved to /var/cache/conftool/dbconfig/20220701-131316-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 1:58 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T13:58:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1134 (T309311)', diff saved to https://phabricator.wikimedia.org/P30728 and previous config saved to /var/cache/conftool/dbconfig/20220701-135831-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 2:59 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T14:59:37Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1106 (T309311)', diff saved to https://phabricator.wikimedia.org/P30729 and previous config saved to /var/cache/conftool/dbconfig/20220701-145937-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 4:08 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T16:08:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T309311)', diff saved to https://phabricator.wikimedia.org/P30730 and previous config saved to /var/cache/conftool/dbconfig/20220701-160831-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 4:53 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T16:53:47Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1106 (T309311)', diff saved to https://phabricator.wikimedia.org/P30733 and previous config saved to /var/cache/conftool/dbconfig/20220701-165347-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 4:54 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T16:54:07Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1105:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30734 and previous config saved to /var/cache/conftool/dbconfig/20220701-165407-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 5:49 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T17:49:30Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30735 and previous config saved to /var/cache/conftool/dbconfig/20220701-174929-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 6:34 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T18:34:45Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1105:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30738 and previous config saved to /var/cache/conftool/dbconfig/20220701-183444-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 6:35 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T18:35:05Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1099:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30739 and previous config saved to /var/cache/conftool/dbconfig/20220701-183504-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 7:47 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T19:47:17Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30740 and previous config saved to /var/cache/conftool/dbconfig/20220701-194716-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 8:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T20:32:32Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1099:3311 (T309311)', diff saved to https://phabricator.wikimedia.org/P30743 and previous config saved to /var/cache/conftool/dbconfig/20220701-203231-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 8:32 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T20:32:52Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1119 (T309311)', diff saved to https://phabricator.wikimedia.org/P30744 and previous config saved to /var/cache/conftool/dbconfig/20220701-203251-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 9:29 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T21:29:04Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T309311)', diff saved to https://phabricator.wikimedia.org/P30745 and previous config saved to /var/cache/conftool/dbconfig/20220701-212903-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 10:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T22:14:19Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1119 (T309311)', diff saved to https://phabricator.wikimedia.org/P30748 and previous config saved to /var/cache/conftool/dbconfig/20220701-221418-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 10:14 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T22:14:39Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depooling db1118 (T309311)', diff saved to https://phabricator.wikimedia.org/P30749 and previous config saved to /var/cache/conftool/dbconfig/20220701-221438-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:10 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T23:10:09Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T309311)', diff saved to https://phabricator.wikimedia.org/P30750 and previous config saved to /var/cache/conftool/dbconfig/20220701-231009-ladsgroup.json

Stashbot added a comment.Jul 1 2022, 11:55 PM

Mentioned in SAL (#wikimedia-operations) [2022-07-01T23:55:24Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Repooling after maintenance db1118 (T309311)', diff saved to https://phabricator.wikimedia.org/P30753 and previous config saved to /var/cache/conftool/dbconfig/20220701-235524-ladsgroup.json

Ladsgroup updated the task description. (Show Details)Jul 7 2022, 12:44 PM
Ladsgroup updated the task description. (Show Details)
Ladsgroup updated the task description. (Show Details)Jul 12 2022, 12:25 PM
Stashbot mentioned this in T298555: Fix mismatching field type of logging.log_timestamp on wmf wikis.Aug 11 2022, 6:06 AM
Stashbot mentioned this in T60674: Drop page.page_restrictions column from Wikimedia wikis.
Stashbot mentioned this in T303603: Add actor and comment columns to cu_changes.
Stashbot mentioned this in T314368: Switchover s2 master (db1162 -> db1122).
Stashbot mentioned this in T298560: Fix mismatching field type of revision.rev_timestamp on wmf wikis.

Mentioned in SAL (#wikimedia-operations) [2022-08-11T06:06:26Z] <ladsgroup@cumin1001> dbctl commit (dc=all): 'Depool db1162 (T314368 T298555 T312863 T310011 T309311 T60674 T298560 T303603 T310485)', diff saved to https://phabricator.wikimedia.org/P32352 and previous config saved to /var/cache/conftool/dbconfig/20220811-060625-ladsgroup.json

Stashbot mentioned this in T310011: Adjust the field type of cu_changes.cuc_timestamp to fixed binary and remove default on wmf wikis.Aug 11 2022, 6:06 AM
Stashbot mentioned this in T312863: Schema change to change primary key of templatelinks.
Ladsgroup updated the task description. (Show Details)Aug 11 2022, 10:01 AM
Stashbot mentioned this in T312984: Adjust the field type of flaggedpages.fp_pending_since to fixed binary on wmf wikis.Aug 16 2022, 6:23 AM
Stashbot mentioned this in T301312: Switchover s1 master (db1118 -> db1163).

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:23:50Z] <ladsgroup@cumin1001> START - Cookbook sre.hosts.downtime for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Stashbot added a comment.Aug 16 2022, 6:24 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-16T06:24:04Z] <ladsgroup@cumin1001> END (PASS) - Cookbook sre.hosts.downtime (exit_code=0) for 1 day, 0:00:00 on db1163.eqiad.wmnet with reason: Maint work on old s1 master (T312984 T312863 T310011 T309311 T60674 T298560 T298555 T310485 T301312)

Ladsgroup updated the task description. (Show Details)Aug 16 2022, 8:13 AM
Stashbot added a comment.Aug 18 2022, 6:11 AM

Mentioned in SAL (#wikimedia-operations) [2022-08-18T06:11:37Z] <Amir1> dbmaint@s8 eqiad (T314369 T312863 T309311 T60674 T303603 T310485)

Stashbot mentioned this in T314369: Switchover s8 master (db1104 -> db1109).Aug 18 2022, 6:11 AM
Ladsgroup closed this task as Resolved.Aug 18 2022, 7:27 AM
Ladsgroup updated the task description. (Show Details)
Maintenance_bot moved this task from In progress to Done on the DBA board.Aug 18 2022, 7:29 AM
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