this query is "select * from ogcount" which is a table containing 1 record, so probably not the packet size, though that's very good info to know. I'm going to see if I get the same error if I use a JDBC driver instead of ODBC. -L
Luke Crouch 918-461-5326 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 8:08 AM To: Crouch, Luke H. Cc: mysql@lists.mysql.com Subject: Re: lost connection DURING query? "Crouch, Luke H." <[EMAIL PROTECTED]> wrote on 03/14/2005 09:34:02 AM: > This error message seems a bit different than others I have gotten. > it is from a ColdFusion server that uses an ODBC driver... > ODBC Error Code = S1000 (General error) > > > [MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL > server during query > > that "during" part threw me, but it may just be the way ODBC states the error? > > mysql error log shows no errors for the time(s) that this happened, > other than a bunch of "aborted connections" - but that is because I > set wait_timeout pretty low to avoid connection problems we were > having with other clients. > > does anyone know if this is the error ODBC gets when trying to use a > connection that has been killed by the MySQL server? if that is so, > it may be that I just need to put the wait_timeout back up. > > any help would be great! thanks! > > -L > > Luke Crouch > 918-461-5326 > [EMAIL PROTECTED] > > I only see this error whenever I send a query that exceeds the server's max_allowed_packet. If you are doing a very large INSERT statement, that's probably what happened. Either split your INSERT into chunks smaller than max_allowed_packet or increase the server's limit until it lets your command through. Shawn Green Database Administrator Unimin Corporation - Spruce Pine