PKG update broken MYSQL mysql Undefined symbol "pthread_setname_np@FBSD_1.6"

[csjjpm]

Good evening everyone.

I have a jail that I have installed apache and mysql on and it has been working for a couple of years.
system is 12.0-U6.1
jail version is 12.1-RELEASE-p13
Mysql version is 8.0.27 for FreeBSD 12.2


I have just performed a pkg update && pkg upgrade in a jail and mysql no longer works.
The err file shows this error

2021-12-20T22:28:33.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol "pthread_setname_np@FBSD_1.6"
2021-12-20T22:28:35.6NZ mysqld_safe mysqld from pid file /var/db/mysql/famp-server.pid ended
2021-12-20T22:40:11.6NZ mysqld_safe Logging to '/var/db/mysql/famp-server.err'.

Can anyone advise how I solve this or roll back to before the pkg upgrade?

Also let me know if there is anything else you need to help me work out the cause.

thank you
Paul

 

[Jailer]

Can anyone advise how I solve this or roll back to before the pkg upgrade?

FreeBSD 12.1 is no longer supported. Upgrade the jail to 12.2 and you should be able to get everything working again.

 

[csjjpm]

FreeBSD 12.1 is no longer supported. Upgrade the jail to 12.2 and you should be able to get everything working again.

Good morning. So I've done that and in the process the upgrade has uninstalled dozens of php related packages which were installed before like mbstring, iconv, nano (and many more). All sorts of my tools stopped working like phpmyadmin, nextcloud, bookstack etc. I am slowly trying to work out what pkgs I need to now reinstall.