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:
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
Hi,
can you post following pls
systemctl restart mariadb.service
journalctl -u mariadb
cat /var/log/mysql/error.log
readlink /var/lib/mysql
readlink -f /var/lib/mysql
report:
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.
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
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
could you try to reboot and check error.log again
cat /var/log/mysql/error.log
here you are:
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
looks like MariaDB is running now
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
systemctl status mariadb.service
perfect, the problem is solved
and now is when you tell me what was happening to mariadb
according error log, another database process was already running, blocking to start the service
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
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.