Page MenuHomePhabricator

bd808 (Bryan Davis)
Engineering Manager, Technical EngagementAdministrator

Projects (37)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Oct 3 2014, 2:36 PM (246 w, 4 d)
Roles
Administrator
Availability
Available
IRC Nick
bd808
LDAP User
BryanDavis
MediaWiki User
BDavis (WMF) [ Global Accounts ]

I'm BDavis (WMF) on wiki, bd808 on irc, and BryanDavis on Gerrit and Wikitech.

I've got a thing for ๐Ÿฆ„s. Don't judge.

I work for or provide services to the Wikimedia Foundation, but this is my only Phabricator account. Edits, statements, or other contributions made from this account are my own, and may not reflect the views of the Foundation.

Recent Activity

Today

bd808 added a comment to T224154: Reduce size of linkwatcher db on toolsdb if at all possible.

@beestra I'm looking at your linkwatcher_linklog table and see that it has records going back to 2013-12-29 19:33:33 and a total of 528,994,352 rows. This 384.8 GB of storage is an order of magnitude larger than the next largest tool database and 2-3 orders of magnitude larger than the "typical" tools db. Is there no way to prune out old data here? At this point I'm actually not sure if we could even effectively move you to your own database instance in your own Cloud VPS project and handle this much mysql storage.

Tue, Jun 25, 7:15 PM ยท Data-Services
bd808 triaged T226537: Follow up on past WMCS #wikimedia-incident tasks as Normal priority.
Tue, Jun 25, 4:58 PM ยท cloud-services-team (Kanban), Epic
bd808 moved T226537: Follow up on past WMCS #wikimedia-incident tasks from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.
Tue, Jun 25, 4:57 PM ยท cloud-services-team (Kanban), Epic
bd808 created T226537: Follow up on past WMCS #wikimedia-incident tasks.
Tue, Jun 25, 4:57 PM ยท cloud-services-team (Kanban), Epic
bd808 updated subscribers of T220836: Guidelines for Rust/Go tools deployment.

Part of what I think the question is there is: Is having CI pull a crate or check out something for a go module equivalent to installing things outside of the rules? Or, do you have to do that locally and then commit it to your gerrit repo, which is functionally identical but obeys the letter of the rules more. What do we do for PHP libraries?

Tue, Jun 25, 12:34 AM ยท serviceops-radar, Packaging

Yesterday

bd808 added a comment to T225082: Request creation of Blog VPS project.

I just created this project.

Mon, Jun 24, 5:03 PM ยท Cloud-VPS (Project-requests)
bd808 updated subscribers of T226427: Removing old detox tool.

Maintainers per https://tools.wmflabs.org/admin/tool/detox:

Mon, Jun 24, 4:30 PM ยท Tools
bd808 added a comment to T226296: Don't show UserFeedBack form on non-existent pages.

Fixed on wikitech using a variation of the fix suggested by @Aklapper in T226296#5275651

Mon, Jun 24, 1:45 AM ยท Developer-Advocacy, Wikimedia-General-or-Unknown, User-DannyS712

Sun, Jun 23

bd808 committed R2073:72c9dd1c5f95: Update setex to work with newer redis versions (authored by bd808).
Update setex to work with newer redis versions
Sun, Jun 23, 3:45 AM
bd808 added a comment to T215888: openstack-browser: include deployment view support.
Sun, Jun 23, 3:26 AM ยท Tools, cloud-services-team (Kanban)

Thu, Jun 20

bd808 added a comment to T226163: A MediaWiki API error occurred: The authorization headers in your request are not valid for metawiki.

mwoauth.errors.OAuthException: A MediaWiki API error occurred: The authorization headers in your request are not valid for metawiki probably means that something is not quite right with your CONSUMER_KEY and/or CONSUMER_SECRET settings.

Thu, Jun 20, 7:43 PM ยท User-Jayprakash12345, Tools
bd808 renamed T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge from DNS from toolforge not working for some host(s) to DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge.
Thu, Jun 20, 2:55 PM ยท cloud-services-team (Kanban), Toolforge

Wed, Jun 19

bd808 moved T225025: Request new Flavor for integration Cloud VPS project from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.
Wed, Jun 19, 9:43 PM ยท cloud-services-team (Kanban), Release-Engineering-Team-TODO, Continuous-Integration-Infrastructure, Cloud-VPS (Quota-requests)
bd808 assigned T225025: Request new Flavor for integration Cloud VPS project to Andrew.

Approved in our 2019-06-18 meeting. Assigning to @Andrew to implement when he gets time. @Andrew you can hand this off too @JHedden too if you'd like to give him a chance to poke at our OpenStack setup. :)

Wed, Jun 19, 9:43 PM ยท cloud-services-team (Kanban), Release-Engineering-Team-TODO, Continuous-Integration-Infrastructure, Cloud-VPS (Quota-requests)
bd808 added a comment to T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge.

Case number is CAS-385915-W6L6G7 opened via the support form at support.nlm.nih.gov:

Wed, Jun 19, 9:33 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge.

dig @8.8.8.8 eutils.ncbi.nlm.nih.gov works from inside Toolforge. This is looking like the default DNS resolvers for all of the Cloud VPS tenant space (208.80.154.143 and 208.80.154.24) being blocked by the ns*.nih.gov DNS primaries.

Wed, Jun 19, 9:13 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge.

From outside of the Foundation's network (DNS resolve success):

$ dig eutils.ncbi.nlm.nih.gov +trace
Wed, Jun 19, 8:37 PM ยท cloud-services-team (Kanban), Toolforge
bd808 moved T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge from Inbox to Clinic Duty on the cloud-services-team (Kanban) board.
Wed, Jun 19, 8:16 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a project to T226088: DNS lookups for nih.gov hosts failing from Cloud VPS/Toolforge: cloud-services-team (Kanban).
Wed, Jun 19, 8:15 PM ยท cloud-services-team (Kanban), Toolforge

Mon, Jun 17

bd808 added a comment to T225704: eqiad: rack/setup/install (4) dbproxy systems..

@Bstorm @bd808 any comments on T225704#5261972?

Mon, Jun 17, 4:52 PM ยท Patch-For-Review, Operations, DBA

Sun, Jun 16

bd808 added a comment to T225191: Backed-up large storage?.

We have hopes of providing archival storage in the future (T209530: Build user data backup service based on remote sync rather than NFS). The intent for this service will be disaster recovery however, not "extra" data storage.

Sun, Jun 16, 5:24 PM ยท Data-Services, Toolforge
bd808 placed T209530: Build user data backup service based on remote sync rather than NFS up for grabs.
Sun, Jun 16, 5:18 PM ยท Data-Services, Epic, cloud-services-team (Kanban)
bd808 updated the task description for T209530: Build user data backup service based on remote sync rather than NFS.
Sun, Jun 16, 5:18 PM ยท Data-Services, Epic, cloud-services-team (Kanban)
bd808 renamed T225373: `qstat -xml` failures lead to incomprehensible error messages from jsub/jstart/job from failed receiving gdi request response for mid=1 to `qstat -xml` failures lead to incomprehensible error messages from jsub/jstart/job.
Sun, Jun 16, 5:13 PM ยท Toolforge
bd808 moved T225190: Object store? from Triage to Feature requests on the Toolforge board.
Sun, Jun 16, 5:06 PM ยท Toolforge
bd808 moved T225191: Backed-up large storage? from Triage to Feature requests on the Toolforge board.
Sun, Jun 16, 5:06 PM ยท Data-Services, Toolforge
bd808 added a comment to T225190: Object store?.

A major focus for the cloud-services-team in the July 2019-June 2020 fiscal year will be improving and enhancing the storage systems that we use both "in the backend" for managing Cloud VPS instance virtual disks and in the more visible areas such as our current NFS system. The backend project will be worked on first, but we hope that work will lead to us being able to provide other features like an S3-like bucket+object storage interface in the later stages of the project. We are not ready to make any timeline commitments yet for when this might be available in Toolforge and other Cloud VPS projects.

Sun, Jun 16, 5:05 PM ยท Toolforge
bd808 moved T209530: Build user data backup service based on remote sync rather than NFS from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท Data-Services, Epic, cloud-services-team (Kanban)
bd808 moved T153943: Coordinate Kubernetes efforts between Tool Labs and Production from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Epic, Prod-Kubernetes, Tools-Kubernetes, Kubernetes, Cloud-Services
bd808 moved T90534: Make toollabs reliable enough (tracking) from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท Epic, cloud-services-team (Kanban), Tracking-Neverending, Toolforge
bd808 moved T128158: Tools web interface for tool authors (Brainstorming ticket) from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Community-Tech-Tool-Labs, Epic, Cloud-Services
bd808 moved T194334: [Epic] Modern Cloud VPS storage layer from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Epic, Cloud-VPS
bd808 moved T127367: Provide modern, non-NFS error log solution for Toolforge webservices and bots from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Epic, Toolforge
bd808 moved T144282: Manually connect existing Diffusion repos to tools in toolsadmin from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Tracking-Neverending, Striker, Epic
bd808 moved T144328: Enable i18n for Striker from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), I18n, Epic, Striker
bd808 moved T194333: [Epic] Provide logging/metrics/monitoring SaaS for Cloud VPS tenants from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Epic, Cloud-VPS
bd808 moved T194335: [Epic] Toolforge community hackathon for community issues from Inbox to Epics on the cloud-services-team (Kanban) board.
Sun, Jun 16, 4:31 PM ยท cloud-services-team (Kanban), Epic, Toolforge

Wed, Jun 12

bd808 added a comment to T74291: Setup IEG grant review project with translatewiki.net.

Greetings everyone.

@bd808 - I know it's been a while, but shall we go ahead and add this project to translatewiki.net?

Wed, Jun 12, 8:41 AM ยท Patch-For-Review, User-abi_, translatewiki.net, Wikimedia-IEG-grant-review
bd808 awarded T225584: Enable UserFeedback Gadget on MediaWiki.org a Like token.
Wed, Jun 12, 8:39 AM ยท Developer-Advocacy (Apr-Jun 2019), Documentation, MediaWiki-API
bd808 added a comment to T225229: User Feedback gadget: "Uncaught TypeError: Cannot read property 'newFromText' of undefined".

I am also wondering if the change @bd808 made to the the Gadget definition made the feedback form to disappear on Wikitech because now the error we are getting there is: "Unknown module: mediawiki.title" and the one we saw previously still exists.

Only guessing that it might be the t in mediawiki.title should be capital? https://www.mediawiki.org/wiki/ResourceLoader/Core_modules#mediawiki.Title.

Wed, Jun 12, 8:34 AM ยท Developer-Advocacy
bd808 added a comment to T225226: Fix button accessibility of emojis in User Feedback gadget.

@bd808 @Krinkle Could one of you help? :)

Wed, Jun 12, 8:28 AM ยท Accessibility, Developer-Advocacy

Tue, Jun 11

bd808 lowered the priority of T224850: Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas from High to Normal.

Lowering priority. Changes announced on cloud-announce mailing list. Still need to document in more places on wikitech.

Tue, Jun 11, 11:44 PM ยท cloud-services-team (Kanban), Data-Services
bd808 added a comment to T225368: Need a Google Organisation to setup Google OAuth login on photo uploader to Commons.

Argh... restoring .

Basically: Is this possible? Does this make sense? If both, who to sort out budget?

Tue, Jun 11, 11:24 PM ยท cloud-services-team, Google-Drive-to-Commons

Mon, Jun 10

bd808 closed T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004 as Resolved.

The "Check the last execution of designate_floating_ip_ptr_records_updater" check for cloudcontrol1004 is now showing "OK" status.

Mon, Jun 10, 3:19 PM ยท cloud-services-team (Kanban), Cloud-Services

Fri, Jun 7

bd808 added a comment to T225308: Users with a different name in the cn field compared to uid field cannot use http auth.

cn !== uid for most of our Developer accounts as far as I know. We encourage cn to be a person's full name (or at least given name + family name) and uid's have other constraints including ASCII alphanumeric charset restrictions.

Fri, Jun 7, 7:30 PM ยท Gerrit
bd808 added a comment to T225229: User Feedback gadget: "Uncaught TypeError: Cannot read property 'newFromText' of undefined".

Thanks for trying. Meh, it did not help. :-(

Fri, Jun 7, 12:49 AM ยท Developer-Advocacy
bd808 moved T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004 from Inbox to Doing on the cloud-services-team (Kanban) board.
Fri, Jun 7, 12:29 AM ยท cloud-services-team (Kanban), Cloud-Services
bd808 claimed T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004.
Fri, Jun 7, 12:29 AM ยท cloud-services-team (Kanban), Cloud-Services

Thu, Jun 6

bd808 added a comment to T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004.

The file is in the state graph:

$  grep check_systemd_unit_status /var/lib/puppet/state/resources.txt
file[/usr/local/lib/nagios/plugins/check_systemd_unit_status]

But it is being ensured absent!

/var/lib/puppet/state/last_run_report.yaml
File[/usr/local/lib/nagios/plugins/check_systemd_unit_status]:
  title: "/usr/local/lib/nagios/plugins/check_systemd_unit_status"
  file: "/etc/puppet/modules/systemd/manifests/timer/job.pp"
  line: 124
  resource: File[/usr/local/lib/nagios/plugins/check_systemd_unit_status]
  resource_type: File
  provider_used: posix
  containment_path:
  - Stage[main]
  - Openstack::Keystone::Cleanup
  - Systemd::Timer::Job[keystone_delete_expired_tokens]
  - File[/usr/local/lib/nagios/plugins/check_systemd_unit_status]
  evaluation_time: 0.039036059
  tags:
  - file
  - systemd::timer::job
  - systemd
  - timer
  - job
  - keystone_delete_expired_tokens
  - class
  - openstack::keystone::cleanup
  - openstack
  - keystone
  - cleanup
  - profile::openstack::eqiad1::keystone::service
  - profile
  - eqiad1
  - service
  - role::wmcs::openstack::eqiad1::control
  - role
  - wmcs
  - control
  time: '2019-06-06T23:27:23.686056831+00:00'
  failed: false
  failed_to_restart: false
  changed: false
  out_of_sync: false
  skipped: false
  change_count: 0
  out_of_sync_count: 0
  events: []
  corrective_change: false

This is an unintended behavior of the Puppet code in ::systemd::timer::job.

Thu, Jun 6, 11:46 PM ยท cloud-services-team (Kanban), Cloud-Services
bd808 added a comment to T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004.

The check that nagios is configured to run is /usr/local/lib/nagios/plugins/check_systemd_unit_status designate_floating_ip_ptr_records_updater. This is failing because /usr/local/lib/nagios/plugins/check_systemd_unit_status is not provisioned on the host. That file should be provisioned by ::systemd::timer::job:

modules/systemd/manifests/timer/job.pp
if $monitoring_enabled {
    if !defined(File['/usr/local/lib/nagios/plugins/check_systemd_unit_status']) {
        file { '/usr/local/lib/nagios/plugins/check_systemd_unit_status':
            ensure => $ensure,
            source => 'puppet:///modules/systemd/check_systemd_unit_status',
            mode   => '0555',
            owner  => 'root',
            group  => 'root',
        }
    }
Thu, Jun 6, 11:37 PM ยท cloud-services-team (Kanban), Cloud-Services
bd808 created T225268: "Check the last execution of designate_floating_ip_ptr_records_updater" NRPE check not working on cloudcontrol1004.
Thu, Jun 6, 11:36 PM ยท cloud-services-team (Kanban), Cloud-Services
bd808 closed T225046: HTML output of https://tools.wmflabs.org/admin/tools getting truncated as Resolved.

I'm not sure if the code update or the service restart fixed this, but it looks to be working now.

Thu, Jun 6, 10:45 PM ยท Tool-admin, cloud-services-team (Kanban), Toolforge
bd808 added a comment to T225229: User Feedback gadget: "Uncaught TypeError: Cannot read property 'newFromText' of undefined".

@Aklapper I tried your suggestion: https://wikitech.wikimedia.org/w/index.php?title=MediaWiki:Gadgets-definition&diff=1828763&oldid=1817182

Thu, Jun 6, 8:21 PM ยท Developer-Advocacy
bd808 edited projects for T225046: HTML output of https://tools.wmflabs.org/admin/tools getting truncated, added: Tool-admin; removed Tools.
Thu, Jun 6, 5:24 AM ยท Tool-admin, cloud-services-team (Kanban), Toolforge
bd808 added a project to T225046: HTML output of https://tools.wmflabs.org/admin/tools getting truncated: cloud-services-team (Kanban).

I can reproduce on https://tools.wmflabs.org/admin/tools but not on https://tools.wmflabs.org/admin-beta/tools. Nothing in the error.log file indicating why the render is stopping in the middle of the list.

Thu, Jun 6, 5:23 AM ยท Tool-admin, cloud-services-team (Kanban), Toolforge
bd808 created T225176: git operations against diffusion showing server-side logging failure messages.
Thu, Jun 6, 5:13 AM ยท Diffusion
bd808 committed R1922:2e083cc040b8: Bump wikimedia/slimapp to dev-master (authored by bd808).
Bump wikimedia/slimapp to dev-master
Thu, Jun 6, 5:12 AM
bd808 merged task T225048: ipblocks.ipb_by_text database column has gone missing from English Wikipedia database replica into T225007: Update operator/user manual description of database tables changed for refactored actor storage.
Thu, Jun 6, 3:56 AM ยท Data-Services, Documentation
bd808 merged T225048: ipblocks.ipb_by_text database column has gone missing from English Wikipedia database replica into T225007: Update operator/user manual description of database tables changed for refactored actor storage.
Thu, Jun 6, 3:56 AM ยท Documentation, Core Platform Team (Code Health (TEC13))

Wed, Jun 5

bd808 closed T224265: Redirect svgtranslate from toolserver.org as Resolved.

Its working now! https://toolserver.org/~nikola/svgtranslate.php?svg=http://upload.wikimedia.org/wikipedia/commons/f/f4/Wiggers_Diagram.svg ends up at https://tools.wmflabs.org/svgtranslate/File:Wiggers_Diagram.svg

Wed, Jun 5, 10:37 PM ยท cloud-services-team (Kanban), Cloud-VPS, Community-Tech (Kanban), Patch-For-Review, SVG Translate Tool
bd808 added a comment to T224265: Redirect svgtranslate from toolserver.org.

@Niharika the apache config wasn't quite right, but we'll get it fixed up with https://gerrit.wikimedia.org/r/514618

Wed, Jun 5, 10:19 PM ยท cloud-services-team (Kanban), Cloud-VPS, Community-Tech (Kanban), Patch-For-Review, SVG Translate Tool
bd808 added a comment to T224265: Redirect svgtranslate from toolserver.org.

Are we good to close this ticket?

Wed, Jun 5, 9:03 PM ยท cloud-services-team (Kanban), Cloud-VPS, Community-Tech (Kanban), Patch-For-Review, SVG Translate Tool
bd808 awarded T216088: Mapping of servers to stakeholders a Love token.
Wed, Jun 5, 7:14 PM ยท Operations
bd808 renamed T224850: Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas from Offer alternate views of the comment table which only check for supression in a single table in the Wiki Replicas to Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas.
Wed, Jun 5, 5:31 PM ยท cloud-services-team (Kanban), Data-Services
Aklapper awarded T225007: Update operator/user manual description of database tables changed for refactored actor storage a Love token.
Wed, Jun 5, 10:18 AM ยท Documentation, Core Platform Team (Code Health (TEC13))
bd808 added a comment to T223902: cloudcontrol: decide on FQDN for service endpoints.

Reading the discussion here and in irc earlier today, I think the more general topic of which TLDs we are going to use for which purpose deserves a wiki page and some strawdog proposals that are easier to iterate on as a group than phab comments. I don't think we need to spend ages on finding a 'perfect' solution here, but nothing will collapse if we pick up the discussion again next week and spend a few days poking holes in draft ideas.

Wed, Jun 5, 12:38 AM ยท Operations, Traffic, Cloud-VPS, cloud-services-team (Kanban)
bd808 added a comment to T224850: Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas.

If we can find a solution that folks like here, the actor table's view could use the same treatment.

Wed, Jun 5, 12:37 AM ยท cloud-services-team (Kanban), Data-Services

Tue, Jun 4

bd808 updated subscribers of T219418: Wikimania Hackathon Phabricator session(s).

@MBinder_WMF (and others!), I had an idea that I shared with @Bmueller and @Aklapper via email that may be of interest to you:

Tue, Jun 4, 10:32 PM ยท Developer-Advocacy (Jul-Sep 2019), International-Developer-Events, Wikimania-Hackathon-2019
bd808 added a comment to T224265: Redirect svgtranslate from toolserver.org.

@Samwilson could you check the patch at https://gerrit.wikimedia.org/r/#/c/operations/puppet/+/512341/ to see if it looks like it will do the redirects you want? Leaving a +1 comment there if you are satisfied would be appreciated.

Tue, Jun 4, 5:51 PM ยท cloud-services-team (Kanban), Cloud-VPS, Community-Tech (Kanban), Patch-For-Review, SVG Translate Tool
bd808 added a subtask for T188327: Deploy refactored actor storage: T225007: Update operator/user manual description of database tables changed for refactored actor storage.
Tue, Jun 4, 5:34 PM ยท MW-1.33-notes, MW-1.34-notes (1.34.0-wmf.4; 2019-05-07), Core Platform Team Kanban (Doing), MW-1.32-notes, Core Platform Team (Code Health (TEC13)), Epic
bd808 added a parent task for T225007: Update operator/user manual description of database tables changed for refactored actor storage: T188327: Deploy refactored actor storage.
Tue, Jun 4, 5:34 PM ยท Documentation, Core Platform Team (Code Health (TEC13))
bd808 created T225007: Update operator/user manual description of database tables changed for refactored actor storage.
Tue, Jun 4, 5:34 PM ยท Documentation, Core Platform Team (Code Health (TEC13))
bd808 added a project to T224265: Redirect svgtranslate from toolserver.org: cloud-services-team (Kanban).
Tue, Jun 4, 5:40 AM ยท cloud-services-team (Kanban), Cloud-VPS, Community-Tech (Kanban), Patch-For-Review, SVG Translate Tool
bd808 added a comment to T222308: Close the engineering mailing list.

+1 to close

Tue, Jun 4, 12:10 AM ยท Wikimedia-Mailing-lists, Operations

Mon, Jun 3

bd808 added a comment to T87001: Provide basic page view metrics for individual tools on toollabs.

Unfortunately there is a PHP 7.2 dependency. This is only to use Krinkle's Intuition i18n framework. Everything else is just JS/CSS.

That said, https://tools.wmflabs.org, https://toolsadmin.wikimedia.org/, etc. don't appear to be localized (that's not a complaint), so maybe we don't need to localize Toolviews either? This way the frontend and the API could live on the same tool account, assuming it's trivial for the Python3 Flask webservice to serve static assets. Basically I could end up giving you three files: the HTML, JS and CSS.

Mon, Jun 3, 11:03 PM ยท cloud-services-team (Kanban), Toolforge
bd808 updated the task description for T224192: Onboard jhedden to Wikimedia Foundation as SRE in Cloud Services.
Mon, Jun 3, 11:00 PM ยท Patch-For-Review, cloud-services-team (Kanban)
bd808 changed the edit policy for Clouds & Unicorns.
Mon, Jun 3, 10:58 PM ยท cloud-services-team
bd808 created P8583 https://tools.wmflabs.org/swviewer/test/test.php.
Mon, Jun 3, 10:18 PM
bd808 added a project to T224892: Installing the striker role fails with " Couldn't load manifest 'staticfiles.json'": Striker.

I found a few bug reports with a web search that point to this being something new that happened to some people after upgrading to Django 2. I'm not sure that I have done a clean install of the role since we did that ourselves, so that could explain why I haven't seen this problem myself yet.

Mon, Jun 3, 3:20 PM ยท Striker, MediaWiki-Vagrant
bd808 added a comment to T87001: Provide basic page view metrics for individual tools on toollabs.

As a tool provider it would (also) be nice to have the data transposed - so to speak: Eg. https://tools.wmflabs.org/toolviews/api/v1/tool/scholia where the returned data is across multiple days.

Mon, Jun 3, 4:40 AM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T87001: Provide basic page view metrics for individual tools on toollabs.

Would it be possible to for me to use the toolviews account? I see https://tools.wmflabs.org/toolviews/ says "coming soon"; and frankly, "Toolviews" is the most fitting name :)

Mon, Jun 3, 4:22 AM ยท cloud-services-team (Kanban), Toolforge
bd808 added a project to T217647: Table field templatelink.tl_from in database does not always match page.page_namespace: DBA.

This does not seem to be specific to the Wiki Replicas. It looks like this is some data corruption/drift in the production database tables:

wikiadmin@10.64.16.33(dewiki)> SELECT page_id, page_title, page_namespace, tl_title, tl_from, tl_from_namespace FROM templatelinks JOIN page ON tl_from = page_id WHERE tl_from_namespace = 2 and tl_title = 'Boolandnot' and tl_from = 10427306;
+----------+---------------------+----------------+------------+----------+-------------------+
| page_id  | page_title          | page_namespace | tl_title   | tl_from  | tl_from_namespace |
+----------+---------------------+----------------+------------+----------+-------------------+
| 10427306 | Aishwarya_von_Nepal |              0 | Boolandnot | 10427306 |                 2 |
+----------+---------------------+----------------+------------+----------+-------------------+
1 row in set (0.00 sec)
Mon, Jun 3, 4:14 AM ยท MediaWiki-Database, Data-Services
bd808 moved T224850: Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas from Backlog to Wiki replicas on the Data-Services board.
Mon, Jun 3, 3:57 AM ยท cloud-services-team (Kanban), Data-Services
bd808 created T224850: Offer alternate views of the comment and actor tables which only check for supression in a single table in the Wiki Replicas.
Mon, Jun 3, 3:49 AM ยท cloud-services-team (Kanban), Data-Services
bd808 added a comment to T106144: Make an evacuation plan for labs instances.

@Andrew I know that you have manually done this quite a few times in the past year. Do you feel that the process is sufficiently documented and automated now, or should we be looking to do more work in this area in the coming months?

Mon, Jun 3, 2:40 AM ยท Cloud-VPS, cloud-services-team (Kanban)
bd808 closed T218987: puppet_alert.py - "It has been 86400 seconds since last Puppet run.Sending nag emails." as Resolved.
Mon, Jun 3, 2:38 AM ยท Cloud-VPS, cloud-services-team (Kanban)
bd808 closed T218987: puppet_alert.py - "It has been 86400 seconds since last Puppet run.Sending nag emails.", a subtask of T132324: Tracking and Reducing cron-spam to root@ , as Resolved.
Mon, Jun 3, 2:38 AM ยท Patch-For-Review, Operations

Sat, Jun 1

bd808 added a comment to T151704: Freenode sometimes throttles bot connections from tools.

1559347684 00:08:04 [card] -!- stashbot [~stashbot@wikimedia/bot/stashbot]

the ~ means no response

Sat, Jun 1, 12:13 AM ยท Patch-For-Review, cloud-services-team (Kanban), wikimedia-irc-freenode, Toolforge

Fri, May 31

bd808 updated subscribers of T87001: Provide basic page view metrics for individual tools on toollabs.

@MusikAnimal Hey! This is the project I was talking to you about at the Prague Hackathon. There is currently a web interface at https://tools.wmflabs.org/toolviews/api/v1/day/2019-05-31 that returns a json dump of each day's traffic stats. The web service is a really simple flask app with no consumers yet, so I can tweak the response any way you'd like to make it easier for you to put a pretty UI on it. It would be pretty awesome if we could generate topviews and siteviews style visualizations of this raw data. Let me know your thoughts about how we might accomplish that without me learning a whole lot about modern javascript UIs. :)

Fri, May 31, 11:25 PM ยท cloud-services-team (Kanban), Toolforge
bd808 added a comment to T151704: Freenode sometimes throttles bot connections from tools.

after speaking with a staffer today there is no issue adding an iline but the box needs to ensure an ident daemon is running for so each individual user with access has a unique identity for them or their bots. if staff see refusals they will easily up the limit for the host, but with a workaround in place they aren't likely to see such

Fri, May 31, 11:17 PM ยท Patch-For-Review, cloud-services-team (Kanban), wikimedia-irc-freenode, Toolforge
bd808 closed T218038: NFS issue affecting Toolforge SGE master as Resolved.

Has not recurred in last 2 months, so probably an unfortunate NFS issue.

Fri, May 31, 11:11 PM ยท cloud-services-team (Kanban), Toolforge
bd808 closed T224272: Request increased quota for sso Cloud VPS project as Resolved.
$ neutron quota-update --tenant-id sso --floatingip 1
+---------------------+-------+
| Field               | Value |
+---------------------+-------+
| floatingip          | 1     |
| network             | 10    |
| port                | 50    |
| rbac_policy         | 10    |
| router              | 10    |
| security_group      | 40    |
| security_group_rule | 100   |
| subnet              | 10    |
| subnetpool          | -1    |
+---------------------+-------+
Fri, May 31, 11:07 PM ยท cloud-services-team (Kanban), Cloud-VPS (Quota-requests)
bd808 closed T224057: Request increased quota for Automation Framework Cloud VPS project as Resolved.
Fri, May 31, 10:59 PM ยท Cloud-VPS (Quota-requests)
bd808 added a comment to T224057: Request increased quota for Automation Framework Cloud VPS project.
$ sudo wmcs-openstack quota show automation-framework
+----------------------+----------------------+
| Field                | Value                |
+----------------------+----------------------+
| cores                | 8                    |
| fixed-ips            | 200                  |
| floating_ips         | 0                    |
| floatingip           | 0                    |
| injected-file-size   | 10240                |
| injected-files       | 5                    |
| injected-path-size   | 255                  |
| instances            | 8                    |
| key-pairs            | 100                  |
| network              | 10                   |
| port                 | 50                   |
| project              | automation-framework |
| properties           | 128                  |
| ram                  | 16384                |
| rbac_policy          | 10                   |
| router               | 10                   |
| secgroup-rules       | 100                  |
| secgroups            | 40                   |
| server_group_members | 10                   |
| server_groups        | 10                   |
| subnet               | 10                   |
| subnetpool           | -1                   |
+----------------------+----------------------+
$ sudo wmcs-openstack quota set --cores 10 --ram 20480 --instances 10 automation-framework
$ sudo wmcs-openstack quota show automation-framework
+----------------------+----------------------+
| Field                | Value                |
+----------------------+----------------------+
| cores                | 10                   |
| fixed-ips            | 200                  |
| floating_ips         | 0                    |
| floatingip           | 0                    |
| injected-file-size   | 10240                |
| injected-files       | 5                    |
| injected-path-size   | 255                  |
| instances            | 10                   |
| key-pairs            | 100                  |
| network              | 10                   |
| port                 | 50                   |
| project              | automation-framework |
| properties           | 128                  |
| ram                  | 20480                |
| rbac_policy          | 10                   |
| router               | 10                   |
| secgroup-rules       | 100                  |
| secgroups            | 40                   |
| server_group_members | 10                   |
| server_groups        | 10                   |
| subnet               | 10                   |
| subnetpool           | -1                   |
+----------------------+----------------------+
Fri, May 31, 10:59 PM ยท Cloud-VPS (Quota-requests)
bd808 updated the task description for T224192: Onboard jhedden to Wikimedia Foundation as SRE in Cloud Services.
Fri, May 31, 9:31 PM ยท Patch-For-Review, cloud-services-team (Kanban)
bd808 added a member for Security: JHedden.
Fri, May 31, 9:31 PM
Bstorm awarded T224192: Onboard jhedden to Wikimedia Foundation as SRE in Cloud Services a Party Time token.
Fri, May 31, 9:19 PM ยท Patch-For-Review, cloud-services-team (Kanban)
bd808 added a comment to T221657: 500 error when deleting ssh key from toolsadmin.

Is anything holding back the gerrit patch?

Fri, May 31, 4:30 PM ยท Patch-For-Review, cloud-services-team (Kanban), Striker
bd808 added a comment to T224708: Drop most of mwopenstackclients.DnsManager in favour of designateclient.

All of this is replaceable with the stuff under designateclient.zones and designateclient.recordsets, except the ensure stuff which probably belongs in applications rather than the library.

Fri, May 31, 3:21 AM ยท Patch-For-Review, Cloud-VPS
bd808 added a comment to T224708: Drop most of mwopenstackclients.DnsManager in favour of designateclient.

There are some parts of DnsManager that are worth keeping, but we should definitely replace the _* private methods that are hacking in support for the X-Auth-Sudo-Tenant-ID header with the proper upstream client library.

Fri, May 31, 2:18 AM ยท Patch-For-Review, Cloud-VPS