From: Date: October 11 2005 11:03pm
Subject: Re: Aborted connection problems
List-Archive: http://lists.mysql.com/mysql/190269
Message-Id: <434C28BC.5020306@bryant-greene.name>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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     album_read@localhost on album
>                      27 Query       SET NAMES utf8
>                      28 Connect     album_read@localhost on album
>                      28 Query       SET NAMES utf8
>                      28 Query       CALL getRandomPhoto()
>                      29 Connect     album_read@localhost 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)
> 

-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/