Glam: Difference between revisions
| Line 2: | Line 2: | ||
== History == | == History == | ||
=== Full drive due to logging === | |||
Mariadb was not happy and generated 10's of GB of logging... | |||
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 === | === 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??? | * 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??? | ||
Revision as of 13:52, 18 September 2025
History
Full drive due to logging
Mariadb was not happy and generated 10's of GB of logging...
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