WordPress.org

Dion Hulse 4:55 am on July 21, 2021
Tags: prio1 ( 39 )

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

Barry 12:00 am on July 23, 2021

wp_versions is fixed but archival_wp_versions will need to be restored from a backup as it crashes the server when trying to fix the table. Working on it…
Barry 12:21 am on July 23, 2021

Both tables are fixed and disabled maint mode. FWIW I think the maintenance mode flag should be in code, not the db 🙂
- Dion Hulse 4:11 am on July 23, 2021
  
  Thank you!
  
  And yes, I agree, I’ll see about streamlining the various independant stats scripts and moving it to a centralised config (The DB was used here, because there wasn’t a centralised config for it, and I needed something ASAP to get SOTW stats done IIRC.).