…_SQL_Running: Yes [...] The error log tells us why the IO thread has not started: 2013-05-17 13:21:26 3130 [ERROR… GTID_MODE OFF and this server has GTID_MODE ON, Error_code: 1593 So unfortunately if you want replication to work correctly… GTID_MODE ON and this server has GTID_MODE OFF, Error_code: 1593 These simple tests answer the first two questions: replication…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined on the table… default SQL mode, a duplicate index will throw a warning instead of a note. In strict mode, it will throw an error…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… engine to InnoDB however, you will get an error message! The exact error message you get is not very interesting and just… can! With this bit of perl code I was able to hit a too many columns error with only 192 columns (i…) { my $n=cname($_,63); $sql.=”`$n`”; $sql.=” ENUM(‘”.cname(0,64).”‘) COMMENT ‘”.cname($_,254).”‘,\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; So the maximum number…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed …. Fixed by replacing the assertion with the error message. Bug fixed #1112224. Fixed the typo … was showing “undefined”. Bug fixed #1171721. Redundant code has been removed from xtrabackup.cc. Bug fixed …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server … –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly … used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server … –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly … used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized …
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
… last error every 10 seconds. 3- Cause an error I run a SQL command that shows this error: ERROR 1025 (HY000): Error on rename of ‘./employees10/#sql… very clear where is the error. Let’s see the explanation with perror: # perror 150 MySQL error code 150: Foreign key constraint is… key errors log them. Just reading the last error happened on the databases is not enough information to dig into the code and…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…> select * from user oder by pwd; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to… error code may have two meanings. Though typically these do not overlap: [pz@sl1 ~]$ perror 124 OS error code 124: Wrong medium type MySQL error code… error 150 is in fact internal Innodb error code. Other storage engines may or may not use same error codes for same kind of error complicating…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
… OS error code 17: File exists It would be already a lot handy if one would walk through all error messages where error code is used and add the text description right into the code. ERROR 1010 (HY000): Error dropping database (can… dropping the database, if you get something else, such as .sql file containing the dump of this database you will not…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… for table ‘/tmp/#sql_21b2_0.MYI’; try to repair it 120326 16:56:45 [ERROR] Got an error from unknown thread, storage… an error. Little-known secret: MyISAM doesn’t handle a disk-full error gracefully 
Sometimes I’ve seen people having trouble with error codes that they don’t believe. Good examples are error 13…
