Hello.
I was unable to find reported bugs with similar symptoms for the 5.0 version (hope I haven't missed something). But at the bottom of: http://dev.mysql.com/doc/mysql/en/packet-too-large.html we have these lines: " You can also get strange problems with large packets if you are using large BLOB values but have not given mysqld access to enough memory to handle the query. If you suspect this is the case, try adding ulimit -d 256000 to the beginning of the mysqld_safe script and restarting mysqld." I don't know if you're using BLOBS in your SPs, but the problem could be in that MySQL doesn't have enough memory to complete the query. If you are able to make a repeatable test case you may want to report a bug at bugs.mysql.com (remember, you may win one of the iPods :) See: http://dev.mysql.com/mysql_5_contest.html Very often trace files might be helpful. See: http://dev.mysql.com/doc/mysql/en/making-trace-files.html Jasper Bryant-Greene wrote: > Just to add to this further, if I reduce max_allowed_packet in my.cnf > down to around 16M, then the error changes to "Got a packet bigger than > 'max_allowed_packet' bytes". > > However, as you can see from the SQL below, the longest SQL statement > I'm executing is around 21 bytes, certainly nowhere near 16MB. > > > Jasper Bryant-Greene wrote: > >> I seem to be getting heaps of aborted connections, and I can't figure >> out why. MySQL's error (from mysqld.err, below) is "Got an error >> reading communication packets", but this is a socket link to localhost >> so that rules out network problems. I simply can't figure it out. Has >> anyone got any ideas? >> >> mysqld Ver 5.0.13-rc-log for pc-linux-gnu on x86_64 (Gentoo Linux) >> >> >> [/tmp/mysqld.sql] >> 051012 21:53:44 27 Connect [EMAIL PROTECTED] on album >> 27 Query SET NAMES utf8 >> 28 Connect [EMAIL PROTECTED] on album >> 28 Query SET NAMES utf8 >> 28 Query CALL getRandomPhoto() >> 29 Connect [EMAIL PROTECTED] on album >> 29 Query SET NAMES utf8 >> 29 Query CALL getHelp('gallery') >> 29 Quit >> >> [/var/log/mysql/mysqld.err] >> 051012 21:53:44 [Warning] Aborted connection 27 to db: 'album' user: >> 'album_read' host: 'localhost' (Got an error reading communication >> packets) >> 051012 21:53:44 [Warning] Aborted connection 28 to db: 'album' user: >> 'album_read' host: 'localhost' (Got an error reading communication >> packets) >> > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
