Comments (11)
fagron
commented on July 4, 2024
root@DietPi:~# readlink -f /var/lib/mysql
/mnt/dietpi_userdata/mysql
root@DietPi:~# readlink /var/lib/mysql
/mnt/dietpi_userdata/mysql
root@DietPi:~# cat /var/log/mysql/error.log
cat: /var/log/mysql/error.log: Datei oder Verzeichnis nicht gefunden
root@DietPi:~# journalctl -u mariadb
Jun 20 19:39:41 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:39:42 DietPi mariadbd[675]: 2024-06-20 19:39:42 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 675
Jun 20 19:39:42 DietPi mariadbd[675]: 2024-06-20 19:39:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: Using liburing
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:39:43 DietPi mariadbd[675]: 2024-06-20 19:39:43 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] Aborting
Jun 20 19:39:44 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:39:44 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:39:44 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 19:40:51 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 1737
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Using liburing
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:40:51 DietPi mariadbd[1737]: 2024-06-20 19:40:51 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:40:52 DietPi mariadbd[1737]: 2024-06-20 19:40:52 0 [ERROR] Aborting
Jun 20 19:40:52 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:40:52 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:40:52 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 19:41:09 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:41:09 DietPi mariadbd[1819]: 2024-06-20 19:41:09 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 1819
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Using liburing
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:41:10 DietPi mariadbd[1819]: 2024-06-20 19:41:10 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:41:11 DietPi mariadbd[1819]: 2024-06-20 19:41:11 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:41:11 DietPi mariadbd[1819]: 2024-06-20 19:41:11 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:41:11 DietPi mariadbd[1819]: 2024-06-20 19:41:11 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:41:11 DietPi mariadbd[1819]: 2024-06-20 19:41:11 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:41:11 DietPi mariadbd[1819]: 2024-06-20 19:41:11 0 [ERROR] Aborting
Jun 20 19:41:11 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:41:11 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:41:11 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 19:41:14 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:41:14 DietPi mariadbd[1878]: 2024-06-20 19:41:14 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 1878
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Using liburing
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:41:15 DietPi mariadbd[1878]: 2024-06-20 19:41:15 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:41:16 DietPi mariadbd[1878]: 2024-06-20 19:41:16 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:41:16 DietPi mariadbd[1878]: 2024-06-20 19:41:16 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:41:16 DietPi mariadbd[1878]: 2024-06-20 19:41:16 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:41:16 DietPi mariadbd[1878]: 2024-06-20 19:41:16 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:41:16 DietPi mariadbd[1878]: 2024-06-20 19:41:16 0 [ERROR] Aborting
Jun 20 19:41:16 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:41:16 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:41:16 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 19:41:49 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:41:49 DietPi mariadbd[2045]: 2024-06-20 19:41:49 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 2045
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Using liburing
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:41:50 DietPi mariadbd[2045]: 2024-06-20 19:41:50 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:41:51 DietPi mariadbd[2045]: 2024-06-20 19:41:51 0 [ERROR] Aborting
Jun 20 19:41:51 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:41:51 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:41:51 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 19:44:11 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 2658
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Using liburing
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 19:44:11 DietPi mariadbd[2658]: 2024-06-20 19:44:11 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: Starting shutdown...
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 19:44:12 DietPi mariadbd[2658]: 2024-06-20 19:44:12 0 [ERROR] Aborting
Jun 20 19:44:12 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 19:44:12 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 19:44:12 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 21:02:37 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 21:02:37 DietPi mariadbd[7273]: 2024-06-20 21:02:37 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 7273
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Number of transaction pools: 1
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Using liburing
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Completed initialization of buffer pool
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: End of log at LSN=5619048737
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: 128 rollback segments are active.
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: FTS optimize thread exiting.
Jun 20 21:02:38 DietPi mariadbd[7273]: 2024-06-20 21:02:38 0 [Note] InnoDB: Starting shutdown...
Jun 20 21:02:39 DietPi mariadbd[7273]: 2024-06-20 21:02:39 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Jun 20 21:02:39 DietPi mariadbd[7273]: 2024-06-20 21:02:39 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jun 20 21:02:39 DietPi mariadbd[7273]: 2024-06-20 21:02:39 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 20 21:02:39 DietPi mariadbd[7273]: 2024-06-20 21:02:39 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Jun 20 21:02:39 DietPi mariadbd[7273]: 2024-06-20 21:02:39 0 [ERROR] Aborting
Jun 20 21:02:39 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 21:02:39 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 21:02:39 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Jun 20 21:13:15 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Jun 20 21:13:16 DietPi mariadbd[24098]: 2024-06-20 21:13:16 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision as process 24098
Jun 20 21:13:16 DietPi mariadbd[24098]: 2024-06-20 21:13:16 0 [ERROR] mariadbd: Error writing file './ddl_recovery.log' (Errcode: 28 "No space left on device")
Jun 20 21:13:16 DietPi mariadbd[24098]: 2024-06-20 21:13:16 0 [ERROR] Aborting
Jun 20 21:13:16 DietPi mariadbd[24098]: 2024-06-20 21:13:16 0 [ERROR] mariadbd: Error on close of '(null)' (Errcode: 9 "Bad file descriptor")
Jun 20 21:13:16 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jun 20 21:13:16 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 20 21:13:16 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
from dietpi.
Joulinar
commented on July 4, 2024
You file system seems to be full
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: preallocating 12582912 bytes for file ./ibtmp1 failed with error 28
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Jun 20 19:39:44 DietPi mariadbd[675]: 2024-06-20 19:39:44 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
and
Jun 20 21:13:16 DietPi mariadbd[24098]: 2024-06-20 21:13:16 0 [ERROR] mariadbd: Error writing file './ddl_recovery.log' (Errcode: 28 "No space left on device")
Can you check following
df -h
from dietpi.
fagron
commented on July 4, 2024
root@DietPi:~# df -h
Dateisystem Größe Benutzt Verf. Verw% Eingehängt auf
/dev/root 30G 29G 0 100% /
devtmpfs 1,7G 0 1,7G 0% /dev
tmpfs 1,9G 2,9M 1,9G 1% /dev/shm
tmpfs 769M 8,7M 761M 2% /run
tmpfs 5,0M 0 5,0M 0% /run/lock
tmpfs 1,9G 0 1,9G 0% /tmp
tmpfs 50M 2,4M 48M 5% /var/log
/dev/mmcblk0p1 127M 33M 95M 26% /boot
/dev/sda1 1,8T 201G 1,6T 11% /mnt/HDD
from dietpi.
Joulinar
commented on July 4, 2024
/dev/root 30G 29G 0 100% /
Your root file system is completely full.
from dietpi.
fagron
commented on July 4, 2024
I know, I did a nextcloudupdate two days ago. After that, the SD card slowly filled up.
What can I delete?
from dietpi.
Joulinar
commented on July 4, 2024
First step would be to find largest files/folder
du -aBM / --exclude /mnt/HDD | sort -n -r | head -n 20
from dietpi.
fagron
commented on July 4, 2024
root@DietPi:~# du -aBM / --exclude /mnt/HDD | sort -n -r | head -n 20
du: Zugriff auf '/proc/24369/task/24369/fd/3' nicht möglich: Datei oder Verzeichnis nicht gefunden
du: Zugriff auf '/proc/24369/task/24369/fdinfo/3' nicht möglich: Datei oder Verzeichnis nicht gefunden
du: Zugriff auf '/proc/24369/fd/4' nicht möglich: Datei oder Verzeichnis nicht gefunden
du: Zugriff auf '/proc/24369/fdinfo/4' nicht möglich: Datei oder Verzeichnis nicht gefunden
29445M /
23782M /mnt/dietpi_userdata
23782M /mnt
23030M /mnt/dietpi_userdata/nextcloud_data
19684M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj
19670M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview
2661M /root/logfile_storage
2661M /root
2626M /root/logfile_storage/pihole
2623M /root/logfile_storage/pihole/pihole.log
2199M /mnt/dietpi_userdata/nextcloud_data/updater-ocshgkvqztuj/backups
2199M /mnt/dietpi_userdata/nextcloud_data/updater-ocshgkvqztuj
1781M /usr
1307M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/5
1267M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/1
1266M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/f
1260M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/7
1256M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/a
1246M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/d
1241M /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj/preview/0
from dietpi.
Joulinar
commented on July 4, 2024
On short notice, you could delete an old Pihole log to gain 2.5GB
rm /root/logfile_storage/pihole/pihole.log
On a long-term, you might need to move /mnt/dietpi_userdata to your HDD. Can be done via drive manager.
Btw, most disk space is used by /mnt/dietpi_userdata/nextcloud_data/appdata_ocshgkvqztuj. Not sure what it is exactly but seem some picture or gallery app as it has a preview folder
from dietpi.
fagron
commented on July 4, 2024
Ok, I have deleted the pihole.log.
restart mariadb.service
nextcloud installed
Thanks for the help. It is working.
from dietpi.
MichaIng
commented on July 4, 2024
Woah, these Nextcloud previews can become huge. But I remember this from my own instance as well, where it currently is 1 GiB only, but it was much larger when I used the preview generator app. I removed everyone at some point, after changing preview settings. It creates a whole set of previews for every image that is viewed via web UI (or when requested by mentioned app), for various apps in various formats, and the default max "preview" size is 4k. Totally insane. Previews then easily take a multiple of the size of the image gallery itself.
I added these config.php settings, to limit it a little:
'preview_max_x' => 2048,
'preview_max_y' => 2048,
'jpeg_quality' => 60,Probably we should apply those by default on Nextcloud installs.
About the pihole.log: That one should not be used by default on installs via dietpi-software. It is a 2nd query log, which actually doubles the one done to the database. It is used only when using pihole -t/pihole tail to print logs to console, but not for the web UI. It can be disabled with:
sudo pihole -l offOtherwise, it is really not suitable for RAMlog #2. I always wanted to add some timestamps before concatenating logs to the disk storage, so logs older than X could be cleared, instead of letting those files grow unlimited.
from dietpi.
Joulinar
commented on July 4, 2024
I guess it has been fixed, right? Therefore I will close the topic for now.
from dietpi.
Related Issues (20)
- Wrong RAM calculation in dietpi banner HOT 5
- Rock 3A fails to bring up network on DietPi 9.5 HOT 17
- DietPi_NanoPiR6C-ARMv8-Bookworm(and Bullseye) Images not working at all HOT 4
- adguard only runs on ipv6 on proxmox HOT 2
- Unable to update Dietpi HOT 11
- TP-Link Archer T2U Nano HOT 9
- Diet-Pi Update failed HOT 5
- [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test HOT 11
- a2enmod command not found HOT 5
- Unable to update DietPi HOT 15
- Network | WiFi extender option HOT 7
- Node-red reinstall issue HOT 9
- Amlogic S802 support
- DietPi-Drive_Manager | Add option to scan for network shares
- installing coolify HOT 8
- Cant install Netdata HOT 13
- Curl error on DietPi update from v8.16.2 to v9.5.1 HOT 2
- Unpackerr - Unpack .rar archives automatically for importing via *arr services HOT 1
- Open Beta v9.6 | Please help testing and hardening our upcoming release
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dietpi.