MySQL (MariaDB) Not Starting '/usr/sbin/mariadbd: Shutdown complete - mariadb.service: Failed with result 'exit-code'.'

MaxPlay066

8/9/23, 2:30 PM

I'm getting an error when i try to start mariadb.service service:

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

systemctl status mariadb.service

mariadb.service - MariaDB 10.5.15 database server
 Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
 Active: failed (Result: exit-code) since Sat 2022-04-09 16:24:54 CEST; 32s ago
   Docs: man:mariadbd(8)
         https://mariadb.com/kb/en/library/systemd/
Process: 8118 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 8119 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 8121 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ >
Process: 8135 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 8154 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 8156 ExecStartPost=/etc/mysql/debian-start (code=exited, status=203/EXEC)

   Main PID: 8135 (code=exited, status=0/SUCCESS)
     Status: "MariaDB server is down"
        CPU: 305ms

Apr 09 16:24:53 raspberrypi mariadbd[8135]: 2022-04-09 16:24:53 0 [Note] Event Scheduler: Purging the queue. 0 events
Apr 09 16:24:53 raspberrypi mariadbd[8135]: 2022-04-09 16:24:53 0 [Note] InnoDB: FTS optimize thread exiting.
Apr 09 16:24:53 raspberrypi mariadbd[8135]: 2022-04-09 16:24:53 0 [Note] InnoDB: Starting shutdown...
Apr 09 16:24:53 raspberrypi mariadbd[8135]: 2022-04-09 16:24:53 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
Apr 09 16:24:53 raspberrypi mariadbd[8135]: 2022-04-09 16:24:53 0 [Note] InnoDB: Buffer pool(s) dump completed at 220409 16:24:53
Apr 09 16:24:54 raspberrypi mariadbd[8135]: 2022-04-09 16:24:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Apr 09 16:24:54 raspberrypi mariadbd[8135]: 2022-04-09 16:24:54 0 [Note] InnoDB: Shutdown completed; log sequence number 45238; transaction>
Apr 09 16:24:54 raspberrypi mariadbd[8135]: 2022-04-09 16:24:54 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Apr 09 16:24:54 raspberrypi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Apr 09 16:24:54 raspberrypi systemd[1]: Failed to start MariaDB 10.5.15 database server.

100

0 + 0

linux

database

service

doneal24

8/9/23, 4:52 PM

Is there any useful information in `/var/log/mariadb/mariadb.log`? Does `journalctl -xe` add any more error messages?

MaxPlay066

8/9/23, 7:30 PM

@doneal24 There isn't a folder called mariadb in /var/log/. [Here journalctl -xe](https://pastebin.com/yFW7zBky)

Nasir Riley

8/9/23, 7:39 PM

It says there in the `journalctl` output: `Apr 09 21:28:55 raspberrypi systemd[1578]: mariadb.service: Failed at step EXEC spawning /etc/mysql/debian-start: No such file or directory`. You need to have that file and go from there.

Elon Musk

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

EN: MySQL (MariaDB) Not Starting '/usr/sbin/mariadbd: Shutdown complete - mariadb.service: Failed with result 'exit-code'.'

TH: MySQL (MariaDB) ไม่เริ่มทำงาน '/usr/sbin/mariadbd: การปิดระบบเสร็จสมบูรณ์ - mariadb.service: ล้มเหลวด้วยผลลัพธ์ 'exit-code''

RO: MySQL (MariaDB) Nu pornește „/usr/sbin/mariadbd: Închidere completă - mariadb.service: Eșuat cu rezultatul „exit-code”.

RU: MySQL (MariaDB) не запускается '/usr/sbin/mariadbd: завершение работы - mariadb.service: сбой с результатом 'код выхода'».

VI: MySQL (MariaDB) Không Bắt đầu '/usr/sbin/mariadbd: Tắt máy hoàn tất - mariadb.service: Không thành công với kết quả 'mã thoát'.'

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.