Your message dated Mon, 21 Sep 2020 22:43:22 +0300
with message-id
<CAHj_TLBgHk1eBcC-AsjHny=rgpj__pb7rwgzx8xgof3rg25...@mail.gmail.com>
and subject line Re: [debian-mysql] Bug#867137: marked as done ("mariadb
install fails with NO_NEW_PRIVILEGES (systemd)")
has caused the Debian Bug report #867137,
regarding "mariadb install fails with NO_NEW_PRIVILEGES (systemd)"
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.)
--
867137: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=867137
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server-10.1
Version: 10.1.23-9+deb9u1
Severity: important
Dear Maintainer,
* What led up to the situation?
sudo apt-get install -y mariadb-server
* What exactly did you do (or not do) that was effective (or
ineffective)?
* ineffective
- create /etc/systemd/system/mariadb.service.d/whatever.conf with
"NoNewPrivileges=false"
- sudo apt-get --autoremove remove mariadb-server
* effective (in some sense)
- sudo apt-get --autoremove remove mariadb-server-10.1
* What was the outcome of this action?
mariadb-server is not installed
* What outcome did you expect instead?
mariadb-server is installed and running
-- System Information:
Debian Release: 9.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to en_US.UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set
to en_US.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages mariadb-server-10.1 depends on:
ii adduser 3.115
ii debconf [debconf-2.0] 1.5.61
pn galera-3 <none>
ii gawk 1:4.1.4+dfsg-1
ii init-system-helpers 1.48
ii iproute2 4.9.0-1
ii libaio1 0.3.110-3
ii libc6 2.24-11+deb9u1
ii libdbi-perl 1.636-1+b1
ii libpam0g 1.1.8-3.6
ii libstdc++6 6.3.0-18
ii libsystemd0 232-25
ii lsb-base 9.20161125
ii lsof 4.89+dfsg-0.1
ii mariadb-client-10.1 10.1.23-9+deb9u1
ii mariadb-common 10.1.23-9+deb9u1
pn mariadb-server-core-10.1 <none>
ii passwd 1:4.4-4.1
ii perl 5.24.1-3
ii psmisc 22.21-2.1+b2
ii rsync 3.1.2-1
pn socat <none>
ii zlib1g 1:1.2.8.dfsg-5
Versions of packages mariadb-server-10.1 recommends:
ii libhtml-template-perl 2.95-2
Versions of packages mariadb-server-10.1 suggests:
ii bsd-mailx [mailx] 8.1.2-0.20160123cvs-4
ii mailutils [mailx] 1:3.1.1-1
ii mailx 1:20081101-2
pn mariadb-test <none>
pn netcat-openbsd <none>
pn tinyca <none>
here's output from my terminal of install mariadb-server attempt, looking
at logs, then uninstalling mariadb:
-begin terminal-----------------------------
ozzloy% sudo apt-get install -y mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
galera-3 mariadb-server-10.1 mariadb-server-core-10.1 socat
Suggested packages:
mariadb-test netcat-openbsd tinyca
The following NEW packages will be installed:
galera-3 mariadb-server mariadb-server-10.1 mariadb-server-core-10.1 socat
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/11.8 MB of archives.
After this operation, 109 MB of additional disk space will be used.
Preconfiguring packages ...
Selecting previously unselected package galera-3.
(Reading database ... 227821 files and directories currently installed.)
Preparing to unpack .../galera-3_25.3.19-2_amd64.deb ...
Unpacking galera-3 (25.3.19-2) ...
Selecting previously unselected package mariadb-server-core-10.1.
Preparing to unpack .../mariadb-server-core-10.1_10.1.23-9+deb9u1_amd64.deb ...
Unpacking mariadb-server-core-10.1 (10.1.23-9+deb9u1) ...
Selecting previously unselected package socat.
Preparing to unpack .../socat_1.7.3.1-2+b1_amd64.deb ...
Unpacking socat (1.7.3.1-2+b1) ...
Selecting previously unselected package mariadb-server-10.1.
Preparing to unpack .../mariadb-server-10.1_10.1.23-9+deb9u1_amd64.deb ...
/var/lib/mysql: found previous version 10.1
Unpacking mariadb-server-10.1 (10.1.23-9+deb9u1) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../mariadb-server_10.1.23-9+deb9u1_all.deb ...
Unpacking mariadb-server (10.1.23-9+deb9u1) ...
Setting up mariadb-server-core-10.1 (10.1.23-9+deb9u1) ...
Setting up socat (1.7.3.1-2+b1) ...
Setting up galera-3 (25.3.19-2) ...
Processing triggers for systemd (232-25) ...
Processing triggers for man-db (2.7.6.1-2) ...
Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ...
Job for mariadb.service failed because the control process exited with error
code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─whatever.conf
Active: failed (Result: exit-code) since Mon 2017-07-03 22:03:34 PDT; 16ms
ago
Process: 26765 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER
$_WSREP_START_POSITION (code=exited, status=227/NO_NEW_PRIVILEGES)
Process: 26673 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] &&
VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited,
status=0/SUCCESS)
Process: 26670 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 26667 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d
/var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 26765 (code=exited, status=227/NO_NEW_PRIVILEGES)
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: Starting MariaDB databas…..
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[26765]: mariadb.service: Fai…nt
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Main pr…ES
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: Failed to start MariaDB …r.
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Unit en…e.
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Failed …'.
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package mariadb-server-10.1 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mariadb-server:
mariadb-server depends on mariadb-server-10.1 (>= 10.1.23-9+deb9u1); however:
Package mariadb-server-10.1 is not configured yet.
dpkg: error processing package mariadb-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mariadb-server-10.1
mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
ozzloy%
ozzloy% sudo systemctl status --no-pager --full mariadb-server
Unit mariadb-server.service could not be found.
ozzloy%
ozzloy% sudo systemctl status --no-pager --full mariadb-server-10.1
Unit mariadb-server-10.1.service could not be found.
ozzloy%
ozzloy% sudo journalctl --no-pager --full -xe | tail -n 30
ozzloy% sudo journalctl --no-pager --full -xe | tail -n 30
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: ssh.service: Failed to set
invocation ID on control group /system.slice/ssh.service, ignoring: Operation
not supported
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: cgmanager.service: Failed
to set invocation ID on control group /system.slice/cgmanager.service,
ignoring: Operation not supported
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[26765]: mariadb.service:
Failed at step NO_NEW_PRIVILEGES spawning /usr/sbin/mysqld: Invalid argument
-- Subject: Process /usr/sbin/mysqld could not be executed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The process /usr/sbin/mysqld could not be executed and failed.
--
-- The error number returned by this process is 22.
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Main
process exited, code=exited, status=227/NO_NEW_PRIVILEGES
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: Failed to start MariaDB
database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Unit
entered failed state.
Jul 03 22:03:34 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Failed
with result 'exit-code'.
Jul 03 22:03:34 ozzloy.lifeafterking.org sudo[26038]: pam_unix(sudo:session):
session closed for user root
Jul 03 22:04:01 ozzloy.lifeafterking.org sudo[27078]: ozzloy : TTY=pts/5 ;
PWD=/home/ozzloy ; USER=root ; COMMAND=/bin/systemctl status --no-pager --full
mariadb-server
Jul 03 22:04:01 ozzloy.lifeafterking.org sudo[27078]: pam_unix(sudo:session):
session opened for user root by ozzloy(uid=0)
Jul 03 22:04:01 ozzloy.lifeafterking.org sudo[27078]: pam_unix(sudo:session):
session closed for user root
Jul 03 22:04:12 ozzloy.lifeafterking.org sudo[27189]: ozzloy : TTY=pts/5 ;
PWD=/home/ozzloy ; USER=root ; COMMAND=/bin/systemctl status --no-pager --full
mariadb-server-10.1
Jul 03 22:04:12 ozzloy.lifeafterking.org sudo[27189]: pam_unix(sudo:session):
session opened for user root by ozzloy(uid=0)
Jul 03 22:04:12 ozzloy.lifeafterking.org sudo[27189]: pam_unix(sudo:session):
session closed for user root
Jul 03 22:04:49 ozzloy.lifeafterking.org sudo[27597]: ozzloy : TTY=pts/5 ;
PWD=/home/ozzloy ; USER=root ; COMMAND=/bin/journalctl --no-pager --full -xe
Jul 03 22:04:49 ozzloy.lifeafterking.org sudo[27597]: pam_unix(sudo:session):
session opened for user root by ozzloy(uid=0)
ozzloy%
ozzloy% sudo apt-get --autoremove remove mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
mariadb-server
0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 63.5 kB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 228082 files and directories currently installed.)
Removing mariadb-server (10.1.23-9+deb9u1) ...
Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ...
Job for mariadb.service failed because the control process exited with error
code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─whatever.conf
Active: failed (Result: exit-code) since Mon 2017-07-03 22:05:59 PDT; 16ms
ago
Process: 28635 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER
$_WSREP_START_POSITION (code=exited, status=227/NO_NEW_PRIVILEGES)
Process: 28541 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] &&
VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl
set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited,
status=0/SUCCESS)
Process: 28532 ExecStartPre=/bin/sh -c systemctl unset-environment
_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 28523 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d
/var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 28635 (code=exited, status=227/NO_NEW_PRIVILEGES)
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[1]: Starting MariaDB databas…..
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[28635]: mariadb.service: Fai…nt
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Main pr…ES
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[1]: Failed to start MariaDB …r.
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Unit en…e.
Jul 03 22:05:59 ozzloy.lifeafterking.org systemd[1]: mariadb.service: Failed …'.
Hint: Some lines were ellipsized, use -l to show in full.
dpkg: error processing package mariadb-server-10.1 (--configure):
subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
mariadb-server-10.1
E: Sub-process /usr/bin/dpkg returned an error code (1)
ozzloy%
ozzloy% sudo apt-get --autoremove remove mariadb-server-10.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be REMOVED:
galera-3 mariadb-server-10.1 mariadb-server-core-10.1 socat
0 upgraded, 0 newly installed, 4 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 109 MB disk space will be freed.
Do you want to continue? [Y/n] Y
(Reading database ... 228079 files and directories currently installed.)
Removing mariadb-server-10.1 (10.1.23-9+deb9u1) ...
Removing galera-3 (25.3.19-2) ...
Removing mariadb-server-core-10.1 (10.1.23-9+deb9u1) ...
Removing socat (1.7.3.1-2+b1) ...
Processing triggers for man-db (2.7.6.1-2) ...
ozzloy%
-end terminal-------------------------------
--- End Message ---
--- Begin Message ---
Control: tags -1 wontfix
This issue is most likely due to interaction with very old kernel
version. If no further information or tentative fixes are suggested,
whis is closed as a 'wontfix'
--- End Message ---
