This massive fix has been pushed into 5.1.19 and so far I cannot repeat any crashes!! Well done Ingo and reviewers ! My testing continues!
changing key_buffer_size on a running server can crash under load
Thursday, May 24, 2007
Monday, May 21, 2007
Think again!. There are many corruptions, crashes, and hangs caused by insert delayed statements. Be especially cautious of using an old version of mysql to do delayed inserts in combination with triggers, stored routines, and merge tables.
Bug #28280 - insert delayed on a table containing trigger leads to server crash
Bug #27998 - mysqld crashed when executing INSERT DELAYED on a BLACKHOLE table
Bug #26464 - insert delayed + update + merge = corruption
Bug #26445 - MySQL crash: drop trigger and insert delayed
Bug #26238 - inserted delayed always inserts 0 for BIT columns
Bug #25712 - insert delayed and check table run together report crashed tables
Bug #25507 - multi-row insert delayed + auto increment causes duplicate key entries on slave
Bug #23312 - server hangs 'closing tables' with insert delayed,flush tables,alter table
Bug #21483 - Server abort or deadlock on INSERT DELAYED with another implicit insert
Bug #16218 - Crash on insert delayed
Sunday, May 20, 2007
It seems doing any partition maintenance in combination with some concurrent workload will fail with many different errors in 5.1. For more or less the same underlying lack of locking, I've filed a few bugs.
To cause a myisam table corruption or server crash (or innodb assert) all you need is 1 thread inserting, and 1 thread altering/optimizing partitions: Of course, the more threads the easier the problems will happen..
Posted by sbester at 17:18
Saturday, May 19, 2007
A short list of some recent bug reports opened by me.
bug #28519 falcon crash with signal 4
bug #28492 subselect returns LONG in >5.0.24a and LONGLONG in <=5.0.24a
bug #28490 crash in handler.cc, handler::print_error(int error, myf errflag)
bug #28489 spurious out of memory message in comment of show table status
bug #28488 Incorrect information in file: './test/t1_test#.frm'
bug #28487 during alter table .. add partition temporary tables are visible to users
bug #28477 innodb assertion and crash during alter table to add/drop partitions
bug #28476 force index on a disabled myisam index gives error 124
bug #28414 please add more useful information to error logs when corruption occurs
bug #28375 mysql crash with subselect and null values
bug #28280 insert delayed on a table containing trigger leads to server crash
bug #28272 server crash during EXPLAIN SELECT ..
bug #28254 innodb crash if shutdown during innodb_table_monitor is running
bug #28211 RENAME DATABASE and query cache don't play nicely together
bug #27860 parser doesn't handle memory well for large queries. crashes server
bug #27854 'mysqladmin debug' command invokes 64bit unaware mallinfo()
bug #27643 query failed : 1114 (The table '' is full)
bug #27594 Can't find file: '.\db1\t1.frm' (errno: 13)
bug #27592 stack overrun when storing datetime value using prepared statements
bug #27516 divide by zero crash during optimize table
Posted by sbester at 14:30