that key_cache bug, 17332

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

Using 'insert delayed into ... '?

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

partition maintenance?

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..

Bug #28477
Bug #28487
Bug #28488
Bug #28489
Bug #28490

to get started

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