[05:02:39] 10Blocked-on-schema-change, 10DBA: Review schema changes for T143962 - https://phabricator.wikimedia.org/T145356#2627432 (10Ladsgroup) [05:30:25] 10Blocked-on-schema-change, 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Review schema changes for T143962 - https://phabricator.wikimedia.org/T145356#2627448 (10Ladsgroup) [06:20:47] 10DBA, 10Analytics-EventLogging, 10ImageMetrics: Drop EventLogging tables for ImageMetricsLoadingTime and ImageMetricsCorsSupport - https://phabricator.wikimedia.org/T141407#2627512 (10Marostegui) Don't know if this throws more light into the issue, but the only table recreated is that one. I just checked a... [07:06:54] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2517589 (10Legoktm) What is the purpose of... [07:08:20] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Review schema changes for T143962 - https://phabricator.wikimedia.org/T145356#2627576 (10jcrespo) Amir, I am not sure what you want #DBAs to do here, as I do not have a patch to apply or review. In any case, this doesn't seem like a #blocke... [07:12:34] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Review schema changes for T143962 - https://phabricator.wikimedia.org/T145356#2627581 (10Ladsgroup) I'm trying to follow https://wikitech.wikimedia.org/wiki/Schema_changes#Workflow_of_a_schema_change. This is the article 3: "Once the soluti... [07:40:02] 07Blocked-on-schema-change, 10DBA, 05MW-1.28-release-notes, 13Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544418 (10jcrespo) Wait, this is not so direct; there is partitioning on the revision tables which on some wikis it is the difference between things... [07:41:53] 10DBA, 05MW-1.28-release-notes, 13Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2627599 (10jcrespo) [07:43:38] 07Blocked-on-schema-change, 10DBA, 05MW-1.28-release-notes, 13Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2544418 (10jcrespo) [07:51:47] 07Blocked-on-schema-change, 10DBA, 05MW-1.28-release-notes, 13Patch-For-Review: Clean up revision UNIQUE indexes - https://phabricator.wikimedia.org/T142725#2627610 (10jcrespo) To clarify, the scope of the ticket can be done with no issue; however, the "special slaves" have to maintain `PRIMARY KEY (rev_id... [07:56:39] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2627634 (10Marostegui) [08:18:14] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2517589 (10Marostegui) I will own this task... [08:18:27] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2627668 (10Marostegui) a:05jcrespo>03Mar... [08:28:27] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Review schema changes for T143962 - https://phabricator.wikimedia.org/T145356#2627682 (10jcrespo) Ladsgroup, this is reverted https://gerrit.wikimedia.org/r/#/c/309818/ . Even if you did that, it is not "merged to HEAD", as far as I can see... [08:29:19] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Check ORES data corruption on Beta do not affect production - https://phabricator.wikimedia.org/T145356#2627683 (10jcrespo) [08:41:30] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Check ORES data corruption on Beta do not affect production - https://phabricator.wikimedia.org/T145356#2627701 (10Ladsgroup) And that revert got reverted later on: https://gerrit.wikimedia.org/r/#/c/309837/ So It' in HEAD now. We should w... [08:47:55] 10DBA, 10MediaWiki-extensions-ORES, 06Revision-Scoring-As-A-Service: Check ORES data corruption on Beta do not affect production - https://phabricator.wikimedia.org/T145356#2627707 (10jcrespo) a:03jcrespo @Ladsgroup, allow me to do that for you properly, so we do not affect the performance of the other que... [08:54:08] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627711 (10Legoktm) [08:54:24] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627711 (10Legoktm) a:05Legoktm>03None [09:01:38] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627711 (10jcrespo) If the table is fully public, and contain no user information or other private information, then I am not a blocker.... [09:02:07] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627747 (10jcrespo) [09:20:09] 10DBA, 10MediaWiki-extensions-Babel, 10Wikimedia-General-or-Unknown: Create and populate babel database table on Wikimedia wikis - https://phabricator.wikimedia.org/T145366#2627788 (10Legoktm) Thanks for the quick review! After a page is edited that uses this feature, a refreshLinks job is submitted to the... [10:13:43] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2627913 (10Marostegui) I am testing the fol... [10:34:44] 10DBA: hitcounter and _counter tables are on the cluster but were deleted/unsused? - https://phabricator.wikimedia.org/T132837#2627935 (10Marostegui) This has been executed: ``` for i in `mysql -hdb1015 -e "show databases;" -AB `; do echo ***$i***; mysql -hdb1015 $i -e "rename table hitcounter to TO_DROP_hitcou... [10:45:07] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2627949 (10Niharika) >>! In T141951#2627562... [11:39:55] 07Blocked-on-schema-change, 03Community-Tech-Sprint, 13Patch-For-Review, 07Schema-change, 05WMF-deploy-2016-09-13_(1.28.0-wmf.19): Add local_user_id and global_user_id fields to localuser table in centralauth database - https://phabricator.wikimedia.org/T141951#2628130 (10Marostegui) The alter is finishe... [11:41:30] ^really nice work [11:42:16] thanks, you guided me well :) [15:41:03] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), 13Patch-For-Review: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2629038 (10debt) p:05Triage>03Normal [15:44:27] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), 13Patch-For-Review: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2629047 (10jcrespo) It should only take a few days more/a week at maximum to finish the schema change and start work... [17:11:08] 10DBA, 10MediaWiki-Maintenance-scripts, 06Operations, 06Release-Engineering-Team, and 2 others: Add section for long-running tasks on the Deployment page (specially for database maintenance) - https://phabricator.wikimedia.org/T144661#2629609 (10greg) Here's what the output looks like from jouncebot when t... [17:25:19] 10DBA, 10MediaWiki-Maintenance-scripts, 06Operations, 06Release-Engineering-Team, and 2 others: Add section for long-running tasks on the Deployment page (specially for database maintenance) - https://phabricator.wikimedia.org/T144661#2629638 (10bd808) >>! In T144661#2629609, @greg wrote: > @bd808: it migh... [17:26:20] 10DBA, 10MediaWiki-Maintenance-scripts, 06Operations, 06Release-Engineering-Team, and 2 others: Add section for long-running tasks on the Deployment page (specially for database maintenance) - https://phabricator.wikimedia.org/T144661#2629655 (10greg) yeah, I'd prefer both because I know some people ignore... [22:53:18] 10DBA, 10MediaWiki-Database, 06Performance-Team, 07Availability: wfWaitForSlaves in JobRunner can massively slow down run rate if just a single slave is lagged - https://phabricator.wikimedia.org/T95799#1200679 (10aaron) [23:05:02] 07Blocked-on-schema-change, 10DBA, 10Wikimedia-Site-requests, 06Wikisource, and 2 others: Schema change for page content language - https://phabricator.wikimedia.org/T69223#2631254 (10Halibutt) Thanks everyone, holding my breath then :)