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-------------------------------
