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 [EMAIL PROTECTED]
----- Original Message -----
From: "Jaap de Heer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
