Thursday Triage Report (2024-11-28)

[Bryce Harrington]

Bugs last updated on 2024-11-27 (Wednesday)
Date range identified as: "Thursday triage"

Found 19 bugs

LP: #2089288 | mysql-8.0           | package mysql-server-8.0 8.0.40-0ubuntu0.24.04.1 failed to … |

The only bug that wasn't already being handled was one of those mysql
apport installation failure bugs due to having the snap installed, as
Andreas figured out recently.  Since that was the only bug to do I put a
couple hour's of attention into it.  Conflicts between the deb and snap
of a given piece of software has some crazy implications, and I wonder
if we'll start running into this beyond mysql.

I filed several bug reports for specific things to look into:

  - apport should collect `snap list` output.  I filed this
    against mysql but I'll bet we'll eventually want it for all
    services that might have a snap published somewhere.
    --> https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2090882

  - Mysql's apport hook should detect a mysql snap and refuse to
    file a bug
    --> https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2090881

  - Mysql's apport hook should check for bound TCP/IP ports.  This
    is a more general problem we've seen crop up in a variety of
    ways, and might be a tough problem to solve, but if we can get
    apport to identify the port issue for us, at least we can have
    it auto-dupe the bugs together or something.
    --> https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2085571

  - Unrelated, but I also noticed KernLog.txt is messed up in a lot of
    the bug reports.  Turns out this comes from apparmor's apport hook.
    I tinkered with the code to try and reproduce the behavior but no
    dice.  But I filed a bug about it:
    --> https://bugs.launchpad.net/ubuntu/+source/apparmor/+bug/2090887

After that, I went through and re-triaged the most recent dozen or so
mysql apport installation bugs, and found several that mentioned a mysql
snap in their dmesg.  I duped those all to LP: #2089288.

Bryce