…do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX …: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on the mysql_install_db process. Every time I tried, I got some variant of this message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We…out where mysqld died. If you see no messages after this, something went terribly wrong… stack_bottom =…mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR… restart replication, it fails. However, I don’t like the error message, specifically the ‘fix in config file’ part. What happens if… no longer works: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master to master_host=”; ERROR 1210 (HY000…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never… by replacing the assertion with the error message. Bug fixed #1112224. Fixed the typo in the innobackupex error output. Bug fixed #1157225. When…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file…_length+int_length+com_length > 65535L || int_count > 255) { my_message(ER_TOO_MANY_FIELDS, ER(ER_TOO_MANY_FIELDS), MYF… storage engine to InnoDB however, you will get an error message! The exact error message you get is not very interesting and just says…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never… #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing “undefined”. Bug fixed…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…. Bugs Fixed: Using Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client introduced a regression…-info option, innobackupex failed with a fatal error. Replaced the fatal error with a diagnostic message about innobackupex –slave-info being ignored in…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 25, 2013 By 26 Comments
I can start the server but failed to connect the server. error message: $ mysql -S /u01/tokudb/run/mysql.sock -uroot ERROR 2012 (HY000): Error in server handshake Is there any solution?
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…
