[00:01:00] 10Cloud-VPS, 10Scoring-platform-team, 10Documentation: Document recommended process for installing OS upgrades in Wikimedia VPS - https://phabricator.wikimedia.org/T169247#3681725 (10bd808) [00:01:05] 10cloud-services-team (Kanban), 10DBA, 10Operations, 10Ops-Access-Requests: Access to raw database tables on labsdb* for wmcs-admin users - https://phabricator.wikimedia.org/T178128#3681728 (10bd808) [00:02:03] 10Data-Services, 10cloud-services-team (Kanban), 10Operations: Switch labstore servers to default SSH configuration - https://phabricator.wikimedia.org/T177914#3681731 (10bd808) [03:00:54] 10Cloud-VPS (Quota-requests): Request increased quota for Cloud VPS project - https://phabricator.wikimedia.org/T178134#3681841 (10Cyberpower678) [03:03:27] 10Cloud-VPS (Quota-requests): Request increased quota for cyberbot Cloud VPS project - https://phabricator.wikimedia.org/T178134#3681853 (10bd808) [03:06:32] 10Cloud-VPS: Create a method for forwarding non-HTTP protocols to VMs withouth public IPs - https://phabricator.wikimedia.org/T178133#3681856 (10bd808) a:05bd808>03None [03:06:54] 10Cloud-VPS: Create a method for forwarding non-HTTP protocols to VMs without public IPs - https://phabricator.wikimedia.org/T178133#3681827 (10bd808) [03:20:04] on the labs replicas I'm getting "ERROR 1030 (HY000): Got error 176 "Read page with wrong checksum" from storage engine Aria" [03:20:28] from query select count(*) from ores_classification where oresc_model = 21 and oresc_class = 1; [03:31:16] 10Cloud-VPS: Create a method for forwarding non-HTTP protocols to VMs without public IPs - https://phabricator.wikimedia.org/T178133#3681864 (10bd808) For @Cyberpower678's specific use case, he would like to setup https://github.com/bjango/istatserverlinux on instances in the cyberbot project and then connect to... [03:38:22] 10Data-Services: ores_classification table corrupt on enwiki labs replica labsdb1001 - https://phabricator.wikimedia.org/T178135#3681866 (10Bawolff) [05:28:37] 10Data-Services, 10DBA, 10Security-Team: pagetranslation log_type missing on replicas - https://phabricator.wikimedia.org/T178052#3681916 (10Marostegui) Just for the record, those are replicated on the labs hosts, they are just missing the views: ``` mysql:root@localhost [commonswiki]> select @@hostname; +--... [05:48:00] 10Data-Services, 10DBA, 10XTools: Request to increase active connection quota for user s51187 on analytics.db.svc.eqiad.wmflabs - https://phabricator.wikimedia.org/T177570#3681922 (10Marostegui) The user `s53003` had no connection limit on the old servers indeed. I have increased it from 10 to 20 on `.web`.... [08:02:37] 10Cloud-Services, 10Huggle: Huggle development environment - portable virtual box - https://phabricator.wikimedia.org/T177145#3682092 (10Petrb) 05Open>03Resolved a:03Petrb [10:59:57] 10Cloud-Services: Cloud services analytics replicas problem - https://phabricator.wikimedia.org/T178155#3682550 (10Magnus) [13:56:47] 10Data-Services: Cloud services analytics replicas problem - https://phabricator.wikimedia.org/T178155#3683097 (10zhuyifei1999) FWIW: ``` 01:55:49 0 ✓ zhuyifei1999@tools-bastion-02: ~$ mysql -h dewiki.analytics.db.svc.eqiad.wmflabs <<< 'SELECT @@hostname;' @@hostname labsdb1010 01:55:58 0 ✓ zhuyifei1999@tools-ba... [14:26:37] 10Cloud-Services, 10Operations, 10Traffic: check_dns needs to be rewritten - https://phabricator.wikimedia.org/T133791#3683244 (10ema) 05Open>03Resolved a:03ema check_dns v1.5 (nagios-plugins 1.5) seems to be doing the right thing currently: ``` 14:25:09 ema@labservices1001.wikimedia.org:~ $ /usr/lib/... [15:39:17] 10cloud-services-team (Kanban), 10Analytics: Remove logging from labs for schema https://meta.wikimedia.org/wiki/Schema:CommandInvocation - https://phabricator.wikimedia.org/T166712#3683389 (10Nuria) ping @elukey Can we drop the CommandInvocation table? Thank you [16:01:58] 10Data-Services, 10DBA, 10XTools: Request to increase active connection quota for user s51187 on analytics.db.svc.eqiad.wmflabs - https://phabricator.wikimedia.org/T177570#3683443 (10MusikAnimal) Thanks! I should also mention our query killer apparently wasn't working... pretty sure that was partly at fault... [16:31:04] 10Cloud-Services, 10cloud-services-team (Kanban), 10Patch-For-Review: Remove non-interactive bots from #wikimedia-cloud - https://phabricator.wikimedia.org/T177427#3683523 (10Matthewrbowker) Do we want wm-bot in `#wikimedia-cloud-feed`? I'm not sure if it would afford any benefit but I can add it and configu... [17:12:03] 10Data-Services, 10DBA, 10XTools: Request to increase active connection quota for user s51187 on analytics.db.svc.eqiad.wmflabs - https://phabricator.wikimedia.org/T177570#3683698 (10Marostegui) Let's leave this open for the weekend and we can close it on Monday or Tuesday if all is fine, sounds good? [17:12:40] 10Data-Services, 10DBA, 10XTools: Request to increase active connection quota for user s51187 on analytics.db.svc.eqiad.wmflabs - https://phabricator.wikimedia.org/T177570#3683700 (10MusikAnimal) >>! In T177570#3683698, @Marostegui wrote: > Let's leave this open for the weekend and we can close it on Monday... [18:39:39] 10Cloud-VPS (Quota-requests): Revert temporary increase of floating-ip quota for 'cvn' project (trusty to debian migration) - https://phabricator.wikimedia.org/T177299#3683958 (10Krinkle) [20:18:39] 10Data-Services, 10DBA, 10Dumps-Generation, 10Blocked-on-schema-change, 10MediaWiki-Platform-Team (MWPT-Q1-Jul-Sep-2017): Schema change for refactored comment storage - https://phabricator.wikimedia.org/T174569#3684216 (10CCicalese_WMF) [20:26:08] 10Data-Services, 10Structured-Data-Commons, 10Wikidata, 10MediaWiki-Platform-Team (MWPT-Q3-Jan-Mar-2018): Provide backwards compatibility views for toolforge replica [MCR] - https://phabricator.wikimedia.org/T174047#3684234 (10CCicalese_WMF) [20:30:15] 10Data-Services, 10cloud-services-team (Kanban), 10Community-Tech, 10DBA, 10Security: Create core ip_changes view for replicas - https://phabricator.wikimedia.org/T173891#3684240 (10bd808) This should be ready for maintain-views to be run on labsdb* to actually create the view in each wikidb. I //think//... [20:31:51] 10Data-Services, 10cloud-services-team (Kanban), 10Community-Tech, 10DBA, 10Security: Create core ip_changes view for replicas - https://phabricator.wikimedia.org/T173891#3543452 (10bd808) p:05Triage>03Normal [20:32:59] 10wikitech.wikimedia.org, 10DBA: Rename database labswiki to wikitech - https://phabricator.wikimedia.org/T171570#3684246 (10bd808) [20:34:29] 10wikitech.wikimedia.org, 10Wikimedia-Site-requests: Remove 'importers' (note the ending 's') group from wikitech - https://phabricator.wikimedia.org/T171682#3684249 (10bd808)