I gave been trying to solve this for few days now, and cant seem to figure this out.
I have been trying to set log rotation for mysql slow using linux logrotate feature, and my script seems to get stuck on mysqladmin flush-logs
.
So I logged into mysql and just entered FLUSH LOGS;
. Not surprisingly I get an error:
mysql> flush logs;
ERROR 1105 (HY000): Unknown error
Now I have been going around asking for ideas, but none seem to work, its not permissions, not owners, not SELinux
I know that there used to be some bug, like in 2005 or 2008 … but its 2012, I assume its fixed.
So if anyone has any ideas, would be much appreciated.
Best Answer
If you are running MySQL on Debian 6 squeeze stable with vMySQL-5.5 then there is a known issue mentioned about dotdeb packaging:
http://bugs.mysql.com/bug.php?id=64988