mysql service is shutdown auto in Ubuntu,

[nczaw]

Hi all,

I'm running Zabbix 7.2.2 on Ubuntu 24 LTS with MySQL. I got the log below, and it looks like the MySQL service is RECEIVE SHUTDOWN, and I can't start it manually. However, after rebooting the VM, it starts fine. Has anyone experienced this issue before?

2025-02-21T06:44:02.291959Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.41-0ubuntu0.24.04.1).
2025-02-21T06:44:04.296743Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127536 user: 'zabbix'.
2025-02-21T06:44:04.296835Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127554 user: 'zabbix'.
2025-02-21T06:44:04.296877Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127570 user: 'zabbix2'.
2025-02-21T06:44:04.296948Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127539 user: 'zabbix'.
2025-02-21T06:44:04.297177Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127548 user: 'zabbix'.
2025-02-21T06:44:04.297224Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127540 user: 'zabbix'.
2025-02-21T06:44:04.297255Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127565 user: 'zabbix'.
2025-02-21T06:44:04.297288Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127541 user: 'zabbix'.
2025-02-21T06:44:04.297349Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127551 user: 'zabbix'.
2025-02-21T06:44:04.297388Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127543 user: 'zabbix'.
2025-02-21T06:44:04.297443Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 127535 user: 'zabbix'.
2025-02-21T06:44:07.080754Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).

[nickologicsnmp]

Yes, I am experiencing the same issue. I am running Zabbix V7 with Ubuntu 24.04.1 LTS

@zabbix:~$ tail /var/log/mysql/error.log

2025-02-26T07:05:05.162641Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5604 user: 'zabbix'.
2025-02-26T07:05:05.163624Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5620 user: 'zabbix'.
2025-02-26T07:05:05.163766Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5613 user: 'zabbix'.
2025-02-26T07:05:05.164646Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5605 user: 'zabbix'.
2025-02-26T07:05:05.164843Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5614 user: 'zabbix'.
2025-02-26T07:05:05.165530Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5606 user: 'zabbix'.
2025-02-26T07:05:05.165706Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5615 user: 'zabbix'.
2025-02-26T07:05:05.166799Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5599 user: 'zabbix'.
2025-02-26T07:05:05.166958Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 5623 user: 'zabbix'.
2025-02-26T07:05:06.892762Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.41-0ubuntu0.24.04.1) (Ubuntu).


When I reboot the server works fine
Thanks
Nick

[Managor]

I encountered this and I assume the root cause of this is apt-daily-upgrade.timer. The time the service ran and when mysql died seemed to align. Can anyone confirm if the dates on your systems align?