In the last episode (Nov 15), matt_lists said:
> I think I found the problem all our input files are prepped in a
> separate table then insert delayed select * from temptable into
> production
>
> 4.0.18-19 removed this!
>
> I dont know why they would allow insert delayed values, or load data
> infile concurrent but not on a select into table!?
>
> Sucks, rewriting all my programs to dump temp tables to the drive,
> then reload them back with load data infile concurrent seems like
> mysql features went backwards instead of forwards with newer
> versions?
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring DELAYED
in this context. (Bug #1983)
http://bugs.mysql.com/bug.php?id=1983
--
Dan Nelson
dnelson@stripped
