[debian-mysql] Bug#1100575: mariadb-server-core: Invalid file '/usr/sbin/mysqld' for capability operation

[NStorm]

Package: mariadb-server-core
Version: 1:10.11.11-0+deb12u1
Severity: normal
X-Debbugs-Cc: lists at nstorm.slmail.me

Hello,

When libcap2-bin installed and setcap available, mariadb-server-core packages
prints this error on install:
Invalid file '/usr/sbin/mysqld' for capability operation
Setcap failed on /usr/sbin/mysqld, required with --memlock if insufficent RLIMIT_MEMLOCK

This happens due to this line in package postinst script:
PROGRAM=$(dpkg-divert --truename /usr/sbin/mysqld)

/usr/sbin/mysqld is a symlink to mariadbd and dpkg-divert --truename aren't resolving it
to target:

root at debian:~# dpkg-divert --truename /usr/sbin/mysqld
/usr/sbin/mysqld
root at debian:~# file /usr/sbin/mysqld
/usr/sbin/mysqld: symbolic link to mariadbd

-- System Information:
Debian Release: 12.10
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 6.1.0-31-amd64 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server-core depends on:
ii  libc6           2.36-9+deb12u10
ii  libcrypt1       1:4.4.33-2
ii  libgcc-s1       12.2.0-14
ii  libnuma1        2.0.16-1
ii  libpcre2-8-0    10.42-1
ii  libssl3         3.0.15-1~deb12u1
ii  libstdc++6      12.2.0-14
ii  libsystemd0     252.36-1~deb12u1
ii  liburing2       2.3-3
ii  mariadb-common  1:10.11.11-0+deb12u1
ii  zlib1g          1:1.2.13.dfsg-1

mariadb-server-core recommends no packages.

mariadb-server-core suggests no packages.

-- no debconf information