Hello.
That's not good: > DBD::mysql::db do failed: Lost connection to MySQL server during query > at /vrmd/admin/cron/apps/purge_logs/purge_logs.pl line 15. MySQL could die during your query. What is in error log? Marten Lehmann <[EMAIL PROTECTED]> wrote: > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
