Bug#996706: [debian-mysql] Bug#996706: mariadb-server-10.5: run directory is not created in multi-instance mode

[Otto Kekäläinen]

Control: tags -1 patch

This Debian bug is still waiting for a contributor to dive deep into
it, but it is easier now as there is a draft of one way to potentially
solve it in 
https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/29

Bug#996706: [debian-mysql] Bug#996706: mariadb-server-10.5: run directory is not created in multi-instance mode

[Otto Kekäläinen]

Hello Peter and Faustin!

We have several related bugs:

#1028271 [mariadb-server] MariaDB systemd: start using sysusers.d
#1028272 [mariadb-server] MariaDB systemd: start using tmpfiles.d
#1028273 [mariadb-server] MariaDB systemd: make multiple systemd files
compatible with --build=all

We also have latest MariaDB 10.11 in Debian unstable now[1].

I would be very glad if you have something to contribute :)

You could look at the current open bugs[2] in Debian (or Ubuntu) and help by
triaging/commenting them or taking one up and submit a Merge Request to fix it.
There are many issues from low-hanging config tweaks to harder build/test issues
on less common architectures.

[1] https://tracker.debian.org/pkg/mariadb
[2] 
https://bugs.debian.org/cgi-bin/pkgreport.cgi?repeatmerged=no&src=mariadb&src=mariadb-10.6&src=mariadb-10.5&src=mariadb-10.3&src=galera-4

Bug#996706: [debian-mysql] Bug#996706: mariadb-server-10.5: run directory is not created in multi-instance mode

[Faustin Lammler]

Hi Peter!
Sorry for the delay in responding to this bug report.

Peter Keresztes Schmidt ,
17/10/2021 – 15:25:16 (+):

> Starting mariadb as multi-instance service (mariadb@instance-name.service) 
> fails
> since the run directory (/run/mysqld) is not created.

Indeed, this is still the case with both 10.6 repos (MariaDB and Debian).

> The normal unit file (mariadb.service) contains following line:
>   ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld

Yep and also still the case in 10.6.

> This is missing from mariadb@.service. In buster both unit files contain the 
> line.

True.

> Upstream I saw that tmpfiles config generation is implementend since
> 7bbc6c14d1e8fcf1f4737e0a5fcf6237fe18bd23, but I don't see those files
> shipped with the package.

Also true, but this commit is in 10.10 branch, and I don't know if it
will reach 10.6 as it could be considered as a breaking change and too
dangerous.

But there is something that probably needs some attention, see bellow:
https://salsa.debian.org/mariadb-team/mariadb-server/-/blob/debian/latest/debian/not-installed#L26

@Otto, can you maybe explain what are the plans for this.

In the mean time, I believe that multi-instance service should be
configured manually by either creating the directory or by specifying
another PATH for the socket.

See also:
https://mariadb.com/kb/en/systemd/#interacting-with-multiple-mariadb-server-processes

Regards.

-- 
Faustin


signature.asc
Description: PGP signature