… error until you run perror: [pz@sl1 ~]$ perror 150 MySQL error code 150: Foreign key constraint is incorrectly formed What is also interesting is – this error 150 is in fact internal Innodb error code…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…: 150) Ok, not very informative. It’s not very clear where is the error. Let’s see the explanation with perror: # perror 150 MySQL error code 150: Foreign key constraint is incorrectly… has logged: mysql> select * from test.foreign_key_errors\G *************************** 1. row *************************** ts: 2012-09-26 14:28:31 error: Error in foreign key…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …== at 0x6B67C51: log_io_complete (sync0sync.ic:150) ==9090== by 0x6B34515: fil_aio_wait (fil0fil…os0file.c:4408) ==9090== by 0x6BC459F: srv_error_monitor_thread (srv0srv.c:1673) ==9090== by…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2… just 150 and there are less than 200 tables in this system. innodb_stats_on_metadata is disabled by default in MySQL… disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5.6 goes – STRICT_MODE and…
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… TABLE bar drop j; ERROR 1025 (HY000): Error on rename of ‘./foobar/#sql-3c13_11′ to ‘./foobar/bar’ (errno: 150) And that’s… set ascii not null; ERROR 1025 (HY000): Error on rename of ‘./oops4/#sql-3c13_14′ to ‘./oops4/dos2′ (errno: 150) Oops, we forgot… I think there’s something of an inconsistency present when MySQL won’t allow us to change an FK-referenced column…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… MySQL 3.23.44 have not been improved in new releases as much as I’d like. We still get cryptic error…: 1 Changed: 1 Warnings: 0 mysql> update child set parent_id=1 and v=’BBB’; ERROR 1452 (23000): Cannot add or update….00 sec) mysql> create table parentx(i int) engine=innodb; ERROR 1005 (HY000): Can’t create table ‘test.parentx’ (errno: 150) Innodb will…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… ‘/var/lib/mysql//galera.cache’. 130221 17:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0… was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
February 14, 2013 By 63 Comments
…Threads started! ALERT: failed to execute mysql_stmt_execute(): Err1317 Query execution was interrupted FATAL: database error, exiting… Done. Another test with mysqlslap : $ mysqlslap -vv -u root -h haproxy -P 3307 –number-of-queries=150 –…
Comment: What does Handler_read_rnd mean?
June 26, 2010 By 15 Comments
… twist to this. The original table with 150 records that was not getting cached was mysql.user. I made its exact copy… not increment Handler_read_rnd_next. However, scanning the original mysql.user does. So it is not the size of the…->thd->killed || (tmp != HA_ERR_RECORD_DELETED)) { tmp= rr_handle_error(info, tmp); break; } } return tmp; } ha_myisam::rnd_next() increments…
Comment: A recovery trivia or how to recover from a lost ibdata1 file
September 1, 2012 By 8 Comments
… can I restore a partitioned mysql InnoDB table from just the .ibd files of the form…result in a “storage engine doesn’t have this option” error for partitioned tables. Wes Filter in one of the …’s worth of data trying this. I have about 150 partitions to recover. Any advice on how to recover …
