Zabbix Proxy: MariaDB: Fails with error code: How do I fix?

[TecDragon]

Zabbix Proxy 6.2
Ubuntu Server 22.04

Recently upgraded main Zabbix server and all 25 proxies to Ubuntu 22.04 most of which where successful. I have 4 proxies servers that wont start Mariadb. Googling is a lot of people said to drop the tables and recreate then reboot. But none of them showed how to do that, so how do you do that? Or is that even what I need to do to fix it?

Sudo service mysql status
Failed
Failed to start MariaDB 10.6.9 database server

journalctl -xeu mariadb.service
THe job identifier is 1310 and the job result is failed
A start job for unit mariadb.service has finished with a failure

Zabbix proxy log
connection to database 'zabbix_proxy' failed: Cant connect to local mysql sever through socket /var/run/mysqld/mysqld.sock

[TecDragon]

Took me a while to figure this one out. Posting the solution incase someone else needs the help.

Two ways to fix so far
1. Rebuild your proxy from the ground up
2. go to cd /var/lib/mysql look for any ib_logfile will be followed by a number such as 0,1,2 etc - then delete it\them sudo rm ib_logfile0 afterwhich restart the service sudo service mysql start let it run for a minute and then reboot - why reboot? because sometimes the file is incorrectly recreated after rebooting and you have to do the steps above twice.

fixed my problem, hope it helps.