| Bug #29607 | MySQL hangs on BLOB insert | ||
|---|---|---|---|
| Submitted: | 6 Jul 2007 20:26 | Modified: | 17 Jul 2007 17:44 |
| Reporter: | Jerry Y | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.41-community-nt | OS: | Windows (2003 Server) |
| Assigned to: | CPU Architecture: | Any | |
[7 Jul 2007 15:02]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior. Please provide output of SHOW CREATE TABLE, SHOW TABLE STATUS for problem table and your configuration file.
[9 Jul 2007 11:05]
Jerry Y
I have uploaded the requested files. MySQL hangs on updates as well. This update/insert times out in PHP, phpMyAdmin, and the MySQL command line interface.
[17 Jul 2007 14:27]
MySQL Verification Team
Could you please test the latest released version 5.0.45 and comment the result here?. Thanks in advance.
[17 Jul 2007 15:41]
Jerry Y
Upgraded to MySQL 5.0.45 and retested. With Blob set to not allow Nulls, MySQL reported correct error: No default value set. Set Blob to allow Nulls, and insert worked properly without blob in insert. For example: insert into photos (filename, filesize, filetype) values('1', '2', '3'). The blob field was not supplied in the insert.
Reverted back to 5.0.41 and verified that 5.0.41 version had the bug; it does.
[17 Jul 2007 17:44]
Sveta Smirnova
Thank you for the feedback. According to last comment I'll close the report as "Can't repeat".
Description: Create a table with the following: field name: Image, type: BLOB NOT NULL field name: FileName, type: varchar(10) NULL INSERT INTO table (FileName) VALUES ('SomeFile') Server/process/insert will hang. How to repeat: See above. Suggested fix: Change NOT NULL for BLOB to NULL. Insert will now work. Without fix, server/process/insert should return error, not hang.