mysql error log always contains errors with mysqlx when installing/upgrading
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Fix Released
|
Undecided
|
Lena Voytek | ||
Bionic |
Invalid
|
Undecided
|
Unassigned | ||
Focal |
Fix Released
|
Undecided
|
Lena Voytek | ||
Impish |
Fix Released
|
Undecided
|
Lena Voytek | ||
Jammy |
Fix Released
|
Undecided
|
Lena Voytek |
Bug Description
[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:
# 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/
2022-03-
2022-03-
2022-03-
[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/
[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/
followed by
[ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/var/run/
This is due to a folder permissions error with /var/run/mysqld during the post-install process.
Related branches
- Bryce Harrington (community): Approve
- Utkarsh Gupta (community): Needs Information
- Canonical Server: Pending requested
- Canonical Server Core Reviewers: Pending requested
-
Diff: 59 lines (+18/-5)2 files modifieddebian/changelog (+10/-0)
debian/mysql-server-8.0.postinst (+8/-5)
- Bryce Harrington (community): Approve
- Utkarsh Gupta (community): Approve
- Canonical Server: Pending requested
- Canonical Server Core Reviewers: Pending requested
-
Diff: 59 lines (+18/-5)2 files modifieddebian/changelog (+10/-0)
debian/mysql-server-8.0.postinst (+8/-5)
- Bryce Harrington (community): Approve
- Canonical Server packageset reviewers: Pending requested
- Canonical Server Core Reviewers: Pending requested
-
Diff: 36 lines (+14/-3)2 files modifieddebian/changelog (+11/-0)
debian/mysql-server-8.0.postinst (+3/-3)
description: | updated |
Changed in mysql-8.0 (Ubuntu Bionic): | |
status: | Confirmed → Invalid |
assignee: | Lena Voytek (lvoytek) → nobody |
Hello Lena, or anyone else affected,
Accepted mysql-8.0 into impish-proposed. The package will build now and be available at https:/ /launchpad. net/ubuntu/ +source/ mysql-8. 0/8.0.28- 0ubuntu0. 21.10.4 in a few hours, and then in the -proposed repository.
Please help us by testing this new package. See https:/ /wiki.ubuntu. com/Testing/ EnableProposed for documentation on how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.
If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, what testing has been performed on the package and change the tag from verification- needed- impish to verification- done-impish. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification- failed- impish. In either case, without details of your testing we will not be able to proceed.
Further information regarding the verification process can be found at https:/ /wiki.ubuntu. com/QATeam/ PerformingSRUVe rification . Thank you in advance for helping!
N.B. The updated package will be released to -updates after the bug(s) fixed by this package have been verified and the package has been in -proposed for a minimum of 7 days.