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