[05:04:31] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576392 (10Marostegui) I have done the alter table on enwiki master (db1052) and it has gone fine. I pre-warmed the big tables (image and filearchive) before... [05:04:43] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576393 (10Marostegui) [05:26:36] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576396 (10Marostegui) Just for the record, I am checking again that the alter has been done across all the host and all the wikis and the only pending one w... [07:44:56] marostegui: WMDE works today but I guess it's WMF holiday [07:45:24] if not, can you take a look at https://gerrit.wikimedia.org/r/375741 [07:45:44] it is a wmf holiday for US as far as i know [07:46:25] why are you decreasing the sleep? [07:46:46] because it passed big items and it can now process batches faster [07:47:00] ah ok [07:47:02] then it looks good [07:47:10] Thank you :) [08:18:02] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576473 (10Marostegui) The new 3D enum value was missing on the new created wiki kbpwiki on s3, as probably the patch was merged after it was created. The r... [08:21:38] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576481 (10Marostegui) a:05Marostegui>03MarkTraceur @MarkTraceur I am going to re-assign this task back to you to see if you can arrange a read-only time... [08:22:30] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3576483 (10Marostegui) [08:23:38] 10Blocked-on-schema-change, 10DBA, 10Patch-For-Review: Apply schema change to add 3D filetype for STL files - https://phabricator.wikimedia.org/T168661#3553487 (10Marostegui) [08:28:12] 10DBA, 10Operations, 10hardware-requests, 10ops-eqiad: Decommission db1045 - https://phabricator.wikimedia.org/T174806#3576491 (10Marostegui) [08:47:56] 10DBA, 10Operations, 10hardware-requests, 10ops-eqiad, 10Patch-For-Review: Decommission db1045 - https://phabricator.wikimedia.org/T174806#3576541 (10Marostegui) [08:50:51] 10DBA, 10Operations, 10hardware-requests, 10ops-eqiad, 10Patch-For-Review: Decommission db1045 - https://phabricator.wikimedia.org/T174806#3576546 (10Marostegui) a:03Cmjohnson This server is ready to be totally decommissioned and only pending the DC Ops steps, so assigning it to @Cmjohnson for the pend... [08:54:49] 10DBA, 10Operations, 10ops-eqiad: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3576559 (10Marostegui) [08:55:09] 10DBA, 10Operations, 10ops-eqiad: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3576571 (10Marostegui) p:05Triage>03Normal [11:10:53] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 10Patch-For-Review, and 2 others: Usage tracking: record which statement group is used - https://phabricator.wikimedia.org/T151717#3576980 (10hoo) >>! In T151717#3574731, @eranroz wrote: > What is the current status of it? Sorry, seems this fell b... [11:40:27] 10DBA, 10Operations, 10ops-eqiad: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3577022 (10Marostegui) [12:08:21] 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3577181 (10Marostegui) [12:17:54] 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3577231 (10Marostegui) [12:24:22] 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: Decommission db1037 - https://phabricator.wikimedia.org/T174902#3577256 (10Marostegui) a:03Cmjohnson MySQL is stopped. This host is now ready for the remaining DC Ops steps to be completed [12:34:51] 10DBA, 10MediaWiki-Database: Integrate Facebooks "Online Schema Change for MySQL" into MediaWiki - https://phabricator.wikimedia.org/T32824#3577288 (10Marostegui) 05Open>03Resolved If no one disagrees I am going to close this as we are already using pt-online-schema-change and when available we use INPLACE... [13:36:13] 10DBA, 10Operations, 10Traffic: Substantive HTTP and mediawiki/database traffic coming from a single ip - https://phabricator.wikimedia.org/T166695#3577497 (10Marostegui) 05stalled>03Resolved Closing this as this has not happened again in months. If it happens again, let's reopen and follow up [13:44:56] 10DBA, 10Discovery, 10GeoData, 10Maps-Sprint: Removal of {{#coordinates:}} leaves DB entries behind - https://phabricator.wikimedia.org/T143366#3577509 (10Marostegui) >>! In T143366#3434141, @Marostegui wrote: > Thanks for the heads up. I assume this will be fixed at some point, right? Any update on this... [16:21:53] 10DBA, 10Discovery, 10GeoData, 10Maps-Sprint: Removal of {{#coordinates:}} leaves DB entries behind - https://phabricator.wikimedia.org/T143366#2566073 (10Gehel) No update... I'm not even sure who's scope this is. It does not look to be part of Kartographer or any of the project in the scope of the maps te... [19:47:13] 10DBA: Run pt-table-checksum on s4 (commonswiki) - https://phabricator.wikimedia.org/T162593#3578344 (10jcrespo) image has been done 100% for db1059, and at the same time the differences with db1068 (which is identical to db1081,84, 91 and 97) have been fixed too. That may have corrected all other errors on all...