Your message dated Thu, 16 Feb 2023 08:55:56 +0000
with message-id <[email protected]>
and subject line Bug#1031116: fixed in mariadb 1:10.11.1-5
has caused the Debian Bug report #1031116,
regarding autopkgtest for cacti/1.2.23+ds1-2 fails as dbconfig-common attempts
to create database before any server is up
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1031116: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031116
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: cacti
(Filing against cacti for now for visibility, actual root cause might
be elsewhere.)
After uploading mariadb 1:10.11.1-4 the autopkgtests for cacti started
failing on all architectures. I suspect the problem is that the
mariadbd server is not running at the time when dbconfig-common
attempts to create credentials for cacti.
Note in log
https://ci.debian.net/data/autopkgtest/testing/s390x/d/dbconfig-common/31204959/log.gz
section:
Setting up mariadb-server (1:10.11.1-4) ...
Created symlink
/etc/systemd/system/multi-user.target.wants/mariadb.service →
/lib/systemd/system/mariadb.service.
Could not execute systemctl: at /usr/bin/deb-systemd-invoke line 145.
...
Determining localhost credentials from /etc/mysql/debian.cnf: succeeded.
...
dbconfig-common: writing config to /etc/dbconfig-common/db-test-multidbtype.conf
debconf (developer): <-- X_LOADTEMPLATEFILE /var/lib/dpkg/info/ucf.templates ucf
debconf (developer): --> 0
Creating config file /etc/dbconfig-common/db-test-multidbtype.conf
with new version
dbc_read_package_config() .
dbc_detect_installed_dbtype() mysql.
_dbc_detect_installed_dbtype() mysql.
dbc_get_admin_pass() .
debconf (developer): <-- FGET db-test-multidbtype/mysql/admin-pass seen
debconf (developer): --> 0 true
debconf (developer): <-- GET db-test-multidbtype/mysql/admin-pass
debconf (developer): --> 0
_dbc_detect_installed_dbtype() mysql.
ERROR 2002 (HY000): Can't connect to local server through socket
'/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
Line 145 in /usr/bin/deb-systemd-invoke is:
system('systemctl', '--quiet', @instance_args, $action,
@start_units) == 0 or die("Could not execute systemctl: $!");
Looking at previous log
https://ci.debian.net/data/autopkgtest/testing/amd64/c/cacti/31113621/log.gz
(with MariaDB 1:10.11.1-3) this section has:
Setting up mariadb-server (1:10.11.1-3) ...
Created symlink
/etc/systemd/system/multi-user.target.wants/mariadb.service →
/lib/systemd/system/mariadb.service.
There is nothing about deb-systemd-invoke.
When I run this manually inside failed cacti autopkgtest shell I get:
root@fb9c1752c1c7:/tmp/autopkgtest.n2vt3p/build.b5I/real-tree#
/usr/bin/deb-systemd-invoke restart mariadb
sh: 1: systemctl: not found
Can't exec "systemctl": No such file or directory at
/usr/bin/deb-systemd-invoke line 133.
mariadb is a disabled or a static unit not running, not starting it.
Reproducing this manually:
# /usr/bin/deb-systemd-invoke restart mariadb
ERROR:systemctl:the ExecStartPre control process exited with error code
Could not execute systemctl: at /usr/bin/deb-systemd-invoke line 145.
After applying some debugging seems the script attempts to run:
systemctl --quiet --system restart mariadb
Checking what the systemd service file tries to run:
# grep ExecStartPre /lib/systemd/system/mariadb.service
ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld
ExecStartPre=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"
ExecStartPre=/bin/sh -c "[ ! -e /usr/bin/galera_recovery ] && VAR= || \
If systemctl is used from package 'systemctl' (not real, but systemd
shim) the start is bound to fail:
# systemctl unset-environment
ERROR:systemctl:Unknown operation unset-environment.
However, nothing about this changed in MariaDB 10.11.1-4.
# diff -u mariadb.service-10.6.11-2 mariadb.service-10.11.1-4
--- mariadb.service-10.6.11-2 2023-02-12 00:22:18.522820677 +0000
+++ mariadb.service-10.11.1-4 2023-02-12 00:25:01.013942479 +0000
@@ -19,7 +19,7 @@
# (at your option) any later version.
[Unit]
-Description=MariaDB 10.6.11 database server
+Description=MariaDB 10.11.1 database server
Documentation=man:mariadbd(8)
Documentation=https://mariadb.com/kb/en/library/systemd/
After=network.target
# systemctl restart mariadb
ERROR:systemctl:the ExecStartPre control process exited with error code
# dpkg -S /lib/systemd/system/mariadb.service
mariadb-server-10.6: /lib/systemd/system/mariadb.service
Did cacti perhaps change how it uses systemd/systemctl?
Probably not, the same version of cacti has been in Debian for a long
time. Latest upload of dbconfig-common was on Feb 2nd, and after that
MariaDB 10.11.1-3 was still working on Feb 3rd..
Suggestions on what to debug next welcome.
--- End Message ---
--- Begin Message ---
Source: mariadb
Source-Version: 1:10.11.1-5
Done: Otto Kekäläinen <[email protected]>
We believe that the bug you reported is fixed in the latest version of
mariadb, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Otto Kekäläinen <[email protected]> (supplier of updated mariadb package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Wed, 15 Feb 2023 22:57:46 -0800
Source: mariadb
Binary: libmariadb-dev libmariadb-dev-compat libmariadb3 libmariadbd19
libmariadbd-dev mariadb-common mariadb-client-core mariadb-client
mariadb-server-core mariadb-server mariadb-backup mariadb-plugin-connect
mariadb-plugin-s3 mariadb-plugin-rocksdb mariadb-plugin-oqgraph
mariadb-plugin-mroonga mariadb-plugin-spider mariadb-plugin-gssapi-server
mariadb-plugin-gssapi-client mariadb-plugin-cracklib-password-check
mariadb-plugin-hashicorp-key-management mariadb-plugin-provider-bzip2
mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma
mariadb-plugin-provider-lzo mariadb-plugin-provider-snappy mariadb-test
mariadb-test-data
Architecture: source
Version: 1:10.11.1-5
Distribution: unstable
Urgency: medium
Maintainer: Debian MySQL Maintainers <[email protected]>
Changed-By: Otto Kekäläinen <[email protected]>
Description:
libmariadb-dev - MariaDB database development files
libmariadb-dev-compat - MariaDB Connector/C, compatibility symlinks
libmariadb3 - MariaDB database client library
libmariadbd-dev - MariaDB embedded database, development files
libmariadbd19 - MariaDB embedded database, shared library
mariadb-backup - Backup tool for MariaDB server
mariadb-client - MariaDB database client binaries
mariadb-client-core - MariaDB database core client binaries
mariadb-common - MariaDB common configuration files
mariadb-plugin-connect - Connect storage engine for MariaDB
mariadb-plugin-cracklib-password-check - CrackLib Password Validation Plugin
for MariaDB
mariadb-plugin-gssapi-client - GSSAPI authentication plugin for MariaDB client
mariadb-plugin-gssapi-server - GSSAPI authentication plugin for MariaDB server
mariadb-plugin-hashicorp-key-management - Hashicorp Key Management plugin for
MariaDB
mariadb-plugin-mroonga - Mroonga storage engine for MariaDB
mariadb-plugin-oqgraph - OQGraph storage engine for MariaDB
mariadb-plugin-provider-bzip2 - BZip2 compression support in the server and
storage engines
mariadb-plugin-provider-lz4 - LZ4 compression support in the server and
storage engines
mariadb-plugin-provider-lzma - LZMA compression support in the server and
storage engines
mariadb-plugin-provider-lzo - LZO compression support in the server and
storage engines
mariadb-plugin-provider-snappy - Snappy compression support in the server and
storage engines
mariadb-plugin-rocksdb - RocksDB storage engine for MariaDB
mariadb-plugin-s3 - Amazon S3 archival storage engine for MariaDB
mariadb-plugin-spider - Spider storage engine for MariaDB
mariadb-server - MariaDB database server binaries
mariadb-server-core - MariaDB database core server files
mariadb-test - MariaDB database regression test suite
mariadb-test-data - MariaDB database regression test suite - data files
Closes: 1030581 1030908 1031116 1031244
Changes:
mariadb (1:10.11.1-5) unstable; urgency=medium
.
[ Otto Kekäläinen ]
* Packages mariadb-plugin-provider-* must depend at least on MariaDB 10.11
* Make postinstall check work with more than one result (Closes: #1031244)
* Revert "Compression plugins as Depends for mariadb-server" (Closes:
#1031116)
to not break the Cacti autopkgtests and allow the mariadb-10.6 autopkgtest
to fail instead (re-introducing Bug#1031116)
.
[ Bubu ]
* Update French translation of debconf messages (Closes: #1030581)
.
[ Adriano Rafael Gomes ]
* Update Brazilian translation of debconf messages (Closes: #1030908)
Checksums-Sha1:
8aa644a1f236bc56d82875fd93ec98884bca842e 5004 mariadb_10.11.1-5.dsc
bc2c1088be56416c761600d80a5d8c240303390d 268460 mariadb_10.11.1-5.debian.tar.xz
5b7ba84013ef28b4ef2a884e629d16c865898e8d 9517
mariadb_10.11.1-5_source.buildinfo
Checksums-Sha256:
46d1b92d06fa0745b1b3a16495ced56cba552e6e77b119a582d9172d0cf42eae 5004
mariadb_10.11.1-5.dsc
167644c1305edddb76e9935ec56636aeed663b1a9c283bf6754faaef580ff9c4 268460
mariadb_10.11.1-5.debian.tar.xz
c5ed2e84d99f5d03e0b1a8bb5b584241bffd5fd0b356247c23c1e7e5a9c0d16a 9517
mariadb_10.11.1-5_source.buildinfo
Files:
d06920f5bad39db5edeebf03ff1f9f8b 5004 database optional mariadb_10.11.1-5.dsc
c7fe492dc1c378266a11473883086fa1 268460 database optional
mariadb_10.11.1-5.debian.tar.xz
b71641159f6fb7e6cd4392d6ff15963e 9517 database optional
mariadb_10.11.1-5_source.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEmbRSsR88dMO0U+RvvthEn87o2ogFAmPt24MACgkQvthEn87o
2oiLxg/8D1L609Fn4dbfTqAAaTcBfGqofwqiaFG+tlT8OZqBmCBpf7xV3U4g8h1L
KjupUxOWYy/y0bUEJv/ZmCDNSgAOdyEIEnpFEEAXo3JiBGTt1bpKv5dxhhnprT3X
dkEp+vr5XVvW9MmnKOEi1Lh5nb028OA6UMfT8rRGEIJp5yXPVO+JR9sLd5qKZOi7
vBuI2orSldy+gDozPoW9EaLLjJ1MqPWCydBhVyg8nDPp4tDw0bnu/DhnBovKFPt8
Re1u4OYg5jZduH/yp0RQ48MtpMQQLY1q+gVXOVUo6lPAvKMGtMbJ/t4MAY8CKiAM
mq0TfnZH6JNst+CCd/rbCGQnIscKa7B20HcVi/e9MeM09ZMXsegELwXBmM6GqnRD
Pd52ON6EyTm9Ifh/LOYFGnUuvpaTpGmdBpdVw4YHuj+gmHxZ5fk80BSJS9FOs10T
DhSVKiVi3Wiyym/ftdx5r+9dR0GtvRz2KrjxIkXQtK30a4sjgljFg4YrS4ALdtnF
BF42JUQ2y9Zef+Gi6Tu1WoNhPd3syNT306aQGijdjVcoQIQyIEPUVESdXG1oCW8u
CYblmUsgeMbyxTa1BXVJeTJw5zzDAXAnckiVDNgsI5N5PfjeMUMzJhI++ivRsSG1
W3Y7631BNCgSChvKZv23gwd7iwGUwsrluta/C7szETASjPkCBu8=
=m5KJ
-----END PGP SIGNATURE-----
--- End Message ---
