[06:31:55] 10DBA, 10AbuseFilter, 10MW-1.34-notes (1.34.0-wmf.1; 2019-04-16), 10Wikimedia-production-error: Read timeout reached while viewing AbuseLog - https://phabricator.wikimedia.org/T221357 (10Marostegui) It is not really making any difference unfortunately, the optimizer still thinks it is better to do a full s... [07:01:04] 10DBA, 10Operations, 10ops-codfw: Degraded RAID on db2037 - https://phabricator.wikimedia.org/T221512 (10Marostegui) p:05Triage→03Normal a:03Papaul Let's get it replaced Thanks! [07:02:12] 10DBA, 10Operations: Predictive failures on disk S.M.A.R.T. status - https://phabricator.wikimedia.org/T208323 (10Marostegui) [10:02:28] 10DBA, 10Core Platform Team, 10MediaWiki-Database, 10MediaWiki-Logging, and 3 others: Special:Log on commons -- entire web request took longer than 60 seconds and timed out - https://phabricator.wikimedia.org/T221458 (10Jc86035) Should T221380 be merged or made a subtask? It seems like the same issue, but... [11:08:51] 10DBA, 10AbuseFilter, 10MW-1.34-notes (1.34.0-wmf.1; 2019-04-16), 10Wikimedia-production-error: Read timeout reached while viewing AbuseLog - https://phabricator.wikimedia.org/T221357 (10Daimona) @Marostegui Thanks! What if a FORCE INDEX (af_id) is added to the join with abuse_filter? Is it still ignored?... [15:59:47] 10DBA, 10AbuseFilter, 10MW-1.34-notes (1.34.0-wmf.1; 2019-04-16), 10Wikimedia-production-error: Read timeout reached while viewing AbuseLog - https://phabricator.wikimedia.org/T221357 (10Marostegui) There is no difference, I don't think it is an optimizer bug, it is an issue with CAST. I personally don't h... [16:20:01] 10DBA, 10Jade, 10Operations, 10TechCom-RFC, and 3 others: Introduce a new namespace for collaborative judgements about wiki entities - https://phabricator.wikimedia.org/T200297 (10Marostegui) As far as I remember (it has been a while) all the stuff that was sent for me to review was reviewed and I believe... [17:12:28] 10DBA, 10Core Platform Team, 10MediaWiki-Database, 10MediaWiki-Logging, and 3 others: Special:Log on commons -- entire web request took longer than 60 seconds and timed out - https://phabricator.wikimedia.org/T221458 (10Jeff_G) A workaround is to start with [[Special:Log/block]] or https://commons.wikimedi... [18:49:05] 10DBA, 10Jade, 10Operations, 10TechCom-RFC, and 3 others: Introduce a new namespace for collaborative judgements about wiki entities - https://phabricator.wikimedia.org/T200297 (10Harej) In your opinion, are there any problems you can foresee from a database design perspective?