Bug #9107 "Lost connection to MySQL..." when inserting lot of blobs
Submitted: 10 Mar 2005 21:54 Modified: 11 Apr 2005 10:20
Reporter: Andris Kardos Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.10 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[10 Mar 2005 21:54] Andris Kardos 
Description:
Client library reports "Lost connection to MySQL server during query" error when inserting large number of BLOBs (1000++) into a database, and doing other inserts, selects too.

How to repeat:
Try it.
[10 Mar 2005 23:51] MySQL Verification Team 
Are you using an adequate --max_allowed_packet=# when doing these
operations ?
[11 Mar 2005 10:20] Andris Kardos 
Yes, it was the max_allowed_packet variable that was too small. The client lib could check the server's max_allowed_packet automaticall and act accordingly. Would be nicer. Thanks.
[14 Apr 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".