** Description changed: + [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 + [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 + 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
** Description changed: [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. + 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 - + 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 + [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 + 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1899248 Title: mysql server crashes during install/update: Error: Unable to shut down server with process id X To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1899248/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs