Bug #2712 Log error file and flush logs command
Submitted: 11 Feb 2004 13:28 Modified: 4 Mar 2004 23:24
Reporter: Miguel Solorzano Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.XX OS:Windows (Windows/Linux)
Assigned to: MySQL Verification Team CPU Architecture:Any

[11 Feb 2004 13:28] Miguel Solorzano
When is issued a flush logs commands the host_name.err file is renamed
to host_name.err-old and created a new host_name.err. However every next
flush logs command host_name.err-old is deleted lossing the older file
containing error messages.

How to repeat:
Issue 2 flush logs commands.

Suggested fix:
Rename the host_name.err to something like host_name.err_system_time
instead of host_name.err-old and preserve them for the user to move
for another location or to decide himself for the deletion action.
[4 Mar 2004 23:24] Michael Widenius
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

This is the expected behaviour and we can't change this without adding commands to make it possible to purge logs.

I have now added a worklog entry so that we can fix this in a future MySQL version.