DB stats table repair – new-api-stats

Looks like db2.stats has some corrupt tables, looks like wp_versions and archival_wp_versions are affected.

This has caused WP version stats to cease to operate as expected: https://wordpress.org/about/stats/

I’ve put the stats scripts into maintenance mode to prevent it trying to write to these tables (while still processing autoupdate stats/etc), if I’m not around to do it myself, please execute UPDATE `rev2_ingestion_settings` SET `value` = '0' WHERE `key` = 'maintenance_mode'; afterwards to re-enable it, if possible.

#prio1

Hi, can the following users…

Hi, can the following users get MC and GA access for dotorg? Release management is not needed, it’s for stats.

  • callye
  • dansoschin
  • eidolonnight

#prio2

cc @andreamiddleton

Patterns API: maybe cache/direct to proper upstreams

https://api.wordpress.org/patterns/1.0/ will start to receive increased GET API requests following Gutenberg PR 28800 being merged, and ultimately being used in WordPress 5.8.

I’m unsure what the request load will be to this endpoint, or how varied the requests will be at this stage, so just flagging this early for attention.

Currently this APIAPI An API or Application Programming Interface is a software intermediary that allows programs to interact with each other and share data in limited, clearly defined ways. endpoint is handled by the catchall API upstream pool, it might make sense to shift this into the coreCore Core is the set of software required to run WordPress. The Core Development Team builds WordPress. or plugins/themes API pools.

The API currently assumes that it’ll be cached by nginxNGINX NGINX is open source software for web serving, reverse proxying, caching, load balancing, media streaming, and more. It started out as a web server designed for maximum performance and stability. In addition to its HTTP server capabilities, NGINX can also function as a proxy server for email (IMAP, POP3, and SMTP) and a reverse proxy and load balancer for HTTP, TCP, and UDP servers. https://www.nginx.com/. (which it’s not), and loads WordPress on every API request. No caching is included at present, other than standard WordPress object caching.
The API only accepts GET requests.

Requests to this endpoint will be all GET and potentially of high volume with similar cacheable responses:

  • GET https://api.wordpress.org/patterns/1.0/?pattern-keywords=11
  • GET https://api.wordpress.org/patterns/1.0/?pattern-categories=1234
  • GET https://api.wordpress.org/patterns/1.0/?search=gallery
  • GET https://api.wordpress.org/patterns/1.0/?pattern-keywords=11&search=gallery
  • GET https://api.wordpress.org/patterns/1.0/?pattern-categories=1234&search=instagram

cc @iandunn

#prio1

Sandbox out of space Similar…

Sandbox out of space

Similar to Ian’s post in December, except I don’t immediately see things in tmp causing issues.

I’m not able to run svn cleanup due to being out of space.

Thanks in advance.

#prio-2

Vary nginx cache by wporg_locale cookie value

This cookie gets set by the locale-detection pluginPlugin A plugin is a piece of software containing a group of functions that can be added to a WordPress website. They can extend functionality or add new features to your WordPress websites. WordPress plugins are written in the PHP programming language and integrate seamlessly with WordPress. These can be free in the WordPress.org Plugin Directory https://wordpress.org/plugins/ or can be cost-based plugin from a third-party, which is used on the login site, and soon on the Learn WordPress site. In the case of Learn, the value of this cookie will determine the language that is displayed in the front end UIUI UI is an acronym for User Interface - the layout of the page the user interacts with. Think ‘how are they doing that’ and less about what they are doing. of the site (see this PR). Caching the pages without consideration of the chosen locale has a lot of potential for bad UXUX UX is an acronym for User Experience - the way the user uses the UI. Think ‘what they are doing’ and less about how they do it..

Could we update the nginxNGINX NGINX is open source software for web serving, reverse proxying, caching, load balancing, media streaming, and more. It started out as a web server designed for maximum performance and stability. In addition to its HTTP server capabilities, NGINX can also function as a proxy server for email (IMAP, POP3, and SMTP) and a reverse proxy and load balancer for HTTP, TCP, and UDP servers. https://www.nginx.com/. config to take this cookie into account when caching wporg pages? This locale switching functionality is intended for use on various wp.org sites beyond just Learn, so ideally this change would apply for *.wordpress.org

#prio1 because we’d like to get the locale switcher launched on the Learn site soon.

Repair translations table.

Occasionally we’ve been seeing PHPPHP PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. http://php.net/manual/en/intro-whatis.php. warnings that the translation table is crashed:

Table ‘translate_translations’ is marked as crashed and should be repaired

This seems to have been happening sporadically for the last year or so, while running a translation job however, I ran into this and tracked it down to a range of IDs which appear to be inaccessible:

SELECT * FROM translate_translations WHERE id BETWEEN 43611019 AND 43611031;

Those IDs are accessible, but the 10 between them are not.

Can something be done, even if it’s to repair the table and remove those records in the process.

#prio1

Update gutenberg.run `A` record

Hi, can you please update the A record for gutenberg.run to point to 165.22.42.103?

The current record points to a droplet under @aduth‘s personal account, and we’d like to change it to a Foundation account that several of us have access to. DigitalOcean doesn’t allow transferring droplets, so we had to setup a new one, hence the IP change.

#prio2

DNS hosting for gutenberg.run

Hi, I’m working w/ @aduth to transfer the gutenberg.run domain to the Foundation. MarkMonitor has initiated the transfer, can you please setup DNSDNS DNS is an acronym for Domain Name System - how you assign a human readable address to a website’s exact numeric coded location (ie. wordpress.org uses the actual IP address 198.143.164.252). hosting on our end, and update the nameservers w/ MM after the domain lands?

I think the only needed record is an A to 138.197.4.192, and the www CNAME.

#prio1 (since the old registrar is currently doing DNS hosting)

Thanks!

Update *.git.wordpress.org to rename `master` to `trunk`.

WordPress CoreCore Core is the set of software required to run WordPress. The Core Development Team builds WordPress. has decided to rename from master to trunk on all repo’s: https://make.wordpress.org/core/2020/06/18/proposal-update-all-git-repositories-to-use-main-instead-of-master/ and Gutenberg did that over here: https://github.com/WordPress/gutenberg/issues/27741

This is primarily for https://github.com/wordpress/wordpress/ & https://github.com/wordpress/wordpress-develop/ ( core.git.wordpress.org & develop.git.wordpress.org) but could also be applied to all of the git mirrors for simplicity.

The full list of *.git.wordpress.orgWordPress.org The community site where WordPress code is created and shared by the users. This is where you can download the source code for WordPress core, plugins and themes as well as the central location for community conversations and organization. https://wordpress.org/ mirrors are the following AFAIK, and all can be updated without issue, as all the projects listed will just follow core’s direction here. I don’t know how this will affect the *.git => githubGitHub GitHub is a website that offers online implementation of git repositories that can can easily be shared, copied and modified by other developers. Public repositories are free to host, private repositories require a paid subscription. GitHub introduced the concept of the ‘pull request’ where code changes done in branches by contributors can be reviewed and discussed before being merged be the repository owner. https://github.com/ syncing process and/or what will need to change on GitHub.
– core.git.wordpress.org
– develop.git.wordpress.org
– backpress.git.wordpress.org
– bbpress.git.wordpress.org
– buddypress.git.wordpress.org
– glotpress.git.wordpress.org
– meta.git.wordpress.org

Can we make the change to our git mirrors please?

Requested via https://wordpress.slack.com/archives/C02QB8GMM/p1614648674097800

cc @noisysocks @jorbin

#prio2

Relax chinese rate limiting for Trac

In https://make.wordpress.org/systems/2020/03/21/re-evaluate-the-chinese-rate-limiting/ the rate limit for chinese traffic was relaxed, but it looks like Trac still has a rate limit in place.

Can we relax the rate limit for TracTrac Trac is the place where contributors create issues for bugs or feature requests much like GitHub.https://core.trac.wordpress.org/. as well?

If DOS traffic is still an issue, is it at all possible for logged in traffic to bypass the limits?

Ref: https://wordpress.slack.com/archives/C02QB8GMM/p1612868603196000

#prio2