[03:02:16] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: db1115 (tendril DB) had OOM for some processes and some hw (memory) issues - https://phabricator.wikimedia.org/T196726 (10Marostegui) 05Stalled→03Resolved I am going to close this for now, as it has been 10 days without issues: ` root@db1115:~# free -g               tota...
[03:06:35] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: db1114 crashed - https://phabricator.wikimedia.org/T214720 (10Marostegui) a:03Cmjohnson @jcrespo +1 to reimage/reclone from an existing host (or mariabackup!)  @Cmjohnson I guess we need to open a case with Dell about this host and upgrade BIOS/firmware?
[03:08:08] <wikibugs>	 10DBA, 10Analytics, 10Operations, 10ops-eqiad, 10Patch-For-Review: swap a2-eqiad PDU with on-site spare - https://phabricator.wikimedia.org/T213748 (10Marostegui) 05Open→03Resolved I believe there is nothing else pending here, and this was re-opened just to get an answer from Chris, which was done. G...
[03:15:22] <wikibugs>	 10DBA, 10Parsing-Team: Provide access to testreduce* databases on scandium + revoke from ruthenium - https://phabricator.wikimedia.org/T214740 (10Marostegui) @ssastry just to make sure we have all the data we need here, so it is easier, faster and we can avoid mistakes, can you confirm the following info:  - A...
[07:44:04] <wikibugs>	 10DBA, 10MediaWiki-extensions-Translate, 10Operations, 10Datacenter-Switchover-2018, and 2 others: DBPerformance warning "Query returned 22186 rows: query: SELECT * FROM `translate_metadata`" on Meta-Wiki - https://phabricator.wikimedia.org/T204026 (10Krinkle)
[10:50:01] <wikibugs>	 10DBA, 10AbuseFilter, 10Stewards-and-global-tools: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Billinghurst) Is it possible to look at something other than a binary solution (off/on).   For those of us who do the unheralded work in the background —  sp...
[11:14:30] <wikibugs>	 10DBA, 10AbuseFilter, 10Stewards-and-global-tools: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Daimona) The result could be cached if needs be, probably, but the point is that this query is terrible. Maybe we could optimize it with a subquery, but that...