** 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 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 + 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: 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?) 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
