…disconnected with my application. The error is given below. Because … BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.BindException: Address already …mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… see questions about how to understand the nature of errors in MySQL‘s error log. Now, there is a lot of complexity to… particular class of errors that is relatively easy to diagnose, if you pay close attention to the error message. Often an error has a little number in it, as in this example from our forums: 120326 16:56:45 [ERROR…
Comment: How to diagnose errors in the MySQL error log
March 27, 2012 By 4 Comments
Is there any good reason why you need to use perror first instead of MySQL writing the error message into the log along with the error code?
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
…, it gives me this error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere on the…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now… you remove this file manually. Another enjoyable error message: “Can’t find messagefile ‘/usr/share/mysql/english/errmsg.sys” Everything is good and…/share/mysql/english/errmsg.sys The file does exist so “can’t find messagefile” error message is misleading to say the least. The error…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
What MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives you information about tokens near by but little details: mysql…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:53:… Server I’m getting error log file flooded with messages like this and there is no hint in the message what would explain… it would be nice to include possible reason for this error message which MySQL already does in many other cases. I’ve now…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… 7 defined in the MySQL This customer was running Percona Server 5.1 and they got this error on two tables during… consider this on a newer version of Percona Server or MysqL 5.6. Another person (I’m looking at you, Baron… to close and be reopened and simply see if the error message comes back. That might something of a performance impact, but…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… log corruption and you can check details in the MySQL Error log file. The error message describes few reasons and indeed because there is… in relay logs. Really this is only one of various error messages you could see if relay log corrupted. You could also… are bad on the master you would get the same error message again and can continue with investigation. What if logs on…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… xtrabackup binary against more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona… operating messages would go to STDERR. With this bug fixed, we have gone through both programs and ensured that only error messages go… –incremental-lsn options were specified together, innobackupexwould give an erroneous error message when it tried to look at the contents of a…
