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.
_ _ _ _
(_|| | |(_|><
_|
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.