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 


Reply via email to