Hi,
I too have a server whose log file is full of these errors.
This server is also running MySQL 4.0.20. It is on Red Hat Enterprise
Linux AS release 3 (Taroon).
The errors are: (many thousands of them)...
051004 15:39:34 Aborted connection 349 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 15:39:56 Aborted connection 134 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 16:09:25 Aborted connection 351 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 16:18:19 Aborted connection 339 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 16:18:20 Aborted connection 325 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 17:32:06 Aborted connection 367 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 18:05:41 Aborted connection 662 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 19:20:55 Aborted connection 61 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 21:59:03 Aborted connection 246 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 22:08:19 Aborted connection 317 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
051004 22:08:34 Aborted connection 314 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
My /etc/my.cnf is:
cat /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer_size=16M
set-variable = max_allowed_packet=5M
datadir=/usr/local/mysql/data
[mysqldump]
quick
Regards,
Ian Collins.
Randy Paries wrote:
>Thanks for the reply and the kindly reprimand
>
>Info:
>
>DB Server
>Mysql 4.0.20
>Mandrakelinux release 10.1 (Official) for i586 - 2.6.8.1-12mdksmp
>
>Application Servers
>Red Hat Linux release 9
>Tomcat 5.0.24
>
>These application servers connect to the DB via Tomcat or by perl scripts
>
>In my data directory I have a file called millhouse.unitnet.com.err
>
>My main db is unitnet
>
>It appears this is a good link that I received from GLEB
>http://dev.mysql.com/doc/mysql/en/communication-errors.html
>
>I am going down that path right now
>
>Thanks
>Randy
>
>-----Original Message-----
>From: SGreen@stripped [mailto:SGreen@stripped]
>Sent: Wednesday, September 21, 2005 8:19 AM
>To: Randy Paries
>Cc: mysql@stripped
>Subject: Re: Log file full of Got an error reading communication packets
>
>"Randy Paries" <randy.paries@stripped> wrote on 09/21/2005 08:56:13 AM:
>
>
>
>>Hello,
>>My log file is getting filled with these.
>>Can someone tell me what these mean?
>>
>>Thanks
>>Randy
>>//-------------------------snip-----------------------------//
>>050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:28:49 Aborted connection 53612 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>050122 20:29:20 Aborted connection 53671 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:32:14 Aborted connection 53910 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:34:47 Aborted connection 54111 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:34:48 Aborted connection 54116 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:35:11 Aborted connection 54142 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>050122 20:38:45 Aborted connection 54468 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:39:46 Aborted connection 54572 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>050122 20:40:54 Aborted connection 54584 to db: 'unitnet' user: 'paries'
>>host: `local.flanders' (Got an error reading communication packets)
>>050122 20:42:09 Aborted connection 54794 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>050122 20:43:33 Aborted connection 54936 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>050122 20:44:40 Aborted connection 55004 to db: 'unitnet' user: 'paries'
>>host: `local.krusty' (Got an error reading communication packets)
>>
>>
>>
>>
>
>Not unless you can tell us which application is making those log entries and
>which log file you just quoted..... What you just did is a lot like playing
>a sound over the telphone and asking a painter what's wrong with your
>plumbing. This may not even be a MySQL problem. Unless we know where those
>entries are (which log) and where they come from(which app is making them),
>we can have no clue what they mean.
>
>Next time, please provide us with more context to your question, OK? We need
>to know what OS you are using, what version of MySQL you are using, and many
>details about what exactly you were doing that created the problem you are
>trying to get us to help you with. If you can describe the problem even
>more, please do.
>
>Shawn Green
>Database Administrator
>Unimin Corporation - Spruce Pine
>
>
>
>
>
