dbTalk Databases Forums  

Aborted clients - Got an error reading communication packets

comp.databases comp.databases


Discuss Aborted clients - Got an error reading communication packets in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
narmathabala@gmail.com
 
Posts: n/a

Default Aborted clients - Got an error reading communication packets - 06-26-2007 , 06:43 AM






Hello,

I get pages of error logs with this message -
"Got an error reading communication packets". And the aborted clients
are easily in hundreds.

Here is my set of configurations:
I am running Microsoft .Net 2.0 on Windows 2003 Server using IIS 6.0.
I am using Mysql 5.0 with Mysql/.Net Connector 1.0.

Some of the settings on my.ini -
Connection timeout - 180
Wait timeout - 360
Max packet size - 10 M
Max connections - 5000 (pretty high, but set to be on a safer side)

When a perform a netstat -ao - I have lot many sockets open with
TIME_WAIT status. On the MySql Command client - the Aborted clients
average around 100's

The connection string from ,Net application has pooling=false with no
help.

The webserver does not have a heavy load and has less than 5 users at
any point in time.

On the registry settings, I have the max ports > 60000 and the
time_wait setting changed to 30.

My application is opens a connection, performs a query and closes the
connection and this is the fashion followed for all DB operations.

Been hunting around for a solution and it has been driving me crazy.
Any suggestions will be highly appreciated.

Thanks,
Narmatha


Reply With Quote
  #2  
Old   
Tonkuma
 
Posts: n/a

Default Re: Aborted clients - Got an error reading communication packets - 06-26-2007 , 10:28 AM






On Jun 26, 8:43 pm, narmathab... (AT) gmail (DOT) com wrote:
Quote:
.....
Here is my set of configurations:
I am running Microsoft .Net 2.0 on Windows 2003 Server using IIS 6.0.
I am using Mysql 5.0 with Mysql/.Net Connector 1.0.

.....
I think that you can get more quickly and exact answer in MySQL forum
than in these general comp.database forum.

comp.databases.mysql
http://groups.google.com/group/comp....nk=gschg&hl=en



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.