From: Date: May 29 2001 4:20pm
Subject: Re: Aborted connections
List-Archive: http://lists.mysql.com/mysql/74951
Message-Id: <049801c0e84a$734fafc0$711663cf@icarz.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,
   I have also noticed these aborted connections,  unfortunately my
time is too divided to give this 100%.  I have just created a test
situation with 3 server and a large application that inserts about
300,000 large rows.  This application aborts after several hours with
an "aborted connection " message of FreeBSD (4.3) but not on Linux,  I
am today running a test with BSDi,  but I think it will succeed.
After that I will start debugging more closely the network reads and
writes.  Can you please tell me what network card/driver you are
running,  the output from dmesg would help.  As I am still gathering
information I can not yet make any firm conclusions.  If anyone else
has comments please e-mail me privately and I will gather a concensus
then report after we have facts.

Thanks
Ken


-----------------------------------------------------
Ken Menzel  ICQ# 9325188
www.icarz.com  kenm@stripped
----- Original Message -----
From: "Jaap de Heer" <jaap@stripped>
To: <mysql@stripped>
Sent: Sunday, May 27, 2001 3:35 PM
Subject: Aborted connections


> Hi,
>
> We've recently upgraded our 2 mysql servers from 3.22 to 3.23.36,
> and since then we occasionally get errors like the following in
> the servers' error logs:
>
> 010527 21:01:26  Aborted connection 461457 to db: 'clantsf' user:
'tsf' host: `pride.gamepoint.net' (Got an error reading communication
packets)
>
> We've upgraded the client machines from 3.22 to 3.23.32 (the
> version that comes with PHP 4.0.5) assuming it was a version
> conflict, but this doesn't seem to make any difference.
> This only happens once in every 1000 connects or so.
> It happens to connections from all client machines.
>
> The server machines run FreeBSD 3.5-STABLE and 4.2-STABLE on
> Intels. Both the mysqlds were compiled from source.
> The client machines are one Sparc running SunOS, and a few Intels
> running RedHat 6.2, with kernels 2.2.19 and 2.4.3.
> The connections are made by PHP scripts running on Apache 1.3.19
> with PHP 4.0.5, using persistent connections.
>
> Does anyone know what the problem might be, or how I can find out?
>
> Thanks a lot,
>
> Jaap de Heer
>
>
>
> --------------------------------------------------------------------
-
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread74836@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-kenm=icarz.com@stripped>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>