2

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.

7
  • 1
    You might not be able to assume the bug is fixed... try to track down a bug report and check the status.
    – Matt Healy
    Apr 11, 2012 at 11:03
  • Two questions : 1) What version of MySQL are you using? 2) Did you recently upgrade? Apr 11, 2012 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, 2012 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 ? Apr 11, 2012 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 ??? Apr 11, 2012 at 20:21

2 Answers 2

2

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

1

You might try setting the permissions for one error-log file. You find the location using:

echo "show global variables like 'log_error';" | mysql -u root -p

And the fix is as trivial as

chown mysql $error_log_file

Worked for me on Ver 14.14 Distrib 5.5.50, for debian-linux-gnu Found at http://forums.mysql.com/read.php?20,584361

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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