Failed to start MySQL Community Server

[nguyenminh]

Hello everyone,

I installed Zabbix on Ubuntu 18.04 on VMWare, then I restart server. After that, I login to the web and have a trouble: "Error connecting to database: No such file or directory".

- I try to restart mysql service and server reply:

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.

- I run "systemctl status mysql.service", and server reply:

● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)          
Active: [COLOR=#FF0000]failed [/COLOR](Result: exit-code) since Mon 2019-06-24 07:24:39 UTC; 53min ago              
Process: 6282 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code  
Process: 6258 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/S
Jun 24 07:24:39 zabbix systemd[1]: mysql.service: Service hold-off time over, scheduling resta
Jun 24 07:24:39 zabbix systemd[1]: mysql.service: Scheduled restart job, restart counter is at
Jun 24 07:24:39 zabbix systemd[1]: Stopped MySQL Community Server.
Jun 24 07:24:39 zabbix systemd[1]: mysql.service: Start request repeated too quickly.        
Jun 24 07:24:39 zabbix systemd[1]: mysql.service: Failed with result 'exit-code'.            
Jun 24 07:24:39 zabbix systemd[1]: [COLOR=#FF0000]Failed to start MySQL Community Server.  [/COLOR]

I search google, and do something, but it's not work. So, please help me to fix this error.

Many thanks

[wreckeur]

Hi all,
I am having this exact same issue. I set up Zabbix last week and it ran all week with no issues, then this morning everything was dead in the water. I rebooted the server and was hit with the "Failed to start MySQL Community and received all of the above output.

I'm hoping someone can point me in the right direction.

[wreckeur]

I tried to update my post with this screenshot of the output I received, but I'm not allowed to edit my own posts

[mmarbury]

Did you guys figure this out?

[wreckeur]

I ended up restoring from backup and kinda starting over. It wasn't that big of a deal for me since I hadn't been using it for very long so there wasn't a lot of data lost.

[mmarbury]

I remembered that I'd always used MariaDB for Zabbix so I switched to that. Problem solved.

[Инна]

Добрый день! Не получается запустить сервис mysql. Помогите разобраться
Выходит ошибка : 2024-12-17T09:00:03.985224Z 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 5 in a file operation.
2024-12-17T09:00:03.985298Z 0 [ERROR] [MY-012596] [InnoDB] Error number 5 means 'Input/output error'
2024-12-17T09:00:03.985336Z 0 [ERROR] [MY-012646] [InnoDB] File ./zabbix/history.ibd: 'Linux aio' returned OS error 105. Cannot continue operation
2024-12-17T09:00:03.985476Z 0 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.