"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
