** 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 are often mistaken for causes of apport reports, which has made bug triage more difficult with mysql. + These errors could obscure others that show up in the future because it causes the initial mysqld run post-install to behave in an unintended manner. + + 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. + + This fix was released in Jammy in version 8.0.28-0ubuntu1, originally + connected to LP #1899248 before this was determined to be a different + issue. + + [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 + + - After the initial install mysqlx errors will show up in the error log + # grep mysqlx /var/log/mysql/error.log + + 2022-03-15T14:16:55.472453Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' + 2022-03-15T14:16:55.472531Z 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-03-15T14:16:58.399083Z 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] + Whenever mysql-server is installed or updated, /var/log/mysql/error.log will contain the following mysqlx errors: [ERROR] [MY-011292] [Server] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible' [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' followed by [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' - - This is due to a folder permissions error with /var/run/mysqld during the post-install process. + This is due to a folder permissions error with /var/run/mysqld during + the post-install process.
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1964969 Title: mysql error log always contains errors with mysqlx when installing/upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1964969/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
