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.html Thanks Suresh Kuna On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED shafi.ah...@sifycorp.comwrote: 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 ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA
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' successfully with no such warning msgs ? Thanks again... Best Rgs, Shafi AHMED Sify - Chennai -Original Message- From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: Monday, May 21, 2012 1:29 PM To: Shafi AHMED Cc: mysql@lists.mysql.com; shafi...@gmail.com 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.ah...@sifycorp.comwrote: 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 ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: [Warning] Aborted connection...... (Got timeout reading communication packets)
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.ah...@sifycorp.com] Sent: Monday, May 21, 2012 2:04 PM To: 'Suresh Kuna' Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' 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:sureshkumar...@gmail.com] Sent: Monday, May 21, 2012 1:29 PM To: Shafi AHMED Cc: mysql@lists.mysql.com; shafi...@gmail.com 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.ah...@sifycorp.comwrote: 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 ad...@sifycorp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: [Warning] Aborted connection...... (Got timeout reading communication packets)
This needs to be investigated on the server, and cannot be guessed. On Mon, May 21, 2012 at 2:29 PM, Shafi AHMED shafi.ah...@sifycorp.comwrote: 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.ah...@sifycorp.com] Sent: Monday, May 21, 2012 2:04 PM To: 'Suresh Kuna' Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com' 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:sureshkumar...@gmail.com] Sent: Monday, May 21, 2012 1:29 PM To: Shafi AHMED Cc: mysql@lists.mysql.com; shafi...@gmail.com 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.ah...@sifycorp.comwrote: 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 ad...@sifycorp.com -- 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
