Logrotate fails to rotate logs

[gboutry]

Steps to reproduce

From what happened in the user environment, after accelerating status hooks, mysql charm started to fail to log rotate

1. juju model-config update-status-hook-interval=30s

Expected behavior

Having faster status hook should not fail the

Actual behavior

Charm fails again and again to logrotate

Versions

mysql-k8s: 8.0/stable 180

Juju CLI: 3.6.0

Log output

Juju debug log:

unit-mysql-0: 13:43:13 ERROR unit.mysql/0.juju-log Failed command: commands=logrotate -f /etc/logrotate.d/flush_mysql_logs, user=None, group=None
unit-mysql-0: 13:43:13 WARNING unit.mysql/0.juju-log Failed to rotate MySQL logs

juju ssh -m openstack --container mysql mysql/0 bash
root@mysql-0:/# logrotate -f /etc/logrotate.d/flush_mysql_logs
error: destination /var/log/mysql/archive_error/error.log-20241205_1344 already exists, skipping rotation
error: destination /var/log/mysql/archive_general/general.log-20241205_1344 already exists, skipping rotation
error: destination /var/log/mysql/archive_audit/audit.log-20241205_1344 already exists, skipping rotation

^C

Additional context

Deleting the files (log lost then) allowed the charm to resume operations.

[syncronize-issues-to-jira]

Thank you for reporting us your feedback!

The internal ticket has been created: https://warthogs.atlassian.net/browse/DPE-6156.

This message was autogenerated