… 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: 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: 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: 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…
