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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]