Activity log for bug #1899248

Date Who What changed Old value New value Message
2020-10-10 08:53:54 Shubham Aggarwal bug added bug
2020-10-10 09:00:08 Apport retracing service tags amd64 apport-package focal need-duplicate-check amd64 apport-package focal
2020-10-10 09:00:08 Apport retracing service bug added subscriber Crash bug triagers for Ubuntu packages
2020-10-12 14:46:14 Christian Ehrhardt  mysql-8.0 (Ubuntu): status New Incomplete
2020-10-12 14:46:32 Christian Ehrhardt  bug added subscriber Lars Tangvald
2020-12-13 04:17:19 Launchpad Janitor mysql-8.0 (Ubuntu): status Incomplete Expired
2021-02-14 04:56:33 Bryce Harrington summary package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: can't create lock file /var/run/mysqld/mysqlx.sock.lock (service startup timeout?)
2021-02-14 04:56:55 Bryce Harrington mysql-8.0 (Ubuntu): status Expired Confirmed
2021-03-26 15:26:40 Robie Basak mysql-8.0 (Ubuntu): importance Undecided High
2021-03-26 15:26:48 Robie Basak bug added subscriber Ubuntu Server
2021-07-27 16:11:17 Retromingent bug added subscriber Retromingent
2021-10-27 15:56:56 Sergio Durigan Junior tags amd64 apport-package focal amd64 apport-package focal server-todo
2021-11-01 20:22:33 Lena Voytek mysql-8.0 (Ubuntu): assignee Lena Voytek (lvoytek)
2021-11-01 20:23:50 Lena Voytek bug added subscriber Lena Voytek
2021-11-24 05:15:51 Kiruthika Srinivasan bug added subscriber Kiruthika Srinivasan
2021-12-13 14:11:11 Lena Voytek mysql-8.0 (Ubuntu): status Confirmed In Progress
2022-01-10 19:55:29 Lena Voytek nominated for series Ubuntu Hirsute
2022-01-10 19:55:29 Lena Voytek bug task added mysql-8.0 (Ubuntu Hirsute)
2022-01-10 19:55:29 Lena Voytek nominated for series Ubuntu Focal
2022-01-10 19:55:29 Lena Voytek bug task added mysql-8.0 (Ubuntu Focal)
2022-01-10 19:55:29 Lena Voytek nominated for series Ubuntu Jammy
2022-01-10 19:55:29 Lena Voytek bug task added mysql-8.0 (Ubuntu Jammy)
2022-01-10 19:55:29 Lena Voytek nominated for series Ubuntu Impish
2022-01-10 19:55:29 Lena Voytek bug task added mysql-8.0 (Ubuntu Impish)
2022-01-10 19:55:29 Lena Voytek nominated for series Ubuntu Bionic
2022-01-10 19:55:29 Lena Voytek bug task added mysql-8.0 (Ubuntu Bionic)
2022-01-10 19:55:41 Lena Voytek mysql-8.0 (Ubuntu Impish): assignee Lena Voytek (lvoytek)
2022-01-10 19:55:43 Lena Voytek mysql-8.0 (Ubuntu Hirsute): assignee Lena Voytek (lvoytek)
2022-01-10 19:55:46 Lena Voytek mysql-8.0 (Ubuntu Focal): assignee Lena Voytek (lvoytek)
2022-01-10 19:55:50 Lena Voytek mysql-8.0 (Ubuntu Bionic): assignee Lena Voytek (lvoytek)
2022-01-11 14:22:26 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/413960
2022-01-11 14:30:42 Lena Voytek bug task deleted mysql-8.0 (Ubuntu Bionic)
2022-01-11 14:30:48 Lena Voytek mysql-8.0 (Ubuntu Focal): status New In Progress
2022-01-11 14:30:52 Lena Voytek mysql-8.0 (Ubuntu Hirsute): status New In Progress
2022-01-11 14:30:55 Lena Voytek mysql-8.0 (Ubuntu Impish): status New In Progress
2022-01-11 14:30:58 Lena Voytek mysql-8.0 (Ubuntu Focal): importance Undecided High
2022-01-11 14:31:01 Lena Voytek mysql-8.0 (Ubuntu Hirsute): importance Undecided High
2022-01-11 14:31:03 Lena Voytek mysql-8.0 (Ubuntu Impish): importance Undecided High
2022-01-11 14:32:54 Gary Caine bug added subscriber Gary Caine
2022-01-11 14:33:18 Gary Caine removed subscriber Gary Caine
2022-01-11 14:33:24 Gary Caine bug added subscriber Gary Caine
2022-01-11 19:13:26 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/413974
2022-01-11 20:13:46 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/413979
2022-01-12 14:39:50 Lena Voytek mysql-8.0 (Ubuntu Hirsute): status In Progress Won't Fix
2022-01-14 14:38:25 Lena Voytek description Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621 [Impact] When mysql is installed or updated in Focal, Hirsute, Impish, or Jammy, mysqlx reports multiple errors, being unable to create a socket file. These errors will activate apport, requesting that the user reports the issue. The lack of a socket file during intsall causes issues when attempting to verify the mysqlx plugin. Adding this fix will allow the mysqlx plugin to create the socket file during the upgrade process. This is fixed by creating and setting the correct permissions for /var/run/mysqld ahead of time. This is where the socket file is created. [Test Plan] # lxc launch images:ubuntu/(jammy, impish, focal) test-failure # lxc exec test-failure bash # apt update && apt dist-upgrade -y # apt install -y mysql-server software-properties-common - After the initial install mysqlx errors will show up in the error log # grep mysqlx /var/log/mysql/error.log 2022-01-10T14:13:23.627340Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' 2022-01-10T14:13:23.627407Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock' 2022-01-10T14:13:26.564209Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock' ... [Where problems could occur] Since the directory is preemptively created through the postinst file rather than the actual program, mysql may have issues if it does not expect the directory to exist beforehand. Ownership of the directory is given to the mysql user/group, which matches the behavior of mysql in general, but should be looked at if permissions errors arise. [Original Description] Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621
2022-01-19 15:50:50 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/414368
2022-02-14 15:21:24 Lena Voytek summary package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: can't create lock file /var/run/mysqld/mysqlx.sock.lock (service startup timeout?) mysql server crashes during install/update: Error: Unable to shut down server with process id X
2022-02-14 15:46:50 Lena Voytek description [Impact] When mysql is installed or updated in Focal, Hirsute, Impish, or Jammy, mysqlx reports multiple errors, being unable to create a socket file. These errors will activate apport, requesting that the user reports the issue. The lack of a socket file during intsall causes issues when attempting to verify the mysqlx plugin. Adding this fix will allow the mysqlx plugin to create the socket file during the upgrade process. This is fixed by creating and setting the correct permissions for /var/run/mysqld ahead of time. This is where the socket file is created. [Test Plan] # lxc launch images:ubuntu/(jammy, impish, focal) test-failure # lxc exec test-failure bash # apt update && apt dist-upgrade -y # apt install -y mysql-server software-properties-common - After the initial install mysqlx errors will show up in the error log # grep mysqlx /var/log/mysql/error.log 2022-01-10T14:13:23.627340Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' 2022-01-10T14:13:23.627407Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock' 2022-01-10T14:13:26.564209Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/mysqld/mysqlx.sock' failed, can't create lock file /var/run/mysqld/mysqlx.sock.lock' ... [Where problems could occur] Since the directory is preemptively created through the postinst file rather than the actual program, mysql may have issues if it does not expect the directory to exist beforehand. Ownership of the directory is given to the mysql user/group, which matches the behavior of mysql in general, but should be looked at if permissions errors arise. [Original Description] Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621 Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:  [mysqld_safe]  syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions:  dpkg 1.19.7ubuntu3  apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621
2022-02-24 04:02:50 Launchpad Janitor mysql-8.0 (Ubuntu Jammy): status In Progress Fix Released
2022-03-14 17:50:52 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/416826
2022-03-15 14:31:39 Lena Voytek mysql-8.0 (Ubuntu Jammy): status Fix Released In Progress
2022-03-15 17:08:35 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/416902
2022-03-15 17:10:57 Lena Voytek merge proposal unlinked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/414368
2022-03-15 17:21:11 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/416904
2022-03-15 17:38:56 Gary Caine removed subscriber Gary Caine
2022-03-16 22:07:58 Launchpad Janitor mysql-8.0 (Ubuntu Jammy): status In Progress Fix Released
2022-03-23 22:22:11 Lena Voytek description Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:  [mysqld_safe]  syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions:  dpkg 1.19.7ubuntu3  apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621 [Impact] When mysql is installed or updated, the post-install process will temporarily run mysqld to confirm everything is working correctly. Sometimes the shutdown process for mysqld takes longer than 1 min 6 seconds, often due to older hardware, in which case apport is triggered. Adding this fix will allow slower systems to install mysql successfully without reporting any errors. This is fixed by extending the shutdown timer to 3 minutes. This time was chosen based on the shutdown times of the systems from which the associated errors were reported. The average shutdown time was 1 minute 31 seconds, with a max of 2 minutes 42 seconds, excluding one outlier of 59 min 40 seconds. This fix was released in Jammy in version 8.0.28-0ubuntu1. [Test Plan] # lxc launch images:ubuntu/(jammy, impish, focal) test-failure # lxc exec test-failure bash # apt update && apt dist-upgrade -y # apt install software-properties-common - These PPAs reduce the shutdown timer to consistently reproduce the error shown in this bug # add-apt-repository ppa:lvoytek/mysql-autofail-install-(jammy, impish, focal) # apt install -y mysql-server - The following error will show up during install mysqld is running as pid X Error: Unable to shut down server with process id X dpkg: error processing package mysql-server-8.0 (--configure): installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 [Where problems could occur] If there are any hidden issues that only arise a minute or more after a mysql shutdown is requested, then they would have the possibility of arising with the increased timeout. The longer timeout can also increase install and update times which may cause issues for apt. [Original Description] Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621
2022-03-23 22:23:03 Lena Voytek description [Impact] When mysql is installed or updated, the post-install process will temporarily run mysqld to confirm everything is working correctly. Sometimes the shutdown process for mysqld takes longer than 1 min 6 seconds, often due to older hardware, in which case apport is triggered. Adding this fix will allow slower systems to install mysql successfully without reporting any errors. This is fixed by extending the shutdown timer to 3 minutes. This time was chosen based on the shutdown times of the systems from which the associated errors were reported. The average shutdown time was 1 minute 31 seconds, with a max of 2 minutes 42 seconds, excluding one outlier of 59 min 40 seconds. This fix was released in Jammy in version 8.0.28-0ubuntu1. [Test Plan] # lxc launch images:ubuntu/(jammy, impish, focal) test-failure # lxc exec test-failure bash # apt update && apt dist-upgrade -y # apt install software-properties-common - These PPAs reduce the shutdown timer to consistently reproduce the error shown in this bug # add-apt-repository ppa:lvoytek/mysql-autofail-install-(jammy, impish, focal) # apt install -y mysql-server - The following error will show up during install mysqld is running as pid X Error: Unable to shut down server with process id X dpkg: error processing package mysql-server-8.0 (--configure): installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 [Where problems could occur] If there are any hidden issues that only arise a minute or more after a mysql shutdown is requested, then they would have the possibility of arising with the increased timeout. The longer timeout can also increase install and update times which may cause issues for apt. [Original Description] Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions: dpkg 1.19.7ubuntu3 apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621 [Impact] When mysql is installed or updated, the post-install process will temporarily run mysqld to confirm everything is working correctly. Sometimes the shutdown process for mysqld takes longer than 1 min 6 seconds, often due to older hardware, in which case apport is triggered. Adding this fix will allow slower systems to install mysql successfully without reporting any errors. This is fixed by extending the shutdown timer to 3 minutes. This time was chosen based on the shutdown times of the systems from which the associated errors were reported. The average shutdown time was 1 minute 31 seconds, with a max of 2 minutes 42 seconds, excluding one outlier of 59 min 40 seconds. This fix was released in Jammy in version 8.0.28-0ubuntu4. [Test Plan] # lxc launch images:ubuntu/(jammy, impish, focal) test-failure # lxc exec test-failure bash # apt update && apt dist-upgrade -y # apt install software-properties-common - These PPAs reduce the shutdown timer to consistently reproduce the error shown in this bug # add-apt-repository ppa:lvoytek/mysql-autofail-install-(jammy, impish, focal) # apt install -y mysql-server - The following error will show up during install mysqld is running as pid X Error: Unable to shut down server with process id X dpkg: error processing package mysql-server-8.0 (--configure):  installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 [Where problems could occur] If there are any hidden issues that only arise a minute or more after a mysql shutdown is requested, then they would have the possibility of arising with the increased timeout. The longer timeout can also increase install and update times which may cause issues for apt. [Original Description] Every time I open up my system, it shows me to report a problem. ProblemType: Package DistroRelease: Ubuntu 20.04 Package: mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 ProcVersionSignature: Ubuntu 5.4.0-49.53-generic 5.4.65 Uname: Linux 5.4.0-49-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.10 Architecture: amd64 CasperMD5CheckResult: skip Date: Sat Oct 10 11:14:24 2020 ErrorMessage: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 InstallationDate: Installed on 2019-11-23 (321 days ago) InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:  [mysqld_safe]  syslog MySQLVarLibDirListing: ['auto.cnf', 'ibdata1', 'binlog.000002', 'client-cert.pem', 'undo_002', 'undo_001', '#ib_16384_1.dblwr', 'server-key.pem', 'ib_buffer_pool', 'binlog.000003', 'ib_logfile0', 'binlog.000001', 'mysql', 'private_key.pem', 'shubh-Aspire-V5-471P.pid', 'ca-key.pem', 'mysql_upgrade_info', 'debian-5.7.flag', 'public_key.pem', 'ca.pem', 'ib_logfile1', '#ib_16384_0.dblwr', 'binlog.000005', 'performance_schema', 'demodb2', 'binlog.000004', 'sys', '#innodb_temp', 'mysql.ibd', 'ibtmp1', 'server-cert.pem', 'demodb', 'binlog.index', 'client-key.pem'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-5.4.0-49-generic root=UUID=5c8875a3-c41f-436e-82a2-23f82e5abed8 ro quiet splash vt.handoff=7 Python3Details: /usr/bin/python3.8, Python 3.8.5, python3-minimal, 3.8.2-0ubuntu2 PythonDetails: /usr/bin/python2.7, Python 2.7.18, python-is-python2, 2.7.17-4 RelatedPackageVersions:  dpkg 1.19.7ubuntu3  apt 2.0.3 SourcePackage: mysql-8.0 Title: package mysql-server-8.0 8.0.21-0ubuntu0.20.04.4 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 UpgradeStatus: Upgraded to focal on 2020-10-10 (0 days ago) modified.conffile..etc.mysql.mysql.cnf: [modified] mtime.conffile..etc.mysql.mysql.cnf: 2020-05-13T16:03:02.957621
2022-04-07 16:06:56 Robie Basak mysql-8.0 (Ubuntu Impish): status In Progress Fix Committed
2022-04-07 16:06:57 Robie Basak bug added subscriber Ubuntu Stable Release Updates Team
2022-04-07 16:06:59 Robie Basak bug added subscriber SRU Verification
2022-04-07 16:07:02 Robie Basak tags amd64 apport-package focal server-todo amd64 apport-package focal server-todo verification-needed verification-needed-impish
2022-04-07 16:07:28 Robie Basak mysql-8.0 (Ubuntu Focal): status In Progress Fix Committed
2022-04-07 16:07:33 Robie Basak tags amd64 apport-package focal server-todo verification-needed verification-needed-impish amd64 apport-package focal server-todo verification-needed verification-needed-focal verification-needed-impish
2022-04-20 16:18:43 Lena Voytek tags amd64 apport-package focal server-todo verification-needed verification-needed-focal verification-needed-impish amd64 apport-package focal server-todo verification-done-focal verification-needed verification-needed-impish
2022-04-20 16:24:49 Lena Voytek tags amd64 apport-package focal server-todo verification-done-focal verification-needed verification-needed-impish amd64 apport-package focal server-todo verification-done verification-done-focal verification-done-impish
2022-04-26 19:44:06 Brian Murray removed subscriber Ubuntu Stable Release Updates Team
2022-04-26 20:00:39 Launchpad Janitor mysql-8.0 (Ubuntu Impish): status Fix Committed Fix Released
2022-05-03 11:09:29 Launchpad Janitor mysql-8.0 (Ubuntu Focal): status Fix Committed Fix Released
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21412
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21413
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21414
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21415
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21417
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21418
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21423
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21425
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21427
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21435
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21436
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21437
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21438
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21440
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21444
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21451
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21452
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21454
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21457
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21459
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21460
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21462
2022-05-03 11:09:29 Launchpad Janitor cve linked 2022-21478