mariadb.service failed Topic is solved

Have some feedback, questions, suggestions, or just fancy a chat? Pop it in here.
Post Reply
User avatar
fran-byte
Posts: 7
Joined: Sat Sep 04, 2021 11:01 pm

mariadb.service failed

Post by fran-byte »

Hello,
The first thing I want to say is that I am a newbie

I'm messing around with a raspi 1 A + and dietpi
I just installed LAMP,
I can see includes Apache2, MySQL (mariadb) and phP
Can I start the apache server correctly
But when starting mariadb reports this error:

Code: Select all

 sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.29 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; disabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Sun 2021-09-05 19:53:27 CEST; 13min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 29328 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 29330 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 29334 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 29383 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 29383 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

sep 05 19:51:13 DietPiP4CO systemd[1]: Starting MariaDB 10.3.29 database server...
sep 05 19:51:15 DietPiP4CO mysqld[29383]: 2021-09-05 19:51:15 0 [Note] /usr/sbin/mysqld (mysqld 10.3.29-MariaDB-0+deb10u1) starting as process 29383 ...
sep 05 19:53:27 DietPiP4CO systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
sep 05 19:53:27 DietPiP4CO systemd[1]: mariadb.service: Failed with result 'exit-code'.
sep 05 19:53:27 DietPiP4CO systemd[1]: Failed to start MariaDB 10.3.29 database server.
someone could help me?

Thanks in advance
User avatar
Joulinar
Posts: 5619
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb.service failed

Post by Joulinar »

Hi,

can you post following pls

Code: Select all

systemctl restart mariadb.service
journalctl -u mariadb
cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
fran-byte
Posts: 7
Joined: Sat Sep 04, 2021 11:01 pm

Re: mariadb.service failed

Post by fran-byte »

report:

Code: Select all

root@DietPiP4CO:/usr/sbin# systemctl restart mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

Code: Select all

root@DietPiP4CO:/usr/sbin# cat /var/log/mysql/error.log
2021-09-05 20:51:30 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2021-09-05 20:52:01 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control'
2021-09-05 20:52:01 0 [ERROR] Plugin 'Aria' init function returned error.
2021-09-05 20:52:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-09-05 20:52:01 0 [Note] InnoDB: Using Linux native AIO
2021-09-05 20:52:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-05 20:52:01 0 [Note] InnoDB: Uses event mutexes
2021-09-05 20:52:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-05 20:52:01 0 [Note] InnoDB: Number of pools: 1
2021-09-05 20:52:01 0 [Note] InnoDB: Using generic crc32 instructions
2021-09-05 20:52:01 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-09-05 20:52:02 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-05 20:52:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-05 20:52:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:02 0 [Note] InnoDB: Retrying to lock the first data file
2021-09-05 20:52:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:42 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:42 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:43 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:43 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:44 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:44 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:45 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:45 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:46 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:46 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:47 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:47 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:48 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:48 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:49 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:49 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:50 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:50 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:51 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:51 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:52 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:52 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:53 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:53 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:54 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:54 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:55 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:55 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:56 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:56 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:57 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:57 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:58 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:58 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:52:59 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:52:59 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:00 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:00 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:01 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:02 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:03 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:03 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:04 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:04 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:05 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:05 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:06 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:06 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:07 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:07 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:08 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:08 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:09 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:09 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:10 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:10 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:11 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:11 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:12 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:12 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:13 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:13 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:14 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:14 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:15 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:15 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:16 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:16 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:17 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:17 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:18 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:18 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:19 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:19 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:20 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:20 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:21 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:21 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:22 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:22 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:23 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:23 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:24 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:24 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:25 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:25 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:26 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:26 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:27 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:27 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:28 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:28 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:29 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:29 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:30 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:30 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:31 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:31 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:32 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:32 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:33 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:33 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:34 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:34 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:35 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:35 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:36 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:36 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:37 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:37 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:38 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:38 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:39 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:39 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:40 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:40 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:41 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:41 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:42 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2021-09-05 20:53:42 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2021-09-05 20:53:42 0 [Note] InnoDB: Unable to open the first data file
2021-09-05 20:53:42 0 [ERROR] InnoDB: Operating system error number 11 in a file operation.
2021-09-05 20:53:42 0 [ERROR] InnoDB: Error number 11 means 'Resource temporarily unavailable'
2021-09-05 20:53:42 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2021-09-05 20:53:42 0 [ERROR] InnoDB: Cannot open datafile './ibdata1'
2021-09-05 20:53:42 0 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2021-09-05 20:53:42 0 [ERROR] InnoDB: Plugin initialization aborted with error Cannot open a file
2021-09-05 20:53:42 0 [Note] InnoDB: Starting shutdown...
2021-09-05 20:53:43 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-09-05 20:53:43 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-09-05 20:53:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-05 20:53:43 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-09-05 20:53:43 0 [ERROR] Aborting

Warning: Memory not freed: 392

Code: Select all

root@DietPiP4CO:/usr/sbin# readlink /var/lib/mysql
/mnt/dietpi_userdata/mysql
root@DietPiP4CO:/usr/sbin# readlink -f /var/lib/mysql
/mnt/dietpi_userdata/mysql
User avatar
Joulinar
Posts: 5619
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb.service failed

Post by Joulinar »

could you try to reboot and check error.log again

Code: Select all

cat /var/log/mysql/error.log
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
fran-byte
Posts: 7
Joined: Sat Sep 04, 2021 11:01 pm

Re: mariadb.service failed

Post by fran-byte »

here you are:

Code: Select all

root@DietPiP4CO:~# cat /var/log/mysql/error.log
2021-09-05 21:05:11 0 [Note] InnoDB: Using Linux native AIO
2021-09-05 21:05:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-05 21:05:11 0 [Note] InnoDB: Uses event mutexes
2021-09-05 21:05:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-05 21:05:11 0 [Note] InnoDB: Number of pools: 1
2021-09-05 21:05:11 0 [Note] InnoDB: Using generic crc32 instructions
2021-09-05 21:05:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-09-05 21:05:11 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-05 21:05:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-05 21:05:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-05 21:05:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-05 21:05:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-05 21:05:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-09-05 21:05:14 0 [Note] InnoDB: Waiting for purge to start
2021-09-05 21:05:14 0 [Note] InnoDB: 10.3.29 started; log sequence number 1625971; transaction id 20
2021-09-05 21:05:14 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
2021-09-05 21:05:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-05 21:05:14 0 [Note] InnoDB: Buffer pool(s) load completed at 210905 21:05:14
2021-09-05 21:05:14 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-09-05 21:05:16 0 [Note] Reading of all Master_info entries succeeded
2021-09-05 21:05:16 0 [Note] Added new Master_info '' to hash table
2021-09-05 21:05:16 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.29-MariaDB-0+deb10u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Raspbian 10
User avatar
Joulinar
Posts: 5619
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb.service failed

Post by Joulinar »

looks like MariaDB is running now

Code: Select all

2021-09-05 21:05:16 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.29-MariaDB-0+deb10u1' socket: '/run/mysqld/mysqld.sock' port: 3306 Raspbian 10
What is status of service

Code: Select all

systemctl status mariadb.service
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
fran-byte
Posts: 7
Joined: Sat Sep 04, 2021 11:01 pm

Re: mariadb.service failed

Post by fran-byte »

:D
perfect, the problem is solved

and now is when you tell me what was happening to mariadb

;)
User avatar
Joulinar
Posts: 5619
Joined: Sat Nov 16, 2019 12:49 am

Re: mariadb.service failed

Post by Joulinar »

according error log, another database process was already running, blocking to start the service

Code: Select all

2021-09-05 20:52:02 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files
A reboot fixed this
Pls let us know if a solution is working. This could help others if they hit by similar situation. Your DietPi Team
User avatar
fran-byte
Posts: 7
Joined: Sat Sep 04, 2021 11:01 pm

Re: mariadb.service failed

Post by fran-byte »

THANKS FOR YOUR TIME !!

I am an electronic technician, if you have any questions in this field, you know who to ask

and I'm sorry for my English, my native language is Spanish.

;)
Post Reply