MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:November 26 2002 3:44pm
Subject:re: Lost connection to MySQL server during query
View as plain text  
Mark,
Tuesday, November 26, 2002, 7:32:15 AM, you wrote:

M> Yes, again. :( Although reluctantly, I finally decided to upgrade to
M> 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors.
M> Alas, 6 out of 10 times when I start a MySQL application, I get an error
M> like this:

M> DBD::mysql::st execute failed: Lost connection to MySQL server during query
M> at /usr/libdata/perl/5.00503/News/MySQL/User.pm line 209.

M> The log is very non-telling; it mostly bales at something entirely trivial;

M> --------------------------------------------
M> 021126  6:15:34       4 Connect     news@localhost on xovers
M>   4 Query       SELECT domain_id FROM smtp.cwdomains
M> 021126  6:15:35       4 Query       SELECT newsgroup FROM newsgroups WHERE
M> local <> 'y'
M>  4 Quit
M> --------------------------------------------

M> The program connects via /tmp/mysql.sock from localhost; so there is no real
M> connection or DNS problem. It just loses the connection. :(

M> Can someone please tell me how to end this problem? I checked the databases
M> a zillion times, and they appear fully intact. I am gravely at a loss here.
M> :(

Check that max_allowed_packet is big enough:
      http://www.mysql.com/doc/en/Gone_away.html

Do you get the same result if you execute this query from
command-line?

What does table 'newsgroups' look like? (table stucture)



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
Lost connection to MySQL server during queryMark26 Nov
  • re: Lost connection to MySQL server during queryVictoria Reznichenko26 Nov
    • Re: Lost connection to MySQL server during queryMark27 Nov