Change to using old data on external harddrive

Troubleshooting
41

ok thanks. I’ll wait

42

personally, I would do it this way. First step would be to install NC.

43

by HC you mean “NC” (Nextcloud)?

44

Yes, sorry typo

45

Hi, so NC has been installed and the hard-dive has been mounted. Could you talk me through the next steps again please.

46 
dietpi-services stop
mv /mnt/dietpi_userdata /mnt/dietpi_userdata_bak
ln -s /mnt/hdd/dietpi_userdata /mnt/dietpi_userdata # assuming your drive is mounted to /mnt/hdd
instanceid=$(find /mnt/dietpi_userdata/nextcloud_data -maxdepth 1 -name 'appdata_*')
dbuser=$(mawk -F\' '/dbuser/{print $4}' /var/www/nextcloud/config/config.php)
dbpassword=$(mawk -F\' '/dbpassword/{print $4}' /var/www/nextcloud/config/config.php)

At this point you might want to verify that the generated variables contain the expected values:

echo "$instanceid"
echo "$dbuser"
echo "$dbpassword"

instanceid should be 12 random characters, dbpassword 30 random characters. dbuser should be “ocadmin” or “nextcloud”, not sure currently. If this is the case, apply them:

G_CONFIG_INJECT "'instanceid'" "  'instanceid' => '$instanceid'," /var/www/nextcloud/config/config.php
mysql -e "grant all privileges on \`nextcloud\`.* to '$dbuser'@localhost identified by '$dbpassword';flush privileges"
dietpi-services start

Wait some seconds and check back whether the database server started up without errors:

journalctl -u mariadb

If so, check whether you can access Nextcloud.

47

Just for clarification - when I enter this into terminal:

G_CONFIG_INJECT "'instanceid'" "  'instanceid' => '$instanceid'," /var/www/nextcloud/config/config.php
mysql -e "grant all privileges on \`nextcloud\`.* to '$dbuser'@localhost identified by '$dbpassword';flush privileges"
dietpi-services start

I replace the turquoise coloured text above with text from the output I get from :

echo "$instanceid"
echo "$dbuser"
echo "$dbpassword"

Correct?

48

Ok I did as I wrote above, and entered the code

G_CONFIG_INJECT "'instanceid'" "  'instanceid' => '$instanceid'," /var/www/nextcloud/config/config.php
mysql -e "grant all privileges on \`nextcloud\`.* to '$dbuser'@localhost identified by '$dbpassword';flush privileges"
dietpi-services start

replacing the terquoise text with the outputs from

echo "$instanceid"
echo "$dbuser"
echo "$dbpassword"

for the first attempt I entered for the ‘instanceid’ I entered just the 12random caractors and it failed

DietPi-Services
─────────────────────────────────────────────────────
 Mode: start 

[  OK  ] DietPi-Services | start : avahi-daemon
[  OK  ] DietPi-Services | start : nmbd
[  OK  ] DietPi-Services | start : smbd
[  OK  ] DietPi-Services | start : redis-server
[FAILED] DietPi-Services | start : mariadb
[  OK  ] DietPi-Services | start : php8.2-fpm
[  OK  ] DietPi-Services | start : apache2
[FAILED] DietPi-Services | start : mpd
[  OK  ] DietPi-Services | start : shairport-sync
[  OK  ] DietPi-Services | start : squeezelite
[  OK  ] DietPi-Services | start : gmediarender
[  OK  ] DietPi-Services | start : networkaudiod
[  OK  ] DietPi-Services | start : roonbridge
[  OK  ] DietPi-Services | start : filebrowser
[  OK  ] DietPi-Services | start : netdata
[  OK  ] DietPi-Services | start : cron

I stopped dietpi-services and I tried with /mnt/dietpi_userdata/nextcloud_data/appdata_XXXXXXXXXXXX where the XXXXXXXXXXXX is replaced with the code - and this also failed :woozy_face: :sob:

this is what

root@DietPi:~# journalctl -u mariadb gave me:

eb 27 09:46:26 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 603
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using liburing
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240227  9:46:30
Feb 27 09:46:31 DietPi mariadbd[603]: 2024-02-27  9:46:31 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 09:46:31 DietPi mariadbd[603]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 09:46:31 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[696]: Upgrading MySQL tables if necessary.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[719]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 10:52:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Starting shutdown...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 10:52:46
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Shutdown completed; log sequence number 50190; transaction id 23
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 10:52:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Consumed 3.084s CPU time.
Feb 27 10:56:13 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:56:13 DietPi mariadbd[10815]: 2024-02-27 10:56:13 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 10815
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using liburing
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 10:57:18 DietPi mariadbd[10815]: 2024-02-27 10:57:18 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 10:57:22 DietPi mariadbd[10815]: 2024-02-27 10:57:22 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 10:57:51 DietPi mariadbd[10815]: 2024-02-27 10:57:51 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 10:57:51 DietPi mariadbd[10815]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 10:57:51 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10848]: Checking for insecure root accounts.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10852]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:57:55 DietPi mariadbd[10815]: 2024-02-27 10:57:55 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 10:57:55
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 11:30:03 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Starting shutdown...
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 11:30:05
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Shutdown completed; log sequence number 1598028; transaction id 2301
Feb 27 11:34:47 DietPi mariadbd[10815]: 2024-02-27 11:34:47 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 11:34:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Consumed 15.471s CPU time.
Feb 27 11:34:47 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:34:47 DietPi mariadbd[11492]: 2024-02-27 11:34:47 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 11492
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using liburing
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: End of log at LSN=1598028
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: log sequence number 1598028; transaction id 2302
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 11:34:48 DietPi mariadbd[11492]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 11:34:48 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11526]: Checking for insecure root accounts.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11531]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 11:34:49 DietPi mariadbd[11492]: 2024-02-27 11:34:49 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 11:34:49
Feb 27 17:25:30 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Starting shutdown...
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 17:25:30
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Shutdown completed; log sequence number 7164559; transaction id 23159
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 17:25:43 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Consumed 33.008s CPU time.
Feb 27 17:28:04 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 39659
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using liburing
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: End of log at LSN=7164559
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: log sequence number 7164559; transaction id 23160
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 17:28:05 DietPi mariadbd[39659]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 17:28:05 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 17:28:05
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 09:55:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Starting shutdown...
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228  9:55:47
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Shutdown completed; log sequence number 21355711; transaction id 80125
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 09:55:56 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Consumed 1min 22.561s CPU time.
Feb 28 09:56:09 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 293279
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Number of transaction pools: 1
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using liburing
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: End of log at LSN=21355711
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: 128 rollback segments are active.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: log sequence number 21355711; transaction id 80126
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 28 09:56:10 DietPi mariadbd[293279]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 28 09:56:10 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:56:10 DietPi /etc/mysql/debian-start[293317]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Buffer pool(s) load completed at 240228  9:56:10
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 10:43:49 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Starting shutdown...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228 10:43:49
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Shutdown completed; log sequence number 22039884; transaction id 82729
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 10:43:58 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Consumed 5.154s CPU time.
Feb 28 10:59:52 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 10:59:53 DietPi mariadbd[306253]: [92B blob data]
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [ERROR] Aborting
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 10:59:53 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 11:04:39 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 11:04:40 DietPi mariadbd[309096]: [92B blob data]
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [ERROR] Aborting
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 11:04:40 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
49

No, you don’t need to do this, but the result should be the same.
You execute the first code block, which fills the variables with the correct values. Than you verify if the are in the right format:

Verify:

If this looks right you run the last codeblock:

G_CONFIG_INJECT "'instanceid'" "  'instanceid' => '$instanceid'," /var/www/nextcloud/config/config.php
mysql -e "grant all privileges on \`nextcloud\`.* to '$dbuser'@localhost identified by '$dbpassword';flush privileges"
dietpi-services start

Wait some seconds and check back whether the database server started up without errors:

journalctl -u mariadb

One command also assumes, that your external drive is mounted to /mnt/hdd, is this the case?

50

hi, yes the hard drive was and is mounted before I entered the code you sent me

It looks like it is not working.

Feb 27 09:46:26 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 603
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using liburing
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240227  9:46:30
Feb 27 09:46:31 DietPi mariadbd[603]: 2024-02-27  9:46:31 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 09:46:31 DietPi mariadbd[603]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 09:46:31 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[696]: Upgrading MySQL tables if necessary.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[719]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 10:52:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Starting shutdown...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 10:52:46
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Shutdown completed; log sequence number 50190; transaction id 23
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 10:52:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Consumed 3.084s CPU time.
Feb 27 10:56:13 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:56:13 DietPi mariadbd[10815]: 2024-02-27 10:56:13 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 10815
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using liburing
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 10:57:18 DietPi mariadbd[10815]: 2024-02-27 10:57:18 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 10:57:22 DietPi mariadbd[10815]: 2024-02-27 10:57:22 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 10:57:51 DietPi mariadbd[10815]: 2024-02-27 10:57:51 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 10:57:51 DietPi mariadbd[10815]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 10:57:51 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10848]: Checking for insecure root accounts.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10852]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:57:55 DietPi mariadbd[10815]: 2024-02-27 10:57:55 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 10:57:55
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 11:30:03 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Starting shutdown...
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 11:30:05
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Shutdown completed; log sequence number 1598028; transaction id 2301
Feb 27 11:34:47 DietPi mariadbd[10815]: 2024-02-27 11:34:47 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 11:34:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Consumed 15.471s CPU time.
Feb 27 11:34:47 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:34:47 DietPi mariadbd[11492]: 2024-02-27 11:34:47 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 11492
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using liburing
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: End of log at LSN=1598028
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: log sequence number 1598028; transaction id 2302
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 11:34:48 DietPi mariadbd[11492]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 11:34:48 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11526]: Checking for insecure root accounts.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11531]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 11:34:49 DietPi mariadbd[11492]: 2024-02-27 11:34:49 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 11:34:49
Feb 27 17:25:30 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Starting shutdown...
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 17:25:30
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Shutdown completed; log sequence number 7164559; transaction id 23159
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 17:25:43 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Consumed 33.008s CPU time.
Feb 27 17:28:04 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 39659
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using liburing
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: End of log at LSN=7164559
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: log sequence number 7164559; transaction id 23160
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 17:28:05 DietPi mariadbd[39659]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 17:28:05 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 17:28:05
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 09:55:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Starting shutdown...
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228  9:55:47
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Shutdown completed; log sequence number 21355711; transaction id 80125
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 09:55:56 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Consumed 1min 22.561s CPU time.
Feb 28 09:56:09 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 293279
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Number of transaction pools: 1
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using liburing
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: End of log at LSN=21355711
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: 128 rollback segments are active.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: log sequence number 21355711; transaction id 80126
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 28 09:56:10 DietPi mariadbd[293279]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 28 09:56:10 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:56:10 DietPi /etc/mysql/debian-start[293317]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Buffer pool(s) load completed at 240228  9:56:10
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 10:43:49 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Starting shutdown...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228 10:43:49
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Shutdown completed; log sequence number 22039884; transaction id 82729
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 10:43:58 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Consumed 5.154s CPU time.
Feb 28 10:59:52 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 10:59:53 DietPi mariadbd[306253]: [92B blob data]
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [ERROR] Aborting
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 10:59:53 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 11:04:39 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 11:04:40 DietPi mariadbd[309096]: [92B blob data]
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [ERROR] Aborting
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 11:04:40 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 12:24:26 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 12:24:26 DietPi mariadbd[354373]: 2024-02-28 12:24:26 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 12:24:26 DietPi mariadbd[354373]: [92B blob data]
Feb 28 12:24:26 DietPi mariadbd[354373]: 2024-02-28 12:24:26 0 [ERROR] Aborting
Feb 28 12:24:26 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 12:24:26 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 12:24:26 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.

what can I do now? thanks in advance

51

Wait, there is an issue with file system permissions

I guess following ist not working?

sudo -u mysql -g mysql touch /var/lib/mysql/demo.file
ls -la /var/lib/mysql/
1 Like
52

Makes sense that the user IDs of the mysql user and potentially the www-data user might have changed:

chmod -R mysql /mnt/dietpi_userdata/mysql
chmod -R www-data /mnt/dietpi_userdata/nextcloud_data # this might take a while

And as Jappe already pointed out: It was not necessary to replace the words in my 2nd command block. The first block stored the the values in the variables, and prefixing a variable name with $ calls it (the shell replaces $variablename with its content), hence the echo commands printed the variable’s content. The the same works for the last command block to apply them to database and Nextcloud config. This to avoid manual copy&paste or typos. However, the result should be the same, and even if something went wrong with this, it can be just repeated. The current issue is the permissions.

53

no sudo -u mysql -g mysql touch /var/lib/mysql/demo.file ls -la /var/lib/mysql/ is not working (see below)

oot@DietPi:~# sudo -u mysql -g mysql touch /var/lib/mysql/demo.file
ls -la /var/lib/mysql/
touch: cannot touch '/var/lib/mysql/demo.file': Permission denied
total 188920
drwxr-xr-x  8 mysql  mysql       4096 Feb  4 21:26 .
drwxrwxr-x 14 dietpi dietpi      4096 Feb 28 10:46 ..
drwx------  2 mysql  mysql       4096 Oct 29 19:38 allo
-rw-rw----  1 mysql  mysql     425984 Feb  4 21:17 aria_log.00000001
-rw-rw----  1 mysql  mysql         52 Feb  4 21:17 aria_log_control
-rw-rw----  1 mysql  mysql          9 Feb  4 20:50 ddl_recovery-backup.log
-rw-rw----  1 mysql  mysql          9 Feb  4 21:26 ddl_recovery.log
-rw-r--r--  1 root   root           0 Oct 29 19:23 debian-10.11.flag
-rw-rw----  1 mysql  mysql      14971 Feb  4 21:17 ib_buffer_pool
-rw-rw----  1 mysql  mysql  100663296 Feb  5 13:04 ib_logfile0
-rw-rw----  1 mysql  mysql   79691776 Feb  4 21:17 ibdata1
-rw-rw----  1 mysql  mysql   12582912 Feb  4 21:26 ibtmp1
-rw-rw----  1 mysql  mysql          0 Oct 29 19:23 multi-master.info
drwx------  2 mysql  mysql       4096 Oct 29 19:23 mysql
-rw-r--r--  1 root   root          15 Oct 29 19:23 mysql_upgrade_info
drwx------  2 mysql  mysql      20480 Dec 18 21:33 nextcloud
drwx------  2 mysql  mysql       4096 Dec  5 13:23 ompd
drwx------  2 mysql  mysql       4096 Oct 29 19:23 performance_schema
drwx------  2 mysql  mysql      12288 Oct 29 19:23 sys
root@DietPi:~#
54

when entering

chmod -R mysql /mnt/dietpi_userdata/mysql
chmod -R www-data /mnt/dietpi_userdata/nextcloud_data

command I get:

chmod: invalid mode: ‘mysql’
Try 'chmod --help' for more information.
chmod: invalid mode: ‘www-data’
Try 'chmod --help' for more information.
55

Sorry typo:

chown -R mysql /mnt/dietpi_userdata/mysql
chown -R www-data /mnt/dietpi_userdata/nextcloud_data
56

Ok It seems to have finished. Nothing to tell me it has done it. how should I proceed now?

57

The database server does now start up?

systemctl restart mariadb
sleep 5
journalctl -u mariadb
58

after entering your code it failed again

Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details.
Feb 27 09:46:26 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 603
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Using liburing
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 09:46:29 DietPi mariadbd[603]: 2024-02-27  9:46:29 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 09:46:30 DietPi mariadbd[603]: 2024-02-27  9:46:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240227  9:46:30
Feb 27 09:46:31 DietPi mariadbd[603]: 2024-02-27  9:46:31 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 09:46:31 DietPi mariadbd[603]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 09:46:31 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[696]: Upgrading MySQL tables if necessary.
Feb 27 09:46:31 DietPi /etc/mysql/debian-start[719]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 10:52:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Starting shutdown...
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 10:52:46
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] InnoDB: Shutdown completed; log sequence number 50190; transaction id 23
Feb 27 10:52:46 DietPi mariadbd[603]: 2024-02-27 10:52:46 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 10:52:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:52:47 DietPi systemd[1]: mariadb.service: Consumed 3.084s CPU time.
Feb 27 10:56:13 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 10:56:13 DietPi mariadbd[10815]: 2024-02-27 10:56:13 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 10815
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Using liburing
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 10:57:12 DietPi mariadbd[10815]: 2024-02-27 10:57:12 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 10:57:18 DietPi mariadbd[10815]: 2024-02-27 10:57:18 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 10:57:22 DietPi mariadbd[10815]: 2024-02-27 10:57:22 0 [Note] InnoDB: End of log at LSN=50190
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: log sequence number 50190; transaction id 22
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 10:57:50 DietPi mariadbd[10815]: 2024-02-27 10:57:50 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 10:57:51 DietPi mariadbd[10815]: 2024-02-27 10:57:51 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 10:57:51 DietPi mariadbd[10815]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 10:57:51 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10848]: Checking for insecure root accounts.
Feb 27 10:57:51 DietPi /etc/mysql/debian-start[10852]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 10:57:55 DietPi mariadbd[10815]: 2024-02-27 10:57:55 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 10:57:55
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 11:30:03 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:30:03 DietPi mariadbd[10815]: 2024-02-27 11:30:03 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Starting shutdown...
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:30:05 DietPi mariadbd[10815]: 2024-02-27 11:30:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 11:30:05
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 11:34:46 DietPi mariadbd[10815]: 2024-02-27 11:34:46 0 [Note] InnoDB: Shutdown completed; log sequence number 1598028; transaction id 2301
Feb 27 11:34:47 DietPi mariadbd[10815]: 2024-02-27 11:34:47 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 11:34:47 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:47 DietPi systemd[1]: mariadb.service: Consumed 15.471s CPU time.
Feb 27 11:34:47 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 11:34:47 DietPi mariadbd[11492]: 2024-02-27 11:34:47 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 11492
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Using liburing
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: End of log at LSN=1598028
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: log sequence number 1598028; transaction id 2302
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 11:34:48 DietPi mariadbd[11492]: 2024-02-27 11:34:48 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 11:34:48 DietPi mariadbd[11492]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 11:34:48 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11526]: Checking for insecure root accounts.
Feb 27 11:34:49 DietPi /etc/mysql/debian-start[11531]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 27 11:34:49 DietPi mariadbd[11492]: 2024-02-27 11:34:49 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 11:34:49
Feb 27 17:25:30 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 27 17:25:30 DietPi mariadbd[11492]: 2024-02-27 17:25:30 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Starting shutdown...
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:25:31 DietPi mariadbd[11492]: 2024-02-27 17:25:31 0 [Note] InnoDB: Buffer pool(s) dump completed at 240227 17:25:30
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] InnoDB: Shutdown completed; log sequence number 7164559; transaction id 23159
Feb 27 17:25:43 DietPi mariadbd[11492]: 2024-02-27 17:25:43 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 27 17:25:43 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:25:43 DietPi systemd[1]: mariadb.service: Consumed 33.008s CPU time.
Feb 27 17:28:04 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 39659
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Number of transaction pools: 1
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Using liburing
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: End of log at LSN=7164559
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: 128 rollback segments are active.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: log sequence number 7164559; transaction id 23160
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 27 17:28:05 DietPi mariadbd[39659]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 27 17:28:05 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 27 17:28:05 DietPi mariadbd[39659]: 2024-02-27 17:28:05 0 [Note] InnoDB: Buffer pool(s) load completed at 240227 17:28:05
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 09:55:46 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:55:46 DietPi mariadbd[39659]: 2024-02-28  9:55:46 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Starting shutdown...
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:55:47 DietPi mariadbd[39659]: 2024-02-28  9:55:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228  9:55:47
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] InnoDB: Shutdown completed; log sequence number 21355711; transaction id 80125
Feb 28 09:55:56 DietPi mariadbd[39659]: 2024-02-28  9:55:56 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 09:55:56 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:55:56 DietPi systemd[1]: mariadb.service: Consumed 1min 22.561s CPU time.
Feb 28 09:56:09 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1 source revision  as process 293279
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Number of transaction pools: 1
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using ARMv8 crc32 instructions
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Using liburing
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Completed initialization of buffer pool
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: End of log at LSN=21355711
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: 128 rollback segments are active.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
Feb 28 09:56:09 DietPi mariadbd[293279]: 2024-02-28  9:56:09 0 [Note] InnoDB: log sequence number 21355711; transaction id 80126
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Loading buffer pool(s) from /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Plugin 'FEEDBACK' is disabled.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] Server socket created on IP: '127.0.0.1'.
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] /usr/sbin/mariadbd: ready for connections.
Feb 28 09:56:10 DietPi mariadbd[293279]: Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 12
Feb 28 09:56:10 DietPi systemd[1]: Started mariadb.service - MariaDB 10.11.6 database server.
Feb 28 09:56:10 DietPi /etc/mysql/debian-start[293317]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Feb 28 09:56:10 DietPi mariadbd[293279]: 2024-02-28  9:56:10 0 [Note] InnoDB: Buffer pool(s) load completed at 240228  9:56:10
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: FTS optimize thread exiting.
Feb 28 10:43:49 DietPi systemd[1]: Stopping mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Starting shutdown...
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Dumping buffer pool(s) to /mnt/dietpi_userdata/mysql/ib_buffer_pool
Feb 28 10:43:49 DietPi mariadbd[293279]: 2024-02-28 10:43:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 240228 10:43:49
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] InnoDB: Shutdown completed; log sequence number 22039884; transaction id 82729
Feb 28 10:43:58 DietPi mariadbd[293279]: 2024-02-28 10:43:58 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Deactivated successfully.
Feb 28 10:43:58 DietPi systemd[1]: Stopped mariadb.service - MariaDB 10.11.6 database server.
Feb 28 10:43:58 DietPi systemd[1]: mariadb.service: Consumed 5.154s CPU time.
Feb 28 10:59:52 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 10:59:53 DietPi mariadbd[306253]: [92B blob data]
Feb 28 10:59:53 DietPi mariadbd[306253]: 2024-02-28 10:59:53 0 [ERROR] Aborting
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 10:59:53 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 10:59:53 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 11:04:39 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 11:04:40 DietPi mariadbd[309096]: [92B blob data]
Feb 28 11:04:40 DietPi mariadbd[309096]: 2024-02-28 11:04:40 0 [ERROR] Aborting
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 11:04:40 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 11:04:40 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 12:24:26 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 12:24:26 DietPi mariadbd[354373]: 2024-02-28 12:24:26 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 12:24:26 DietPi mariadbd[354373]: [92B blob data]
Feb 28 12:24:26 DietPi mariadbd[354373]: 2024-02-28 12:24:26 0 [ERROR] Aborting
Feb 28 12:24:26 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 12:24:26 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 12:24:26 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 14:59:10 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 14:59:10 DietPi mariadbd[397358]: 2024-02-28 14:59:10 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 14:59:10 DietPi mariadbd[397358]: [92B blob data]
Feb 28 14:59:10 DietPi mariadbd[397358]: 2024-02-28 14:59:10 0 [ERROR] Aborting
Feb 28 14:59:10 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 14:59:10 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 14:59:10 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 14:59:42 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 14:59:42 DietPi mariadbd[397448]: 2024-02-28 14:59:42 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 14:59:42 DietPi mariadbd[397448]: [92B blob data]
Feb 28 14:59:42 DietPi mariadbd[397448]: 2024-02-28 14:59:42 0 [ERROR] Aborting
Feb 28 14:59:42 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 14:59:42 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 14:59:42 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.
Feb 28 15:00:00 DietPi systemd[1]: Starting mariadb.service - MariaDB 10.11.6 database server...
Feb 28 15:00:01 DietPi mariadbd[398261]: 2024-02-28 15:00:01 0 [Warning] Can't create test file '/var/lib/mysql/DietPi.lower-test' (Errcode: 13 "Permission denied")
Feb 28 15:00:01 DietPi mariadbd[398261]: [92B blob data]
Feb 28 15:00:01 DietPi mariadbd[398261]: 2024-02-28 15:00:01 0 [ERROR] Aborting
Feb 28 15:00:01 DietPi systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb 28 15:00:01 DietPi systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb 28 15:00:01 DietPi systemd[1]: Failed to start mariadb.service - MariaDB 10.11.6 database server.

:sob:

59

nothing changed. Can you share

ls -la /var/lib/mysql/
60

here it is:

root@DietPi:~# ls -la /var/lib/mysql/
total 188920
drwxr-xr-x  8 mysql  mysql       4096 Feb  4 21:26 .
drwxrwxr-x 14 dietpi dietpi      4096 Feb 28 10:46 ..
drwx------  2 mysql  mysql       4096 Oct 29 19:38 allo
-rw-rw----  1 mysql  mysql     425984 Feb  4 21:17 aria_log.00000001
-rw-rw----  1 mysql  mysql         52 Feb  4 21:17 aria_log_control
-rw-rw----  1 mysql  mysql          9 Feb  4 20:50 ddl_recovery-backup.log
-rw-rw----  1 mysql  mysql          9 Feb  4 21:26 ddl_recovery.log
-rw-r--r--  1 mysql  root           0 Oct 29 19:23 debian-10.11.flag
-rw-rw----  1 mysql  mysql      14971 Feb  4 21:17 ib_buffer_pool
-rw-rw----  1 mysql  mysql  100663296 Feb  5 13:04 ib_logfile0
-rw-rw----  1 mysql  mysql   79691776 Feb  4 21:17 ibdata1
-rw-rw----  1 mysql  mysql   12582912 Feb  4 21:26 ibtmp1
-rw-rw----  1 mysql  mysql          0 Oct 29 19:23 multi-master.info
drwx------  2 mysql  mysql       4096 Oct 29 19:23 mysql
-rw-r--r--  1 mysql  root          15 Oct 29 19:23 mysql_upgrade_info
drwx------  2 mysql  mysql      20480 Dec 18 21:33 nextcloud
drwx------  2 mysql  mysql       4096 Dec  5 13:23 ompd
drwx------  2 mysql  mysql       4096 Oct 29 19:23 performance_schema
drwx------  2 mysql  mysql      12288 Oct 29 19:23 sys