MySQL Server Configuration creating error

jfeuzeu · December 7, 2021, 10:48pm

Ubuntu
20.04.3

I’m getting an error (Failed to save MySQL server options :
Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.) after entering some values in MySQL Database Server and clicking on “Save and Restart MySQL”.
You could do the following to repeat my error.

Install Ubuntu 20.04 on a server
Via SSH, install Webmin and Virtualmin with these two steps.
wget https://software.virtualmin.com/gpl/scripts/install.sh
sudo /bin/sh install.sh
Log in and Navigate to Webmin/Server/MySql Database Server configuration page.
Enter 16 MB in the Query cache size in bytes field and select“Default”, 512MB in the Maximum packet size field and select “Default”, and 64 kB in the MyISAM sort buffer size field and select “Default”
Click on “Save and Restart my Sql” and you will see that error.

Joe · December 7, 2021, 11:02pm

What is the actual error?

i.e. follow the instructions and check systemctl status mysql and journalctl -xe

jfeuzeu · December 7, 2021, 11:04pm

Error: systemctl status mysql.service” and “journalctl -xe” for details.) after entering some values in MySQL Database Server and clicking on “Save and Restart MySQL

systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start) since Tue 2021-12-07 04:41:37 EST; 743ms ago
Process: 89827 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 89835 (mysqld)
Status: “Server startup in progress”
Tasks: 30 (limit: 9485)
Memory: 352.1M
CGroup: /system.slice/mysql.service
└─89835 /usr/sbin/mysqld

jfeuzeu · December 7, 2021, 11:05pm

The error described here (journalctl -xe) was very long.

Joe · December 7, 2021, 11:07pm

Try restarting the mysql service systemctl restart mysql and then immediately check the journal…problems related to mysql will begin with mysql. We need to see those errors.

You can also tail the mysql unit in another terminal session with journalctl -fu mysql. That will only show mysql errors, and will show new entries as they happen. We need to see one restart attempt worth of logs. (Probably not more than a few lines.)

jfeuzeu · December 7, 2021, 11:11pm

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

jfeuzeu · December 7, 2021, 11:14pm

This won’t output anything.

jfeuzeu · December 7, 2021, 11:19pm

– Logs begin at Tue 2021-12-07 17:27:40 EST. –

Dec 07 18:17:01 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 11.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:02 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 12.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:04 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 13.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:06 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 14.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:09 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 15.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:11 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 16.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:13 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:15 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 17.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:16 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 18.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:18 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 19.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:20 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:22 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 20.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:23 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 21.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:25 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:27 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 22.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:28 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 23.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:30 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 24.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:32 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 25.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:34 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:36 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 26.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:37 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 27.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:39 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:41 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 28.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:42 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 29.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:44 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 30.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:46 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:48 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 31.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:49 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 32.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:51 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 33.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:53 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 34.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:55 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:17:57 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 35.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:17:58 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 36.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:00 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 37.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:02 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 38.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:05 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 39.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:07 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 40.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:10 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 41.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:12 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 42.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:14 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 43.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:17 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 44.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:19 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 45.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:22 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 46.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:24 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 47.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:26 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 48.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:29 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Failed with result ‘exit-code’.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Failed to start MySQL Community Server.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: mysql.service: Scheduled restart job, restart counter is at 49.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Stopped MySQL Community Server.

Dec 07 18:18:31 vmi734854.contaboserver.net systemd[1]: Starting MySQL Community Server…

I just copied part of it, it’s very long.

Joe · December 7, 2021, 11:28pm

Pretty sure this is not the Ubuntu MySQL package. Check to see what mysql packages are installed with dpkg -l | grep -i mysql. If it is a third party package (including the one provided by the MySQL team), it is not supported. You’re on your own with third party packages…Virtualmin will support it, but it will not be configured correctly out of the box to use it (and I don’t recommend you use it, if you don’t really know what you’re doing).

If this is not the Ubuntu MySQL package (as I’m pretty confident it is not) you should start with a fresh OS install without third party packages installed, instead of whatever this is.

Joe · December 7, 2021, 11:36pm

Huh, actually, it does appear the Ubuntu standard package does refer to itself that way. That’s new-ish, I think.

Nevermind. I dunno what’s going on, if you have the standard mysql-server package.

I still need to see a useful error message. Looks like you can find other logs in /var/log/mysql, probably error.log.

jfeuzeu · December 7, 2021, 11:36pm

Well, I will have to ask that question to the server provider as they provide the installation software.

jfeuzeu · December 7, 2021, 11:37pm

OK, I just read this

Joe · December 7, 2021, 11:37pm

It’s a red herring, and I’m probably wrong. I tested on a local Ubuntu install, and their MySQL package does now call itself MySQL Community Server. That used to only show up in the MySQL team’s build.

jfeuzeu · December 7, 2021, 11:38pm

How to access this log and error log?

jfeuzeu · December 7, 2021, 11:48pm

2021-12-07T23:25:57.172367Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:25:57.349802Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:25:57.465771Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:25:57.465798Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:25:57.466497Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:25:57.466527Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:25:57.468719Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:25:57.469020Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:25:58.941200Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:25:59.423170Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86036
2021-12-07T23:25:59.431670Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:25:59.633293Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:25:59.791194Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:25:59.791221Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:25:59.791831Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:25:59.791859Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:25:59.794168Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:25:59.794432Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:01.226014Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:01.915143Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86086
2021-12-07T23:26:01.923651Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:02.102747Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:02.214471Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:02.214495Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:02.215104Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:02.215131Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:02.217083Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:02.217356Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:03.706447Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:04.175340Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86136
2021-12-07T23:26:04.184503Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:04.364374Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:04.489951Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:04.489975Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:04.490797Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:04.490828Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:04.492823Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:04.493098Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:05.964710Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:06.650081Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86188
2021-12-07T23:26:06.658213Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:06.837134Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:06.950518Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:06.950553Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:06.951488Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:06.951524Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:06.954087Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:06.954412Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:08.425726Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:08.900912Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86239
2021-12-07T23:26:08.909326Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:09.088924Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:09.200770Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:09.200794Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:09.201471Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:09.201499Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:09.203347Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:09.203623Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:10.682694Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:11.146939Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86289
2021-12-07T23:26:11.154934Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:11.330340Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:11.436900Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:11.436925Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:11.437733Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:11.437762Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:11.439505Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:11.439806Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:12.920042Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:13.390190Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86339
2021-12-07T23:26:13.398180Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:13.579291Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:13.697556Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:13.697584Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:13.698273Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:13.698303Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:13.700687Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:13.701025Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:15.186024Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:15.677327Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86389
2021-12-07T23:26:15.686397Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:15.894735Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:16.077398Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:16.077433Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:16.078336Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:16.078374Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:16.080945Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:16.081300Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:17.502328Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:18.154621Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86439
2021-12-07T23:26:18.163031Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:18.341359Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:18.457291Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:18.457319Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:18.458002Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:18.458033Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:18.460006Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:18.460299Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:19.936326Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:20.398864Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86489
2021-12-07T23:26:20.407085Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:20.586352Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:20.714544Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:20.714574Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:20.715244Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:20.715273Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:20.717080Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:20.717413Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:22.204695Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:22.699765Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86539
2021-12-07T23:26:22.708798Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:22.916200Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:23.033022Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:23.033047Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:23.033753Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:23.033783Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:23.035661Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:23.035931Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:24.518123Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:25.192357Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86589
2021-12-07T23:26:25.201548Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:25.402079Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:25.521456Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:25.521491Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:25.522380Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:25.522422Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:25.525128Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:25.525516Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:26.996469Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:27.659930Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86639
2021-12-07T23:26:27.668131Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:27.852423Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:27.974177Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:27.974208Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:27.974927Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:27.974956Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:27.977178Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:27.977495Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:29.454696Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:29.921546Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86689
2021-12-07T23:26:29.930515Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:30.116119Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:30.223451Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:30.223475Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:30.224073Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:30.224100Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:30.225850Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:30.226109Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:31.708985Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:32.169508Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86739
2021-12-07T23:26:32.178083Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:32.363289Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:32.467689Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:32.467714Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:32.468320Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:32.468347Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:32.470226Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:32.470486Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:33.952985Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:34.423155Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86789
2021-12-07T23:26:34.432566Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:34.610948Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:34.728529Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:34.728561Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:34.729340Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:34.729377Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:34.732014Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:34.732309Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:36.212695Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:36.895571Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86839
2021-12-07T23:26:36.903677Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:37.078717Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:37.187850Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:37.187876Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:37.188465Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:37.188493Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:37.190378Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:37.190639Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:38.667548Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:39.138335Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86889
2021-12-07T23:26:39.146522Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:39.326493Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:39.445091Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:39.445115Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:39.445742Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:39.445771Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:39.447845Z 0 [ERROR] [MY-000067] [Server] unknown variable ‘query_cache_size=16M’.
2021-12-07T23:26:39.448151Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-07T23:26:40.919767Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.27-0ubuntu0.20.04.1) (Ubuntu).
2021-12-07T23:26:41.428343Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.27-0ubuntu0.20.04.1) starting as process 86939
2021-12-07T23:26:41.437364Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-07T23:26:41.615788Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-12-07T23:26:41.733215Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2021-12-07T23:26:41.733241Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2021-12-07T23:26:41.733892Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-12-07T23:26:41.733923Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-12-07T23:26:41.735841Z 0 [ER

jfeuzeu · December 7, 2021, 11:49pm

I only copied part of the log.

Joe · December 7, 2021, 11:56pm

So, there’s the error. This option was removed in MySQL 8.

https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed

The MySQL module in Webmin, I guess, shouldn’t let you set that option since it doesn’t exist…but, since it doesn’t exist you don’t need to set it. So, remove it from your my.cnf and restart mysql.

jfeuzeu · December 8, 2021, 12:15am

How do I remove it please?

jotst · December 8, 2021, 1:45am

Should be in my.cnf file

Sorry short break in topic:
To be sure for some information

You did write Contabo , there you did the choice for Operating system and version yes?
Preinstalled yes?
You also choose a Control panel there as for example Webmin preinstalled yes or no?

Only to get things right for the Support from Joe here , that you don’t have some preinstalled things he don’'t expect.

I know Contabo does some if you choose those in VPS…

And yes i know you did write in start topic some.

Just to be 100% sure you didn’t start with some preinstalled things before you do…
Or you use kind off their (pre) Image (s) for setup ?

Joe · December 8, 2021, 3:02am

I think the problem is understood, @jotst. No need to make it more complicated.

@jfeuzeu edit /etc/my.cnf and remove that line. It’s possible that removing the value you added in the Webmin MySQL module will also remove it, but I’m not confident of that…I don’t remember how it deals with unsetting previously set values…