Re: Lost Connection Upon Loading Dump

2016-04-21 Thread Peter Brawley
On 4/21/2016 10:51, Stephen R Guglielmo wrote: Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is 95610 characters

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
sounds like a scheduler issue did you try "deadline"? http://en.wikipedia.org/wiki/Deadline_scheduler on Linux systems pass "elevator=deadline" as kernel param Am 12.10.2013 20:58, schrieb Chris McKeever: > We had a similar issue a bit back - and although it sounds similar - based > on your foll

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Chris McKeever
We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers bandwidth

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 17:36, Reindl Harald wrote: >> so someone did "optimize table" on a large table >> you do yourself not a favour restarting the server in such a moment > > 7 hours before the server was shut down, we did a alter table t

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
On Saturday 12 October 2013 17:36, Reindl Harald wrote: > so someone did "optimize table" on a large table > you do yourself not a favour restarting the server in such a moment 7 hours before the server was shut down, we did a alter table to add a primary key to a table that is read-only from the

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 13:07, Andrew Moore wrote: >> Could be a crash related to innodb data dictionary being out of sync. Could >> be a bug. > > Seems like a bug yes. However, we had a strange situation yesterday when we > had several proc

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
On Saturday 12 October 2013 13:07, Andrew Moore wrote: > Could be a crash related to innodb data dictionary being out of sync. Could > be a bug. Seems like a bug yes. However, we had a strange situation yesterday when we had several processes in the state "copying to tmp table" (if i remember the

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Andrew Moore
Could be a crash related to innodb data dictionary being out of sync. Could be a bug. http://bugs.mysql.com/bug.php?id=55277 On 12 Oct 2013 11:21, "Jørn Dahl-Stamnes" wrote: > On Saturday 12 October 2013 12:01, nixofortune wrote: > > You might want to comment > > > > bind-address= 12

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
On Saturday 12 October 2013 12:01, nixofortune wrote: > You might want to comment > > bind-address= 127.0.0.1 > > in your my.cnf and restart mysql server. It does not explain why it works under low load and not under high load. However, I seem to have found something. When I started p

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread nixofortune
You might want to comment bind-address= 127.0.0.1 in your my.cnf and restart mysql server. On 12/10/13 10:49, Jørn Dahl-Stamnes wrote: Hello, I got a strange problem related to a production server. It has been working OK for months, but yesterday it start to fail. There are seve

Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
the application program and mysql server are in the same host and i have add skip-name-resolv to the my.cnf and extend the max_allowed_packet from 16M to 32M our application connected to mysql server from mysql.sock before the query which cause "lost connection to MySQLserver.." we only ran some

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Since it is very unlikely that you lose connection on the socket file, I guess you are using a PHP app, that uses the mysql driver and the problem must be in the driver. I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the later one. Try different PHP (and driver) versions.

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
Can you provide more details? network layout, type of client/app used, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy > hi,all: > > we met a problem that: > > * Lost connection to MySQL server during query > SHOW TABLE STATUS WHERE ENGINE='MyISAM' > > *sometimes it works well, sometim

Re: "lost connection to mysql server during query" errors

2008-10-30 Thread Moon's Father
In my experiences, there're three reasons below. 1. Your network is not stable. 2. Your mysqld's parameter called max_allowed_packet is adjusted too small, trying to increase it. 3. Your mysqld's parameter called connect_timeout is adjusted too small, trying to increase it. On Thu, Oct 30, 2008 at

Re: "lost connection to mysql server during query" errors

2008-10-29 Thread mos
At 10:21 PM 10/29/2008, you wrote: I've never had a lot of luck tracking down this sort of problem. One thing I've found to be a good first step is to add each server involved to the other server's /etc/hosts file (and restart MySQL so it notices). Don't have much more to offer other than the us

Re: "lost connection to mysql server during query" errors

2008-10-29 Thread Jake Maul
I've never had a lot of luck tracking down this sort of problem. One thing I've found to be a good first step is to add each server involved to the other server's /etc/hosts file (and restart MySQL so it notices). Don't have much more to offer other than the usual suspects: recent versions, persis

Re: Lost connection

2008-08-26 Thread Moon's Father
Only increase max_allowed_packet is ok. On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> wrote: > Mad Unix wrote: > >> >> During the update of the MySQL DB (delete/insert), I keep getting the >> following message >> Lost connection to MySQL server during query... >> > > By defaul

Re: Lost connection

2008-08-19 Thread Warren Young
Mad Unix wrote: During the update of the MySQL DB (delete/insert), I keep getting the following message Lost connection to MySQL server during query... By default, the MySQL server drops a connection after 8 hours of receiving no queries on that connection. This can happen in an application

Re: Lost Connection each hour :(

2008-01-17 Thread Matthias Witte
On Tue, Jan 15, 2008 at 09:27:10PM +0100, MAS! wrote: > Can anyone help me to understand why my site (php 4.4.2 / ubuntu > dapper) loose all connections to mysql server when /etc/cron/hourly > starts? (there are no process to start hourly, the directory is empty) Is the assumption correct, tha

Re: Lost Connection each hour :(

2008-01-16 Thread Baron Schwartz
Hi, On Jan 16, 2008 3:36 AM, MAS! <[EMAIL PROTECTED]> wrote: > > Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: > > > Post your error message here. > > (from php) > > Error message: mysql_connect(): Lost connection to MySQL server > during query > > and I have that for _each_ apa

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
MAS! napsal(a): can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about +-

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about +---

Re: Lost Connection each hour :(

2008-01-16 Thread Dušan Pavlica
Marco, can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about those timeouts also

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
You should give me an error message here. On Jan 16, 2008 4:44 PM, MAS! <[EMAIL PROTECTED]> wrote: > > Enter your mysql shell and enter the command: > > set global max_allowed_packet=10M > > I have it setted at 32M, but that is not the problem; the data are > not too much ... > > and it's strange

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- MySQL Gener

Re: Lost Connection each hour :(

2008-01-16 Thread Moon's Father
Enter your mysql shell and enter the command: set global max_allowed_packet=10M The value of the variable can be set whatever you want . On Jan 16, 2008 4:36 PM, MAS! <[EMAIL PROTECTED]> wrote: > > Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: > > > Post your error message here

Re: Lost Connection each hour :(

2008-01-16 Thread MAS!
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- MySQL General Mailing List For list

Re: Lost Connection each hour :(

2008-01-15 Thread Moon's Father
Post your error message here. On Jan 16, 2008 4:27 AM, MAS! <[EMAIL PROTECTED]> wrote: > Can anyone help me to understand why my site (php 4.4.2 / ubuntu > dapper) loose all connections to mysql server when /etc/cron/hourly > starts? (there are no process to start hourly, the directory is empty)

Re: Lost Connection

2007-07-23 Thread Carlos Proal
This can be a serious issue, maybe a sign of some kind of data corruption. If you lost the connection, probably the server is restarting (you can check that on the error log), do this happen only with this table ? Carlos krishna chandra prajapati wrote: Hi All, I have connect to mysql-ser

Re: Lost connection to MySQL server during query

2006-01-25 Thread sheeri kritzer
error message last night when doing a > numeric comparison on a varchar column. Oops. > Kind of misleading, though. > > > - Original Message - > From: "David Godsey" <[EMAIL PROTECTED]> > To: "George Law" <[EMAIL PROTECTED]> > Cc: &g

Re: Lost connection to MySQL server during query

2006-01-24 Thread Jonathan Mangin
ary 24, 2006 4:43 PM Subject: RE: Lost connection to MySQL server during query > Thanks for the reply. I'm not using persistend connections though. It > appears that it looses the connection in the middle of the query or in > other words, before the procedure returns. So that

RE: Lost connection to MySQL server during query

2006-01-24 Thread David Godsey
Thanks for the reply. I'm not using persistend connections though. It appears that it looses the connection in the middle of the query or in other words, before the procedure returns. So that means I not getting the data I need. So for debug purposes, are you saying to do a "check status" from

RE: Lost connection to MySQL server during query

2006-01-24 Thread George Law
David, Are you using persistent connections? Sounds like perhaps a persistent connection is timing out. Maybe a quick work around would be to call a "check status" routine (ie - do a show status), just to see if the connection is still there. If this fails, just do a mysql_connect... Before c

Re: Lost Connection executing query

2006-01-09 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Tripp Bishop wrote: > Howdy all, > > First off, We're running 5.0.15. > > Theres a particular update statement that we run that > updates data in several tables. On our mac OSX test > server (also running 5.0.15) th

Re: Lost Connection executing query

2006-01-05 Thread Kyle
On 1/4/06, Tripp Bishop <[EMAIL PROTECTED]> wrote: > > We did recently upgrade the server from 4.0.40 to > 5.0.15 and we did not dump the tables and reimport > them. On the MAC we did do a dump and reimport. I > wonder if that could be the cause of this problem. I > had forgetten about that importa

RE: Lost Connection executing query

2006-01-05 Thread Imran Chaudhry
The fact that on your Mac installation you re-imported your table data makes me think it's an index efficiency issue. I have seen MySQL just lose the connection if the join becomes massively big. On re-import, the indexes would have been rebuilt and your query would be able to take advantage of the

RE: Lost Connection executing query

2006-01-04 Thread Tripp Bishop
l Message- > From: Tripp Bishop [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 04, 2006 11:01 AM > To: emierzwa; mysql@lists.mysql.com > Subject: RE: Lost Connection executing query > > The query fails instantly so I don't think it's a > timeout issue. > &

RE: Lost Connection executing query

2006-01-04 Thread emierzwa
ubject: RE: Lost Connection executing query The query fails instantly so I don't think it's a timeout issue. The wait_timeout and interactive_timeout variables are set to 28800. The server seems to be crashing and auto restarting because as you suggested the uptime is small when I do

RE: Lost Connection executing query

2006-01-04 Thread Tripp Bishop
The query fails instantly so I don't think it's a timeout issue. The wait_timeout and interactive_timeout variables are set to 28800. The server seems to be crashing and auto restarting because as you suggested the uptime is small when I do a show status right after attempting the query. The sc

RE: Lost Connection executing query

2006-01-04 Thread emierzwa
What are your wait_timeout and/or interactive_timeout values set to? Does the server crash and auto restart? Check server's up time. Do both servers have the exact table schema? Same column datatypes and indexes to be specific. Although your data volumn may be similar, can the actual data be probla

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-26 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote: > Thing is, even though I get that error, the server keeps running and > accepting other connections and responding to queries fine. Probably because the mysqld_safe wrapper script has restarted i

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-26 Thread Greg 'groggy' Lehey
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote: > Jasper Bryant-Greene wrote: >> I have a stored procedure defined as follows: >> >> ... >> >> Sometimes when I execute this stored procedure ... I get the error >> "Lost connection to MySQL server during query". >> >> I

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-22 Thread Jasper Bryant-Greene
Greg 'groggy' Lehey wrote: On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote: Jasper Bryant-Greene wrote: Sometimes when I execute this stored procedure ... I get the error "Lost connection to MySQL server during query". I am using MySQL 5.0.12-beta-log on Gentoo

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for examp

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
Daniel wrote: What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, etc.? PHP MySQLi Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKE

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Daniel
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, etc.? -Daniel Jasper Bryant-Greene wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM user

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Pooly
Hi, 2005/9/21, Jasper Bryant-Greene <[EMAIL PROTECTED]>: > Martijn Tonies wrote: > > > >>I have a stored procedure defined as follows: > >> > >>CREATE PROCEDURE `album`.`getUser`( IN userID INT ) > >> READS SQL DATA > >> DETERMINISTIC > >> SQL SECURITY INVOKER > >>SELECT * FROM users

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
Martijn Tonies wrote: I have a stored procedure defined as follows: CREATE PROCEDURE `album`.`getUser`( IN userID INT ) READS SQL DATA DETERMINISTIC SQL SECURITY INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example:

Re: "Lost connection to MySQL server during query" when calling stored procedure

2005-09-21 Thread Martijn Tonies
> I have a stored procedure defined as follows: > > CREATE PROCEDURE `album`.`getUser`( IN userID INT ) > READS SQL DATA > DETERMINISTIC > SQL SECURITY INVOKER > SELECT * FROM users WHERE id=userID LIMIT 1; > > Sometimes when I execute this stored procedure with, for example: > > C

Re: Lost connection to MySQL server during query - on long queries

2005-06-01 Thread Dobromir Velev
Hi, Can you send some more output from the MySQL error log (normally located at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the tables that are giving the errors? Also you might want to take a look at http://dev.mysql.com/doc/mysql/en/gone-away.html On Wednesday 01 June 20

Re: Lost connection to MySQL server during query problem

2005-05-31 Thread Gleb Paharenko
Hello. You should solve the issue with server crashes. I'm not familiar with JDBC, and if changing the values of parameters with SET statement doesn't work with JDBC, probably somebody clever on the list could help you. You may forward your message to: http://lists.mysql.com/java

Re: Lost connection to MySQL server during query problem

2005-05-27 Thread Amir Shay
Hi, Yes the server dies during the queries from JDBC. Regarding the client parameters, what if the client doesn't have mySQL installed? Amir Hello. Does SHOW STATUS executed from JDBC client return increased values of this parameters? Could your server die during queries from JDBC (ch

Re: Lost connection to MySQL server during query problem

2005-05-26 Thread Gleb Paharenko
Hello. Does SHOW STATUS executed from JDBC client return increased values of this parameters? Could your server die during queries from JDBC (check the error log)? Sometimes you should increase interactive_timeout as well. A lot of variables usually could be changed using SET statement. See:

Re: Lost connection to Mysql server during query using a group by clause and sub query

2005-05-19 Thread Ware Adams
On May 19, 2005, at 12:51 AM, Dan Rossi wrote: Hi there, I am having issues with this funny error message. I am trying to do a sub query and then a group by clause on a date. However i keep getting this annoying message for some reason. Happens via terminal aswell as my sql gui. Here is the

Re: Re: lost connection DURING query?

2005-03-18 Thread Sapna Todwal
  Hi , You can try one simple thing. Wherever in ur code u try to run mysql_query(), check the last error value using mysql_errno(). If the value is 2013, then connect to the mysql server again and try running mysql_query again. I hope this solution works for u. Regards, Sapna On Fri, 18 Ma

Re: lost connection DURING query?

2005-03-18 Thread Neharkar, Mukund
Hi; I'm using Apache 2.0 + MySQL 4.1 + PHP 4.3.10 for a site. The database server and web server are on different machines. I get this Error "lost connection DURING query" when I try to access some of the web Pages. I have been through this thread. http://lists.mysql.com/mysql/181322 I tried

Re: lost connection DURING query?

2005-03-15 Thread Sapna Todwal
I got the same error when my web server and mysql server were separate. And the error was caused bcoz of too many unauthenticated users. The reason behind it was that the reverse dns lookup for the webserver was failing. but as soon as i added the web server to /etc/hosts, the error went off. H

Re: lost connection DURING query?

2005-03-15 Thread Terry Riley
Luke - Original Message - > 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) Which version of CF are you using? If it is MX6.1, surely you can use a native MySQL

RE: lost connection DURING query?

2005-03-15 Thread Crouch, Luke H.
TED] -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 A

Re: lost connection DURING query?

2005-03-15 Thread SGreen
"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

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Adams, Pat 006
> -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED] > Sent: Friday, December 10, 2004 2:17 PM > To: Adams, Pat 006; [EMAIL PROTECTED] > Subject: RE: Lost connection during query when using SSH tunneling > > I am not sure of Putty as I am using plink.e

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Karam Chand
I am not sure of Putty as I am using plink.exe that is the SSH tunneler for tunnel. The thing is that I call up plink.exe from my app to create an ssh tunnel and then set the correct values for mysql_real_connect() in my app. What I am doing is that I am bundling plink.exe with my app and then as

RE: Lost connection during query when using SSH tunneling

2004-12-10 Thread Adams, Pat 006
> -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED] > Sent: Friday, December 10, 2004 12:08 PM > To: [EMAIL PROTECTED] > Subject: Lost connection during query when using SSH tunneling > > So I use Putty to create the SSH tunneler and then connecting > to the local port. >

Re: Lost connection during query when using SSH tunneling

2004-12-10 Thread Rhino
- Original Message - From: "Karam Chand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 1:08 PM Subject: Lost connection during query when using SSH tunneling > Hello, > > I have a MySQL database hosted with my ISP. They > provide direction as well as thru S

Re: Lost Connection To Mysql....................................Roime

2004-11-24 Thread Gleb Paharenko
Hello. Citing Egor Egorov as of http://lists.mysql.com/mysql/166245: "Check that it's not max_allowed_packet or wait_timeout issue: http://dev.mysql.com/doc/mysql/en/Gone_away.html"; > After that, when i tried to reconnect it, it's hang up > ! Your Red Hat server machine hangs up?

Re: Lost connection to MySQL server during query & bind-address

2004-09-17 Thread Egor Egorov
Marten Lehmann <[EMAIL PROTECTED]> wrote: > Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client). OKay, here's the problem - a self-built MySQL. Unfortunately, due to some glibc bugs it's not really possible to build a stable MySQL under linux using stock glibc... And the pro

Re: Lost connection to MySQL server during query & bind-address

2004-09-14 Thread Marten Lehmann
Hello, Tell us the OS, the MySQL server and client version and the build information (custom or binary downloaded from MySQL.com). Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client). This *might* be a problem of resolver in glibc. I don't see a reason why it should be a resolver

Re: Lost connection to MySQL server during query & bind-address

2004-09-13 Thread Egor Egorov
Marten Lehmann <[EMAIL PROTECTED]> wrote: > I'm experiencing a strange thing: When bind is running without > "bind-address" everything works fine. But when I'm doing a "bind-address > = ..." the clients get "Lost connection to MySQL server during query". I > don't understand this, because ot wo

Re: Lost connection to MySQL server during query - pls help

2003-12-13 Thread Matt W
Hi Vanessa, I don't think I saw a reply to this... You can just reconnect to MySQL if you get this error. :-) Trying to send the query a second or third time may also make the client try to reconnect again. Hope that helps. Matt - Original Message - From: "Kiky" Sent: Friday, Decemb

Re: Lost connection to MySQL server during query - pls help

2003-12-07 Thread Kiky
; <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 06, 2003 12:56 AM Subject: RE: Lost connection to MySQL server during query - pls help > At 10:44 -0600 12/5/03, Jay Blanchard wrote: > >[snip] > >Ple

RE: Lost connection to MySQL server during query - pls help

2003-12-05 Thread Paul DuBois
At 10:44 -0600 12/5/03, Jay Blanchard wrote: [snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem See t

Re: Lost connection to MySQL server during query - pls help

2003-12-05 Thread Egor Egorov
"Kiky" <[EMAIL PROTECTED]> wrote: > I have a problem with > "Error 2013 - Lost connection to MySQL server during query" > > I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. > They turn out to have the same error. > > My problem is: > I have a Java program which is

RE: Lost connection to MySQL server during query - pls help

2003-12-05 Thread Jay Blanchard
[snip] Please upgrade you MySQL Windows client to 4.0.16 there is a bug with net_read_timeout and net_write_timeout on 4.0.15 that disconnect when the query takes more than 30 secons. [/snip] Can you elaborate on this, we have not seen this problem -- MySQL General Mailing List For list archives:

Re: Lost connection to MySQL server during query - pls help

2003-12-05 Thread miguel solorzano
At 14:14 5/12/2003 +0800, Kiky wrote: Hi Guys, I have a problem with "Error 2013 - Lost connection to MySQL server during query" I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro. They turn out to have the same error. Please upgrade you MySQL Windows client to 4.0.16

Re: Lost Connection to MySQL server during query

2003-09-09 Thread Matt W
Hi Donald, Is the script possibly sending a query larger than max_allowed_packet (1MB default)? Have you read http://www.mysql.com/doc/en/Gone_away.html ? Matt - Original Message - From: "Donald Tyler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, Sept

RE: Lost connection to MySQL server during query

2003-06-06 Thread Dathan Vance Pattishall
-->-Original Message- -->From: Alec Smith [mailto:[EMAIL PROTECTED] On Behalf Of Alec -->Smith -->Sent: Friday, June 06, 2003 11:24 AM -->To: [EMAIL PROTECTED] -->Subject: Lost connection to MySQL server during query --> -->Hi - --> -->[Perhaps not exactly the right list, but [EMAIL PROTE

Re: Lost connection to MySQL server during query

2003-02-19 Thread KH Chiu
Assume the ip address of your remote machine is 192.168.0.88 You should perform a nslookup 192.168.0.88 on your LOCAL machine that hold the mysqld If it cannot resolve into a symbolic name then you will get into trouble. Add an entry to /etc/hosts or your DNS will solve the problem. Regards,

re: Lost connection to MySQL server during query

2003-01-16 Thread Egor Egorov
On Thursday 16 January 2003 00:32, Gustavo A. Baratto wrote: > This old bug reappeared after the upgrading mysql from version 3.23.54a > (rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by > mysql.com as well). > > Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this p

Re: Lost connection to MySQL server during query at ... After upgrade to 3.23.54

2003-01-15 Thread Gustavo A. Baratto
You can use --skip-name-resolve when starting mysqld, but this is not a real solution. Even doing that,'I'm still having some odd problems I never had before, like table corruption (I'm on 4.0.8 though) - Original Message - From: "Patrick de Kievit" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Re: Lost connection to MySQL server during query

2002-11-26 Thread Mark
- Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 4:44 PM Subject: re: Lost connection to MySQL server during query > Mark, > Tuesday, November 26, 2002, 7:32:15 AM, you wrote: &g

re: Lost connection to MySQL server during query

2002-11-26 Thread Victoria Reznichenko
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:

re: Lost connection...

2002-11-14 Thread Egor Egorov
Staffan, Thursday, November 14, 2002, 9:44:05 AM, you wrote: SH> I'm using RedHat 8.0 and MySQL 3.23.52. I've also downloaded the MySQL Control Center (latest). On the Linux mashine everything works just fine, but when I try to connect to MySQLserver from SH> Win2k using alpha version of MySQL C

Re: lost connection....

2002-11-06 Thread Michael Gargiullo
Flavio, If your running RedHat check https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 off topic question flavio. Did you ever work in New York City? -Mike On Wed, 2002-11-06 at 10:09, Flavio wrote: > I try to update my linux to next version, and it was running a previ

Re: Lost Connection to MySQL Server during query

2002-11-02 Thread Eric Frazier
Hi, Isn't it time to add a manual section like this one http://www.mysql.com/doc/en/Communication_errors.html on the Lost Connection to MySQL Server during query? These emails come in at a regualr rate, they seem to vary in cause somewhat, and I still have not solved my own problem with this erro

Re: Lost Connection to MySQL Server during query

2002-11-02 Thread Mark Matthews
AuctionWare Admin wrote: Hello all, I have came across a pretty peculiar problem and am hoping someone can help me out. Each time I try to connect to a MySQL server on my network, I receive the following error: Lost Connection to MySQL Server during query It isn't just one server that is givi

re: Re: Lost connection to MySQL server during query

2002-10-31 Thread Egor Egorov
From: "Egor Egorov" <[EMAIL PROTECTED]> FT> To: <[EMAIL PROTECTED]> FT> Sent: Wednesday, October 30, 2002 5:09 AM FT> Subject: re: Lost connection to MySQL server during query >> Frederic, >> Tuesday, October 29, 2002, 11:49:19 PM, you wrote: >&g

Re: Lost connection to MySQL server during query

2002-10-30 Thread Frederic Trudeau
ROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 5:09 AM Subject: re: Lost connection to MySQL server during query > Frederic, > Tuesday, October 29, 2002, 11:49:19 PM, you wrote: > > FT> What are the possible causes for this error message ? > > The pos

re: Lost connection to MySQL server during query

2002-10-30 Thread Egor Egorov
Frederic, Tuesday, October 29, 2002, 11:49:19 PM, you wrote: FT> What are the possible causes for this error message ? The possible source of error is the glibc provided by RedHat. Do you use RedHat? If so, check the mailing list archives, there were a lot of possible error descriptions during la

Re: Lost Connection

2002-10-25 Thread Mark Matthews
John Coder wrote: On Fri, 2002-10-25 at 00:14, Lewis Watson wrote: - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 8:40 PM Subject: Re: Lost Connection [snip] O

Re: Lost Connection

2002-10-24 Thread John Coder
On Fri, 2002-10-25 at 00:14, Lewis Watson wrote: > > - Original Message - > From: "Mark Matthews" <[EMAIL PROTECTED]> > To: "Lewis Watson" <[EMAIL PROTECTED]> > Sent: Thursday, October 24, 2002 8:40 PM > Subject: Re: Lost Connection >

Re: Lost Connection

2002-10-24 Thread Lewis Watson
- Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 8:40 PM Subject: Re: Lost Connection > Lewis Watson wrote: > > > >>>I am getting this same error. I

RE: Lost Connection

2002-10-24 Thread Jennifer Goodie
13 happens during connection via TCP/IP and not socket. > -Original Message- > From: Lewis Watson [mailto:lists@;visionsix.com] > Sent: Thursday, October 24, 2002 2:53 PM > To: Mark Matthews > Cc: Mauro Romano Trajber; [EMAIL PROTECTED] > Subject: Re: Lost Connection >

Re: Lost Connection

2002-10-24 Thread Lewis Watson
> > > > I am getting this same error. I have tried reseting, flushing, rebooting the > > server. Please let me know if you find anything on this... > > Thanks. > > Lewis > > This is RedHat GLIBC upgrade badnessSearch the mailing list over the > last 4 weeks, you'll see what I mean. > > For no

Re: Lost Connection

2002-10-24 Thread Ricardo Orduna
Mauro: I was experencing the same problem in two different mysql setups the first one is runing 3.23.36. the problem started after an up2date with red hat. Then i seted up a nother machine runing red hat 8 with mysql 5.23.53.. and the i found the same problemm.. Early this morning

Re: Lost Connection

2002-10-24 Thread Mark Matthews
Lewis Watson wrote: - Original Message - From: "Mauro Romano Trajber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 4:09 PM Subject: Lost Connection Hi Im trying to connect to a remote mysql server (/usr/local/mysql/bin/mysql -u root -h myhost -p ) an

Re: Lost Connection

2002-10-24 Thread Lewis Watson
- Original Message - From: "Mauro Romano Trajber" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 4:09 PM Subject: Lost Connection > Hi > Im trying to connect to a remote mysql server (/usr/local/mysql/bin/mysql -u > root -h myhost -p ) > and i get the follow

re: lost connection inquery : ODBC

2002-10-23 Thread Egor Egorov
Petre, Tuesday, October 22, 2002, 9:18:27 PM, you wrote: PA> Any known issues with RH8.0 and ODBC? PA> I keep getting lost connection messages when trying to connect from a PA> windows box to mysql, it worked 100% on a 7.3RH box. PA> There is no firewall. PA> Any workarounds? "Lost connection" yo

Re: lost connection inquery : ODBC

2002-10-22 Thread walt
Petre Agenbag wrote: > That works fine, I can log in as my root user and the perms look fine, I > also use phpmyadmin, and looks fine too, can access all my db's that > way, just the odbc that seems to be bitchin. > It's not a train smash, I exported it to my older rh7.0 server over the > net, but

Re: lost connection inquery : ODBC

2002-10-22 Thread Petre Agenbag
That works fine, I can log in as my root user and the perms look fine, I also use phpmyadmin, and looks fine too, can access all my db's that way, just the odbc that seems to be bitchin. It's not a train smash, I exported it to my older rh7.0 server over the net, but I'd still like to know for futu

Re: lost connection inquery : ODBC

2002-10-22 Thread walt
On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote: > Hi Walt > Thanks for the quick reply. > > Answer to both questions is yes. > As a matter of interest, > What I usually do is to create a "myodbc" db with a "myodbc" user and > password "myodbc" > I create this db and user with the mysql_se

  1   2   >