[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
This also affects Artful running a sid container in lxd. Nothing is particularly MySQL specific I here I think, since the failure happens before MySQL runs at all. The only special systemd things I see in the service unit are the use of ExecStartPre on a bash script and PermissionsStartOnly=true. The full service unit definition is: # MySQL systemd service file [Unit] Description=MySQL Community Server After=network.target [Install] WantedBy=multi-user.target [Service] User=mysql Group=mysql PermissionsStartOnly=true ExecStartPre=/usr/share/mysql/mysql-systemd-start pre ExecStart=/usr/sbin/mysqld ExecStartPost=/usr/share/mysql/mysql-systemd-start post TimeoutSec=600 Restart=on-failure RuntimeDirectory=mysqld RuntimeDirectoryMode=755 -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
AFAICT, /usr/share/mysql/mysql-systemd-start is never run: Aug 18 10:53:51 autopkgtest-lxd-mnbewo systemd[1]: Starting MySQL Community Server... -- Subject: Unit mysql.service has begun start-up -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit mysql.service has begun starting up. Aug 18 10:53:51 autopkgtest-lxd-mnbewo systemd[1649]: mysql.service: Failed at step KEYRING spawning /usr/share/mysql/mysql-systemd-start: Permission denied -- Subject: Process /usr/share/mysql/mysql-systemd-start could not be executed -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- The process /usr/share/mysql/mysql-systemd-start could not be executed and failed. -- -- The error number returned by this process is 13. -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
** Changed in: systemd (Ubuntu Artful) Milestone: ubuntu-17.07 => ubuntu-17.08 -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
For good measure I also installed all of the above packages on a kvm artful instance and services came up fine. systemd version 233-8ubuntu3. -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
I tried systemd from proposed as well but still hit the failure: root@a1:~# apt policy systemd systemd: Installed: 234-2ubuntu3 Candidate: 234-2ubuntu3 Version table: *** 234-2ubuntu3 500 500 http://archive.ubuntu.com/ubuntu artful-proposed/main amd64 Packages 100 /var/lib/dpkg/status 233-8ubuntu3 500 500 http://archive.ubuntu.com/ubuntu artful/main amd64 Packages I was able to reproduce this with several openstack services (cinder-scheduler, nova-scheduler, nova-conductor) and this is blocking autopkgtests so it appears to be fairly pervasive. -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
It looks like I'm hitting the same error with murano-cfapi in an artful unprivileged container: $ sudo apt install murano-cfapi $ sudo tail /var/log/syslog Aug 15 12:25:25 a1 systemd[1]: murano-cfapi.service: Failed to set invocation ID on control group /system.slice/murano-cfapi.service, ignoring: Operation not permitted Aug 15 12:25:25 a1 systemd[1]: Starting OpenStack Murano CF API... Aug 15 12:25:25 a1 systemd[19791]: murano-cfapi.service: Failed at step KEYRING spawning /bin/mkdir: Permission denied Aug 15 12:25:25 a1 systemd[1]: murano-cfapi.service: Control process exited, code=exited status=237 -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
** Changed in: systemd (Ubuntu Artful) Milestone: ubuntu-17.10 => ubuntu-17.07 ** Changed in: systemd (Ubuntu Artful) Status: New => Triaged -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
** Changed in: systemd (Ubuntu Artful) Assignee: (unassigned) => Dimitri John Ledkov (xnox) -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: Triaged Status in systemd source package in Artful: Triaged Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
** Also affects: systemd (Ubuntu Artful) Importance: High Status: New -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: New Status in systemd source package in Artful: New Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp
[Touch-packages] [Bug 1691096] Re: mysql in lxd fails to start with systemd 233: failed at step KEYRING
** Summary changed: - mysql fails to start with systemd 233: failed at step KEYRING + mysql in lxd fails to start with systemd 233: failed at step KEYRING -- You received this bug notification because you are a member of Ubuntu Touch seeded packages, which is subscribed to systemd in Ubuntu. https://bugs.launchpad.net/bugs/1691096 Title: mysql in lxd fails to start with systemd 233: failed at step KEYRING Status in systemd package in Ubuntu: New Bug 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 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. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/systemd/+bug/1691096/+subscriptions -- Mailing list: https://launchpad.net/~touch-packages Post to : touch-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~touch-packages More help : https://help.launchpad.net/ListHelp