Mysql Error 1105
running mysql-4.0.22 on Gentoo Linux. We do regular mysqlhotcopy of all databases and do regular flush logs for transaction logs. However, My flush logs failed since yesterday, the mysqladmin flush-logs gave me error: /usr/bin/mysqladmin: refresh failed; error: 'Unknown error' When I login to server, do 'flush logs' in command line, got error ' ERROR 1105: Unknown error ' Anyone has idea on how to resolve this issue, please share with us. Thanks. Jennifer Thread• ERROR 1105: Unknown error with flush logsJenniferSun28Mar • Re: ERROR 1105: Unknown error with flush logsGlebPaharenko29Mar © 1995, 2016, Oracle Corporation and/or its affiliates Legal Policies Your Privacy Rights Terms of Use Contact Us Page generated in 0.007 sec. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: General :: flush logs; Unkown error New Topic Advanced Search flush logs; Unkown error Posted by: Adam Scott () Date: April 19, 2013 02:32PM If you get ERROR 1105 (HY000): Unknown Error after issuing a flush logs; make sure the permissions are set correctly on your log_error file. Hints * Find the path of log_error for mysql. Send the following to mysql: show global http://lists.mysql.com/mysql/181783 variables like '%err%'; * Check the permissions and make sure the UID (from ps -C mysqld -f at linux prompt) has permissions to write to the file Hoping this helps somebody. Adam Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted flush logs; Unkown error Adam Scott 04/19/2013 02:32PM Sorry, you can't reply to this http://forums.mysql.com/read.php?20,584361 topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Oracle Corporation and/or its affiliates
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting http://dba.stackexchange.com/questions/16339/mysql-flush-logs-unknown-error ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ 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. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL flush logs, unknown error up vote 1 down vote favorite 1 mysql error 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 mysql error 1105 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. mysql logs slow-log share|improve this question asked Apr 11 '12 at 10:26 Katafalkas 3961619 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 '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 | show 2 more comments 2 Answers 2 active oldest votes 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 answered Jul 25 '12 at 11:19 Mahesh Patil 2,071517 add a