Hello,
the current 4.1.11 implementation of PURGE LOGS doesn't seem to work any more. I created a script running once each day doing the following statement:
purge master logs before (select adddate(current_timestamp(), interval -4 day))
That way, all logs prior to today - 4 days will become deleted. This worked fine with 4.1.9. But since I upgraded from 4.1.9 to 4.1.11 I alway get this error:
DBD::mysql::db do failed: Lost connection to MySQL server during query at /vrmd/admin/cron/apps/purge_logs/purge_logs.pl line 15.
This also happens when I'm doing the query manually logged in at the mysql-prompt.
For testing, I simplified to statement e.g. to
purge master logs before '2005-04-24';
Now I didn't lost the connection, but on the other hand, the purging wasn't done. All logfiles remained at their position. To clear a bit of space, I was running "reset master". But so all logfiles have been removed, but I want to keep the logfiles for at least the last 4 days to be able to track statements in case of errors. Any idea what is going wrong? As it worked in 4.1.9, I guess there's a problem in the mysql-server?
Regards Marten
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
