[Bug 2120936] Re: logrotate returns an error if mysql service is disabled

[Ghadi Rahme]

noble verification:

root at noble-logrotate:~# apt list mysql-server --installed
Listing... Done
mysql-server/noble-proposed,now 8.0.43-0ubuntu0.24.04.2 all [installed]
N: There are 2 additional versions. Please use the '-a' switch to see them.

root at noble-logrotate:~#  systemctl stop mysql.service

root at noble-logrotate:~# systemctl status mysql.service
○ mysql.service - MySQL Community Server
     Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: enabled)
     Active: inactive (dead) since Tue 2025-09-09 07:38:33 UTC; 7s ago
   Duration: 2d 7h 7min 8.709s
    Process: 226363 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
    Process: 226386 ExecStart=/usr/sbin/mysqld (code=exited, status=0/SUCCESS)
   Main PID: 226386 (code=exited, status=0/SUCCESS)
     Status: "Server shutdown complete"
        CPU: 3min 50.252s

Sep 07 00:31:21 noble-logrotate systemd[1]: Starting mysql.service - MySQL Community Server...
Sep 07 00:31:22 noble-logrotate systemd[1]: Started mysql.service - MySQL Community Server.
Sep 09 07:38:31 noble-logrotate systemd[1]: Stopping mysql.service - MySQL Community Server...
Sep 09 07:38:33 noble-logrotate systemd[1]: mysql.service: Deactivated successfully.
Sep 09 07:38:33 noble-logrotate systemd[1]: Stopped mysql.service - MySQL Community Server.
Sep 09 07:38:33 noble-logrotate systemd[1]: mysql.service: Consumed 3min 50.252s CPU time.

root at noble-logrotate:~# sudo logrotate -f /etc/logrotate.conf

root at noble-logrotate:~# echo $?
0

This confirms that noble is working as expected after this patch!

** Tags removed: verification-needed-noble
** Tags added: verification-done-noble

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/2120936

Title:
  logrotate returns an error if mysql service is disabled

Status in mysql-8.0 package in Ubuntu:
  New
Status in mysql-8.4 package in Ubuntu:
  Fix Released
Status in mysql-8.0 source package in Jammy:
  Fix Committed
Status in mysql-8.0 source package in Noble:
  Fix Committed
Status in mysql-8.4 source package in Plucky:
  Fix Committed
Status in mysql-8.4 source package in Questing:
  Fix Released

Bug description:
  [Description]

  After the MR part of this bug report:
  https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1850980

  logrotate returns an error when running the mysql log rotation script
  if the mysql service is disabled.

  It is expected of logrotate not to return an error if the service is disabled since a disabled service will not generate logs to rotate anyways.
  I have written a fix that checks first the status of the mysql service before running the rest of the log rotate script.

  [Test Plan]

  Run the following commands, and verify the output of logrotate:

  $ sudo apt install mysql-server

  $ sudo systemctl stop mysql.service

  $ sudo logrotate -f /etc/logrotate.conf

  If no error is returned by logrotate it means the fix was successful,
  else the following error is shown:

  error: error running shared postrotate script for '/var/log/mysql.log
  /var/log/mysql/*log '

  
  [Where problems could occur]

  Since the changes is related to logs, possible issues may be that the script falsely detects that the mysql service is disabled and not rotate the logs.
  Any problems resulting from this patch are expected to only be limited to log rotation.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/2120936/+subscriptions