Database error with Zabbix 7.0.30 and mySQL

[hrrapozo]

This morning (9/1/26) both my test and production systems which run Ubuntu 24.04.04 LTS, Zabbix 7.0.30 and mySQL gave a Database error when attempting to access their webpage (screen shot is below).

Right now I am trying to shutdown the zabbix server (via sudo systemctl stop zabbix-server) but it is taking a while to do.

When doing a apt list --upgradable on the production system it notes that there are 5 updates relating to mysql

apt list --upgradable
coreutils/noble-updates,noble-security 9.4-3ubuntu6.3 amd64 [upgradable from: 9.4-3ubuntu6.2]
cpio/noble-updates,noble-security 2.15+dfsg-1ubuntu2.1 amd64 [upgradable from: 2.15+dfsg-1ubuntu2]
diffutils/noble-updates,noble-security 1:3.10-1ubuntu0.1 amd64 [upgradable from: 1:3.10-1build1]
libmysqlclient21/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 amd64 [upgradable from: 8.0.46-0ubuntu0.24.04.3]
libpython3.12-minimal/noble-updates 3.12.3-1ubuntu0.16 amd64 [upgradable from: 3.12.3-1ubuntu0.15]
libpython3.12-stdlib/noble-updates 3.12.3-1ubuntu0.16 amd64 [upgradable from: 3.12.3-1ubuntu0.15]
libpython3.12t64/noble-updates 3.12.3-1ubuntu0.16 amd64 [upgradable from: 3.12.3-1ubuntu0.15]
libssh-4/noble-updates,noble-security 0.10.6-2ubuntu0.5 amd64 [upgradable from: 0.10.6-2ubuntu0.4]
libudisks2-0/noble-updates,noble-security 2.10.1-6ubuntu1.5 amd64 [upgradable from: 2.10.1-6ubuntu1.3]
mysql-client-8.0/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 amd64 [upgradable from: 8.0.46-0ubuntu0.24.04.3]
mysql-client-core-8.0/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 amd64 [upgradable from: 8.0.46-0ubuntu0.24.04.3]
mysql-server-8.0/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 amd64 [upgradable from: 8.0.46-0ubuntu0.24.04.3]
mysql-server-core-8.0/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 amd64 [upgradable from: 8.0.46-0ubuntu0.24.04.3]
mysql-server/noble-updates,noble-security 8.0.46-0ubuntu0.24.04.4 all [upgradable from: 8.0.46-0ubuntu0.24.04.3]
python3.12-minimal/noble-updates 3.12.3-1ubuntu0.16 amd64 [upgradable from: 3.12.3-1ubuntu0.15]
python3.12/noble-updates 3.12.3-1ubuntu0.16 amd64 [upgradable from: 3.12.3-1ubuntu0.15]
udisks2/noble-updates,noble-security 2.10.1-6ubuntu1.5 amd64 [upgradable from: 2.10.1-6ubuntu1.3]

Anyway I am just wondering if anyone else is suffering from this same problem?

[tim.mooney]

Ubuntu defaults to auto-applying updates, at least for security-related updates. I don't know if updates are turned on for everything, or just for security; I don't run Ubuntu so I'm not certain.

Security updates were released that impact mysql. You can see them in the list you show, along with other updates.

Either the updates failed to apply (for some reason) or something else with the updates went wrong, because mysql was shut down as part of the update process that never happened. That's why you're seeing the database error. The system shut it down as part of automated updates, but didn't complete the automated updates.

The zabbix_server basically requires a database of some type (in your case, mysql) at all times. It's still running, but it's not healthy. In addition, the service file that starts zabbix_server will wait a really long time for the database to be "ready". The developers did that for a reason and I'm certain it's a good one, but in situations like this, where the database goes away unexpectedly, it can make restarts difficult.

If you can manually apply all the updates, do so. Then reboot. I think everything should come back once you've updated the database and it's willing to start up.