Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
1  
You might not be able to assume the bug is fixed... try to track down a bug report and check the status. –  matthewh Apr 11 '12 at 11:03
    
Two questions : 1) What version of MySQL are you using? 2) Did you recently upgrade? –  RolandoMySQLDBA Apr 11 '12 at 15:35
    
MySQL version - 5.5.21. I did not upgrade recently. OS: CentOS - 6 . Kernel 2.6.32-220.7.1.el6.x86_64 –  Katafalkas Apr 11 '12 at 16:11
    
Next two questions: Did you ever run flush logs before? If you did, did you get this same error message ERROR 1105 (HY000): Unknown error ? –  RolandoMySQLDBA Apr 11 '12 at 20:18
    
Let me restart my previous question: You have MySQL 5.5.21. Did you recently upgrade to MySQL 5.5.21 from a previous version ??? –  RolandoMySQLDBA Apr 11 '12 at 20:21

1 Answer 1

up vote 1 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.