… Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined on…sec) Records: 0 Duplicates: 0 Warnings: 0 We get no warnings and no errors in 5.6, as the indexes are …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…, improperly built, or misconfigured. This error can also be caused by malfunctioning…mysqld died. If you see no messages after this, something went terribly wrong… ….6(clone+0x6d)[0x33dfee890d] Trying to get some variables. Some pointers may … from pid file /var/lib/mysql/srv-d2-mysql02.pid ended …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… not, it may get writes from the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET…) 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…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…. However… for those using MySQL, Percona Server, MariaDB or any other of the MySQL branches/forks, you get to have these odd limitations… the storage engine to InnoDB however, you will get an error message! The exact error message you get is not very interesting and just says “Can…
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… answer is you may get some extra files, which do not belong to MySQL in database directory. MySQL will only remove files it…/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: Confusing MySQL Replication Error Message
June 4, 2008 By 11 Comments
I already wrote about some MySQL Error Messages which are confusing, here is one more: 080603 20:53:… slave 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: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…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…get the explanation but for some reason it is not done automatically. Even more – the operating system error are often mixed with MySQL errors…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids…Running: Yes [...] Now, if you don’t get any error like primary/unique key duplication then you can…! It is important to mention that these kind of error messages can dissapear on the shell buffer because the…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… new errors in the log simply because the table hadn’t been re-opened. But, before getting too crazy… on a newer version of Percona Server or MysqL 5.6. Another person (I’m looking at you… and be reopened and simply see if the error message comes back. That might something of a performance impact…
