Activity log for bug #1969369

Date Who What changed Old value New value Message
2022-04-18 16:04:27 Lena Voytek bug added bug
2022-04-18 16:05:00 Lena Voytek mysql-8.0 (Ubuntu): assignee Lena Voytek (lvoytek)
2022-04-18 16:05:15 Lena Voytek bug added subscriber Ubuntu Server
2022-04-21 19:13:32 Lena Voytek mysql-8.0 (Ubuntu): status New In Progress
2022-04-21 21:03:54 Lena Voytek nominated for series Ubuntu Impish
2022-04-21 21:03:54 Lena Voytek bug task added mysql-8.0 (Ubuntu Impish)
2022-04-21 21:03:54 Lena Voytek nominated for series Ubuntu Jammy
2022-04-21 21:03:54 Lena Voytek bug task added mysql-8.0 (Ubuntu Jammy)
2022-04-21 21:03:54 Lena Voytek nominated for series Ubuntu Focal
2022-04-21 21:03:54 Lena Voytek bug task added mysql-8.0 (Ubuntu Focal)
2022-04-21 21:04:07 Lena Voytek mysql-8.0 (Ubuntu Focal): status New In Progress
2022-04-21 21:04:12 Lena Voytek mysql-8.0 (Ubuntu Impish): status New In Progress
2022-04-21 21:04:17 Lena Voytek mysql-8.0 (Ubuntu Focal): assignee Lena Voytek (lvoytek)
2022-04-21 21:04:19 Lena Voytek mysql-8.0 (Ubuntu Impish): assignee Lena Voytek (lvoytek)
2022-05-11 20:38:30 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/422034
2022-06-09 18:02:18 Launchpad Janitor mysql-8.0 (Ubuntu): status In Progress Fix Released
2022-06-27 17:27:42 Lena Voytek description Whenever an apport report is made for mysql-8.0 my.cnf goes unreported with the following message: MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' 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-0ubuntu0.20.04.3 ProcVersionSignature: User Name 5.4.0-107.121-generic 5.4.174 Uname: Linux 5.4.0-107-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.23 Architecture: amd64 CasperMD5CheckResult: skip Date: Mon Apr 18 08:57:38 2022 Logs.var.log.daemon.log: MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql] MySQLConf.etc.mysql.conf.d.mysqldump.cnf: [mysqldump] quick quote-names max_allowed_packet = 16M MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' MySQLVarLibDirListing: False PackageArchitecture: all ProcEnviron: TERM=xterm-256color PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=C.UTF-8 SHELL=/bin/bash SourcePackage: mysql-8.0 UpgradeStatus: No upgrade log present (probably fresh install) [Impact] Whenever a mysql crash is reported to Launchpad through apport, the my.cnf attachment will often report back as: MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' 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:ubuntu/[kinetic, jammy, impish, focal] test-mysql # 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.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' 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-0ubuntu0.20.04.3 ProcVersionSignature: User Name 5.4.0-107.121-generic 5.4.174 Uname: Linux 5.4.0-107-generic x86_64 ApportVersion: 2.20.11-0ubuntu27.23 Architecture: amd64 CasperMD5CheckResult: skip Date: Mon Apr 18 08:57:38 2022 Logs.var.log.daemon.log: MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql] MySQLConf.etc.mysql.conf.d.mysqldump.cnf: [mysqldump] quick quote-names max_allowed_packet = 16M MySQLConf.etc.mysql.my.cnf: Error: [Errno 40] Too many levels of symbolic links: '/etc/mysql/my.cnf' MySQLVarLibDirListing: False PackageArchitecture: all ProcEnviron: TERM=xterm-256color PATH=(custom, no user) XDG_RUNTIME_DIR=<set> LANG=C.UTF-8 SHELL=/bin/bash SourcePackage: mysql-8.0 UpgradeStatus: No upgrade log present (probably fresh install)
2022-06-27 20:03:08 Launchpad Janitor merge proposal linked https://code.launchpad.net/~lvoytek/ubuntu/+source/mysql-8.0/+git/mysql-8.0/+merge/425666
2022-07-01 23:20:50 Steve Langasek mysql-8.0 (Ubuntu Jammy): status In Progress Fix Committed
2022-07-01 23:20:52 Steve Langasek bug added subscriber Ubuntu Stable Release Updates Team
2022-07-01 23:20:54 Steve Langasek bug added subscriber SRU Verification
2022-07-01 23:20:57 Steve Langasek tags amd64 apport-bug focal uec-images amd64 apport-bug focal uec-images verification-needed verification-needed-jammy
2022-07-11 16:47:30 Lena Voytek mysql-8.0 (Ubuntu Impish): status In Progress Won't Fix
2022-07-14 14:12:50 Lena Voytek tags amd64 apport-bug focal uec-images verification-needed verification-needed-jammy amd64 apport-bug focal uec-images verification-done-jammy verification-needed
2022-07-25 11:45:13 Robie Basak removed subscriber Ubuntu Stable Release Updates Team
2022-07-25 11:45:08 Launchpad Janitor mysql-8.0 (Ubuntu Jammy): status Fix Committed Fix Released