[debian-mysql] Bug#996706: 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 <carbenium at outlook.com>,
17/10/2021 – 15:25:16 (+0000):

> Starting mariadb as multi-instance service (mariadb at 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 at .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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20220906/205491da/attachment.sig>