Description of problem: The rules for rotating the mariodb logs are wrong in the case, that the file to be zipped is still in use and may change while zipping. Version-Release number of selected component (if applicable): mariadb-server-10.3.12-10.fc29.x86_64 How reproducible: Always Steps to Reproduce: 1. regular log rotate 2. 3. Actual results: /etc/cron.daily/logrotate: error: Compressing program wrote following message to stderr when compressing log /var/log/mariadb/mariadb.log-20190228: gzip: stdin: file size changed while zipping Expected results: No error at all Additional info: You might want to use "copytruncate" and zip the copied file.
I'd incline to adding "delaycompress" option. The "copytruncate" explixitly says in its manpage it may loose log entries. -- The whole script would use fixing on several places. You can check and discuss upstream. https://jira.mariadb.org/browse/MDEV-16621
Any progress on that topic concerning the Fedora package?
Let's move this bug to Rawhide. -- Progress? Not really. I've dig deeper into the issue and it's really like 4 issues entangled together. What we need right now, would be MariaDB start flushing logs more wisely on ceratin signals, so the signals can be used in real-case, heavy load, scenario. Without solving this part, in the database itself, I won't expect a huge progress. -- I'll keep the needinfo on myself to remind me to check on it time to time.
This bug appears to have been reported against 'rawhide' during the Fedora 31 development cycle. Changing version to '31'.
This bug appears to have been reported against 'rawhide' during the Fedora 31 development cycle. Changing version to 31.
This bug appears to have been reported against 'rawhide' during the Fedora 33 development cycle. Changing version to 33.
Also reported for RHEL. Can you please fix this. Thank you. I tested "delaycompress" and works well. RHEL bug: https://bugzilla.redhat.com/show_bug.cgi?id=1772330
Commited to git: https://src.fedoraproject.org/rpms/mariadb/c/f20aec3d3dbd2e0410749bec263ad74a32c9e31e?branch=rawhide
Build available: https://koji.fedoraproject.org/koji/buildinfo?buildID=1708682 I'd be glad for a feedback
Changes looks fine, but hard to test. Need to wait a week or two on a real production server and wait until there are enough logs to rotate. I can really test only if you can put this change at least to updates-testing for stable Fedora/EPEL. Then I can test on production servers.
FEDORA-2021-7e035eeb6e has been submitted as an update to Fedora 34. https://bodhi.fedoraproject.org/updates/FEDORA-2021-7e035eeb6e
FEDORA-2021-7e035eeb6e has been pushed to the Fedora 34 testing repository. Soon you'll be able to install the update with the following command: `sudo dnf upgrade --enablerepo=updates-testing --advisory=FEDORA-2021-7e035eeb6e` You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2021-7e035eeb6e See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.
FEDORA-2021-7e035eeb6e has been pushed to the Fedora 34 stable repository. If problem still persists, please make note of it in this bug report.