Hello! Thanks for reviewing the systemd scripts in MariaDB. I added a couple of MariaDB devs as the systemd service files are not maintained in Debian but inherited from upstream MariaDB.
On Thu, 11 Mar 2021 at 19:42, Marc Lehmann <[email protected]> wrote: > > Package: mariadb-server-core-10.5 > Version: 1:10.5.9-1 > Severity: normal > > Dear Maintainer, > > * What led up to the situation? > > various scripts (e.g. galera_new_cluster) and the systemd.unit modify the > global/systemwide environment, e.g. with variables _WSREP_START_POSITION. > > This has the effect of polluting the environment of other sservices with > these variables, which is usually pretty harmless. > > However, if there are multiple server instances then this creates a race > condition where starting/stopping one server or bootstrapping one cluster > will interfere with the other instance,s which could easily lead to > database corruption. > > * What exactly did you do (or not do) that was effective (or > ineffective)? > > I didn't try to solve the problem, it seems to be too fundamental to > easily work around. The mechanism (systemd environment block) is wholly > unsuitable to solve this problem. > > * What was the outcome of this action? > > Environment polluted, critical environment variables of other services > erased/modified. > > * What outcome did you expect instead? > > A systemd service should _never_ _ever_ modify the global environment. > > > -- System Information: > Debian Release: 10.8 > APT prefers stable > APT policy: (990, 'stable'), (500, 'unstable-debug'), (500, > 'testing-debug'), (500, 'stable-updates'), (500, 'stable-debug'), (500, > 'unstable'), (500, 'testing'), (1, 'experimental-debug'), (1, 'experimental') > Architecture: amd64 (x86_64) > Foreign Architectures: i386, x32 > > Kernel: Linux 5.8.18-050818-generic (SMP w/8 CPU threads) > Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, > TAINT_UNSIGNED_MODULE > Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8), LANGUAGE not > set > Shell: /bin/sh linked to /usr/bin/dash > Init: systemd (via /run/systemd/system) > LSM: AppArmor: enabled > > _______________________________________________ > pkg-mysql-maint mailing list > [email protected] > https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-mysql-maint -- - Otto
