Glam: Difference between revisions
| Line 5: | Line 5: | ||
=== Full drive due to logging === | === Full drive due to logging === | ||
Mariadb was not happy and generated 10's of GB of logging... | Mariadb was not happy and generated 10's of GB of logging... | ||
root@glam:/var/log# tail syslog.1 | |||
2025-09-14T00:00:02.262984+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB'). | 2025-09-14T00:00:02.262984+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB'). | ||
2025-09-14T00:00:02.263026+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255). | 2025-09-14T00:00:02.263026+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255). | ||
Revision as of 13:53, 18 September 2025
History
Full drive due to logging
Mariadb was not happy and generated 10's of GB of logging...
root@glam:/var/log# tail syslog.1
2025-09-14T00:00:02.262984+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2025-09-14T00:00:02.263026+00:00 glam mariadbd[1076]: 2025-09-14 0:00:02 1908080 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
Upgrade to Ubuntu 22.04
- PHP on Apache2: 22.04 uses PHP 8.1. Everything seemed to upgrade just fine, but wordpress, mediawiki, etc. stopped working. I browsed to https://bitpost.com/wiki to confirm that php was being displayed as code, not run. After a shitton of wasted time, I found that the PHP Apache mod simply needed to be enabled. WHY???
sudo a2enmod php8.1
- mariadb upgrade failed because it did not know my root password. Just upgrade manually:
sudo mariadb-upgrade
- wordpress news site took some heavy damage with all the updating, needs some widget love