[debian-mysql] Bug#1067491: time_t transition upgrade: failed systemctl call in preinst due to missing pre-dependencies

[Wouter Verhelst]

Package: mariadb-server
Version: 1:10.11.7-3
Severity: serious

I did a 2G "apt dist-upgrade" to get my way through the time_t
transition. This failed halfway through with the following messages:

Uitpakken van .../10-mariadb-server_1%3a10.11.7-3_amd64.deb wordt voorbereid...
systemctl: error while loading shared libraries: libcrypto.so.3: cannot open shared object file: No such file or directory
dpkg: waarschuwing: subproces van het verouderd pakket mariadb-server het script pre-removal gaf de foutwaarde 127 terug
dpkg: script uit het nieuwe pakket wordt geprobeerd als alternatief...
systemctl: error while loading shared libraries: libcrypto.so.3: cannot open shared object file: No such file or directory
dpkg: fout bij verwerken van archief /tmp/apt-dpkg-install-IuQoIO/10-mariadb-server_1%3a10.11.7-3_amd64.deb (--unpack):
 subproces van het nieuwe pakket mariadb-server het script pre-removal gaf de foutwaarde 127 terug

Here, the Dutch terms translate (approximately) to:

"Unpacking .../10-mariadb-..."

dpkg: warning: subproces of the old package mariadb-server pre-removal script return error value 127
dpkg: trying script from the new package as alternative...

i.e., the prerm script tries to call systemctl, which fails because
libcrypto.so.3 is not on the filesystem. The new package's prerm script
tries the same, which fails for the same reason.

Checking dpkg.log, I see:

2024-03-22 12:12:24 remove libssl3:i386 3.1.5-1 <none>
2024-03-22 12:12:24 status half-configured libssl3:i386 3.1.5-1
2024-03-22 12:12:24 status half-installed libssl3:i386 3.1.5-1
2024-03-22 12:12:24 status config-files libssl3:i386 3.1.5-1
2024-03-22 12:12:24 status not-installed libssl3:i386 <none>
2024-03-22 12:12:24 remove libssl3:amd64 3.1.5-1 <none>
2024-03-22 12:12:24 status half-configured libssl3:amd64 3.1.5-1
2024-03-22 12:12:24 status half-installed libssl3:amd64 3.1.5-1
2024-03-22 12:12:24 status config-files libssl3:amd64 3.1.5-1
2024-03-22 12:12:24 status not-installed libssl3:amd64 <none>
2024-03-22 12:12:24 startup archives unpack
2024-03-22 12:12:25 install libssl3t64:i386 <none> 3.1.5-1.1
2024-03-22 12:12:25 status half-installed libssl3t64:i386 3.1.5-1.1
2024-03-22 12:12:25 status unpacked libssl3t64:i386 3.1.5-1.1

[...]

2024-03-22 12:18:20 upgrade mariadb-server:amd64 1:10.11.7-1 1:10.11.7-3
2024-03-22 12:18:20 status half-configured mariadb-server:amd64 1:10.11.7-1
2024-03-22 12:18:20 status installed mariadb-server:amd64 1:10.11.7-1
2024-03-22 12:18:20 upgrade mariadb-server-core:amd64 1:10.11.7-1 1:10.11.7-3
2024-03-22 12:18:20 status half-configured mariadb-server-core:amd64 1:10.11.7-1
2024-03-22 12:18:20 status unpacked mariadb-server-core:amd64 1:10.11.7-1
2024-03-22 12:18:20 status half-installed mariadb-server-core:amd64 1:10.11.7-1
2024-03-22 12:18:21 status unpacked mariadb-server-core:amd64 1:10.11.7-3

Full dpkg.log of this run attached.

-- System Information:
Debian Release: trixie/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable'), (500, 'testing'), (500, 'stable'), (500, 'oldstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386, arm64

Kernel: Linux 6.7.9-amd64 (SMP w/16 CPU threads; PREEMPT)
Locale: LANG=nl_BE.UTF-8, LC_CTYPE=nl_BE.UTF-8 (charmap=UTF-8), LANGUAGE=nl_BE:nl
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server depends on:
ii  adduser                3.137
ii  debconf [debconf-2.0]  1.5.86
ii  galera-4               26.4.16-2+b1
ii  gawk                   1:5.2.1-2
ii  init-system-helpers    1.66
ii  iproute2               6.8.0-1
ii  libc6                  2.37-15.1
ii  libdbi-perl            1.643-4+b1
ii  libpam0g               1.5.3-6
ii  libssl3t64             3.1.5-1.1
ii  libstdc++6             14-20240315-1
ii  lsof                   4.95.0-1
ii  mariadb-client         1:10.11.7-3
ii  mariadb-common         1:10.11.7-3
ii  mariadb-server-core    1:10.11.7-3
ii  passwd                 1:4.13+dfsg1-4
ii  perl                   5.38.2-3.2
ii  procps                 2:4.0.4-4
ii  psmisc                 23.7-1
ii  rsync                  3.2.7-1+b1
ii  socat                  1.8.0.0-4
ii  zlib1g                 1:1.3.dfsg-3.1

Versions of packages mariadb-server recommends:
ii  libhtml-template-perl           2.97-2
ii  mariadb-plugin-provider-bzip2   1:10.11.7-3
ii  mariadb-plugin-provider-lz4     1:10.11.7-3
ii  mariadb-plugin-provider-lzma    1:10.11.7-3
ii  mariadb-plugin-provider-lzo     1:10.11.7-3
ii  mariadb-plugin-provider-snappy  1:10.11.7-3
ii  pv                              1.8.5-2

Versions of packages mariadb-server suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20220412cvs-1
ii  mailutils [mailx]  1:3.17-1.1+b1
pn  mariadb-test       <none>
ii  netcat-openbsd     1.226-1

-- debconf information excluded
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dpkg.log.gz
Type: application/gzip
Size: 74632 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20240322/38f15cf4/attachment-0001.gz>