bedankt voor je bericht. Well, I was working with people from Amsterdam for more than 6 years but still don't speak dutch Therefore let's stick to English
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@DietPi:~#
journalctl -u mariadb
-- Logs begin at Mon 2020-06-22 17:16:45 BST, end at Mon 2020-06-22 18:55:01 BST. --
Jun 22 17:17:20 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 17:17:21 DietPi mysqld[601]: 2020-06-22 17:17:21 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 601 ...
Jun 22 17:17:22 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 17:17:22 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 17:17:22 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Jun 22 17:44:22 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 17:44:23 DietPi mysqld[5897]: 2020-06-22 17:44:23 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 5897 ...
Jun 22 17:44:27 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 17:44:27 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 17:44:27 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Jun 22 17:53:01 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 17:53:02 DietPi mysqld[6480]: 2020-06-22 17:53:02 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 6480 ...
Jun 22 17:53:06 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 17:53:06 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 17:53:06 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Jun 22 17:54:07 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 17:54:07 DietPi mysqld[7498]: 2020-06-22 17:54:07 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 7498 ...
Jun 22 17:54:08 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 17:54:08 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 17:54:08 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Jun 22 17:54:24 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 17:54:24 DietPi mysqld[7931]: 2020-06-22 17:54:24 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 7931 ...
Jun 22 17:54:25 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 17:54:25 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 17:54:25 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
Jun 22 18:54:56 DietPi systemd[1]: Starting MariaDB 10.3.22 database server...
Jun 22 18:54:56 DietPi mysqld[11718]: 2020-06-22 18:54:56 0 [Note] /usr/sbin/mysqld (mysqld 10.3.22-MariaDB-0+deb10u1) starting as process 11718 ...
Jun 22 18:55:01 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 22 18:55:01 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 22 18:55:01 DietPi systemd[1]: Failed to start MariaDB 10.3.22 database server.
root@DietPi:~#
cat /var/log/mysql/error.log
2020-06-22 18:54:56 0 [Note] InnoDB: Using Linux native AIO
2020-06-22 18:54:56 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-06-22 18:54:56 0 [Note] InnoDB: Uses event mutexes
2020-06-22 18:54:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-06-22 18:54:56 0 [Note] InnoDB: Number of pools: 1
2020-06-22 18:54:56 0 [Note] InnoDB: Using generic crc32 instructions
2020-06-22 18:54:56 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-06-22 18:54:56 0 [Note] InnoDB: Completed initialization of buffer pool
2020-06-22 18:54:56 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/gtid_slave_pos.ibd' OS error: 81
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`gtid_slave_pos``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`gtid_slave_pos` because it could not be opened.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`innodb_index_stats``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`innodb_index_stats` because it could not be opened.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`innodb_table_stats``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`innodb_table_stats` because it could not be opened.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/transaction_registry.ibd' OS error: 81
2020-06-22 18:55:00 0 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 0 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`transaction_registry``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`transaction_registry` because it could not be opened.
2020-06-22 18:55:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-06-22 18:55:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-06-22 18:55:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-06-22 18:55:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-06-22 18:55:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-06-22 18:55:00 0 [Note] InnoDB: 10.3.22 started; log sequence number 1625502; transaction id 21
2020-06-22 18:55:00 2 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_index_stats` in the cache. Attempting to load the tablespace with space id 2
2020-06-22 18:55:00 2 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 2 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 2 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_index_stats.ibd' OS error: 81
2020-06-22 18:55:00 2 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 2 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/hd500/dietpi_userdata/mysql/ib_buffer_pool
2020-06-22 18:55:00 2 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`innodb_index_stats``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-06-22 18:55:00 3 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_table_stats` in the cache. Attempting to load the tablespace with space id 1
2020-06-22 18:55:00 3 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 3 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 3 [ERROR] InnoDB: Cannot open datafile for read-only: './mysql/innodb_table_stats.ibd' OS error: 81
2020-06-22 18:55:00 3 [ERROR] InnoDB: Operating system error number 13 in a file operation.
2020-06-22 18:55:00 3 [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
2020-06-22 18:55:00 3 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`innodb_table_stats``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2020-06-22 18:55:00 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-06-22 18:55:00 0 [Note] Recovering after a crash using tc.log
2020-06-22 18:55:00 0 [Note] Starting crash recovery...
2020-06-22 18:55:00 0 [Note] Crash recovery finished.
2020-06-22 18:55:00 0 [Note] InnoDB: Buffer pool(s) load completed at 200622 18:55:00
2020-06-22 18:55:00 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2020-06-22 18:55:00 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-06-22 18:55:00 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
root@DietPi:~#