Are you using large blobs by any chance? when max_allowed_packet (google it ;) ) is set too small, the server will also terminate the connection with this error message. Remember to set it correctly at the server and at the client side.
One of the better explanations by monty is found here: http://bugs.mysql.com/bug.php?id=2110 regards, Walter Heck On Tue, Mar 24, 2009 at 8:12 PM, Jesse <j...@msdlg.com> wrote: > I thought that the # of connections might be a problem at some point too. > The last time this happened, there were a lot of connections. Right now, > there are 19 connections. > > How do I tell what the TTL is? > > I'm not too familiar with perfmon. How do I set it up to watch MySQL > connections? > > Thanks, > Jesse > > ----- Original Message ----- From: "Gary Smith" <g...@primeexalia.com> > To: "Jesse" <j...@msdlg.com>; <mysql@lists.mysql.com> > Sent: Tuesday, March 24, 2009 2:55 PM > Subject: Re: MySQL server has gone away... > > >> Netstat -an. How many 3306 entries do you have in there. What's the TTL on >> them. Once the pool issues the bad connection multiple issuances of the same >> connection will probably result in the same error.if yoi birst to 20 >> connections then drop to 10 for the next 24 hours then burst to 11 that 11th >> might have been dropped. Next asp request gets 11. Next one gets 11. And so >> on until the active requests drop to the point where the connections are >> still active. Does this make sense? >> >> It doesn't round robin them (at least to the best of my knowledge) so some >> may go stayle. >> >> When testing the odbc connection some time ago I had connections stay in >> the pool for a day whereas my timeout was 120 minutes. >> >> Anyway. Watch the connection count with the windows perfmon and see if >> there is a corrolation. >> >> >> Sent via BlackBerry by AT&T >> >> -----Original Message----- >> From: Jesse <j...@msdlg.com> >> >> Date: Tue, 24 Mar 2009 14:47:30 >> To: Jesse<j...@msdlg.com>; <mysql@lists.mysql.com> >> Subject: Re: MySQL server has gone away... >> >> >> An update on this issue. It just happened again, and the first error was: >> [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection >> to >> MySQL server during que >> >> Then, after that, I got a BUNCH of "[MySQL][ODBC 3.51 >> Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away" errors. >> >> I'm pretty sure that the 2nd errors were caused by the first error. Again, >> there is nothing strange in the IIS logs, or Windows Event log The >> database >> server is on the same machine as the web server, so the network should not >> be involved here. >> >> Why would it suddenly loose connection? >> >> Jesse >> >> ----- Original Message ----- >> From: "Jesse" <j...@msdlg.com> >> To: <mysql@lists.mysql.com> >> Sent: Tuesday, March 24, 2009 11:41 AM >> Subject: MySQL server has gone away... >> >> >>> We are running MySQL Server version 5.0.67-community-nt-log on a WS03 >>> server. It seems like every once in a while (sometimes once or twice a >>> week, sometimes more), something will happen, then I'll start getting a >>> lot of errors: >>> [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has >>> gone away >>> >>> This is driving me absolutely nuts. I don't see any errors in the Event >>> Viewer, or the MySQL error log. Does anyone know of any reasons that >>> this might happen? >>> >>> Jesse >>> >>> -- >>> MySQL General Mailing List >>> For list archives: http://lists.mysql.com/mysql >>> To unsubscribe: http://lists.mysql.com/mysql?unsub...@msdlg.com >>> >>> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=g...@primeexalia.com >> >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
