| 2022-03-15 14:26:00 |
Lena Voytek |
bug |
|
|
added bug |
| 2022-03-15 14:26:00 |
Lena Voytek |
attachment added |
|
A copy of a fresh install error log from focal on lxd https://bugs.launchpad.net/bugs/1964969/+attachment/5569300/+files/Logs.var.log.mysql.error.log.txt |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
nominated for series |
|
Ubuntu Impish |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Impish) |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
nominated for series |
|
Ubuntu Bionic |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Bionic) |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
nominated for series |
|
Ubuntu Jammy |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Jammy) |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
nominated for series |
|
Ubuntu Focal |
|
| 2022-03-15 14:26:46 |
Lena Voytek |
bug task added |
|
mysql-8.0 (Ubuntu Focal) |
|
| 2022-03-15 14:26:55 |
Lena Voytek |
mysql-8.0 (Ubuntu Jammy): status |
In Progress |
Fix Released |
|
| 2022-03-15 14:27:00 |
Lena Voytek |
mysql-8.0 (Ubuntu Impish): status |
New |
In Progress |
|
| 2022-03-15 14:27:04 |
Lena Voytek |
mysql-8.0 (Ubuntu Focal): status |
New |
In Progress |
|
| 2022-03-15 14:27:07 |
Lena Voytek |
mysql-8.0 (Ubuntu Bionic): status |
New |
In Progress |
|
| 2022-03-15 14:27:16 |
Lena Voytek |
mysql-8.0 (Ubuntu Bionic): assignee |
|
Lena Voytek (lvoytek) |
|
| 2022-03-15 14:27:19 |
Lena Voytek |
mysql-8.0 (Ubuntu Focal): assignee |
|
Lena Voytek (lvoytek) |
|
| 2022-03-15 14:27:21 |
Lena Voytek |
mysql-8.0 (Ubuntu Impish): assignee |
|
Lena Voytek (lvoytek) |
|
| 2022-03-15 14:27:24 |
Lena Voytek |
mysql-8.0 (Ubuntu Bionic): status |
In Progress |
Confirmed |
|
| 2022-03-15 14:28:11 |
Lena Voytek |
bug |
|
|
added subscriber Ubuntu Server |
| 2022-03-15 14:30:38 |
Launchpad Janitor |
merge proposal linked |
|
https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/416826 |
|
| 2022-03-15 17:10:54 |
Lena Voytek |
merge proposal linked |
|
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-16 14:30:27 |
Lena Voytek |
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. |
[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. |
|
| 2022-04-07 16:07:06 |
Robie Basak |
mysql-8.0 (Ubuntu Impish): status |
In Progress |
Fix Committed |
|
| 2022-04-07 16:07:07 |
Robie Basak |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
| 2022-04-07 16:07:09 |
Robie Basak |
bug |
|
|
added subscriber SRU Verification |
| 2022-04-07 16:07:12 |
Robie Basak |
tags |
|
verification-needed verification-needed-impish |
|
| 2022-04-07 16:07:36 |
Robie Basak |
mysql-8.0 (Ubuntu Focal): status |
In Progress |
Fix Committed |
|
| 2022-04-07 16:07:39 |
Robie Basak |
tags |
verification-needed verification-needed-impish |
verification-needed verification-needed-focal verification-needed-impish |
|
| 2022-04-20 16:17:19 |
Lena Voytek |
tags |
verification-needed verification-needed-focal verification-needed-impish |
verification-done-focal verification-needed verification-needed-impish |
|
| 2022-04-20 16:23:50 |
Lena Voytek |
tags |
verification-done-focal verification-needed verification-needed-impish |
verification-done verification-done-focal verification-done-impish |
|
| 2022-04-20 16:32:32 |
Lena Voytek |
mysql-8.0 (Ubuntu Bionic): status |
Confirmed |
Invalid |
|
| 2022-04-20 16:32:38 |
Lena Voytek |
mysql-8.0 (Ubuntu Bionic): assignee |
Lena Voytek (lvoytek) |
|
|
| 2022-04-26 19:44:11 |
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 |
|
