| 2017-05-16 12:52:22 |
Andreas Hasenack |
bug |
|
|
added bug |
| 2017-05-16 12:55:51 |
Andreas Hasenack |
attachment added |
|
syslog https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+attachment/4877468/+files/syslog |
|
| 2017-05-16 12:58:01 |
Andreas Hasenack |
attachment added |
|
journalctl-xe.log https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+attachment/4877469/+files/journalctl-xe.log |
|
| 2017-05-16 12:58:35 |
Andreas Hasenack |
attachment added |
|
dmesg.txt https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+attachment/4877470/+files/dmesg.txt |
|
| 2017-05-16 13:00:03 |
Andreas Hasenack |
description |
artful unprivileged container on a xenial host
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
We start with systemd-232:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
artful unprivileged container on a xenial host
xnox hinted that https://github.com/systemd/systemd/commit/b3415f5daef49642be3d5f417b8880c078420ff7 might be related
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
We start with systemd-232:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
|
| 2017-05-16 13:01:30 |
Andreas Hasenack |
description |
artful unprivileged container on a xenial host
xnox hinted that https://github.com/systemd/systemd/commit/b3415f5daef49642be3d5f417b8880c078420ff7 might be related
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
We start with systemd-232:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
artful unprivileged container on a xenial host
xnox hinted that https://github.com/systemd/systemd/commit/b3415f5daef49642be3d5f417b8880c078420ff7 might be related
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
Reproducing it on a fresh xenial kvm. We start with systemd-232:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
|
| 2017-05-16 13:02:08 |
Andreas Hasenack |
description |
artful unprivileged container on a xenial host
xnox hinted that https://github.com/systemd/systemd/commit/b3415f5daef49642be3d5f417b8880c078420ff7 might be related
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
Reproducing it on a fresh xenial kvm. We start with systemd-232:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
artful unprivileged container on a xenial host
xnox hinted that https://github.com/systemd/systemd/commit/b3415f5daef49642be3d5f417b8880c078420ff7 might be related
With systemd 233, mysql-server-5.7 in an artful lxd unprivileged container fails to start:
Process: 6460 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=237/KEYRING)
May 16 12:20:08 artful-mysql systemd[1]: mysql.service: Failed to set invocation ID on control group /system.slice/mysql.service, ignoring: Operation not permitted
(...)
May 16 12:20:08 artful-mysql systemd[6460]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied
Reproducing it on a fresh xenial kvm as host, fresh artful lxd image. We start with systemd-232 in the artful lxd:
ubuntu@intense-sunbeam:~$ apt-cache policy systemd
systemd:
Installed: 232-21ubuntu3
Candidate: 233-6ubuntu1
Version table:
233-6ubuntu1 500
500 http://br.archive.ubuntu.com/ubuntu artful/main amd64 Packages
*** 232-21ubuntu3 100
100 /var/lib/dpkg/status
Then we install mysql-server-5.7:
ubuntu@intense-sunbeam:~$ sudo apt install mysql-server-5.7
...
Setting up mysql-server-5.7 (5.7.17-0ubuntu1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Created symlink /etc/systemd/system/multi-user.target.wants/mysql.service → /lib/systemd/system/mysql.service.
Processing triggers for libc-bin (2.24-9ubuntu2) ...
Processing triggers for systemd (232-21ubuntu3) ...
Which starts just fine:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
...
We then upgrade systemd:
ubuntu@intense-sunbeam:~$ sudo apt install systemd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpam-systemd libsystemd0
(...)
Setting up libpam-systemd:amd64 (233-6ubuntu1) ...
mysql is still running:
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
(...)
But restarting mysql fails:
ubuntu@intense-sunbeam:~$ sudo service mysql restart
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
ubuntu@intense-sunbeam:~$ mysql -uroot -psecret
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
More logs attached. |
|
| 2017-05-16 14:58:14 |
Robie Basak |
systemd (Ubuntu): importance |
Undecided |
High |
|
| 2017-05-16 14:58:29 |
Robie Basak |
systemd (Ubuntu): milestone |
|
ubuntu-17.10 |
|
| 2017-05-16 14:58:31 |
Robie Basak |
bug |
|
|
added subscriber Robie Basak |
| 2017-05-16 15:36:22 |
Andreas Hasenack |
summary |
mysql fails to start with systemd 233: failed at step KEYRING |
mysql in lxd fails to start with systemd 233: failed at step KEYRING |
|
| 2017-05-19 21:48:17 |
Brian Murray |
nominated for series |
|
Ubuntu Artful |
|
| 2017-05-19 21:48:17 |
Brian Murray |
bug task added |
|
systemd (Ubuntu Artful) |
|
| 2017-06-09 18:53:36 |
Brian Murray |
systemd (Ubuntu Artful): assignee |
|
Dimitri John Ledkov (xnox) |
|
| 2017-06-09 18:55:31 |
Steve Langasek |
systemd (Ubuntu Artful): milestone |
ubuntu-17.10 |
ubuntu-17.07 |
|
| 2017-06-09 18:55:40 |
Steve Langasek |
systemd (Ubuntu Artful): status |
New |
Triaged |
|
| 2017-08-16 15:48:06 |
Dimitri John Ledkov |
systemd (Ubuntu Artful): milestone |
ubuntu-17.07 |
ubuntu-17.08 |
|
| 2017-09-19 12:45:41 |
Andreas Hasenack |
summary |
mysql in lxd fails to start with systemd 233: failed at step KEYRING |
mysql in lxd fails to start with systemd 233, 234: failed at step KEYRING |
|
| 2017-09-19 16:38:48 |
Dimitri John Ledkov |
bug watch added |
|
https://github.com/systemd/systemd/issues/6871 |
|
| 2017-09-19 16:38:48 |
Dimitri John Ledkov |
bug task added |
|
systemd |
|
| 2017-09-19 21:55:46 |
Bug Watch Updater |
systemd: status |
Unknown |
New |
|
| 2017-09-20 22:16:53 |
Bug Watch Updater |
systemd: status |
New |
Fix Released |
|
| 2017-09-29 17:26:11 |
Francis Ginther |
tags |
|
id-597a8312028fa1cd2c156565 |
|
| 2017-10-04 08:25:37 |
Dimitri John Ledkov |
systemd (Ubuntu Artful): status |
Triaged |
Fix Committed |
|
| 2017-10-06 22:27:50 |
Launchpad Janitor |
systemd (Ubuntu Artful): status |
Fix Committed |
Fix Released |
|
