maria-discuss team mailing list archive

[Jogchum Reitsma <jogchum.reitsma@xxxxxxxxx>]

I'm not sure my previous reply to this message came through, (maybe 
withheld because of html-format) so I give it a try again.
Anyway, my problem is not solved yet.
Funny thing is I don't see my own messages in this conversation (I'm on 
Thunderbird)..

Op 13-10-2022 om 15:36 schreef Reindl Harald:
> Am 13.10.22 um 15:29 schrieb Jogchum Reitsma:
> > Op 13-10-2022 om 15:10 schreef Reindl Harald:
> > > > There I have plenty of room in a raid6 configuration, where the 
> > > > default location is much smaller, and populated by the infamous 
> > > > (well, with me at least) btrfs filesystem.
> > >
> > > you can put the data in /home/mysql, make a bind-mount from 
> > > /var/lib/mysql to /home/mysql and change the config to use 
> > > /var/lib/mysql
> >
> > OK, so, to be quite sure, the command then is
> >
> > mount --bind <the-location-the-database-resides-now> /var/lib/mysql
> yes, the only difference to any other mount is type "bind"
>
> my /etc/fstab for /home while "/mnt/data/home" is the phyiscal 
> location on a 4 TB RAID
>
> /mnt/data/home /home  none  bind
>
> i don't create bind mounts manually because you can mount, unmount and 
> comment out them in fstab like every other mountpoint and i perfer 
> them to survive reboots
OK, I've done so, and now

l /var/lib/mysql

reads, no surprise, the contents of the original db location.

In /etc/my.cnf I changed the location to /var/lib/mysql.

But, starting the database server still fails with the same error and 
warning messages:

okt 13 16:35:15 linux-mkay systemd[1]: Starting MariaDB database server...
░░ Subject: A start job for unit mariadb.service has begun execution
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has begun execution.
░░
░░ The job identifier is 6638394.
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 
16:35:15 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as 
process 92738 ...
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 
16:35:15 0 [Warning] Can't create test file 
/var/lib/mysql/linux-mkay.lower-test
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: [90B blob data]
okt 13 16:35:15 linux-mkay mysql-systemd-helper[92738]: 2022-10-13 
16:35:15 0 [ERROR] Aborting
okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
okt 13 16:35:15 linux-mkay systemd[1]: mariadb.service: Failed with 
result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mariadb.service has entered the 'failed' state with result 
'exit-code'.
okt 13 16:35:15 linux-mkay systemd[1]: Failed to start MariaDB database 
server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 6638394 and the job result is failed.


So nothing is gained so far...

regards, Jogchum