Re: Lost connection to MySQL server during query
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 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/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- Claudio
Re: Lost connection to MySQL server during query
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. Claudio 2009/9/9 stutiredboy stutired...@gmail.com 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 sql that create table(s) i have read this article http://dev.mysql.com/doc/refman/5.1/en/gone-away.html and can get rid of the problems this article referred it seems that our problem is similar to this bug: http://lists.mysql.com/commits/9447 http://bugs.mysql.com/bug.php?id=15752 but, this bug has been fixed in 5.0.25 are there any suggestions ? or any other informaion (s) should i post here? thanks! stutiredboy Claudio Nanni wrote: Can you provide more details? network layout, type of client/app used, 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 mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- Claudio -- Claudio
Re: Lost connection to MySQL server during query
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 sql that create table(s) i have read this article http://dev.mysql.com/doc/refman/5.1/en/gone-away.html and can get rid of the problems this article referred it seems that our problem is similar to this bug: http://lists.mysql.com/commits/9447 http://bugs.mysql.com/bug.php?id=15752 but, this bug has been fixed in 5.0.25 are there any suggestions ? or any other informaion (s) should i post here? thanks! stutiredboy Claudio Nanni wrote: Can you provide more details? network layout, type of client/app used, 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 mysql version is 5.0.84 our system is FreeBSD 6.2 thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: lost connection to mysql server during query errors
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 1:05 PM, mos [EMAIL PROTECTED] wrote: 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 usual suspects: recent versions, persistent vs. non-persistent connections, etc. A long shot would be to make sure your always talking to the same database server- if you're doing, say, DNS round-robin or load balancing or something, maybe you're getting shunted to a different db server and it's killing the connection... don't know what your setup is. Another long shot in a multi-db-server config would be to make sure they all have different server ID's. Good luck... hopefully someone else has better advice :) Jake Just a guess, but maybe it's your network card? I'm using MySQL 5.01 with MyISAM tables and my application will occasionally hang for hours in the midst of executing a simple 1 table Select statement. I usually end up killing the program. There are no processes running on the MySQL server. I think the problem was the number of connections the program created. Although there were only at most 10 simultaneous connections, my program when the query finished executing, it threw the connection away and recreated a new one for each query, and MySQL reported there were some 10k connections made to the server. I ended up using connection 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 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 to name database []' I usually only see this mesasge when I don't use a connection for awhile and it timeouts, but in this case, the connection is only opened for the duration of a script, which can't be running for more than a second. The mysql error logs don't show anything, and wait_timeout is set to 28800. At first, I thought it was because I was calling mysql_select_db too much, so I ended up using two mysql connections per page load, but that didn't seem to change anything. How can we prevent this error from happening, what else can I do to diagnose this further? Google brings up some more discussions about it, but nothing seems related to this, like packetsize. This is happening when we select two ids from a database. And SHOW PROCESSLIST shows that the number of connections aren't even coming close to max connections. Thanks for any advice, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: lost connection to mysql server during query errors
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, persistent vs. non-persistent connections, etc. A long shot would be to make sure your always talking to the same database server- if you're doing, say, DNS round-robin or load balancing or something, maybe you're getting shunted to a different db server and it's killing the connection... don't know what your setup is. Another long shot in a multi-db-server config would be to make sure they all have different server ID's. Good luck... hopefully someone else has better advice :) Jake 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 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 to name database []' I usually only see this mesasge when I don't use a connection for awhile and it timeouts, but in this case, the connection is only opened for the duration of a script, which can't be running for more than a second. The mysql error logs don't show anything, and wait_timeout is set to 28800. At first, I thought it was because I was calling mysql_select_db too much, so I ended up using two mysql connections per page load, but that didn't seem to change anything. How can we prevent this error from happening, what else can I do to diagnose this further? Google brings up some more discussions about it, but nothing seems related to this, like packetsize. This is happening when we select two ids from a database. And SHOW PROCESSLIST shows that the number of connections aren't even coming close to max connections. Thanks for any advice, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: lost connection to mysql server during query errors
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 usual suspects: recent versions, persistent vs. non-persistent connections, etc. A long shot would be to make sure your always talking to the same database server- if you're doing, say, DNS round-robin or load balancing or something, maybe you're getting shunted to a different db server and it's killing the connection... don't know what your setup is. Another long shot in a multi-db-server config would be to make sure they all have different server ID's. Good luck... hopefully someone else has better advice :) Jake Just a guess, but maybe it's your network card? I'm using MySQL 5.01 with MyISAM tables and my application will occasionally hang for hours in the midst of executing a simple 1 table Select statement. I usually end up killing the program. There are no processes running on the MySQL server. I think the problem was the number of connections the program created. Although there were only at most 10 simultaneous connections, my program when the query finished executing, it threw the connection away and recreated a new one for each query, and MySQL reported there were some 10k connections made to the server. I ended up using connection 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 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 to name database []' I usually only see this mesasge when I don't use a connection for awhile and it timeouts, but in this case, the connection is only opened for the duration of a script, which can't be running for more than a second. The mysql error logs don't show anything, and wait_timeout is set to 28800. At first, I thought it was because I was calling mysql_select_db too much, so I ended up using two mysql connections per page load, but that didn't seem to change anything. How can we prevent this error from happening, what else can I do to diagnose this further? Google brings up some more discussions about it, but nothing seems related to this, like packetsize. This is happening when we select two ids from a database. And SHOW PROCESSLIST shows that the number of connections aren't even coming close to max connections. Thanks for any advice, Waynn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query
Check out: http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html http://dev.mysql.com/doc/refman/5.0/en/gone-away.html (I've noticed this has come up a lot recently on the list. . .) -Sheeri On 1/24/06, Jonathan Mangin [EMAIL PROTECTED] wrote: I got exactly that 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: mysql@lists.mysql.com Sent: Tuesday, January 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 means I not getting the data I need. So for debug purposes, are you saying to do a check status from PHP or in the procedure? From the procedure it wouldn't do any good right? From PHP it would be after I didn't get the data, so I would have to reconnect and rerun the query. That won't really work for me either. David Godsey 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 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 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 procedure I've written, so I'm sure I've done something wrong here. I assume the error message means I'm hitting some kind of timeout? Any ideas would be welcome. Thanks. create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint
RE: Lost connection to MySQL server during query
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 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 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 procedure I've written, so I'm sure I've done something wrong here. I assume the error message means I'm hitting some kind of timeout? Any ideas would be welcome. Thanks. create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint; END IF; CASE data_type WHEN Float THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Double THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Signed THEN call toSigned(fdata_bigint,fdata_signed); SET @fdata_converted=fdata_signed; WHEN Unsigned THEN
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. So for debug purposes, are you saying to do a check status from PHP or in the procedure? From the procedure it wouldn't do any good right? From PHP it would be after I didn't get the data, so I would have to reconnect and rerun the query. That won't really work for me either. David Godsey 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 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 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 procedure I've written, so I'm sure I've done something wrong here. I assume the error message means I'm hitting some kind of timeout? Any ideas would be welcome. Thanks. create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint; END IF; CASE data_type WHEN Float THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN call polyConv(fdata_float,conv_param,fdata_float); END IF; SET @fdata_converted=fdata_float; WHEN Double THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param)) THEN
Re: Lost connection to MySQL server during query
I got exactly that 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: mysql@lists.mysql.com Sent: Tuesday, January 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 means I not getting the data I need. So for debug purposes, are you saying to do a check status from PHP or in the procedure? From the procedure it wouldn't do any good right? From PHP it would be after I didn't get the data, so I would have to reconnect and rerun the query. That won't really work for me either. David Godsey 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 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 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 procedure I've written, so I'm sure I've done something wrong here. I assume the error message means I'm hitting some kind of timeout? Any ideas would be welcome. Thanks. create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE) BEGIN DECLARE mfid INT UNSIGNED; DECLARE pid INT UNSIGNED; DECLARE foffset INT UNSIGNED; DECLARE flength INT UNSIGNED; DECLARE vid INT UNSIGNED; DECLARE rfid INT UNSIGNED; DECLARE tpid INT UNSIGNED; DECLARE fdata BLOB; DECLARE fdata_tmp BLOB; DECLARE fdata_bigint BIGINT UNSIGNED; DECLARE fdata_signed INT; DECLARE fdata_unsigned INT UNSIGNED; DECLARE fdata_float DOUBLE; DECLARE data_type VARCHAR(20); DECLARE byte_order VARCHAR(20); DECLARE conv_param VARCHAR(255); SELECT major_frame_desc_id, parent_id, frame_offset, frame_length, version_id, top_level_parent_id FROM MajorFrameDescription WHERE name=n INTO mfid,pid,foffset,flength,vid,tpid; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=NormalizedType INTO data_type; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ConvParams INTO conv_param; SELECT attribute_value FROM MajorFrameAttributes WHERE major_frame_desc_id=mfid AND attribute_name=ByteOrder INTO byte_order; SELECT MAX(raw_major_frame_id) FROM RawMajorFrames WHERE major_frame_desc_id=tpid INTO rfid; IF rfid 0 THEN SELECT payload_time, SUBSTR(BINARY(frame_data), FLOOR(foffset/8)+1, CEIL((flength + (foffset %8 ))/8)) FROM RawMajorFrames WHERE raw_major_frame_id=rfid INTO ptime,fdata; call toBigInt(fdata,fdata_bigint); IF (foffset %8) 0 THEN SET @mask_off=foffset%8; call mask_data(fdata,@mask_off,fdata_bigint); END IF; IF (8-((flength+(foffset%8)) %8)) 0 THEN SELECT (fdata_bigint (8-((flength+(foffset%8)) %8))) INTO fdata_bigint; END IF; CASE data_type WHEN Float THEN call toFloat(fdata_bigint,fdata_float); IF(!ISNULL(conv_param
Re: Lost connection to MySQL server during query when calling stored procedure
-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 right after the crash. Take a look at the server's log files. My server log shows absolutely nothing after server startup, no matter how many times that stored procedure fails. I'm about to recompile with the debug USE flag (I'm on Gentoo) to try to track down the problem; once I've done that I'll file a bug. Before you file a bug, please re-test it with 5.0.13 - several SP-releated bugs have been fixed since 5.0.12 was released. If it's still repeatable in 5.0.13, please file a bug report at http://bugs.mysql.com. Thanks! Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany Are you MySQL certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQFDOOvWSVDhKrJykfIRAh8uAJ4n1NLXykT3Ob65mTK/VT239cQTpACfZaW8 bym5rslnYYYrOeJTZOXvnjw= =0fJP -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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 5.0.12-beta-log on Gentoo Linux x86. This only seems to happen when accessing MySQL from PHP's MySQLi API, not when accessing it using the mysql command-line client. Is this a bug I should report to MySQL or to PHP? I'm not able to test other APIs at the moment. If the server dies, that's a MySQL problem. Take a look at http://bugs.mysql.com/ for information on how to report it. In particular, the server logs should give some information. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia See complete headers for address and phone numbers. Are you MySQL certified? http://www.mysql.com/certification/ pgpjYgw1PlK8L.pgp Description: PGP signature
Re: Lost connection to MySQL server during query when calling stored procedure
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 Linux x86. This only seems to happen when accessing MySQL from PHP's MySQLi API, not when accessing it using the mysql command-line client. Is this a bug I should report to MySQL or to PHP? I'm not able to test other APIs at the moment. If the server dies, that's a MySQL problem. Take a look at http://bugs.mysql.com/ for information on how to report it. In particular, the server logs should give some information. Thing is, even though I get that error, the server keeps running and accepting other connections and responding to queries fine. My server log shows absolutely nothing after server startup, no matter how many times that stored procedure fails. I'm about to recompile with the debug USE flag (I'm on Gentoo) to try to track down the problem; once I've done that I'll file a bug. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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: 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? ;-) Most probably, a server crash... With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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: 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 probably, a server crash... Can you be a little bit more specific please? The MySQL server is working absolutely fine for everything else and also continues to respond to connections and queries perfectly after getting that error. Thanks -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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 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 on Gentoo Linux x86. And what is your question? Fairly obviously, how do I fix it!? ;) Most probably, a server crash... Can you be a little bit more specific please? The MySQL server is working absolutely fine for everything else and also continues to respond to connections and queries perfectly after getting that error. I think he means, that you should try the official binaries, and this still happens, file a bug report because 5.0 is still in Beta stage. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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 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 on Gentoo Linux x86. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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 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 5.0.12-beta-log on Gentoo Linux x86. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query when calling stored procedure
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 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, not when accessing it using the mysql command-line client. Is this a bug I should report to MySQL or to PHP? I'm not able to test other APIs at the moment. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - on long queries
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 2005 12:04, Amir Shay wrote: 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... 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) The problem is probably not in the network parameters, see list of the variables below The database is quit big around 5 GB After the error the server restart automatically and continue to run for the short queries We found one place where long queries work - when we run from the query browser the same select * from some big table. However running from the same place check table... reproduce the error !. Again running the same select * from some big table from all the other palaces cause the server to fall Amir Server parameters 'back_log', '50' 'basedir', '/' 'binlog_cache_size', '32768' 'bulk_insert_buffer_size', '8388608' 'character_set_client', 'utf8' 'character_set_connection', 'utf8' 'character_set_database', 'hebrew' 'character_set_results', 'utf8' 'character_set_server', 'hebrew' 'character_set_system', 'utf8' 'character_sets_dir', '/usr/share/mysql/charsets/' 'collation_connection', 'utf8_general_ci' 'collation_database', 'hebrew_general_ci' 'collation_server', 'hebrew_general_ci' 'concurrent_insert', 'ON' 'connect_timeout', '100' 'datadir', '/var/lib/mysql/' 'date_format', '%Y-%m-%d' 'datetime_format', '%Y-%m-%d %H:%i:%s' 'default_week_format', '0' 'delay_key_write', 'ON' 'delayed_insert_limit', '100' 'delayed_insert_timeout', '300' 'delayed_queue_size', '1000' 'expire_logs_days', '0' 'flush', 'OFF' 'flush_time', '0' 'ft_boolean_syntax', '+ -()~*:|' 'ft_max_word_len', '84' 'ft_min_word_len', '4' 'ft_query_expansion_limit', '20' 'ft_stopword_file', '(built-in)' 'group_concat_max_len', '1024' 'have_archive', 'NO' 'have_bdb', 'NO' 'have_blackhole_engine', 'NO' 'have_compress', 'YES' 'have_crypt', 'YES' 'have_csv', 'NO' 'have_example_engine', 'NO' 'have_geometry', 'YES' 'have_innodb', 'YES' 'have_isam', 'NO' 'have_ndbcluster', 'NO' 'have_openssl', 'NO' 'have_query_cache', 'YES' 'have_raid', 'NO' 'have_rtree_keys', 'YES' 'have_symlink', 'YES' 'init_connect', '' 'init_file', '' 'init_slave', '' 'innodb_additional_mem_pool_size', '14680064' 'innodb_autoextend_increment', '8' 'innodb_buffer_pool_awe_mem_mb', '0' 'innodb_buffer_pool_size', '1073741824' 'innodb_data_file_path', 'ibdata1:10M:autoextend' 'innodb_data_home_dir', '/var/lib/mysql' 'innodb_fast_shutdown', 'ON' 'innodb_file_io_threads', '4' 'innodb_file_per_table', 'OFF' 'innodb_flush_log_at_trx_commit', '1' 'innodb_flush_method', '' 'innodb_force_recovery', '0' 'innodb_lock_wait_timeout', '50' 'innodb_locks_unsafe_for_binlog', 'OFF' 'innodb_log_arch_dir', '' 'innodb_log_archive', 'OFF' 'innodb_log_buffer_size', '1048576' 'innodb_log_file_size', '5242880' 'innodb_log_files_in_group', '2' 'innodb_log_group_home_dir', './' 'innodb_max_dirty_pages_pct', '90' 'innodb_max_purge_lag', '0' 'innodb_mirrored_log_groups', '1' 'innodb_open_files', '300' 'innodb_table_locks', 'ON' 'innodb_thread_concurrency', '8' 'interactive_timeout', '100' 'join_buffer_size', '131072' 'key_buffer_size', '8388600' 'key_cache_age_threshold', '300' 'key_cache_block_size', '1024' 'key_cache_division_limit', '100' 'language', '/usr/share/mysql/english/' 'large_files_support', 'ON' 'license', 'GPL' 'local_infile', 'ON' 'locked_in_memory', 'OFF' 'long_query_time', '10' 'low_priority_updates', 'OFF' 'lower_case_file_system', 'OFF' 'lower_case_table_names', '1' 'max_allowed_packet', '1047552' 'max_binlog_cache_size', '4294967295' 'max_binlog_size', '1073741824' 'max_connect_errors', '10' 'max_connections', '100' 'max_delayed_threads', '20' 'max_error_count', '64' 'max_heap_table_size', '16777216' 'max_insert_delayed_threads', '20' 'max_join_size', '4294967295' 'max_length_for_sort_data', '1024' 'max_relay_log_size', '0' 'max_seeks_for_key', '4294967295' 'max_sort_length', '1024' 'max_tmp_tables', '32' 'max_user_connections', '0' 'max_write_lock_count', '4294967295' 'net_buffer_length', '16384' 'net_read_timeout', '30' 'net_retry_count', '10' 'net_write_timeout', '60' 'new', 'OFF' 'old_passwords', 'OFF' 'open_files_limit', '1024' 'pid_file',
Re: Lost connection to MySQL server during query problem
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 Yes the server dies during the queries from JDBC. Regarding the client parameters, what if the client doesn't have mySQL installed? Amir Amir Shay [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query problem
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 (check the error log)? Sometimes you should increase interactive_timeout as well. A lot of variables usually could be changed using SET statement. See: 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 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 with Lost connection to... 4.When running the query from another machine using software like EMS it fails with Lost connection to... 5.The error is always after 4.7 seconds and only in heavy queries (not only SELECT, even DELETES ) The problem is probably not in the communication parameters, like max_allowed_packet or connection_timeout on the server because I increased then Does anyone know how can I control those parameters from JDBC? Amir Shay [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com
Re: Lost connection to MySQL server during query problem
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: 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 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 with Lost connection to... 4.When running the query from another machine using software like EMS it fails with Lost connection to... 5.The error is always after 4.7 seconds and only in heavy queries (not only SELECT, even DELETES ) The problem is probably not in the communication parameters, like max_allowed_packet or connection_timeout on the server because I increased then Does anyone know how can I control those parameters from JDBC? Amir Shay [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to Mysql server during query using a group by clause and sub query
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 query I am trying to do select (select count(discrepancy_originID) FROM report_log WHERE discrepancy_originID=1) as total FROM report_log GROUP BY MONTH (tx_date) let me know, if i take the sub query out its ok ? Is your server crashing during the query? Check the .err file which should be in the data directory for restarts. --Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query bind-address
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 problems are like the one you are experiencing. I'd suggest you to download and install MySQL binary RPMs from www.mysql.com. I'm sure, the problem will disappear. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query bind-address
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 problem? The error messages says lost connection _during_ query, this means that the connection is already established, so obviously the resolver already did it's job to find out the ip-address of the mysql-server. And anyway: I used bind-address before and it worked. I just don't understand why it doesn't work again now. Mysql itself is starting correctly and the server log doesn't show anything. But the clients are losing the connection. Regards Marten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query bind-address
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 before and the ip-address the clients are connection to is the same as the one mentioned at bind-address= Do you have any ideas for that? Tell us the OS, the MySQL server and client version and the build information (custom or binary downloaded from MySQL.com). This *might* be a problem of resolver in glibc. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
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, December 05, 2003 12:14 AM Subject: Lost connection to MySQL server during query - pls help 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. My problem is: I have a Java program which is actually a thread to send emails, so it keeps running all the time. When it's time to send emails, it will access MySQL database. Based on my wait_timeout in mysql, I think the connection closes after 8 hrs. If it's the time to send emails, and mysql has already closed the connection, the first connection attemp will throw an error Error 2013 - Lost connection to MySQL server during query * Is there a way that I can avoid this error? Or to make the connection keeps open all the the time? Any help / suggestions will be very much appreciated :) Thank you in advance. Rgds, Vanessa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
Thank you so much guys, for your attention and help. I'm upgrading my MySQL to 4.0.16 as suggested. Rgds, Vanessa - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Jay Blanchard [EMAIL PROTECTED]; miguel solorzano [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] 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 the Bugs fixed section of: http://www.mysql.com/doc/en/News-4.0.16.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
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 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. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection to MySQL server during query - pls help
[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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query - pls help
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 actually a thread to send emails, so it keeps running all the time. When it's time to send emails, it will access MySQL database. Based on my wait_timeout in mysql, I think the connection closes after 8 hrs. If it's the time to send emails, and mysql has already closed the connection, the first connection attemp will throw an error Error 2013 - Lost connection to MySQL server during query * Is there a way that I can avoid this error? Or to make the connection keeps open all the the time? You can increase value of wait_timeout variable. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection to MySQL server during query - pls help
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 the Bugs fixed section of: http://www.mysql.com/doc/en/News-4.0.16.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost Connection to MySQL server during query
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, September 09, 2003 10:36 AM Subject: Lost Connection to MySQL server during query I have a script that is processing data from a single table and splitting it into smaller normalized tables. The script takes anywhere between 5-10 minutes to complete, and as it runs it constantly outputs a report on its progress. The script seems to run fine the first time I run it, but with subsequent runs (To see if it incorrectly creates duplicates of records etc), after a couple of minutes the script ends with an error message saying Lost connection to MySQL server during query. During the first run, the script is mostly just chopping up the data and placing it in the new tables, and doing a little comparing. But during subsequent runs, all of the records in the new tables should already exist, so the script see's this, and instead of creating new records, it compares them to see if its correct. Does anyone have any idea why it would be losing connection all the time? This is just being run on a test server at the moment. Being used as the server and also the client, configured as follows: Windows XP Tablet Edition PHP 4.3.3 PHP Extensions: XmlRPC MySQL 4.0.14 Apache 2.0.47 Please help, this has been making my life hell for a week now! Thanks Donald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Lost connection to MySQL server during query
---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 PROTECTED] doesn't
--seem to be too active, so I'm hoping someone here might be able to
offer
--some insight.]
--
--I'm getting the below error when trying to connect to a MySQL 4.0.12
--server on RedHat 9 using a Perl script:
--
--DBI connect('mailers:192.168.50.201','admin',...)
--failed: Lost connection to MySQL server during query at ./dialer line
24
--Can't call method prepare on an undefined value at ./dialer line
28.
--
--The client machines are RH9 also, using the 3.23.56 libraries and
clients
--shipped with RedHat. Perl on RH9 is 5.8.0.
--
--Any ideas where to start?
Does your script run for a long time?
Look for a variable in my.cnf called wait_timeout it might be set pretty
low. Do a $DBI-ping in your loop to test your connection and reconnect
if not connected -OR- set wait_timeout really high.
--
--Thanks,
--Alec
--
--MySQL General Mailing List
--For list archives: http://lists.mysql.com/mysql
--To unsubscribe:
--http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost connection to MySQL server during query
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, Hi All I just installed a RedHat Linux 8.0 box with mysql-server-3.23.52-3 mysql-3.23.52-3 mysql-devel-3.23.52-3 Changed the password for root using mysqladmin logged in using a mysql client (locally) and mysql GRANT ALL ON *.* TO araheja@'%' IDENTIFIED BY 'amanraheja'; I DID THE SAME STEPS ON ANOTHER BOX WITH Linux Slackware box with mysql 3.23.39 When I try to login using a remote client in both the servers, Slackware box allows me but RedHat BOX gives me the following error Lost connection to MySQL server during query I also downloaded and installed mysql-server-3.23.54a-1 mysql-3.23.54a-1 mysql-devel-3.23.54a-1 Still the same problem. Any suggestions? Thank you in advance Regards -- Aman Raheja AGF Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Lost connection to MySQL server during query
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 problem) This server has glibc 2.2.4-31 installed for quite a while, and mysql 3.23.54a was working just fine with it. Mysql 4.0.8 stopped crashing when I added --skip-name-resolve in the mysql startup... but some tables are getting corrupted very often, and I can't find a reason. It doesn't the tables are getting corrupted because of mysql is crashing, because bin-log index is not increasing, and there is nothing in the logs saying it was restarted. This is one example of check table: alpgrafik_com_1.kent_session_info warning Not used space is supposed to be: 30612 but is: 30404 alpgrafik_com_1.kent_session_info error record delete-link-chain corrupted alpgrafik_com_1.kent_session_info error Corrupt --- I searched for delete-link-chain on google but I didn't have much luck Not all clients (eg, php) have been upgraded to version 4, but the mysql docs say there shouldn't be a problem if we are not using the new features. Ideias? Please, upgrade to the version 4.0.9. There was a bug in 4.0.8 when MySQL crashes if he can't resolve remote hostname. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query at ... After upgrade to 3.23.54
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 PROTECTED] Sent: Wednesday, January 15, 2003 2:34 PM Subject: Lost connection to MySQL server during query at ... After upgrade to 3.23.54 Hi all, Pure randomly my server tells me the its Lost connection to MySQL server during query at ... This all happened after my upgrade to version 3.23.54. I searched google and read some threads here. A possible solution is to DOWNGRADE some libc files? Tell me is this the only solution ? Is there a patch ? Thanks, Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Lost connection to MySQL server during query
Mark, Tuesday, November 26, 2002, 7:32:15 AM, you wrote: M Yes, again. :( Although reluctantly, I finally decided to upgrade to M 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors. M Alas, 6 out of 10 times when I start a MySQL application, I get an error M like this: M DBD::mysql::st execute failed: Lost connection to MySQL server during query M at /usr/libdata/perl/5.00503/News/MySQL/User.pm line 209. M The log is very non-telling; it mostly bales at something entirely trivial; M M 021126 6:15:34 4 Connect news@localhost on xovers M 4 Query SELECT domain_id FROM smtp.cwdomains M 021126 6:15:35 4 Query SELECT newsgroup FROM newsgroups WHERE M local 'y' M 4 Quit M M The program connects via /tmp/mysql.sock from localhost; so there is no real M connection or DNS problem. It just loses the connection. :( M Can someone please tell me how to end this problem? I checked the databases M a zillion times, and they appear fully intact. I am gravely at a loss here. M :( Check that max_allowed_packet is big enough: http://www.mysql.com/doc/en/Gone_away.html Do you get the same result if you execute this query from command-line? What does table 'newsgroups' look like? (table stucture) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
- 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: M Yes, again. :( Although reluctantly, I finally decided to upgrade M to 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these M annoying errors. Alas, 6 out of 10 times when I start a MySQL M application, I get an error like this: M DBD::mysql::st execute failed: Lost connection to MySQL server M during query at /usr/libdata/perl/5.00503/News/MySQL/User.pm M line 209. M The log is very non-telling; it mostly bales at something entirely trivial; Check that max_allowed_packet is big enough: http://www.mysql.com/doc/en/Gone_away.html Max_allowed_packet is not in issue here (set at 1M). This query only returns 30 newsgroups or so. Besides, the connection to MySQL does not always get lost here; sometimes a bit later, sometimes a bit earlier, and sometimes not at all. Do you get the same result if you execute this query from command-line? The problem only occurs after my news server called an external check-table program, which does an extended check on all tables within its scope. This only happens when the news server was not shutdown properly. Before you ask, no, there are no errors in the tables (nor have there, as far as I know, ever been). And besides, like I said, my program does not always lose the connection; just 6 out of 10 times after it ran the rather intense extended table check program. The two seem related; but I cannot figure out how. It seems as if the huge activity on the tables prior to my news server doing its regular startup (after it just called the table-check program), has an effect on the stability of the new connection I am trying to make. Although, for the life of me, I cannot figure out how (the table-check program logs into MySQL as a special maintenance user). When the connection gets losts, I restart the news server a few times; and once the connection holds, it remains running smoothly. As it should, since the tables contain no errors. I even set a ridiculously high connection timeout value in /etc/my.cnf: set-variable = connect_timeout=15 But that makes no difference. - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 last 3-4 weeks .. FT This problem occured right after I restarted mysqld on my machine. I can FT access mysql on localhost without any failure, either in command mode, FT telnet or via httpd with PHP, but connection via PHP on remote machine FT fails. FT Here's what I see if I try to telnet, seams like the service is simply FT dropping the connection. FT [root@intranet CAMusage]# telnet 10.0.6.2 3306 FT Trying 10.0.6.2... FT Connected to 10.0.6.2. FT Escape character is '^]'. FT Connection closed by foreign host. FT Here's what I see in mysqld.log : FT Number of processes running now: 1 FT mysqld process hanging, pid 30546 - killed FT 021029 16:46:23 mysqld restarted FT /usr/libexec/mysqld: ready for connections FT ... and in queries.log : FT /usr/libexec/mysqld, Version: 3.23.41-log, started with: FT Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock FT Time Id CommandArgument FT Any help would be very appreciate. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Lost connection to MySQL server during query
Hello Graham, Tuesday, October 15, 2002, 12:03:34 PM, you wrote: 1. replace Red Hat's rpms with MySQL binary release, download it from http://www.mysql.com/ 2. run myisamchk on all files. 3. run MySQL and enjoy the reliability since then :-) GM Why do Linux distributions ship broken MySQL packages? The newly GM released SuSE 8.1 shows similar problems, connecting from the local GM system works fine but the server crashes (and is restarted by GM safe_mysqld) as soon as a remote user attempts to connect. As has GM already been noted, after installing the official MySQL RPMs GM everything works. This is a common problem with non-MySQL builds. Why? First, because compiling MySQL is a very careful job to do, you don't have to miss a single point in instructions. Say, compiling with wrong options will give you a binary that will not be able to resolve hostnames, load data more than 2gb, work with more than a couple of hundreds of connections and so on. Second, because the only stable GNU C compiler today is gcc 2.95. It's true that MySQL cannot be compiled correctly with gcc 2.96 and 3.xx. Third, because making a correct glibc binary is very, very hard goal to accomplish. Not to speak about other binaries, but, say, MySQL works with threads, and the thread stack in glibc should be around 256k for MySQL can handle hundreds of connections. In other case, MySQL will just crash after Nth connection. By default, the stack is 2mb in glibc. This is causing crashes, too. There are a lot of many other reasons. That's (in short) why MySQL official binaries are compiled statically and works well. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Egor Egorov [EMAIL PROTECTED] writes: 1. replace Red Hat's rpms with MySQL binary release, download it from http://www.mysql.com/ 2. run myisamchk on all files. 3. run MySQL and enjoy the reliability since then :-) Why do Linux distributions ship broken MySQL packages? The newly released SuSE 8.1 shows similar problems, connecting from the local system works fine but the server crashes (and is restarted by safe_mysqld) as soon as a remote user attempts to connect. As has already been noted, after installing the official MySQL RPMs everything works. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Lost connection to MySQL server during query
Hello Me-Selfe, Saturday, October 12, 2002, 2:25:23 AM, you wrote: MS After a reboot, the database server running Redhat 7.2 and mySQL MS 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the MS server, nothing happens and when i check in the log file for mysql, i MS get something like: MS Number of processes running now: 1 MS mysqld process hanging, pid 11437 - killed MS 021012 01:24:09 mysqld restarted MS /usr/libexec/mysqld: ready for connections MS (It looks like mysql crash when i connect) MS At the start, i had no clue what was going on, i checked all the tables MS with myisamchk. No errors found. What I would suggest you is: 1. replace Red Hat's rpms with MySQL binary release, download it from http://www.mysql.com/ 2. run myisamchk on all files. 3. run MySQL and enjoy the reliability since then :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Gerald R. Jensen wrote: Network problems ... something is breaking TCP/IP. Gerald, I can view the webpages on the server, though. Doesn't it use the same TCP/IP? - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Connection type, network configuration, operating system, ODBC configuration, etc. can be factors. You haven't shared any of that information, so it is hard to speculate. - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 2:54 PM Subject: Re: Lost connection to MySQL server during query Gerald R. Jensen wrote: Network problems ... something is breaking TCP/IP. Gerald, I can view the webpages on the server, though. Doesn't it use the same TCP/IP? - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Gerald R. Jensen wrote: Connection type, network configuration, operating system, ODBC configuration, etc. can be factors. You haven't shared any of that information, so it is hard to speculate. Sorry, I'm on a University wide LAN, running mysql 3.23.49 on RH7.3 . I don't think I'm using ODBC, but I'm a bit vague on this. - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 2:54 PM Subject: Re: Lost connection to MySQL server during query Gerald R. Jensen wrote: Network problems ... something is breaking TCP/IP. Gerald, I can view the webpages on the server, though. Doesn't it use the same TCP/IP? - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can not login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Network problems ... something is breaking TCP/IP. - Original Message - From: Yanglong Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 4:57 AM Subject: Lost connection to MySQL server during query Hi there, This is an error message from MySQL when I try to connect to my remote MySQL server. Does anyone know what this message mean. I'm completely puzzled. I used to make the same connection with the exactly the same command routinely get connected easily. But all in a sudden, I cannot make the connection at all. I looked on the localhost. I can login on the localhost just fine. I simply can login from another machine. I did not upgrade the MySQL in the mean time. What could be the reason?? Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lost connection to MySQL server during query
Sorry all! I have resolved the issue. -- Forwarded Message --- From: Vernon Webb [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sun, 13 Oct 2002 17:18:16 -0500 Subject: Lost connection to MySQL server during query After spending the entire day trying to figure out what the you-know-what has happended to MySQL on my box, and after throughly messing things up and fixing them again it has come down to a final error message when trying to access some databases (some mind you, not all): Lost connection to MySQL server during query Anyone have any idea what this is all about? Thanks -- This message has been scanned for viruses and dangerous content by Webb Solutions' MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lost connection to MySQL server during query
At 17:29 -0500 10/13/02, Vernon Webb wrote: Sorry all! I have resolved the issue. Don't leave us hanging. How? -- Forwarded Message --- From: Vernon Webb [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sun, 13 Oct 2002 17:18:16 -0500 Subject: Lost connection to MySQL server during query After spending the entire day trying to figure out what the you-know-what has happended to MySQL on my box, and after throughly messing things up and fixing them again it has come down to a final error message when trying to access some databases (some mind you, not all): Lost connection to MySQL server during query Anyone have any idea what this is all about? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lost connection to MySQL server during query
Somehow MySQL got broke and by removing MySQL and reinstalling it, removing the /var/lib/mysql folder and restaring MySQL put me back at the where it was once I first configured MySQL. Then I copied the database folders back to the folder, but I had changed the password and forgot to change it in my web pages on the server that actually accessed those databses. -- This message has been scanned for viruses and dangerous content by Webb Solutions' MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Lost connection to MySQL server during query
Hi, How did you solve the problem, Lost connection to MySQL server during query, please let me know this i am facing the same problem. thanks, swati --- Vernon Webb [EMAIL PROTECTED] wrote: Sorry all! I have resolved the issue. -- Forwarded Message --- From: Vernon Webb [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sun, 13 Oct 2002 17:18:16 -0500 Subject: Lost connection to MySQL server during query After spending the entire day trying to figure out what the you-know-what has happended to MySQL on my box, and after throughly messing things up and fixing them again it has come down to a final error message when trying to access some databases (some mind you, not all): Lost connection to MySQL server during query Anyone have any idea what this is all about? Thanks -- This message has been scanned for viruses and dangerous content by Webb Solutions' MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Lost Connection to MySQL Server During Query
Graphfixz, Tuesday, October 01, 2002, 5:14:13 PM, you wrote: G I am getting the following error: G [TCX][MyODBC] Lost Connection to MySQL Server During Query G My code is simply dumping an IP Address to the database... at the most 10 G lines of code. Any ideas what is causing this error? I have searched on line G and have not found much help. You can get this error if the dump is bigger than max_allowed_packet: http://www.mysql.com/doc/en/Gone_away.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Ah! Thanks, this gave me the clue. I had to up the limit of openfiles
(csh/OpenBSD) limit openfiles 1024 (from 64) and it works like a
charm now. Thanks!
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 4:31 PM
Subject: Re: Lost connection to MySQL server during query
Hi,
My opinion:
This can be a very good reason to kill the socket(is a file too) which is
open during query.
This error show you that you have too many open files in the system.I
tested
something like this(Linux - Red Hat 7.2) some time ago and after 2000
(this
mean sockets) clients connected this error occured.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Steve Mertz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 11:49 PM
Subject: Re: Lost connection to MySQL server during query
No, nothing other than the startup and shutdown messages.
And every once and a while:
020708 21:00:46 Error in accept: Bad file descriptor
But this doesn't happen all the time after restarting the database and I
still
have problems so I don't think that this is related.
Thanks!
-- Steve
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 3:43 PM
Subject: Re: Lost connection to MySQL server during query
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
Server timeout is set for 8 hours (default) and I have been trying
to hit the server all within a couple of minutes.
Sometimes it works, sometimes it doesn't. (below is a repeat of the
command 2 minutes after the first one was issued.)
marcos:mysql-3.23.51 {120} !!
mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL
license
Server version 3.23.51-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 57 sec
Threads: 2 Questions: 108 Slow queries: 0 Opens: 34 Flush
tables:
1
Open tables: 28 Queries per second avg: 0.164
marcos:mysql-3.23.51 {121} uname -a
OpenBSD marcos 3.1 marcos#5 i386
What should I start looking for? (below is mysqladmin variables)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
Server timeout is set for 8 hours (default) and I have been trying
to hit the server all within a couple of minutes.
Sometimes it works, sometimes it doesn't. (below is a repeat of the
command 2 minutes after the first one was issued.)
marcos:mysql-3.23.51 {120} !!
mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.51-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 57 sec
Threads: 2 Questions: 108 Slow queries: 0 Opens: 34 Flush tables: 1
Open tables: 28 Queries per second avg: 0.164
marcos:mysql-3.23.51 {121} uname -a
OpenBSD marcos 3.1 marcos#5 i386
What should I start looking for? (below is mysqladmin variables)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
No, nothing other than the startup and shutdown messages.
And every once and a while:
020708 21:00:46 Error in accept: Bad file descriptor
But this doesn't happen all the time after restarting the database and I
still
have problems so I don't think that this is related.
Thanks!
-- Steve
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 3:43 PM
Subject: Re: Lost connection to MySQL server during query
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
Server timeout is set for 8 hours (default) and I have been trying
to hit the server all within a couple of minutes.
Sometimes it works, sometimes it doesn't. (below is a repeat of the
command 2 minutes after the first one was issued.)
marcos:mysql-3.23.51 {120} !!
mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.51-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 57 sec
Threads: 2 Questions: 108 Slow queries: 0 Opens: 34 Flush tables: 1
Open tables: 28 Queries per second avg: 0.164
marcos:mysql-3.23.51 {121} uname -a
OpenBSD marcos 3.1 marcos#5 i386
What should I start looking for? (below is mysqladmin variables)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost connection to MySQL server during query
Hi,
My opinion:
This can be a very good reason to kill the socket(is a file too) which is
open during query.
This error show you that you have too many open files in the system.I tested
something like this(Linux - Red Hat 7.2) some time ago and after 2000 (this
mean sockets) clients connected this error occured.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Steve Mertz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 11:49 PM
Subject: Re: Lost connection to MySQL server during query
No, nothing other than the startup and shutdown messages.
And every once and a while:
020708 21:00:46 Error in accept: Bad file descriptor
But this doesn't happen all the time after restarting the database and I
still
have problems so I don't think that this is related.
Thanks!
-- Steve
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 3:43 PM
Subject: Re: Lost connection to MySQL server during query
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server during query'
Server timeout is set for 8 hours (default) and I have been trying
to hit the server all within a couple of minutes.
Sometimes it works, sometimes it doesn't. (below is a repeat of the
command 2 minutes after the first one was issued.)
marcos:mysql-3.23.51 {120} !!
mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
and you are welcome to modify and redistribute it under the GPL
license
Server version 3.23.51-log
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 min 57 sec
Threads: 2 Questions: 108 Slow queries: 0 Opens: 34 Flush tables:
1
Open tables: 28 Queries per second avg: 0.164
marcos:mysql-3.23.51 {121} uname -a
OpenBSD marcos 3.1 marcos#5 i386
What should I start looking for? (below is mysqladmin variables)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost Connection to mysql server during query
Hi, Thanx for your mail You are rightin my case the mysqld is getting restarted. But, whey is mysqld getting restarted and giving the Lost Connection error. How can i avoid that?? Thanx anil - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: Anil Garg [EMAIL PROTECTED] Sent: Saturday, June 29, 2002 9:04 AM Subject: Re: Lost Connection to mysql server during query Pada Thu, 27 Jun 2002 10:59:48 -0400 Anil Garg [EMAIL PROTECTED] menulis : Now when i try to insert by using the following query: INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,20011223105127); It gives the error: Error 2013 at line 235: Lost connection to MySQL server during query If i decrease the lenght of time stamp in the INSERT query INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122); it works fine. Can anyone help me by telling wots going wrong here!! Have you retry the first query again ? Usually, Lost Connection happens because your query process has been killed by someone else (or even the system - maybe something related to query timeout values) or the mysqld was restarted. -- People disagree with me. I just ignore them. -- Linus Torvalds, regarding the use of C++ for the Linux kernel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Lost Connection to mysql server during query
I just tried to do this on my MySQL server (version 3.23.51-max-log). It works fine. Mikhail. - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 4:59 PM Subject: Lost Connection to mysql server during query Hi, Here is a strange problem!! I created a table by the following qurey: CREATE TABLE 1_polls ( id int(11) unsigned NOT NULL auto_increment, question varchar(128) NOT NULL default '', active tinyint(1) unsigned NOT NULL default '1', sortorder int(11) NOT NULL default '0', module_id int(11) NOT NULL default '0', last_access timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; Now when i try to insert by using the following query: INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,20011223105127); It gives the error: Error 2013 at line 235: Lost connection to MySQL server during query If i decrease the lenght of time stamp in the INSERT query INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122); it works fine. Can anyone help me by telling wots going wrong here!! thanx anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
