List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:May 22 2012 1:09am
Subject:Re: [Warning] Aborted connection...... (Got timeout reading
communication packets)
View as plain text  
This needs to be investigated on the server, and cannot be guessed.

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

> 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
>
>


-- 
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