Re: My MySQL server has wanderlust...

Not exactly a Perl question, ;) but since I happen to know the problem ... here you are.
This page should give you the answer.
Shortly, if it is not a timeout problem, it could be that your query has exceeded the size limits set by "max_allowed_packet".
Check the queries that you are feeding the server through the DBI, and see if you have the same result in a command line client.
I also had this error when I tried to update a BLOB field with a chunk of data bigger than the field size.

I hope these hints could be helpful.
If none of the things listed in the manual are solving your problem, you may try at the MySQL mail list

update Try also this link. It will give you more than 200 comments on this issue.

 _  _ _  _  
(_|| | |(_|><
 _|
[download]

Comment on Re: My MySQL server has wanderlust... Download Code

Replies are listed 'Best First'.
Re: Re: My MySQL server has wanderlust... by Sinister (Friar) on Feb 28, 2002 at 13:58 UTC
This could even be the solution to my problem. I insert serialized data (CGI Session info) into my poor MySQL server... - I have now altered the table to have a longglob for dinner... (-;) So far it seems to actually work.... Sinister greetings. "With tying hashes you can do everything God and Larry have forbidden" -- Johan Vromans - YAPC::Europe 2001 perldoc -q $_	[reply]