MySQL service crash

[cmmourik]

Plz help,

I have the following query which runs fine without the insert
statment.

INSERT INTO `db_x`.`attributes` (id, typeid, value, start_time,
end_time)
SELECT distinct i.id,
at.id AS typeid,
d.megapixels AS value,
NULL AS start_time,
NULL AS end_time
FROM `db_y`.`data` d, `db_x`.`attribute_types` at, `db_x`.`items`
i
WHERE at.name = 'megapixel' AND i.secondid = d.p_id
AND d.megapixels is not null;

When I run it without the insert statement it return 500 rows in about
90ms, when I add the insert statement the whole MySQL service stops.
The `db_x`.`attributes` table furthermore contains a field 'yo' which
is the primary key and an auto_increment field.
I am running MySQL 4.1.9-nt. It is running on Windows Server 2003. I found out it's the following error: 2013 Lost connection to MySQL
server during query. It also happens when I execute a large batch file.

Does anybody have an idea?

Thanks in advance,

Christiaan

 

[dalchri]

Check your error log, there should be a more descriptive error message there.

 

[cmmourik]

I found out what's wrong. the d.megapixels field is a double and the value field is a varchar, MYSQL doesn't like this and crashes.