Bug #14974 INSERT DELAYED fails
Submitted: 16 Nov 2005 10:21 Modified: 5 Dec 2005 10:53
Reporter: Jean-Luc Fontaine Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.15 OS:Linux (Linux Fedora Core 3)
Assigned to: MySQL Verification Team CPU Architecture:Any

[16 Nov 2005 10:21] Jean-Luc Fontaine 
Description:
mysql> insert delayed into data values(0, 0, 0, 'xxx', 'ccc');
ERROR 2013 (HY000): Lost connection to MySQL server during query

How to repeat:
use insert delayed command.
[16 Nov 2005 10:22] Jean-Luc Fontaine 
mispelled DELAYED in synopsis.
[16 Nov 2005 14:45] Hartmut Holzgraefe 
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[16 Nov 2005 15:02] Jean-Luc Fontaine 
I do not understand what is missing from my bug report.
Have you tried an INSERT DELAYED into any table? I always get the error.
[18 Nov 2005 13:06] MySQL Verification Team 
Could you please verify if not a duplicate of bug:

http://bugs.mysql.com/bug.php?id=13707

otherwise could you please provide the complete test case
create table & inserts and offended query. 

Thanks in advance.
[21 Nov 2005 11:42] Jean-Luc Fontaine 
Apologies: this happens on tables created by a 4.1 server, but also on a 5.0 using CREATE TABLE ... SELECT * FROM TABLE ... where source table is from 4.1.
Recreating from a mysqldump makes INSERT DELAYED work again.
I leave it up to you to decide whether this is a bug.
Thanks.
[28 Nov 2005 19:28] MySQL Verification Team 
I was unable to repeat with server built from current source using table
created with version 4.1.16.
[5 Dec 2005 10:53] Jean-Luc Fontaine 
I did a little investigation: the table seems old and may have been created by a 4.0 server.