MySQL Bugs: #2712: Log error file and flush logs command

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.XX	OS:	Windows (Windows/Linux)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
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.

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.