DBA Update
The change is prepared at https://docs.google.com/document/d/1mw4CQxYyNP2PruzlG30dPVQjVOqJTC3Q_DLViIhWrm0/edit?usp=sharing
The alter to run is:
ALTER TABLE user DROP COLUMN IF EXISTS user_options;
Where to run the alter: s1, s2, s3, s4, s5, s6, s7, s8
When to run: start at 2018-11-14
If the schema change is backwards compatible: compatible with the current code deployed
If the schema change has been tested already on some of the test/beta wikis.: wikis created since 2011-09-28 doesn't have this column
If it is involves new columns to tables: no, it's a drop
Phases
Testing
- db2046
- db1088
Execution
- s1
- s2
- s3
- s4
- s5
- s6
- s7
- s8
s6
- db2039 codfw master, execute with replication!
- db1088
- db1093
- db1113
- db1098
- db1096
- dbstore1002
- dbstore1001
- db1085 Sanitarium master, execute with replication!
- db1061 MASTER
s2
- db2035 codfw master, execute with replication!
- db1076
- db1090
- db1095
- db1103
- db1105
- db1122
- dbstore1002
- db1074 Sanitarium master , execute with replication!
- db1066 MASTER
s5
- db2052 codfw master, execute with replication!
- db1096
- db1097
- db1100
- db1102
- db1110
- db1113
- dbstore1002
- db1082 Sanitarium master , execute with replication!
- db1070 MASTER
s4
- db2051 codfw master, execute with replication!
- db1081
- db1084
- db1091
- db1097
- db1102
- db1103
- dbstore1002
- db1121 Sanitarium master , execute with replication!
- db1068 MASTER
s7
- db2040 codfw master, execute with replication!
- db1086
- db1090
- db1094
- db1098
- db1101
- db1116
- dbstore1002
- db1079 Sanitarium master , execute with replication!
- db1062 MASTER
s8
- db2045 codfw master, execute with replication!
- db1092
- db1099
- db1101
- db1104
- db1109
- db1116
- db1087 Sanitarium master , execute with replication!
- db1071 MASTER
s1
- db2048 codfw master, execute with replication!
- db1080
- db1083
- db1089
- db1099
- db1105
- db1114
- db1119
- dbstore1002
- dbstore1001
- db1106 Sanitarium master , execute with replication!
- db1067 MASTER
s3
- db2043 codfw master, execute with replication!
- db1075
- db1095
- db1123
- dbstore1002
- db1077 Sanitarium master , execute with replication!
- db1078 MASTER
In CODFW (Secondary datacenter) the alter table command we need to use is:
./wmfmariadbpy/wmfmariadbpy/osc_host.py --method=ddl --host <section_codfw_master>.codfw.wmnet --dblist mediawiki-config/dblists/<section>.dblist --table user "DROP COLUMN IF EXISTS user_options"
On EQIAD (primary datacenter) the alter command will be (on all hots one by one, depooled except sanitarium master where we need replication):
./wmfmariadbpy/wmfmariadbpy/osc_host.py --no-repicate --method=ddl --host <hostname>.codfw.wmnet --dblist mediawiki-config/dblists/<section>.dblist --table user "DROP COLUMN IF EXISTS user_options"
On Sanitarium hosts we need to recreate the TRIGGERS as:
/home/banyek/T85757/fix_triggers.sh db2094:3315 s5
Original text
The column user.user_options is visible on ToolLabs (at least on dewiki_p). I assume that the field also exists on wmf wikis.
It was dropped with http://git.wikimedia.org/commit/mediawiki%2Fcore.git/eda06e8593c12b4359a46cf3b428c1a1a88e40c4 and should be dropped in production as well.
If it already dropped from production wikis, please move this task to ToolLabs to get the field also dropped there. Thanks.