List:General Discussion« Previous MessageNext Message »
From:Shafi AHMED Date:May 21 2012 8:59am
Subject:RE: [Warning] Aborted connection...... (Got timeout reading communication packets)
View as plain text  
Sorry- a  typo :) 

Hi suresh: I have gone through your blog..and feel it is more generic...
Can you please elaborate why the other setup(DR) works fine when the similar
prod(with no application code/web/db structural changes etc) has gone thru'
failures with such warning msgs ?

 
Best Rgs,
    Shafi AHMED
    Sify - Chennai

 
 

-----Original Message-----
From: Shafi AHMED [mailto:shafi.ahmed@stripped] 
Sent: Monday, May 21, 2012 2:04 PM
To: 'Suresh Kuna'
Cc: 'mysql@stripped'; 'shafidba@stripped'
Subject: RE: [Warning] Aborted connection...... (Got timeout reading
communication packets)

Hi suresh: I have gone through your blog..and feel it is more generic...
Can you please elaborate why the other setup(DR) works fine when the similar
prod(with no application code/web/db structural changes etc) has gone thru'
failures with such warning msgs ?

Thanks again...

 
Best Rgs,
    Shafi AHMED
    Sify - Chennai

 
 

-----Original Message-----
From: Suresh Kuna [mailto:sureshkumarilu@stripped] 
Sent: Monday, May 21, 2012 1:29 PM
To: Shafi AHMED
Cc: mysql@stripped; shafidba@stripped
Subject: Re: [Warning] Aborted connection...... (Got timeout reading
communication packets)

Hello Shafi,

The below blog will give you more information on the error -
http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.h
tml

Thanks
Suresh Kuna

On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED
<shafi.ahmed@stripped>wrote:

> Ladies and Gentlemen:
>
> I am getting below errors and therefore the user sessions terminate
causing
> business impact...Can some one who is expertise already in this advice at
> the earliest?
>
>
> 120513  8:19:45 [Warning] Aborted connection 1167257 to db: 'iib' user:
> 'iibuser' host: '210.18.3.94' (Got timeout reading communication packets)
>
>
> OS version: RHEL 5.3
>
> DB version: MYSQL 5.1
>
> Table involved in the DB is of type : inndoDB
>
> Background : This is an online exam registration site DB and the
concurrent
> connex invariably reaches to 200 for 500 users which should not be the
> case.
>
> Ideally the concurrent connex must be <10.
>
> Normally , we run truncate table before the exam starts up.
>
> A similar setup(in terms of DB/OS/config etc )  works fine which is
> actually
> DR at different site.
>
> PS: Network segment between web and DB tier has been thoroughly checked
and
> seems to be fine.
>
> Thanks a ton!
>
>
> Best Rgs,
>    Shafi AHMED
>    Sify - Chennai
>
>
>
>
>
>
>
> Get your world in your inbox!
>
> Mail, widgets, documents, spreadsheets, organizer and much more with your
> Sifymail WIYI id!
> Log on to http://www.sify.com
>
> ********** DISCLAIMER **********
> Information contained and transmitted by this E-MAIL is proprietary to
> Sify Technologies Limited and is intended for use only by the individual
> or entity to
> which it is addressed, and may contain information that is privileged,
> confidential or exempt from disclosure under applicable law. If this is a
> forwarded message, the content of this E-MAIL may not have been sent with
> the authority of the Company. If you are not the intended recipient, an
> agent of the intended recipient or a  person responsible for delivering
the
> information to the named recipient,  you are notified that any use,
> distribution, transmission, printing, copying or dissemination of this
> information in any way or in any manner is strictly prohibited. If you
have
> received this communication in error, please delete this mail & notify us
> immediately at admin@stripped
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
[Warning] Aborted connection...... (Got timeout reading communication packets)Shafi AHMED21 May
Re: [Warning] Aborted connection...... (Got timeout readingcommunication packets)Suresh Kuna21 May
  • RE: [Warning] Aborted connection...... (Got timeout reading communication packets)Shafi AHMED21 May
RE: [Warning] Aborted connection...... (Got timeout reading communication packets)Shafi AHMED21 May
Re: [Warning] Aborted connection...... (Got timeout readingcommunication packets)Suresh Kuna22 May