List:General Discussion« Previous MessageNext Message »
From:Michael Bacarella Date:July 9 2002 8:43pm
Subject:Re: Lost connection to MySQL server during query
View as plain text  
Is there anything in the error log?

See mysql/data/hostname.err

-M

On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
> I keep getting "Lost connection to MySQL server during query"
> 
> marcos:mysql-3.23.51 {117} mysqladmin version
> mysqladmin: connect to server at 'localhost' failed
> error: 'Lost connection to MySQL server during query'
> 
> Server timeout is set for 8 hours (default) and I have been trying
> to hit the server all within a couple of minutes.
> 
> Sometimes it works, sometimes it doesn't. (below is a repeat of the
> command 2 minutes after the first one was issued.)
> 
> 
> marcos:mysql-3.23.51 {120} !!
> mysqladmin version
> mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
> 
> Server version          3.23.51-log
> Protocol version        10
> Connection              Localhost via UNIX socket
> UNIX socket             /tmp/mysql.sock
> Uptime:                 10 min 57 sec
> 
> Threads: 2  Questions: 108  Slow queries: 0  Opens: 34  Flush tables: 1
> Open tables: 28 Queries per second avg: 0.164
> 
> marcos:mysql-3.23.51 {121} uname -a
> OpenBSD marcos 3.1 marcos#5 i386
> 
> What should I start looking for?  (below is "mysqladmin variables")
Thread
Lost connection to MySQL server during querySteve Mertz9 Jul
  • Re: Lost connection to MySQL server during queryMichael Bacarella9 Jul
  • Re: Lost connection to MySQL server during querySteve Mertz9 Jul
  • Re: Lost connection to MySQL server during queryGelu Gogancea9 Jul
  • Re: Lost connection to MySQL server during querySteve Mertz10 Jul