mysql-server apport fails to report my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Fix Released
|
Undecided
|
Lena Voytek | ||
Focal |
In Progress
|
Undecided
|
Lena Voytek | ||
Impish |
Won't Fix
|
Undecided
|
Lena Voytek | ||
Jammy |
Fix Released
|
Undecided
|
Lena Voytek |
Bug Description
[Impact]
Whenever a mysql crash is reported to Launchpad through apport, the my.cnf attachment will often report back as:
MySQLConf.
This makes it difficult to debug a user's configuration issues, and can lead to an incorrect triage of the issue by those unfamiliar with mysql's apport reports.
The provided fix shows what my.cnf links to if it is a symbolic link, or outputs the content of the file if has been customized.
[Test Plan]
To test, create a local apport report of mysql-server:
# lxc launch images:
# lxc exec test-mysql bash
# apt update && apt dist-upgrade -y
# apt install apport mysql-server
# ubuntu-bug mysql-server
V
- Under the my.cnf section the too many symbolic links error will be shown
C
[Where problems could occur]
Now that the apport script follows symlinks to find the actual contents of my.cnf, additional errors could be caused while the crash report is generated.
[Other Info]
This fix was uploaded to kinetic in 8.0.29-0ubuntu3
[Original Description]
Whenever an apport report is made for mysql-8.0 my.cnf goes unreported with the following message:
MySQLConf.
See the auto-generated report below which contains this. The report is from a focal vm with no other errors reported.
ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: mysql-server 8.0.28-
ProcVersionSign
Uname: Linux 5.4.0-107-generic x86_64
ApportVersion: 2.20.11-
Architecture: amd64
CasperMD5CheckR
Date: Mon Apr 18 08:57:38 2022
Logs.var.
MySQLConf.
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLConf.
MySQLVarLibDirL
PackageArchitec
ProcEnviron:
TERM=xterm-
PATH=(custom, no user)
XDG_RUNTIME_
LANG=C.UTF-8
SHELL=/bin/bash
SourcePackage: mysql-8.0
UpgradeStatus: No upgrade log present (probably fresh install)
Related branches
- git-ubuntu bot: Approve
- Christian Ehrhardt (community): Approve
- Canonical Server Reporter: Pending requested
-
Diff: 65 lines (+25/-2)3 files modifieddebian/additions/source_mysql-8.0.py (+7/-1)
debian/changelog (+9/-0)
debian/mysql-server-8.0.postinst (+9/-1)
- Robie Basak: Approve
- Canonical Server: Pending requested
- Canonical Server Core Reviewers: Pending requested
-
Diff: 34 lines (+14/-1)2 files modifieddebian/additions/source_mysql-8.0.py (+7/-1)
debian/changelog (+7/-0)
Changed in mysql-8.0 (Ubuntu): | |
status: | New → In Progress |
Changed in mysql-8.0 (Ubuntu Focal): | |
status: | New → In Progress |
Changed in mysql-8.0 (Ubuntu Impish): | |
status: | New → In Progress |
Changed in mysql-8.0 (Ubuntu Focal): | |
assignee: | nobody → Lena Voytek (lvoytek) |
Changed in mysql-8.0 (Ubuntu Impish): | |
assignee: | nobody → Lena Voytek (lvoytek) |
description: | updated |
This error seems to show up because my.cnf has two levels of symbolic link:
my.cnf -> /etc/alternativ es/my.cnf -> /etc/mysql/ mysql.cnf