Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-08 Thread Manuel Arostegui
2014/1/7 h...@tbbs.net 2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-07 Thread hsv
2014/01/06 17:07 +0100, Reindl Harald what about look in the servers logfiles most likely max_allowed_packet laughable low Is this then, too, likly when the server and the client are the same machine? I left this out, that it only then happens when the client has been idle, and right

ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread hsv
Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread Reindl Harald
Am 06.01.2014 15:36, schrieb h...@tbbs.net: Now that I installed 5.6.14 on our Vista machine, when using mysql I often see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely max_allowed_packet laughable low

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-08-01 Thread Fred G
the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-31 Thread Michael Widenius
, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). What is the exact error message? Which client are you using to do the query? It's strange that the query

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-26 Thread Fred G
; The query without exporting the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-26 Thread hsv
2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL server writes into some directory where it is, not where MySQL client

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-26 Thread Fred G
Thanks! On Thu, Jul 26, 2012 at 12:05 AM, h...@tbbs.net wrote: 2012/07/26 06:52 +0530, Dhaval Jaiswal SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' as above give your join condition before INTO OUTFILE. Right: MySQL

Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-25 Thread Fred G
the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). I'm

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-25 Thread Dhaval Jaiswal
read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes). I'm wondering: a) What is going on? b) How do I

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-07 Thread Blog Tieng Viet
(HY000): Lost connection to MySQL server during query To: javad bakhshi javadbakh...@yahoo.com Cc: mysql@lists.mysql.com mysql@lists.mysql.com Date: Monday, March 5, 2012, 10:40 PM Checking your firewall settings.. S On Mon, Mar 5, 2012 at 08:39, javad bakhshi javadbakh...@yahoo.com wrote

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-05 Thread javad bakhshi
1, 2012 11:09 AM Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Il 01/03/2012 11:03, javad bakhshi ha scritto: Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-05 Thread Singer X.J. Wang
, From: mail...@securitylabs.it mail...@securitylabs.it To: mysql@lists.mysql.com Sent: Thursday, March 1, 2012 11:09 AM Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Il 01/03/2012 11:03, javad bakhshi ha scritto: Hi, I am trying to load

ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-01 Thread javad bakhshi
Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection to MySQL server during query My file size is around 4G and I have 220M lines in my file which have to be loaded in to my table.  I have 10

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-01 Thread mail...@securitylabs.it
Il 01/03/2012 11:03, javad bakhshi ha scritto: Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection to MySQL server during query My file size is around 4G and I have 220M lines in my file which have

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 stutired...@gmail.com hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy stutired...@gmail.com mailto:stutired...@gmail.com hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works well, sometimes not our

Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
...@gmail.com mailto:stutired...@gmail.com hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works well, sometimes not our mysql version is 5.0.84 our system is FreeBSD 6.2 thanks

Lost connection to MySQL server during query

2009-09-08 Thread 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, sometimes not our mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: mysql error 2013 Lost connection to MySQL server during query

2009-06-02 Thread Per Jessen
Per Jessen wrote: It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread,

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-27 Thread Per Jessen
Per Jessen wrote: I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following

mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. The application is running

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting Error 2013 Lost connection to MySQL server during query. I

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Steinfeld
just a thought: Did you run mysql_upgrade after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen p...@computer.org wrote: Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Steinfeld
On Mon, May 25, 2009 at 11:19 AM, Per Jessen p...@computer.org wrote: Per Jessen wrote: Michael Steinfeld wrote: just a thought: Did you run mysql_upgrade after the import? No, I didn't - I didn't think of it as I really only moved the data across. I suspect that will solve your issue.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. Is there anything else which runs against this

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Per Jessen wrote: Michael Dykman wrote: Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. I've also just run the query

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems.

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Michael Dykman wrote: Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Darryle Steplight
an application had choked on getting Error 2013 Lost connection to MySQL server during query. The application is running remotely on 32bit using mysql library from version 5.0.67. I've been googling quite a bit, but haven't really found anything of any use.  I've checked the two configurations

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Per Jessen
Darryle Steplight wrote: Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT

Re: lost connection to mysql server during query errors

2008-10-30 Thread Moon's Father
of mysql_error() (in php), i get lost connection to mysql server during query. Here's an example stack trace: 'Can't connect to name database [Lost connection to MySQL server during query]' Similarly, we're seeing stack traces here as well: 'Can't connect to name database []' I

lost connection to mysql server during query errors

2008-10-29 Thread Waynn Lue
We've started seeing mysql errors in the logs, and when i look at the output of mysql_error() (in php), i get lost connection to mysql server during query. Here's an example stack trace: 'Can't connect to name database [Lost connection to MySQL server during query]' Similarly, we're seeing stack

Re: lost connection to mysql server during query errors

2008-10-29 Thread Jake Maul
, and when i look at the output of mysql_error() (in php), i get lost connection to mysql server during query. Here's an example stack trace: 'Can't connect to name database [Lost connection to MySQL server during query]' Similarly, we're seeing stack traces here as well: 'Can't connect

Re: lost connection to mysql server during query errors

2008-10-29 Thread mos
server during query. Here's an example stack trace: 'Can't connect to name database [Lost connection to MySQL server during query]' Similarly, we're seeing stack traces here as well: 'Can't connect to name database []' I usually only see this mesasge when I don't use a connection for awhile

A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

2007-05-23 Thread aiton
I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get

Re: A question about how to debug the error 2013, 'Lost connection to MySQL server during query'

2007-05-23 Thread Sebastian Mendel
[EMAIL PROTECTED] schrieb: I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log

ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) 061220 14:48:44 mysqld restarted Also, if I execute mysqladmin shutdown, it restarts also slmini:/usr/local admin$ mysqladmin -u root -p shutdown Enter password: slmini:/usr/local admin$ 061220 14:59:19 mysqld restarted

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query, 061220 14:48:44 mysqld restarted

2006-12-20 Thread Kieran Kelleher
was stopped. Here is error I got this time for stop slave: stop slave; ERROR 2013 (HY000): Lost connection to MySQL server during query ([EMAIL PROTECTED]) (none) /usr/local/mysql/bin/mysqld_safe: line 1: 401 Illegal instruction nohup /usr/local/mysql/libexec/ mysqld --defaults-extra-file=/usr

ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-06-08 Thread murthy gandikota
Hi, I am getting this error. Can anyone please help? mysql create table sfgbackup.advEmail select * from sfg.advEmail; ERROR 2013 (HY000): Lost connection to MySQL server during query Bye [EMAIL PROTECTED] mgandikota]$ mysql -V mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686) Thanks

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-06-08 Thread 古雷
connection to MySQL server during query Hi, I am getting this error. Can anyone please help? mysql create table sfgbackup.advEmail select * from sfg.advEmail; ERROR 2013 (HY000): Lost connection to MySQL server during query Bye [EMAIL PROTECTED] mgandikota]$ mysql -V mysql Ver 14.7 Distrib

ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-03-27 Thread Marten Lehmann
Hello, again, I'm having problems with InnoDB tables. A certain table cannot be dropped. If I'm issueing the drop table statement, the connection is lost and I get the following in the logfile: 060327 14:38:11 InnoDB: error: space object of table db15670/mw_pagelinks, InnoDB: space id 12

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2006-03-27 Thread Heikki Tuuri
Sent: Monday, March 27, 2006 3:46 PM Subject: ERROR 2013 (HY000): Lost connection to MySQL server during query Hello, again, I'm having problems with InnoDB tables. A certain table cannot be dropped. If I'm issueing the drop table statement, the connection is lost and I get the following

Re: Lost connection to MySQL server during query

2006-01-25 Thread sheeri kritzer
continuing. -- George -Original Message- From: David Godsey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 4:09 PM To: mysql@lists.mysql.com Subject: Lost connection to MySQL server during query I am getting this error when connecting to mysql with PHP

Lost connection to MySQL server during query

2006-01-24 Thread David Godsey
I am getting this error when connecting to mysql with PHP: Lost connection to MySQL server during query This happens only when I use this procedure, but it doesn't necessarily fail when this procedure is called. The error will happen frequently, however it is not consistent. This is my first

RE: Lost connection to MySQL server during query

2006-01-24 Thread George Law
continuing. -- George -Original Message- From: David Godsey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 4:09 PM To: mysql@lists.mysql.com Subject: Lost connection to MySQL server during query I am getting this error when connecting to mysql with PHP: Lost connection to MySQL

RE: Lost connection to MySQL server during query

2006-01-24 Thread David Godsey
Godsey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 4:09 PM To: mysql@lists.mysql.com Subject: Lost connection to MySQL server during query I am getting this error when connecting to mysql with PHP: Lost connection to MySQL server during query This happens only when I use

Re: Lost connection to MySQL server during query

2006-01-24 Thread Jonathan Mangin
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 means I not getting the data I need

Re: localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'

2006-01-11 Thread Gleb Paharenko
: connect to server at '127.0.0.1' failed error: 'Lost connection to MySQL server during query' ok so my issue is the software that i am using is hardcoded to use 127.0.0.1 and not localhost. Even if i add the bind-address to my.cnf I still get the same error. If I bind it to an external

localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'

2006-01-10 Thread Lance Rochelle
at '127.0.0.1' failed error: 'Lost connection to MySQL server during query' ok so my issue is the software that i am using is hardcoded to use 127.0.0.1 and not localhost. Even if i add the bind-address to my.cnf I still get the same error. If I bind it to an external ip address I then can still

Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-16 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html Doug Dalton wrote: I found a log error after turning on warning running the server manually: 051215 17:32:42 [Warning] Aborted connection 3961 to db: 'db' user: 'user' host: `client'

Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-15 Thread Gleb Paharenko
] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativec ode=2013 ** Lost connection to MySQL server during query] ) ) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email

Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-15 Thread Doug Dalton
] DB_Error Object ( [error_message_prefix] = [mode] = 1 [level] = 1024 [code] = -14 [message] = DB Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query

Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-15 Thread Doug Dalton
[userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php

Re: HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-15 Thread Doug Dalton
Error: no database selected [userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5

HELP [nativecode=2013 ** Lost connection to MySQL server during query]

2005-12-14 Thread Doug Dalton
[userinfo] = SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] = Array ( [0] = Array ( [file] = /usr/share/php5/PEAR/DB.php

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

2005-09-27 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 it

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 am using MySQL

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

Lost connection to MySQL server during query when calling stored procedure

2005-09-21 Thread Jasper Bryant-Greene
the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General

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

2005-09-21 Thread Martijn Tonies
getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. And what is your question? ;-) Most probably, a server crash... With regards

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

2005-09-21 Thread Jasper Bryant-Greene
: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. And what is your question? Fairly obviously, how do I fix it!? ;) Most

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

2005-09-21 Thread Pooly
; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86

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

2005-09-21 Thread Daniel
users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log

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

2005-09-21 Thread Jasper Bryant-Greene
INVOKER SELECT * FROM users WHERE id=userID LIMIT 1; Sometimes when I execute this stored procedure with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL

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

2005-09-21 Thread Jasper Bryant-Greene
with, for example: CALL getUser(7); I get the error Lost connection to MySQL server during query. This only ever happens with stored procedures, never with any normal kind of query. I am using MySQL 5.0.12-beta-log on Gentoo Linux x86. This only seems to happen when accessing MySQL from PHP's MySQLi API

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-02 Thread Jerome Macaranas
-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-02 Thread Jerome Macaranas
on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console

Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread JM
Hi all, Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread Pooly
read this link http://dev.mysql.com/doc/mysql/en/gone-away.html; hoping this has something to do with the error... Ive already checked based on the page the list of roots of error to produce gone-away.. w/c i hope leads to Lost connection to MySQL server during query and non

Re: Please I need inputs on Lost connection to MySQL server during query

2005-09-01 Thread SGreen
hope leads to Lost connection to MySQL server during query and non of it is present. One thing Ive noticed. When I tried connecting using mysql client from web server to my DB box its takes time before mysql console shows-up after giving the password. Client and Server

Lost connection to MySQL server during query - on long queries

2005-06-01 Thread Amir Shay
Hello, Each time we run long queries (over around 5 seconds) the mySQL server fails and restarts (you can see it in the error log that starts with Database page corruption on disk or a fail.. and then there is a dump...) and the query return with Lost connection to MySQL server during query

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

2005-06-01 Thread Dobromir Velev
to MySQL server during query... Using Linux 9 with mySQL 4.1.11-standard the tables are InnoDB The error is happening from everywhere: mysql command line, Query browser, from local and remote computers, running selects, insert and even check table, EMS client . Java (see below the log

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
to MySQL server during query. Here are the symptoms 1.When running the query from the server it returns OK 2.When running the query from another machine using the mySQL query browser it returns OK 3.When running the query from another machine from Java using mySQL JDBC it fails

Re: Lost connection to MySQL server during query problem

2005-05-26 Thread Gleb Paharenko
: http://dev.mysql.com/doc/mysql/en/system-variables.html Sometimes when querying mySQL 4.1.11 on Linux machine I get the error Lost connection to MySQL server during query. Here are the symptoms 1.When running the query from the server it returns OK 2.When running

Lost connection to MySQL server during query problem

2005-05-25 Thread Amir Shay
Hi, Sometimes when querying mySQL 4.1.11 on Linux machine I get the error Lost connection to MySQL server during query. Here are the symptoms 1. When running the query from the server it returns OK 2. When running the query from another machine using the mySQL query browser

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002

Re: problem-Lost connection to MySQL server during query

2005-05-24 Thread Gleb Paharenko
Hello. Have you looked into error log? Server could die during the query execution. Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Hi, I install Mysql 4.1.12-0 by rpm. When I try to create a table, it give me Lost connection to MySQL server during query. My query is like: CREATE TABLE ArrayBatch ( id int(11) NOT NULL auto_increment, arrayType int(11) NOT NULL default '0', descr text NOT NULL, printStartDate

Re: problem-Lost connection to MySQL server during query

2005-05-24 Thread Gleb Paharenko
Hello. Resolve a stack trace. See: http://dev.mysql.com/doc/mysql/en/using-stack-trace.html Hi, This is my first time to instll mysql. So I have not so much experience. I am apprecia ted your help! Now I check my mysqld.log file, there is something like: mysqld got signal

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

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

2005-05-18 Thread Dan Rossi
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 query I am trying to do select (select

Re: ERROR 2013: Lost connection to MySQL server during query

2005-04-21 Thread Michael Gale
Daniel Kasak wrote: Michael Gale wrote: Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP

ERROR 2013: Lost connection to MySQL server during query

2005-04-20 Thread Michael Gale
Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect to a database and try

Re: ERROR 2013: Lost connection to MySQL server during query

2005-04-20 Thread Daniel Kasak
Michael Gale wrote: Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect

Re:ERROR 2013: Lost connection to MySQL server during query

2005-03-21 Thread TheRefUmp
Hi, I'm having a similar problem using the LOAD DATA. I get an intermittent error: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query The command is: LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by '~' lines terminated by '\n'; I cannot

ERROR 2013: Lost connection to MySQL server during query

2005-03-18 Thread sol beach
/initial_20050318_102517/page_path.tab4' - REPLACE INTO TABLE page_path - FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' - (PAGE_PATH_ID,NAME,DATE_CREATED); ERROR 2013: Lost connection to MySQL server during query mysql [EMAIL PROTECTED]:/b/martgen/mysql/bingrep -i

''Lost connection to MySQL server during query'' on Stored Procedure

2005-01-07 Thread Holger Sunke
Hello, I just installed MySQL 5.0.2 (on Debian Sarge) and started to do some experimets with Stored Procedures. I very often get the error Lost connection to MySQL server during query when executing such a self created Procedure. Sometimes the same Precedure works fine, sometimes it results

Lost connection to MySQL server during query after 4.1 upgrade

2004-11-26 Thread Gustafson, Tim
Hello All! I have had mySQL 3.2 running on my server for about 2 years now without incident. Recently upgraded to 4.1, and suddenly I'm getting the following message from queries: Lost connection to MySQL server during query This is in response to a PHP script issuing a query to the mySQL

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

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

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 worked once

  1   2   3   >