Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: MySQL 4.0 crash on REPLACE SELECT

Posted on 2006-07-15 19:26:12 by Jeremy Gardiner

Can anyone tell me if this is a known bug?

I haven't been able to find anything similar in the bug database.

With MySQL version 4.0.12 running on Windows 2000:

CREATE TABLE s7 (col9 DOUBLE (1, 1) UNSIGNED NULL DEFAULT 1 AUTO_INCREMENT
PRIMARY KEY ) /* 1518 */;
0000 SUCCESS

CREATE TABLE b9 (col0 MEDIUMINT UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY )
AVG_ROW_LENGTH = 1 AVG_ROW_LENGTH = 1 PACK_KEYS = DEFAULT TYPE = MERGE
INSERT_METHOD = FIRST REPLACE SELECT * FROM s7 /* 3443 */;
0000 SUCCESS

CREATE TABLE a8 (col6 FLOAT (1, 1) NOT NULL DEFAULT 1 ) /* 7284 */;
0000 SUCCESS

CREATE TABLE m5 (col4 LONGTEXT ) /* 7833 */;
0000 SUCCESS

CREATE TEMPORARY TABLE IF NOT EXISTS a8 (col8 DATETIME NULL PRIMARY KEY
REFERENCES g8 ) MIN_ROWS = 1 INSERT_METHOD = NO REPLACE SELECT * FROM m5 /*
9670 */;
0000 SUCCESS

INSERT IGNORE INTO a8 (col8 ) VALUES ("") , (NULL) /* 25906 */;
0000 SUCCESS

REPLACE b9 SELECT * FROM a8 /* 27899 */;
2013 Lost connection to MySQL server during query

----- While I'm on the subject, here is another one: -----

CREATE TEMPORARY TABLE p1 (col8 TINYINT UNSIGNED NULL PRIMARY KEY )
AUTO_INCREMENT = 60 COMMENT = "o" INDEX DIRECTORY = "my_index_directory"
INSERT_METHOD = FIRST TYPE = HEAP RAID_TYPE = STRIPED RAID_CHUNKS = +9
RAID_CHUNKSIZE = 6 TYPE = MERGE /* 6176 */;
0000 SUCCESS

REPLACE p1 VALUES (NULL) , (NULL) , (NULL) /* 15030 */;
2013 Lost connection to MySQL server during query

Again, I haven't found anything similar in the bug database - can anyone
tell me if this is a known bug?

Perhaps it is another manifestation of the bug at the top of this thread?

Thanks,
Jeremy Gardiner


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message

#2: Re: MySQL 4.0 crash on REPLACE SELECT

Posted on 2006-07-17 08:45:31 by Oli Sennhauser

Hi Jeremy

I can reproduce it on my 4.0.26 and my 5.0.22. I think it is a bug and I
recommend you to file a bug. Would you like to do it (the honor is up to
you) or shall I?

Oli

mysql> REPLACE b9 SELECT * FROM a8 /* 27899 */;
ERROR 2013: Lost connection to MySQL server during query
mysql>
Number of processes running now: 0
060717 08:36:33 mysqld restarted


Jeremy Gardiner wrote:
> Can anyone tell me if this is a known bug?
>
> I haven't been able to find anything similar in the bug database.
>
> With MySQL version 4.0.12 running on Windows 2000:
>
> CREATE TABLE s7 (col9 DOUBLE (1, 1) UNSIGNED NULL DEFAULT 1 AUTO_INCREMENT
> PRIMARY KEY ) /* 1518 */;
> 0000 SUCCESS
>
> CREATE TABLE b9 (col0 MEDIUMINT UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY )
> AVG_ROW_LENGTH = 1 AVG_ROW_LENGTH = 1 PACK_KEYS = DEFAULT TYPE = MERGE
> INSERT_METHOD = FIRST REPLACE SELECT * FROM s7 /* 3443 */;
> 0000 SUCCESS
>
> CREATE TABLE a8 (col6 FLOAT (1, 1) NOT NULL DEFAULT 1 ) /* 7284 */;
> 0000 SUCCESS
>
> CREATE TABLE m5 (col4 LONGTEXT ) /* 7833 */;
> 0000 SUCCESS
>
> CREATE TEMPORARY TABLE IF NOT EXISTS a8 (col8 DATETIME NULL PRIMARY KEY
> REFERENCES g8 ) MIN_ROWS = 1 INSERT_METHOD = NO REPLACE SELECT * FROM m5 /*
> 9670 */;
> 0000 SUCCESS
>
> INSERT IGNORE INTO a8 (col8 ) VALUES ("") , (NULL) /* 25906 */;
> 0000 SUCCESS
>
> REPLACE b9 SELECT * FROM a8 /* 27899 */;
> 2013 Lost connection to MySQL server during query
>
> ----- While I'm on the subject, here is another one: -----
>
> CREATE TEMPORARY TABLE p1 (col8 TINYINT UNSIGNED NULL PRIMARY KEY )
> AUTO_INCREMENT = 60 COMMENT = "o" INDEX DIRECTORY = "my_index_directory"
> INSERT_METHOD = FIRST TYPE = HEAP RAID_TYPE = STRIPED RAID_CHUNKS = +9
> RAID_CHUNKSIZE = 6 TYPE = MERGE /* 6176 */;
> 0000 SUCCESS
>
> REPLACE p1 VALUES (NULL) , (NULL) , (NULL) /* 15030 */;
> 2013 Lost connection to MySQL server during query
>
> Again, I haven't found anything similar in the bug database - can anyone
> tell me if this is a known bug?
>
> Perhaps it is another manifestation of the bug at the top of this thread?
>
> Thanks,
> Jeremy Gardiner
>
>
>


--
------------------------------------------------------------ ------------

Haben Sie Ihre Firma schon im FOSS-Directory (www.foss-directory.net) eingetragen?

Oli Sennhauser
Rebenweg 6
CH - 8610 Uster / Switzerland

Phone (+41) 44 940 24 82
e-Mail oli.sennhauser@bluewin.ch
Website http://www.shinguz.ch/
Skype: oli_sennhauser


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Report this message