Note
I upgraded an OpenBSD server from 6.9 to 7.0 the other day which updated MariaDB server from 10.5.9 to 10.6.4 and mariadbd started crashing this evening with an InnoDB assertion failure on a specific query (reproducible) even after a clean re-import of the entire database. \
There's a warning on
https://mariadb.com/kb/en/mariadb-1064-release-notes/ (thanks @jimh_@twitter.com) about file corruption on FreeBSD (
https://jira.mariadb.org/browse/MDEV-26537) which might be the same issue. I'll have to debug after my hair is no longer on fire.
Just a heads up for anyone else having MariaDB crashes on OpenBSD 7.0.
Ok false alarm, I don't think it's related to that FreeBSD corruption issue. I filed a new issue for my crash and rolled back to mariadb-{server,client} 10.5.9 packages for now: