[04:45:59] 10DBA: job_cmd is varbinary(255) in production while being varbinary(60) in code since 2007 - https://phabricator.wikimedia.org/T278621 (10Marostegui) [06:23:11] 10DBA: job_cmd is varbinary(255) in production while being varbinary(60) in code since 2007 - https://phabricator.wikimedia.org/T278621 (10Marostegui) [06:24:13] 10DBA: DB maintenance work to do while eqiad is passive (June 2021) - https://phabricator.wikimedia.org/T285139 (10Marostegui) [06:24:15] 10DBA: job_cmd is varbinary(255) in production while being varbinary(60) in code since 2007 - https://phabricator.wikimedia.org/T278621 (10Marostegui) 05Open→03Resolved All done [06:24:18] 10DBA, 10Datasets-General-or-Unknown, 10Patch-For-Review, 10Sustainability (Incident Followup), and 2 others: Detect object, schema and data drifts between mediawiki HEAD, production masters and replicas - https://phabricator.wikimedia.org/T104459 (10Marostegui) [06:43:00] 10Blocked-on-schema-change, 10DBA: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp - https://phabricator.wikimedia.org/T283499 (10Marostegui) [06:45:56] 10Blocked-on-schema-change, 10DBA: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp - https://phabricator.wikimedia.org/T283499 (10Marostegui) [09:23:18] 10Blocked-on-schema-change, 10DBA: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp - https://phabricator.wikimedia.org/T283499 (10Marostegui) [09:34:43] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Marostegui) Runtimes so far this week: ` Monday 5th: * pc1: 13h * pc2: 15h * pc3: 14h... [10:14:30] 10Blocked-on-schema-change, 10DBA: Schema change for dropping rev_page_id index - https://phabricator.wikimedia.org/T285149 (10Marostegui) @Ladsgroup do you have any update on this? [10:19:07] 10Blocked-on-schema-change, 10DBA: Schema change for dropping rev_page_id index - https://phabricator.wikimedia.org/T285149 (10Ladsgroup) The only thing left is the dumpers. I couldn't come up with a good plan to move forward yet but it's not too complicated. I wonder if we remove the index hint, it might make... [10:19:56] 10Blocked-on-schema-change, 10DBA: Schema change for dropping rev_page_id index - https://phabricator.wikimedia.org/T285149 (10Marostegui) No other queries use any hint? [10:27:09] 10Blocked-on-schema-change, 10DBA: Schema change for dropping rev_page_id index - https://phabricator.wikimedia.org/T285149 (10Ladsgroup) not that I know of. Search seems not to bring anything for it either. [10:28:09] 10Blocked-on-schema-change, 10DBA: Schema change for dropping rev_page_id index - https://phabricator.wikimedia.org/T285149 (10Marostegui) ok, let's see what @ArielGlenn says. Thanks! [10:35:01] 10Blocked-on-schema-change, 10DBA, 10MW-1.37-notes (1.37.0-wmf.12; 2021-06-28): Schema change for renaming several indexes in logging table - https://phabricator.wikimedia.org/T270620 (10Marostegui) [10:36:55] 10Blocked-on-schema-change, 10DBA, 10MW-1.37-notes (1.37.0-wmf.12; 2021-06-28): Schema change for renaming several indexes in logging table - https://phabricator.wikimedia.org/T270620 (10Marostegui) codfw s6 [] db2141 [] db2129 [] db2124 [] db2117 [] db2114 [] db2095 [] db2089 [x] db2087 [] db2076 [10:37:19] 10Blocked-on-schema-change, 10DBA, 10MW-1.37-notes (1.37.0-wmf.12; 2021-06-28): Schema change for renaming several indexes in logging table - https://phabricator.wikimedia.org/T270620 (10Marostegui) [10:38:07] 10Blocked-on-schema-change, 10DBA, 10MW-1.37-notes (1.37.0-wmf.12; 2021-06-28): Schema change for renaming several indexes in logging table - https://phabricator.wikimedia.org/T270620 (10Marostegui) Altered two hosts in production in s6 to make sure we don't see anymore issues. If we don't, I will continue w... [11:02:38] 10Blocked-on-schema-change, 10DBA: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp - https://phabricator.wikimedia.org/T283499 (10Marostegui) [12:02:15] 10Blocked-on-schema-change, 10DBA: Schema change to make rc_id unsigned and rc_timestamp BINARY - https://phabricator.wikimedia.org/T276150 (10Marostegui) [12:03:04] 10DBA: DB maintenance work to do while eqiad is passive (June 2021) - https://phabricator.wikimedia.org/T285139 (10Marostegui) [12:03:06] 10DBA: Switchover s1 from db1083 to db1163 - https://phabricator.wikimedia.org/T278214 (10Marostegui) [12:03:08] 10DBA: Switchover s7 from db1086 to db1136 - https://phabricator.wikimedia.org/T274336 (10Marostegui) [12:03:11] 10Blocked-on-schema-change, 10DBA: Schema change to make rc_id unsigned and rc_timestamp BINARY - https://phabricator.wikimedia.org/T276150 (10Marostegui) 05Open→03Resolved This is all done [12:15:09] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Marostegui) Just something I noticed on each run: ` Jul 6 14:03:57 mwmaint2002 media... [13:27:38] 10Blocked-on-schema-change, 10DBA, 10MW-1.37-notes (1.37.0-wmf.12; 2021-06-28): Schema change for renaming several indexes in logging table - https://phabricator.wikimedia.org/T270620 (10Marostegui) [14:15:05] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Marostegui) Runtimes: ` Wednesday 7th: * pc1: 11h * pc2: 13h * pc3: 11h ` [14:31:02] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Krinkle) >>! In T282761#7200172, @Marostegui wrote: > ` > Jul 6 14:06:21 mwmaint2002... [14:31:47] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Marostegui) Excellent, thank you! [16:17:18] 10Blocked-on-schema-change, 10DBA: Schema change for renaming page_timestamp index on revision table to rev_page_timestamp - https://phabricator.wikimedia.org/T283499 (10Marostegui) [23:44:56] 10DBA, 10MediaWiki-Parser, 10Performance-Team, 10MW-1.37-notes (1.37.0-wmf.14; 2021-07-12), and 2 others: purgeParserCache.php should not take over 24 hours for its daily run - https://phabricator.wikimedia.org/T282761 (10Krinkle)