MySQL doesn't start

BestRazer

7/28/23, 7:52 PM

Today I wanted to restart mariaDB because I couldn't connect to the database anymore. When I tried to restart it, I got these errors:

● mariadb.service - MariaDB 10.7.3 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             └─migrated-from-my.cnf-settings.conf
     Active: failed (Result: resources) since Mon 2022-03-28 21:23:20 CEST; 18min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
      Tasks: 102 (limit: 36046)
     Memory: 613.7M
        CPU: 4h 54min 2.270s
     CGroup: /system.slice/mariadb.service
             └─127990 /usr/sbin/mariadbd

Mar 28 21:23:20 vmd89408.contaboserver.net systemd[1]: mariadb.service: Will not start SendSIGKILL=no service of type KillMode=control-group or mixed while processes exist
Mar 28 21:23:20 vmd89408.contaboserver.net systemd[1]: mariadb.service: Failed to run 'start-pre' task: Device or resource busy
Mar 28 21:23:20 vmd89408.contaboserver.net systemd[1]: mariadb.service: Failed with result 'resources'.
Mar 28 21:23:20 vmd89408.contaboserver.net systemd[1]: Failed to start MariaDB 10.7.3 database server.
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: mariadb.service: Found left-over process 127990 (mariadbd) in control group while starting unit. Ignoring.
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: mariadb.service: Will not start SendSIGKILL=no service of type KillMode=control-group or mixed while processes exist
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: mariadb.service: Failed to run 'start-pre' task: Device or resource busy
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: mariadb.service: Failed with result 'resources'.
Mar 28 21:41:36 vmd89408.contaboserver.net systemd[1]: Failed to start MariaDB 10.7.3 database server.

From what I understand, the problem is that it wasn't properly shutdown. I already tried to kill the process by running kill 127990 but that didn't fix it either.

134

0 + 0

mysql

ubuntu

mariadb

eblock

8/6/23, 9:51 AM

Is the mysql directory usually mounted? The message `device or resource busy` usually indicates that the filesystem is not available. So you might need to check all mount points and re-mount. If that doesn't work, a reboot might help.

Elon Musk

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

EN: MySQL doesn't start

TH: MySQL ไม่เริ่มทำงาน

RO: MySQL nu pornește

RU: MySQL не запускается

VI: MySQL không bắt đầu

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.