** Description changed: - [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 + [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
