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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 21, 2005 8:19 AM
To: Randy Paries
Cc: mysql@lists.mysql.com
Subject: Re: Log file full of Got an error reading communication packets
"Randy Paries" <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
