⚓ T190780 Schema changes to site

EddieGP created this task.Mar 27 2018, 7:44 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 27 2018, 7:44 AM

@jcrespo You asked to create a deployment task on merge, please tell me if you need any more info from me! :-)

EddieGP mentioned this in T56888: Fresh MW lists "-1 recent contributors" / Overhaul site_stats table.Mar 27 2018, 8:08 AM

Peachey88 added a project: Schema-change.Mar 27 2018, 9:06 AM

@EddieGP Please follow the following advice and tags: https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change

EddieGP updated the task description. (Show Details)Mar 27 2018, 9:17 PM

If the schema change has been tested already on some of the test/beta wikis: No

In the next db update after the merge on beta it says 00:23:48 Modifying table site_stats ...done. Another run later there's 01:22:54 ...table site_stats already modified by patch patch-site_stats-modify.sql.

So I guess it has been applied to the beta cluster, but I'm lacking access to actually connect to betas dbs and verify that.

@EddieGP Contact someone with access so it can be verified, and also check things are working smoothly there (checking it is working as intended should be trivial). When that is done, I will add the tags Blocked-on-schema-change and schedule its deploy to production.

Most developers and deployers should have access, and you should ask for access too (but that should be handled separately from this deployment).

I can now verify it was applied to beta. Creating pages and editing them still increases the counters on Special:Statistics like it should. There's not much else I can think of that could be tested in beta.

P6939 site_stats on beta

1	----- aawiki -----
2	Field Type Null Key Default Extra
3	ss_row_id int(10) unsigned NO PRI NULL
4	ss_total_edits bigint(20) unsigned YES NULL
5	ss_good_articles bigint(20) unsigned YES NULL
6	ss_total_pages bigint(20) unsigned YES NULL
7	ss_users bigint(20) unsigned YES NULL
8	ss_active_users bigint(20) unsigned YES NULL
9	ss_images bigint(20) unsigned YES NULL
10
11	----- arwiki -----
12	Field Type Null Key Default Extra
13	ss_row_id int(10) unsigned NO PRI NULL
14	ss_total_edits bigint(20) unsigned YES NULL
15	ss_good_articles bigint(20) unsigned YES NULL
16	ss_total_pages bigint(20) unsigned YES NULL
17	ss_users bigint(20) unsigned YES NULL
18	ss_active_users bigint(20) unsigned YES NULL
19	ss_images bigint(20) unsigned YES NULL
20
21	----- cawiki -----
22	Field Type Null Key Default Extra
23	ss_row_id int(10) unsigned NO PRI NULL
24	ss_total_edits bigint(20) unsigned YES NULL
25	ss_good_articles bigint(20) unsigned YES NULL
26	ss_total_pages bigint(20) unsigned YES NULL
27	ss_users bigint(20) unsigned YES NULL
28	ss_active_users bigint(20) unsigned YES NULL
29	ss_images bigint(20) unsigned YES NULL
30
31	----- commonswiki -----
32	Field Type Null Key Default Extra
33	ss_row_id int(10) unsigned NO PRI NULL
34	ss_total_edits bigint(20) unsigned YES NULL
35	ss_good_articles bigint(20) unsigned YES NULL
36	ss_total_pages bigint(20) unsigned YES NULL
37	ss_users bigint(20) unsigned YES NULL
38	ss_active_users bigint(20) unsigned YES NULL
39	ss_images bigint(20) unsigned YES NULL
40
41	----- deploymentwiki -----
42	Field Type Null Key Default Extra
43	ss_row_id int(10) unsigned NO PRI NULL
44	ss_total_edits bigint(20) unsigned YES NULL
45	ss_good_articles bigint(20) unsigned YES NULL
46	ss_total_pages bigint(20) unsigned YES NULL
47	ss_users bigint(20) unsigned YES NULL
48	ss_active_users bigint(20) unsigned YES NULL
49	ss_images bigint(20) unsigned YES NULL
50
51	----- dewiki -----
52	Field Type Null Key Default Extra
53	ss_row_id int(10) unsigned NO PRI NULL
54	ss_total_edits bigint(20) unsigned YES NULL
55	ss_good_articles bigint(20) unsigned YES NULL
56	ss_total_pages bigint(20) unsigned YES NULL
57	ss_users bigint(20) unsigned YES NULL
58	ss_active_users bigint(20) unsigned YES NULL
59	ss_images bigint(20) unsigned YES NULL
60
61	----- dewiktionary -----
62	Field Type Null Key Default Extra
63	ss_row_id int(10) unsigned NO PRI NULL
64	ss_total_edits bigint(20) unsigned YES NULL
65	ss_good_articles bigint(20) unsigned YES NULL
66	ss_total_pages bigint(20) unsigned YES NULL
67	ss_users bigint(20) unsigned YES NULL
68	ss_active_users bigint(20) unsigned YES NULL
69	ss_images bigint(20) unsigned YES NULL
70
71	----- en_rtlwiki -----
72	Field Type Null Key Default Extra
73	ss_row_id int(10) unsigned NO PRI NULL
74	ss_total_edits bigint(20) unsigned YES NULL
75	ss_good_articles bigint(20) unsigned YES NULL
76	ss_total_pages bigint(20) unsigned YES NULL
77	ss_users bigint(20) unsigned YES NULL
78	ss_active_users bigint(20) unsigned YES NULL
79	ss_images bigint(20) unsigned YES NULL
80
81	----- enwiki -----
82	Field Type Null Key Default Extra
83	ss_row_id int(10) unsigned NO PRI NULL
84	ss_total_edits bigint(20) unsigned YES NULL
85	ss_good_articles bigint(20) unsigned YES NULL
86	ss_total_pages bigint(20) unsigned YES NULL
87	ss_users bigint(20) unsigned YES NULL
88	ss_active_users bigint(20) unsigned YES NULL
89	ss_images bigint(20) unsigned YES NULL
90
91	----- enwikibooks -----
92	Field Type Null Key Default Extra
93	ss_row_id int(10) unsigned NO PRI NULL
94	ss_total_edits bigint(20) unsigned YES NULL
95	ss_good_articles bigint(20) unsigned YES NULL
96	ss_total_pages bigint(20) unsigned YES NULL
97	ss_users bigint(20) unsigned YES NULL
98	ss_active_users bigint(20) unsigned YES NULL
99	ss_images bigint(20) unsigned YES NULL
100
101	----- enwikinews -----
102	Field Type Null Key Default Extra
103	ss_row_id int(10) unsigned NO PRI NULL
104	ss_total_edits bigint(20) unsigned YES NULL
105	ss_good_articles bigint(20) unsigned YES NULL
106	ss_total_pages bigint(20) unsigned YES NULL
107	ss_users bigint(20) unsigned YES NULL
108	ss_active_users bigint(20) unsigned YES NULL
109	ss_images bigint(20) unsigned YES NULL
110
111	----- enwikiquote -----
112	Field Type Null Key Default Extra
113	ss_row_id int(10) unsigned NO PRI NULL
114	ss_total_edits bigint(20) unsigned YES NULL
115	ss_good_articles bigint(20) unsigned YES NULL
116	ss_total_pages bigint(20) unsigned YES NULL
117	ss_users bigint(20) unsigned YES NULL
118	ss_active_users bigint(20) unsigned YES NULL
119	ss_images bigint(20) unsigned YES NULL
120
121	----- enwikisource -----
122	Field Type Null Key Default Extra
123	ss_row_id int(10) unsigned NO PRI NULL
124	ss_total_edits bigint(20) unsigned YES NULL
125	ss_good_articles bigint(20) unsigned YES NULL
126	ss_total_pages bigint(20) unsigned YES NULL
127	ss_users bigint(20) unsigned YES NULL
128	ss_active_users bigint(20) unsigned YES NULL
129	ss_images bigint(20) unsigned YES NULL
130
131	----- enwikiversity -----
132	Field Type Null Key Default Extra
133	ss_row_id int(10) unsigned NO PRI NULL
134	ss_total_edits bigint(20) unsigned YES NULL
135	ss_good_articles bigint(20) unsigned YES NULL
136	ss_total_pages bigint(20) unsigned YES NULL
137	ss_users bigint(20) unsigned YES NULL
138	ss_active_users bigint(20) unsigned YES NULL
139	ss_images bigint(20) unsigned YES NULL
140
141	----- enwikivoyage -----
142	Field Type Null Key Default Extra
143	ss_row_id int(10) unsigned NO PRI NULL
144	ss_total_edits bigint(20) unsigned YES NULL
145	ss_good_articles bigint(20) unsigned YES NULL
146	ss_total_pages bigint(20) unsigned YES NULL
147	ss_users bigint(20) unsigned YES NULL
148	ss_active_users bigint(20) unsigned YES NULL
149	ss_images bigint(20) unsigned YES NULL
150
151	----- enwiktionary -----
152	Field Type Null Key Default Extra
153	ss_row_id int(10) unsigned NO PRI NULL
154	ss_total_edits bigint(20) unsigned YES NULL
155	ss_good_articles bigint(20) unsigned YES NULL
156	ss_total_pages bigint(20) unsigned YES NULL
157	ss_users bigint(20) unsigned YES NULL
158	ss_active_users bigint(20) unsigned YES NULL
159	ss_images bigint(20) unsigned YES NULL
160
161	----- eowiki -----
162	Field Type Null Key Default Extra
163	ss_row_id int(10) unsigned NO PRI NULL
164	ss_total_edits bigint(20) unsigned YES NULL
165	ss_good_articles bigint(20) unsigned YES NULL
166	ss_total_pages bigint(20) unsigned YES NULL
167	ss_users bigint(20) unsigned YES NULL
168	ss_active_users bigint(20) unsigned YES NULL
169	ss_images bigint(20) unsigned YES NULL
170
171	----- eswiki -----
172	Field Type Null Key Default Extra
173	ss_row_id int(10) unsigned NO PRI NULL
174	ss_total_edits bigint(20) unsigned YES NULL
175	ss_good_articles bigint(20) unsigned YES NULL
176	ss_total_pages bigint(20) unsigned YES NULL
177	ss_users bigint(20) unsigned YES NULL
178	ss_active_users bigint(20) unsigned YES NULL
179	ss_images bigint(20) unsigned YES NULL
180
181	----- eswikibooks -----
182	Field Type Null Key Default Extra
183	ss_row_id int(10) unsigned NO PRI NULL
184	ss_total_edits bigint(20) unsigned YES NULL
185	ss_good_articles bigint(20) unsigned YES NULL
186	ss_total_pages bigint(20) unsigned YES NULL
187	ss_users bigint(20) unsigned YES NULL
188	ss_active_users bigint(20) unsigned YES NULL
189	ss_images bigint(20) unsigned YES NULL
190
191	----- fawiki -----
192	Field Type Null Key Default Extra
193	ss_row_id int(10) unsigned NO PRI NULL
194	ss_total_edits bigint(20) unsigned YES NULL
195	ss_good_articles bigint(20) unsigned YES NULL
196	ss_total_pages bigint(20) unsigned YES NULL
197	ss_users bigint(20) unsigned YES NULL
198	ss_active_users bigint(20) unsigned YES NULL
199	ss_images bigint(20) unsigned YES NULL
200
201	----- hewiki -----
202	Field Type Null Key Default Extra
203	ss_row_id int(10) unsigned NO PRI NULL
204	ss_total_edits bigint(20) unsigned YES NULL
205	ss_good_articles bigint(20) unsigned YES NULL
206	ss_total_pages bigint(20) unsigned YES NULL
207	ss_users bigint(20) unsigned YES NULL
208	ss_active_users bigint(20) unsigned YES NULL
209	ss_images bigint(20) unsigned YES NULL
210
211	----- hewiktionary -----
212	Field Type Null Key Default Extra
213	ss_row_id int(10) unsigned NO PRI NULL
214	ss_total_edits bigint(20) unsigned YES NULL
215	ss_good_articles bigint(20) unsigned YES NULL
216	ss_total_pages bigint(20) unsigned YES NULL
217	ss_users bigint(20) unsigned YES NULL
218	ss_active_users bigint(20) unsigned YES NULL
219	ss_images bigint(20) unsigned YES NULL
220
221	----- hiwiki -----
222	Field Type Null Key Default Extra
223	ss_row_id int(10) unsigned NO PRI NULL
224	ss_total_edits bigint(20) unsigned YES NULL
225	ss_good_articles bigint(20) unsigned YES NULL
226	ss_total_pages bigint(20) unsigned YES NULL
227	ss_users bigint(20) unsigned YES NULL
228	ss_active_users bigint(20) unsigned YES NULL
229	ss_images bigint(20) unsigned YES NULL
230
231	----- jawiki -----
232	Field Type Null Key Default Extra
233	ss_row_id int(10) unsigned NO PRI NULL
234	ss_total_edits bigint(20) unsigned YES NULL
235	ss_good_articles bigint(20) unsigned YES NULL
236	ss_total_pages bigint(20) unsigned YES NULL
237	ss_users bigint(20) unsigned YES NULL
238	ss_active_users bigint(20) unsigned YES NULL
239	ss_images bigint(20) unsigned YES NULL
240
241	----- kowiki -----
242	Field Type Null Key Default Extra
243	ss_row_id int(10) unsigned NO PRI NULL
244	ss_total_edits bigint(20) unsigned YES NULL
245	ss_good_articles bigint(20) unsigned YES NULL
246	ss_total_pages bigint(20) unsigned YES NULL
247	ss_users bigint(20) unsigned YES NULL
248	ss_active_users bigint(20) unsigned YES NULL
249	ss_images bigint(20) unsigned YES NULL
250
251	----- loginwiki -----
252	Field Type Null Key Default Extra
253	ss_row_id int(10) unsigned NO PRI NULL
254	ss_total_edits bigint(20) unsigned YES NULL
255	ss_good_articles bigint(20) unsigned YES NULL
256	ss_total_pages bigint(20) unsigned YES NULL
257	ss_users bigint(20) unsigned YES NULL
258	ss_active_users bigint(20) unsigned YES NULL
259	ss_images bigint(20) unsigned YES NULL
260
261	----- metawiki -----
262	Field Type Null Key Default Extra
263	ss_row_id int(10) unsigned NO PRI NULL
264	ss_total_edits bigint(20) unsigned YES NULL
265	ss_good_articles bigint(20) unsigned YES NULL
266	ss_total_pages bigint(20) unsigned YES NULL
267	ss_users bigint(20) unsigned YES NULL
268	ss_active_users bigint(20) unsigned YES NULL
269	ss_images bigint(20) unsigned YES NULL
270
271	----- nlwiki -----
272	Field Type Null Key Default Extra
273	ss_row_id int(10) unsigned NO PRI NULL
274	ss_total_edits bigint(20) unsigned YES NULL
275	ss_good_articles bigint(20) unsigned YES NULL
276	ss_total_pages bigint(20) unsigned YES NULL
277	ss_users bigint(20) unsigned YES NULL
278	ss_active_users bigint(20) unsigned YES NULL
279	ss_images bigint(20) unsigned YES NULL
280
281	----- ruwiki -----
282	Field Type Null Key Default Extra
283	ss_row_id int(10) unsigned NO PRI NULL
284	ss_total_edits bigint(20) unsigned YES NULL
285	ss_good_articles bigint(20) unsigned YES NULL
286	ss_total_pages bigint(20) unsigned YES NULL
287	ss_users bigint(20) unsigned YES NULL
288	ss_active_users bigint(20) unsigned YES NULL
289	ss_images bigint(20) unsigned YES NULL
290
291	----- simplewiki -----
292	Field Type Null Key Default Extra
293	ss_row_id int(10) unsigned NO PRI NULL
294	ss_total_edits bigint(20) unsigned YES NULL
295	ss_good_articles bigint(20) unsigned YES NULL
296	ss_total_pages bigint(20) unsigned YES NULL
297	ss_users bigint(20) unsigned YES NULL
298	ss_active_users bigint(20) unsigned YES NULL
299	ss_images bigint(20) unsigned YES NULL
300
301	----- sqwiki -----
302	Field Type Null Key Default Extra
303	ss_row_id int(10) unsigned NO PRI NULL
304	ss_total_edits bigint(20) unsigned YES NULL
305	ss_good_articles bigint(20) unsigned YES NULL
306	ss_total_pages bigint(20) unsigned YES NULL
307	ss_users bigint(20) unsigned YES NULL
308	ss_active_users bigint(20) unsigned YES NULL
309	ss_images bigint(20) unsigned YES NULL
310
311	----- svwiki -----
312	Field Type Null Key Default Extra
313	ss_row_id int(10) unsigned NO PRI NULL
314	ss_total_edits bigint(20) unsigned YES NULL
315	ss_good_articles bigint(20) unsigned YES NULL
316	ss_total_pages bigint(20) unsigned YES NULL
317	ss_users bigint(20) unsigned YES NULL
318	ss_active_users bigint(20) unsigned YES NULL
319	ss_images bigint(20) unsigned YES NULL
320
321	----- testwiki -----
322	Field Type Null Key Default Extra
323	ss_row_id int(10) unsigned NO PRI NULL
324	ss_total_edits bigint(20) unsigned YES NULL
325	ss_good_articles bigint(20) unsigned YES NULL
326	ss_total_pages bigint(20) unsigned YES NULL
327	ss_users bigint(20) unsigned YES NULL
328	ss_active_users bigint(20) unsigned YES NULL
329	ss_images bigint(20) unsigned YES NULL
330
331	----- ukwiki -----
332	Field Type Null Key Default Extra
333	ss_row_id int(10) unsigned NO PRI NULL
334	ss_total_edits bigint(20) unsigned YES NULL
335	ss_good_articles bigint(20) unsigned YES NULL
336	ss_total_pages bigint(20) unsigned YES NULL
337	ss_users bigint(20) unsigned YES NULL
338	ss_active_users bigint(20) unsigned YES NULL
339	ss_images bigint(20) unsigned YES NULL
340
341	----- wikidatawiki -----
342	Field Type Null Key Default Extra
343	ss_row_id int(10) unsigned NO PRI NULL
344	ss_total_edits bigint(20) unsigned YES NULL
345	ss_good_articles bigint(20) unsigned YES NULL
346	ss_total_pages bigint(20) unsigned YES NULL
347	ss_users bigint(20) unsigned YES NULL
348	ss_active_users bigint(20) unsigned YES NULL
349	ss_images bigint(20) unsigned YES NULL
350
351	----- zerowiki -----
352	Field Type Null Key Default Extra
353	ss_row_id int(10) unsigned NO PRI NULL
354	ss_total_edits bigint(20) unsigned YES NULL
355	ss_good_articles bigint(20) unsigned YES NULL
356	ss_total_pages bigint(20) unsigned YES NULL
357	ss_users bigint(20) unsigned YES NULL
358	ss_active_users bigint(20) unsigned YES NULL
359	ss_images bigint(20) unsigned YES NULL
360
361	----- zhwiki -----
362	Field Type Null Key Default Extra
363	ss_row_id int(10) unsigned NO PRI NULL
364	ss_total_edits bigint(20) unsigned YES NULL
365	ss_good_articles bigint(20) unsigned YES NULL
366	ss_total_pages bigint(20) unsigned YES NULL
367	ss_users bigint(20) unsigned YES NULL
368	ss_active_users bigint(20) unsigned YES NULL
369	ss_images bigint(20) unsigned YES NULL

In T190780#4087083, @jcrespo wrote:

When that is done, I will add the tags Blocked-on-schema-change and schedule its deploy to production.

This change is just a cleanup, it does not block any code or further development. I didn't add that tag, because of the description of Blocked-on-schema-change:

If there is a schema change but it is a "cleanup" (e.g. a column that is stopped being used but it is not blocking code), just use the DBA tag to avoid prioritizing those over actual blockers.

"it does not block any code or further development"

It is ok, we can still say it is blocked and give it a lower priority, this is just a list of pending stuff for us to attend. It is however important because there is a difference between code HEAD and production deployment, and that should be minimized.

Just for the record, this table has less than 5 rows in all the wikis.

Yes, we could do this on the masters even with a table reconstruction- but we should check if a table reconstruction is needed only for a definition change.

In T190780#4119348, @Marostegui wrote:

Just for the record, this table has less than 5 rows in all the wikis.

For each and every wiki, this table is expected to contain exactly one row (the one with ss_row_id = 1). If you happen to notice any tables having more or less than one row, please file a task/tasks for them. Thanks.

In T190780#4119392, @jcrespo wrote:

Yes, we could do this on the masters even with a table reconstruction- but we should check if a table reconstruction is needed only for a definition change.

Looks like it does need a full table rebuild

MariaDB [test]> ALTER TABLE  site_stats ALTER ss_total_edits SET DEFAULT NULL, ALTER ss_good_articles SET DEFAULT NULL, MODIFY COLUMN ss_total_pages bigint unsigned DEFAULT NULL, MODIFY COLUMN ss_users bigint unsigned DEFAULT NULL, MODIFY COLUMN ss_active_users bigint unsigned DEFAULT NULL, MODIFY COLUMN ss_images bigint unsigned DEFAULT NULL, ALGORITHM=INPLACE;
ERROR 1846 (0A000): ALGORITHM=INPLACE is not supported. Reason: Cannot change column type INPLACE. Try ALGORITHM=COPY.

It should not be a big deal as the table is just tiny.

The only concern about doing it directly on the master could be the fact that this table is being updated almost every second.

In T190780#4122733, @Marostegui wrote:

The only concern about doing it directly on the master could be the fact that this table is being updated almost every second.

If your worry is about losing some of those updates, you can run foreachwiki initSiteStats.php --update on terbium to have this table repopulated for all wikis after the schema change. If these statistics are off a bit while the schema change happens that's fine. It's not like they're 100% accurate anyways. In fact we saw them being inaccurate due do different bugs so often and the maintenance script works well enough performance-wise that we're going to run that exact command in a cron in the near future (https://gerrit.wikimedia.org/r/c/415066) .

@EddieGP No queries will be lost, but if they pileup blocking the wiki's activity, it will be a worse issue (actual outage or edit outage).

Alright, ignore me then. :-)

Mentioned in SAL (#wikimedia-operations) [2018-04-12T05:34:22Z] <marostegui> Deploy schema change on s5 primary master (db1070) - T190780

I have tried this on dewiki directly on the master with no issues.
I also used: SET SESSION innodb_lock_wait_timeout=1; SET SESSION lock_wait_timeout=15;

Will do the same with s6, as that one is also a not very loaded set of wikis.

Marostegui updated the task description. (Show Details)Apr 12 2018, 5:37 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T05:39:09Z] <marostegui> Deploy schema change on s6 primary master (db1061) - T190780

Marostegui updated the task description. (Show Details)Apr 12 2018, 5:39 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T05:45:45Z] <marostegui> Deploy schema change on s4 primary master (db1068) - T190780

I also did it on commons, which has a lot more load than s5 or s6, and there were no issues there as well.

Marostegui updated the task description. (Show Details)Apr 12 2018, 5:46 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T05:49:31Z] <marostegui> Deploy schema change on s8 primary master (db1071) - T190780

Marostegui updated the task description. (Show Details)Apr 12 2018, 5:49 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T05:52:26Z] <marostegui> Deploy schema change on s2 primary master (db1054) - T190780

Marostegui updated the task description. (Show Details)Apr 12 2018, 6:09 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:11:35Z] <marostegui> Deploy schema change on s7 primary master (db1062) - T190780

Marostegui updated the task description. (Show Details)Apr 12 2018, 6:22 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:24:16Z] <marostegui> Deploy schema change on s1 primary master (db1052) - T190780

enwiki has been altered directly on the master without any issues.

For s3, I will alter codfw on the master and eqiad I will do slave by slave (there are just 3 of them + dbstore1002), because there will be contention issues there as we have seen those before

Marostegui updated the task description. (Show Details)Apr 12 2018, 6:25 AM

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:27:46Z] <marostegui> Deploy schema change on s3 codfw master (db2043) - this will generate lag on s3 codfw -T190780

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

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

gerritbot added a project: Patch-For-Review.Apr 12 2018, 6:31 AM

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

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

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:36:17Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1072 for alter table - T190780 (duration: 01m 18s)

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:42:12Z] <marostegui> Deploy schema change on db1072 (sanitarium master for s3) - this will generate lag on s3 labsdb - T190780

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:48:07Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Repool db1072 after alter table - T190780 (duration: 01m 16s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:53:08Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1077 for alter table - T190780 (duration: 01m 17s)

Mentioned in SAL (#wikimedia-operations) [2018-04-12T06:57:30Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Repool db1077 after alter table - T190780 (duration: 01m 17s)

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

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

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

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

Mentioned in SAL (#wikimedia-operations) [2018-04-12T07:11:56Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Depool db1078 for alter table - T190780 (duration: 01m 17s)

Mentioned in SAL (#wikimedia-operations) [2018-04-12T07:17:56Z] <marostegui@tin> Synchronized wmf-config/db-eqiad.php: Repool db1078 after alter table - T190780 (duration: 01m 16s)

This is all done!
One less drift between HEAD and production!
Thanks! :)

Marostegui updated the task description. (Show Details)Apr 12 2018, 7:26 AM

No issue or locking or strangeness of any kind on any server?

jcrespo awarded a token.Apr 12 2018, 7:35 AM

None of those :)

Marostegui mentioned this in T200140: Ensure labswiki and labtestwiki are up to date with MW schema changes.Jul 22 2018, 6:19 AM

Schema changes to site_stats
Closed, ResolvedPublic
Actions

Description

Details

Related Objects

Event Timeline

operations/mediawiki-config : master	db-eqiad.php: Depool db1078
operations/mediawiki-config : master	db-eqiad.php: Depool db1077
operations/mediawiki-config : master	db-eqiad.php: Depool db1072

Schema changes to site_statsClosed, ResolvedPublicActions

Description

Details

Related Objects

Event Timeline

Schema changes to site_stats
Closed, ResolvedPublic
Actions