Unable to start mysql service on ubuntu server

kuri

7/10/24, 5:15 AM

    rgs@rgs-PowerEdge-T710:/$ sudo systemctl restart mysql.service
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
rgs@rgs-PowerEdge-T710:/$ systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2023-07-10 07:11:25 CEST; 43s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 17811 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 17759 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 17811 (code=exited, status=1/FAILURE)
   Status: "Server shutdown complete"

jul 10 07:11:15 rgs-PowerEdge-T710 systemd[1]: Starting MySQL Community Server...
jul 10 07:11:25 rgs-PowerEdge-T710 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
jul 10 07:11:25 rgs-PowerEdge-T710 systemd[1]: mysql.service: Failed with result 'exit-code'.
jul 10 07:11:25 rgs-PowerEdge-T710 systemd[1]: Failed to start MySQL Community Server.

/var/log/mysql/error.log

2023-07-10T04:45:13.232034Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.33)  MySQL Community Server - GPL.
2023-07-10T05:11:15.862463Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.33) starting as process 17811
2023-07-10T05:11:15.874143Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-10T05:11:24.651270Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-07-10T05:11:24.663489Z 1 [ERROR] [MY-011092] [Server] Upgrading the data dictionary from dictionary version '1' is not supported.
2023-07-10T05:11:24.663780Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-07-10T05:11:24.663814Z 0 [ERROR] [MY-010119] [Server] Aborting

0 + 5

mysql

18.04

rfm

7/10/24, 5:57 AM

There may be more information in /var/lib/mysql/log/error.log -- share the last bits if so.

kuri

7/10/24, 6:06 AM

@guiverc, my bad - I am using Ubuntu 18.04.6 LTS. I have corrected the tags

kuri

7/10/24, 6:07 AM

@rfm error.log output is added in the question summary

guiverc

7/10/24, 6:21 AM

[Ubuntu 18.04 LTS has reached the end of it's *standard* support life](https://fridge.ubuntu.com/2023/05/13/extended-security-maintenance-for-ubuntu-18-04-bionic-beaver-begins-31-may-2023/) thus is now off-topic here unless your question is specific to helping you move to a *fully supported* release of Ubuntu. Ubuntu 18.04 ESM support is available, but not on-topic here, see https://askubuntu.com/help/on-topic See also https://ubuntu.com//blog/18-04-end-of-standard-support

rfm

7/11/24, 11:34 PM

Did you in fact upgrade Ubuntu and/or mysql just before this started? It looks like mysql is trying to upgrade from a too-old previous release. This is certainly beyond my mysql skills; if you have backups of the data from before the upgrade, the best thing to do would be to start fresh with a new mysql install (on an in-support Ubuntu) and restore from backup.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Unable to start mysql service on ubuntu server

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.