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

2014-01-08 Thread Manuel Arostegui
2014/1/7 > 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 th

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, a

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 signatu

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: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-08-01 Thread Fred G
er never gives a timeout for running queries). > - The mysqld server died (not likely but possible). > - Some process in your system is killing quries that runs too long. > > One way to quickly check that things are working are by adding LIMIT 1 > to the query. > > Fred> Does

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

2012-07-31 Thread Michael Widenius
an idea of what is going on? >>> 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: &g

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, 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

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

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

2012-07-26 Thread Fred G
sale.sale_total_amt >> into outfile 'test123.csv' >> FIELDS terminated by ',' >> FROM db.emp >> LEFT OUTER JOIN db.sale >> ON db.sale.emp_id = db.emp.emp_id; >> >> The query without exporting the file works fine, in about 12 sec/77 sec.

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

2012-07-25 Thread Dhaval Jaiswal
mp_id; > > 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,

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

2012-07-25 Thread Fred G
ery 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 values

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

2012-03-07 Thread Blog Tieng Viet
...@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: > >

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

2012-03-05 Thread Singer X.J. Wang
egards, > Javad Bakhshi, > > > > From: "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 sc

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

2012-03-05 Thread javad bakhshi
, 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)

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 to be

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 of these

Re: Lost connection to MySQL server during query

2009-09-09 Thread stutiredboy
ilto: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 tha

Re: Lost connection to MySQL server during query

2009-09-09 Thread Claudio Nanni
audio Nanni wrote: > >> Can you provide more details? >> network layout, type of client/app used, connectors,etc,etc? >> Thanks >> >> Claudio >> >> >> 2009/9/9 stutiredboy mailto:stutired...@gmail.com >> >> >> >>hi,all: &

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'

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

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 threa

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 inform

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: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Darryle Steplight
ation 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.

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 have

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 whi

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
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 t

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 Michael Steinfeld
On Mon, May 25, 2009 at 11:19 AM, Per Jessen 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 i

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 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 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 unsubscrib

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 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. > > The

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. I

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 se

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

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

2008-10-30 Thread Moon's Father
nection pooling and now the number of connections reaches a high of > around 10 and I haven't had the problem since. > > Mike > > On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue <[EMAIL PROTECTED]> wrote: >> > We've started seeing mysql errors in the logs, and when

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

2008-10-29 Thread mos
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 database [Lost connection to MySQL server during > query]' > > Similarly, we're seeing st

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

2008-10-29 Thread Jake Maul
; wrote: > 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 database [Lost connection to

"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 database [Lost connection to MySQL server during query]&#

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 durin

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, bu

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

2006-12-20 Thread Kieran Kelleher
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-fil

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

2006-12-20 Thread Kieran Kelleher
000): 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 restarte

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

2006-12-20 Thread Kieran Kelleher
ROR 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

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

2006-06-08 Thread 古雷
nection 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

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) Tha

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

2006-03-27 Thread Heikki Tuuri
ED]> Newsgroups: mailing.database.myodbc 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 lo

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 did

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 > &

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
. Before 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 t

RE: Lost connection to MySQL server during query

2006-01-24 Thread George Law
... Before 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 con

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

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

2006-01-11 Thread Gleb Paharenko
| 28800 =20 > | > +-+= > --+ > > [EMAIL PROTECTED]:~# cat /etc/hosts > 127.0.0.1 localhost localhost.localdomain > > [EMA

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

2006-01-10 Thread Lance Rochelle
27.0.0.1 -u root -p ping Enter password: mysqladmin: 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

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: `clie

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

2005-12-15 Thread Doug Dalton
] => 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] [backtrace] => Array (

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

2005-12-15 Thread Doug Dalton
B 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 (

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

2005-12-15 Thread Doug Dalton
32:20] 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 connec

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

2005-12-15 Thread Gleb Paharenko
; mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** > Lost > connection to MySQL server during query] >[backtrace] => Array >( >[0] => Array >( >[file] =>

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

2005-12-14 Thread Doug Dalton
tabase selected [userinfo] => SELECT * FROM buser Where mUserID='d86659dcee2cf9933d84ea337b1b9785' LIMIT 0,1 [nativecode=2013 ** Lost connection to MySQL server during query] [backtrace] => Array ( [0] => Array ( [fi

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 >> "

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.1

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

2005-09-21 Thread Jasper Bryant-Greene
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 PH

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.

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.1

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

2005-09-21 Thread Pooly
NISTIC > >> SQL SECURITY 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

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 d

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

2005-09-21 Thread Martijn Tonies
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.

"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/

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

2005-09-02 Thread Jerome Macaranas
ng 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. > > > >

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

2005-09-02 Thread Jerome Macaranas
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

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

2005-09-01 Thread SGreen
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 ta

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

2005-09-01 Thread Pooly
t; 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

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

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

2005-06-01 Thread Dobromir Velev
the query return with "Lost connection 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 select

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 MySQ

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
;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 it returns OK > 3.When running the query fr

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

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

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 si

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 NU

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 M

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: 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 count(disc

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. Then

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

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 the

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 termin

ERROR 2013: Lost connection to MySQL server during query

2005-03-18 Thread sol beach
ysql> LOAD DATA CONCURRENT LOCAL INFILE '../data/mysql/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

''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

"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 que

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 dur

  1   2   3   >