Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: > It happened agaIn this morning, but slightly different: > > [snip] > thd=0x7fe0140c7e00 > Attempting backtrace. You can use the following information to find > out where mysqld died. If you see no messages after this, something > went terribly wrong... > Cannot determine thread, fp=0xb, backtrace may not be correct. > Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, > thread_stack=262144, aborting backtrace. > Trying to get some variables. > Some pointers may be invalid and cause the dump to abort... > thd->query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT > * FROM quarantine WHERE state=1 AND domain='example.com' > thd->thread_id=1493537 > > The context is the same as previously, except the query: > > INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE > state=1 AND domain='example.com' This is not exactly reproducable, but it is fairly predictable - happens every morning towards 0600 - I have an archive job starting at 0500. For the last three days, the query has been roughly the same, except the 'example.com' varies. > Is there nothing I can do to attempt to diagnose crashes such as this? Still no suggestions? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: > I have just discovered that my mysql server was restarted this > morning, which is what gave me the 2013. In the log I found this: [snip] It happened agaIn this morning, but slightly different: [snip] thd=0x7fe0140c7e00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x4514, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x1355140 = INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' thd->thread_id=1493537 The context is the same as previously, except the query: INSERT IGNORE INTO quarantine_archive SELECT * FROM quarantine WHERE state=1 AND domain='example.com' It's getting to be a bit annoying - not all our apps were written to be able to handle the database connection disappearing at any time. Yes, they should have been, but it is a pretty unusual situation after all. Is there nothing I can do to attempt to diagnose crashes such as this? /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Darryle Steplight wrote: > Hi Per, > > Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf > file. Are these queries appearing in your slow query logs?What is your > LOG_QUERY_TIMES set too? > > Here are some other settings you may want to play around wtih > CONNECT_TIMEOUT > INTERACTIVE_TIMEOUT > WAIT_TIMEOUT > NET_WRITE_TIMEOUT > NET_READ_TIMEOUT > MAX_CONNECT_ERRORS > Hi Darryle I did notice references to some of those when I was googling, but because I didn't change any settings in my migration except up the key_buffer space, I didn't really pay much attention. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Hi Per, Maybe you need to beef up your CONNECT_TIMEOUT setting in your .my.cnf file. Are these queries appearing in your slow query logs?What is your LOG_QUERY_TIMES set too? Here are some other settings you may want to play around wtih CONNECT_TIMEOUT INTERACTIVE_TIMEOUT WAIT_TIMEOUT NET_WRITE_TIMEOUT NET_READ_TIMEOUT MAX_CONNECT_ERRORS On Mon, May 25, 2009 at 3:06 AM, Per Jessen wrote: > This weekend we completed migrating a large(ish) mysql server from > 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively > smoothly, until this morning when I noticed an application had choked > on getting "Error 2013 Lost connection to MySQL server during query". > The application is running remotely on 32bit using mysql library from > version 5.0.67. > > I've been googling quite a bit, but haven't really found anything of any > use. I've checked the two configurations, and they are the same. Can > anyone help point me in the right direction? Thanks. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
The issues that we saw only came to light under stress. The application I am referring to ran under a fair bit of load at the best of times but it was during sustained spikes that the flaws in our driver made themselves apparent. Mind you, we weren't using JFS, so I'm not sure how that would have reacted. - michael On Mon, May 25, 2009 at 12:19 PM, Per Jessen wrote: > Michael Dykman wrote: > >> Given the new hardware, I'm now suspecting the RAID controller. I have >> seen misconfigured RAIDs or bad RAID drivers take out a server in just >> such a manner. I had a debian server connected to an EMC SAN.. As >> debian isn't supported, we had this open-source driver which gave us >> no end of problems. >> >> If a logical drive acts up or does something unexpected, MySQL could >> react to that in a manner consistent with what you are seeing in your >> log. > > Shouldn't/wouldn't the filesystem complain first? There is a lot of > activity on the filesystem, mysql is just a tiny part of it. > >> I would be tempted to put the hardware through a stress test. I know >> that's not much help. > > I really have no reason to suspect the hardware. It's new, but it's > been running in "burn-in" mode for about a month (although not with > much load, mostly idling). I might as well suspect the mysql build and > try upgrading to a newer one. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: > Given the new hardware, I'm now suspecting the RAID controller. I have > seen misconfigured RAIDs or bad RAID drivers take out a server in just > such a manner. I had a debian server connected to an EMC SAN.. As > debian isn't supported, we had this open-source driver which gave us > no end of problems. > > If a logical drive acts up or does something unexpected, MySQL could > react to that in a manner consistent with what you are seeing in your > log. Shouldn't/wouldn't the filesystem complain first? There is a lot of activity on the filesystem, mysql is just a tiny part of it. > I would be tempted to put the hardware through a stress test. I know > that's not much help. I really have no reason to suspect the hardware. It's new, but it's been running in "burn-in" mode for about a month (although not with much load, mostly idling). I might as well suspect the mysql build and try upgrading to a newer one. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Given the new hardware, I'm now suspecting the RAID controller. I have seen misconfigured RAIDs or bad RAID drivers take out a server in just such a manner. I had a debian server connected to an EMC SAN.. As debian isn't supported, we had this open-source driver which gave us no end of problems. If a logical drive acts up or does something unexpected, MySQL could react to that in a manner consistent with what you are seeing in your log. I would be tempted to put the hardware through a stress test. I know that's not much help. - michael On Mon, May 25, 2009 at 12:02 PM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Dykman wrote: >> >>> Have you tried running the offending SQL manually against you new >>> installation? Does it come back clean in the isolated case? >> >> No, not manually, but the job/the SQL is run several times a day, >> maybe 2-3 times per hour. > > I've also just run the query manually a couple of times, no problems. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: > Michael Dykman wrote: > >> Have you tried running the offending SQL manually against you new >> installation? Does it come back clean in the isolated case? > > No, not manually, but the job/the SQL is run several times a day, > maybe 2-3 times per hour. I've also just run the query manually a couple of times, no problems. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: > Have you tried running the offending SQL manually against you new > installation? Does it come back clean in the isolated case? No, not manually, but the job/the SQL is run several times a day, maybe 2-3 times per hour. > Is there anything else which runs against this database at night? > crons? Yes, lots of stuff. Cron-jobs, jobs submitted by daemons, etc. > Could you post the script that you are running to give some context to > the statement which winds up in your error log? I'm generating a zonefile for rbldnsd with entries from my table since midnight. Entries from before midnight are put in a main-table, entries after are in this regular "diff". The statement is this: SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)>='' Tonight it will be changed to: (single domain, not domain,domain) SELECT domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)>='' Additional context: The server is brandnew, an HP Proliant with dual quad-core Xeons and 10Gb RAM. The filesystem is JFS on hardware RAID6. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
On Mon, May 25, 2009 at 11:19 AM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Steinfeld wrote: >> >>> just a thought: Did you run "mysql_upgrade" after the import? >>> >> >> No, I didn't - I didn't think of it as I really only moved the data >> across. >> > I suspect that will solve your issue. Keep me posted. > Okay, have done a mysqlcheck --check-upgrade - came back all clean. I > don't see a need to run mysql_fix_privilege as I manually copied the > necessary privilege data. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Have you tried running the offending SQL manually against you new installation? Does it come back clean in the isolated case? Is there anything else which runs against this database at night? crons? Could you post the script that you are running to give some context to the statement which winds up in your error log? Considering that you did use mysqldump to manually inject your data, cross-version incompatibilities are pretty much out of the question. - michael On Mon, May 25, 2009 at 11:19 AM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Steinfeld wrote: >> >>> just a thought: Did you run "mysql_upgrade" after the import? >>> >> >> No, I didn't - I didn't think of it as I really only moved the data >> across. >> > > Okay, have done a mysqlcheck --check-upgrade - came back all clean. I > don't see a need to run mysql_fix_privilege as I manually copied the > necessary privilege data. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: > Michael Steinfeld wrote: > >> just a thought: Did you run "mysql_upgrade" after the import? >> > > No, I didn't - I didn't think of it as I really only moved the data > across. > Okay, have done a mysqlcheck --check-upgrade - came back all clean. I don't see a need to run mysql_fix_privilege as I manually copied the necessary privilege data. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Steinfeld wrote: > just a thought: Did you run "mysql_upgrade" after the import? > No, I didn't - I didn't think of it as I really only moved the data across. best regards Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
just a thought: Did you run "mysql_upgrade" after the import? On Mon, May 25, 2009 at 10:19 AM, Per Jessen wrote: > Michael Dykman wrote: > >> It might be helpful if you could tell us how you affected your data >> migration > > Sorry, I'm not familiar with reporting problems in/on mysql. > > The data migration was done with a full database dump (mysqldump) from the > 32bit system, then a reload on the new 64bit system. I think it took 6-8 > hours. > >> and what kind of job was running at the time it went down. > > The job executing the SQL mentioned in the log ran on another server. It is > a SELECT running from the command line (in a Makefile). I'm not sure what > else to tell you. > >> Having the server go away mid-query generally does mean you have run >> into a bug of some sort but, more often than not, you were doing >> something ill-advised at the time. > > The setup has been running for at least two years with no such problems. > > Let me know what other info would be interesting. > > > best regards > Per Jessen > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mikeisgr...@gmail.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Michael Dykman wrote: It might be helpful if you could tell us how you affected your data migration Sorry, I'm not familiar with reporting problems in/on mysql. The data migration was done with a full database dump (mysqldump) from the 32bit system, then a reload on the new 64bit system. I think it took 6-8 hours. > and what kind of job was running at the time it went down. The job executing the SQL mentioned in the log ran on another server. It is a SELECT running from the command line (in a Makefile). I'm not sure what else to tell you. Having the server go away mid-query generally does mean you have run into a bug of some sort but, more often than not, you were doing something ill-advised at the time. The setup has been running for at least two years with no such problems. Let me know what other info would be interesting. best regards Per Jessen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql error 2013 Lost connection to MySQL server during query
Per Jessen wrote: > This weekend we completed migrating a large(ish) mysql server from > 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively > smoothly, until this morning when I noticed an application had choked > on getting "Error 2013 Lost connection to MySQL server during query". I have just discovered that my mysql server was restarted this morning, which is what gave me the 2013. In the log I found this: 090525 6:04:35 - mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=6442450944 read_buffer_size=258048 max_used_connections=43 max_connections=100 threads_connected=26 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 6367855 Kbytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x7fa6fc0173e0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb, backtrace may not be correct. Bogus stack limit or frame pointer, fp=0xb, stack_bottom=0x41a6, thread_stack=262144, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x1340aa0 = SELECT domain,domain FROM dodgy_domain,spamdns_ipaddr WHERE dodgy_domain.ipaddr=spamdns_ipaddr.ipaddr group by domain having min(first)>='2009-05-25 00:00:00' thd->thread_id=434983 /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql error 2013 Lost connection to MySQL server during query
This weekend we completed migrating a large(ish) mysql server from 5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively smoothly, until this morning when I noticed an application had choked on getting "Error 2013 Lost connection to MySQL server during query". The application is running remotely on 32bit using mysql library from version 5.0.67. I've been googling quite a bit, but haven't really found anything of any use. I've checked the two configurations, and they are the same. Can anyone help point me in the right direction? Thanks. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A question about how to debug the error "2013, 'Lost connection to MySQL server during query'"
[EMAIL PROTECTED] schrieb: > I am running the 64 bit version of mysql server 5.1.18, and on the > client side I am running python with the mysqldb module. While > running a very large insert query I get the following error : > > 2013, 'Lost connection to MySQL server during query' > > I have --log-warnings set to 3, but I get no corresponding errors in > the error log. > > The question is : how do I go about debugging this problem? the most common error in this case is a crash of the thread processing your query -- Sebastian Mendel www.sebastianmendel.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A question about how to debug the error "2013, 'Lost connection to MySQL server during query'"
I am running the 64 bit version of mysql server 5.1.18, and on the client side I am running python with the mysqldb module. While running a very large insert query I get the following error : 2013, 'Lost connection to MySQL server during query' I have --log-warnings set to 3, but I get no corresponding errors in the error log. The question is : how do I go about debugging this problem? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013: Lost connection to MySQL server during query
Hello, Thanks to all who applied but I was able to get access to the log file today. The server was shutting down and it seemed to be a performance problem. I increased the RAM in the server and adjusted the Innodb settings to take advantage of this. Now everything is much better. Michael Daniel Kasak wrote: Michael Gale wrote: Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect to a database and try the following: CREATE INDEX hostdate ON syslog (machine,date1); There are about 3 million rows .. about a minute or two into the command I would get disconnected. Sometimes I could log back but not others, I tried seaching google and the only answer I found was "This is fix the in the next release of 5.X.X". This does not help as I am stuck with 4.0.X right now. How can I fix this ? Michael Is the server crashing? What does your error log say? If you're using 4.0.x, then my first hunch would be table corruption. Have you checked for that yet? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013: Lost connection to MySQL server during query
Michael Gale wrote: > Hello, > > Earlier today I tried to make some table alterations on a mysql server > (4.0.24) and kept on receiving this error: > > ERROR 2013: Lost connection to MySQL server during query > > I would login to the server, either through the socket or using the > IP. Then connect to a database and try the following: > > CREATE INDEX hostdate ON syslog (machine,date1); > > There are about 3 million rows .. about a minute or two into the > command I would get disconnected. Sometimes I could log back but not > others, I tried seaching google and the only answer I found was "This > is fix the in the next release of 5.X.X". > > This does not help as I am stuck with 4.0.X right now. > > How can I fix this ? > > Michael > Is the server crashing? What does your error log say? If you're using 4.0.x, then my first hunch would be table corruption. Have you checked for that yet? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013: Lost connection to MySQL server during query
Hello, Earlier today I tried to make some table alterations on a mysql server (4.0.24) and kept on receiving this error: ERROR 2013: Lost connection to MySQL server during query I would login to the server, either through the socket or using the IP. Then connect to a database and try the following: CREATE INDEX hostdate ON syslog (machine,date1); There are about 3 million rows .. about a minute or two into the command I would get disconnected. Sometimes I could log back but not others, I tried seaching google and the only answer I found was "This is fix the in the next release of 5.X.X". This does not help as I am stuck with 4.0.X right now. How can I fix this ? Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013: Lost connection to MySQL server during query
I've tried looking up this error code on www.mysql.org & via Google. I'm not sure it matters but if you look closely at the SQL below, you can see it is working on file "page_path.tab4". It has already successfully loaded files page_path.tab1 thru page_path.tab3 I seriously could use a CLUE on what needs to be changed to avoid this error. TIA! Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 183 to server version: 3.23.58-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> LOAD DATA CONCURRENT LOCAL INFILE '../data/mysql/initial_20050318_102517/page_path.tab4' -> REPLACE INTO TABLE page_path -> FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' -> (PAGE_PATH_ID,NAME,DATE_CREATED); ERROR 2013: Lost connection to MySQL server during query mysql> [EMAIL PROTECTED]:/b/martgen/mysql/bin>grep -i large show-variables.log large_files_support ON [EMAIL PROTECTED]:/b/martgen/mysql/bin>uname -a Linux sdb2.hitbox.com 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003 i686 i686 i386 GNU/Linux [EMAIL PROTECTED]:/b/martgen/mysql/bin> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013: Lost connection to MySQL server during query
> I am running Debian sarge with MySQL 4.0.20. My problem is I can > connect from localhost, but when I try to connect from other host this > error comes up: > ERROR 2013: Lost connection to MySQL server during query Sorry I found the answer. I have ALL:ALL in hosts.deny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013: Lost connection to MySQL server during query
Hi, I am running Debian sarge with MySQL 4.0.20. My problem is I can connect from localhost, but when I try to connect from other host this error comes up: ERROR 2013: Lost connection to MySQL server during query I tried from many clients, included MySQL 4.0 and MySQL 3.23, but they all got same error. I also noticed that usually when I connct to server that I have no access, the error looks like: ERROR 1130: Host '219.106.XX.XX' is not allowed to connect to this MySQL server But when I tried to connect to this server, the error was: ERROR 2013: Lost connection to MySQL server during query I have tried google, without any result. Please help. Thanks in advance, Batara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error 2013 : Lost connection to MySQL server during query
Ok, it seems I fixed my problem before anybody was available to help me. The error was due to bad code -- the program was trying to send multiple queries through the same connection. Even though it was compiled as "thread safe", you still have to find some way to prevent concurrent queries on the same connection. Anybody writing server-side applications using the C api, please beware of this issue. I can suggest a few workarounds if anybody else out there is having the same problem with their C program. Daniel Daniel Whitener wrote: Hello all, I'm getting the error message "2013 : Lost connection to MySQL server during query" during inserts on a lightly-loaded mysql server. I also noticed the following error in the error log... Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock' port: 3306 040603 16:25:48 Aborted connection 1 to db: 'milterdb' user: 'milteruser' host: `localhost' (Got an error reading communication packets) I am going nuts trying to fix this error! I've done some googling and the only fixes I've heard of are fixing name resolution errors. I'm thinking that has nothing to do with this setup since 1000s of other inserts/queries are fine. One second it is working, the next second it stops with this error. The application interfaces with a Sendmail mail server and archives all incoming/outgoing email traffic to the MySQL database. The source is available if anybody thinks my poor coding is the problem. Any help or ideas will be greatly appreciated. Thanks in advance! Daniel Whitener basic config info is below. I can provide more details if needed... I'm using suse 9.1 uranus:~ # uname -a Linux uranus 2.6.4-52-default #1 Wed Apr 7 02:08:30 UTC 2004 i686 i686 i386 GNU/Linux uranus:~ # mysql> status; -- mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) Connection id: 15 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: less Using outfile: '' Server version: 4.0.20-standard-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 55 min 51 sec Threads: 2 Questions: 313 Slow queries: 1 Opens: 11 Flush tables: 1 Open tables: 5 Queries per second avg: 0.093 mysqld section of the my.cnf file... # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock wait_timeout = 7200 interactive_timeout = 28800 skip-locking key_buffer = 64M max_allowed_packet = 10M table_cache = 128 sort_buffer_size = 1M read_buffer_size = 1M net_buffer_length = 8K myisam_sort_buffer_size = 16M user = mysql thread_stack = 1M thread_cache = 8 query_cache_size = 16M thread_concurrency = 4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 2013 : Lost connection to MySQL server during query
Hello all, I'm getting the error message "2013 : Lost connection to MySQL server during query" during inserts on a lightly-loaded mysql server. I also noticed the following error in the error log... Version: '4.0.20-standard-log' socket: '/tmp/mysql.sock' port: 3306 040603 16:25:48 Aborted connection 1 to db: 'milterdb' user: 'milteruser' host: `localhost' (Got an error reading communication packets) I am going nuts trying to fix this error! I've done some googling and the only fixes I've heard of are fixing name resolution errors. I'm thinking that has nothing to do with this setup since 1000s of other inserts/queries are fine. One second it is working, the next second it stops with this error. The application interfaces with a Sendmail mail server and archives all incoming/outgoing email traffic to the MySQL database. The source is available if anybody thinks my poor coding is the problem. Any help or ideas will be greatly appreciated. Thanks in advance! Daniel Whitener basic config info is below. I can provide more details if needed... I'm using suse 9.1 uranus:~ # uname -a Linux uranus 2.6.4-52-default #1 Wed Apr 7 02:08:30 UTC 2004 i686 i686 i386 GNU/Linux uranus:~ # mysql> status; -- mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) Connection id: 15 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: less Using outfile: '' Server version: 4.0.20-standard-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 55 min 51 sec Threads: 2 Questions: 313 Slow queries: 1 Opens: 11 Flush tables: 1 Open tables: 5 Queries per second avg: 0.093 mysqld section of the my.cnf file... # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock wait_timeout = 7200 interactive_timeout = 28800 skip-locking key_buffer = 64M max_allowed_packet = 10M table_cache = 128 sort_buffer_size = 1M read_buffer_size = 1M net_buffer_length = 8K myisam_sort_buffer_size = 16M user = mysql thread_stack = 1M thread_cache = 8 query_cache_size = 16M thread_concurrency = 4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE
At 03:57 PM 6/20/2003 -0300, Dyego Souza do Carmo wrote: Hi, I wasn't able for to repeat with the last bk tree 4.0 on Linux and Windows. The query was performed from a Linux machine and also from a Windows machine. c:\mysql\bin>mysql -uroot test --local-infile=1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.0.14-max-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data local infile "c:\\temp\\bah.1d" into table cfgimpressao; Query OK, 3 rows affected (0.33 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 4.0.14-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> load data local infile "/share/bah.1D" into table cfgimpressao; Query OK, 3 rows affected (0.56 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 Something else I did wrong for to repeat your case ? The bug is: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 257 to server version: 4.0.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use sqlreg3; Database changed mysql> LOAD DATA LOCAL INFILE 'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT O TABLE cfgimpressao; ERROR 2013: Lost connection to MySQL server during query mysql> The Files of table are in FTP the names is: cfgimpressao.dat.zip - The zipped Data of File ( saved with the OUTFILE command, please unzip before run ! ) cfgimpressao.str - The Structure cfgimpressao.ref - The references cfgimpressao.idx - The Indexes The files are in support.mysql.com in the secret dir. My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21 with 768MB of ram -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE
The bug is: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 257 to server version: 4.0.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use sqlreg3; Database changed mysql> LOAD DATA LOCAL INFILE 'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT O TABLE cfgimpressao; ERROR 2013: Lost connection to MySQL server during query mysql> The Files of table are in FTP the names is: cfgimpressao.dat.zip - The zipped Data of File ( saved with the OUTFILE command, please unzip before run ! ) cfgimpressao.str - The Structure cfgimpressao.ref - The references cfgimpressao.idx - The Indexes The files are in support.mysql.com in the secret dir. My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21 with 768MB of ram - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into "my eyes" Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 2013 - Lost connection to MySQL server during query
Now, it's working fine ! Thanks a lot Nivaldo - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 04, 2003 12:12 AM Subject: Re: Error 2013 - Lost connection to MySQL server during query > > Suporte schrieb: > > Hi > > > > I installed MySQL on a server running RedHat 8.0 and it's working fine. But > > when I try to connect to MySQL from a remote station, using MySQL Control > > Center, or even using the command-line "mysql", I get the message: > > > > "Error 2013 - Lost connection to MySQL server during query" > > > > The remote station is running Windows XP Professional SP1 > > The server is running RedHat 8.0 + MySQL 3.23.54 > > > > i am not in the list > > you can try this one > and please post it *in* the list if it could solve your problem > > > > https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467 > > "lost connection ..." > [mysqld] > set-variable=thread_stack=256k > > > - > 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: Error 2013 - Lost connection to MySQL server during query
Suporte schrieb: Hi I installed MySQL on a server running RedHat 8.0 and it's working fine. But when I try to connect to MySQL from a remote station, using MySQL Control Center, or even using the command-line "mysql", I get the message: "Error 2013 - Lost connection to MySQL server during query" The remote station is running Windows XP Professional SP1 The server is running RedHat 8.0 + MySQL 3.23.54 i am not in the list you can try this one and please post it *in* the list if it could solve your problem https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467 "lost connection ..." [mysqld] set-variable=thread_stack=256k - 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
Error 2013 - Lost connection to MySQL server during query
Hi I installed MySQL on a server running RedHat 8.0 and it's working fine. But when I try to connect to MySQL from a remote station, using MySQL Control Center, or even using the command-line "mysql", I get the message: "Error 2013 - Lost connection to MySQL server during query" The remote station is running Windows XP Professional SP1 The server is running RedHat 8.0 + MySQL 3.23.54 Thanks Nivaldo - 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
"Error 2013: Lost connection to mysql server during query"
Like several other people I noticed on the web, I am receiving an error message "Error 2013: Lost connection to mysql server during query", however I can not find the results of you corrections? Can you please point me to the place where I can find a fix for this error? Thanks Bob - 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
ERROR 2013: Lost connection to MySQL server during query
Hi, I have MySQL version 3.23.41 and when I connect from localhost, it's OK. Hovewer, when I connect via IP (f.e. mysql -h IP, or from other computer in Internet), then MySQL resut error ERROR 2013: Lost connection to MySQL server during query. This is a part of variable from MySQL on the my server: | connect_timeout | 5 | max_allowed_packet | 1047552 | max_binlog_cache_size | 4294967295 | max_binlog_size | 1073741824 | max_connections | 100 | max_connect_errors | 10 | max_delayed_threads | 20 | max_heap_table_size | 16777216 | max_join_size | 4294967295 | max_sort_length | 1024 | max_user_connections| 0 | net_buffer_length | 16384 | net_read_timeout| 30 | net_retry_count | 10 | net_write_timeout | 60 | open_files_limit| 0 | pid_file| /var/run/mysqld/mysqld.pid | port| 3306 | protocol_version| 10 | record_buffer | 131072 | record_rnd_buffer | 131072 | query_buffer_size | 0 | safe_show_database | OFF | server_id | 0 | slave_net_timeout | 3600 | skip_locking| ON | skip_networking | OFF | skip_show_database | OFF Please, where is error, or what is wrong? Ing. Jan Tobolík, Czech Republic programmer, administrator tel: 777/ 01 01 77 - 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: ERROR 2013: Lost connection to MySQL server during query
Davide, Monday, October 28, 2002, 9:56:46 AM, you wrote: DP> Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. DP> The problem seems to be the version of RedHat. We have now installed the DP> same version of MySql on RedHat 7.3 and it seems to work fine. Can you DP> give me a confirmation of this problem? "Lost connection" on RedHat 7.x/8.0 was caused by RedHat glibc. But 3.23.53a was compiled with statically linked glibc, so this problem shouldn't occur ... DP> On Fri, 2002-10-25 at 15:36, Egor Egorov wrote: >> Davide, >> Friday, October 25, 2002, 11:57:23 AM, you wrote: >> >> DP> I'm new to MySQL. I am trying to set replication in MySQL but i get the >> DP> error in the subject. >> >> DP> Can you help me please? >> >> Can you be more detailed? >> What OS? What versions of MySQL servers? What did you done before you got >> this error? You gave incomplete info .. -- 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: ERROR 2013: Lost connection to MySQL server during query
Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. The problem seems to be the version of RedHat. We have now installed the same version of MySql on RedHat 7.3 and it seems to work fine. Can you give me a confirmation of this problem? Thanks Davide On Fri, 2002-10-25 at 15:36, Egor Egorov wrote: > Davide, > Friday, October 25, 2002, 11:57:23 AM, you wrote: > > DP> I'm new to MySQL. I am trying to set replication in MySQL but i get the > DP> error in the subject. > > DP> Can you help me please? > > Can you be more detailed? > What OS? What versions of MySQL servers? What did you done before you got > this error? You gave incomplete info .. > > > > -- > 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 - 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: ERROR 2013: Lost connection to MySQL server during query
Davide, Friday, October 25, 2002, 11:57:23 AM, you wrote: DP> I'm new to MySQL. I am trying to set replication in MySQL but i get the DP> error in the subject. DP> Can you help me please? Can you be more detailed? What OS? What versions of MySQL servers? What did you done before you got this error? You gave incomplete info .. -- 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
ERROR 2013: Lost connection to MySQL server during query
Hy All, I'm new to MySQL. I am trying to set replication in MySQL but i get the error in the subject. Can you help me please? Thanks to all - 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
Another solution for ERROR 2013: Lost connection to MySQL server during query
Hi all, I found another solution of a problem with buggy glibc. Try to start mysqld with --skip-name-resolve It's work for me fine, but hosts part in security must be only IP addresses, not names. Dishko Georgiev SysAdmin Terasyst Ltd. - 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: ERROR 2013: Lost connection to MySQL server during query
I had similar problem in my case. The solution was that maybe you are accessing the column which has data which is greater then the specified in Max_data_allowed in my.cnf. Change it to something more and I hope that the problem is solved ? Insane SQLyog - The Definative GUI For MySQL http://www.sqlyog.com/ - Original Message - From: "Animesh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 19, 2002 2:23 AM Subject: ERROR 2013: Lost connection to MySQL server during query > Hi All,, > > I am getting this error and mysqld is dying out while tring to access a > particular table in a particular databae while others don't fail.. > > ERROR 2013: Lost connection to MySQL server during query > > Plz Help as early as possible. > Regards, > Animesh > > [EMAIL PROTECTED] > DeepRoot Linux Pvt. Ltd. > Bangalore, India > > - > 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: ERROR 2013: Lost connection to MySQL server during query
Hi, This is the same error that I am getting, except that in my case the server does not die, I just cant connect from another machine. All I get is this error, which seems to be because the server is not responding to the 3306 port. or something like that. I don't know if this is the same problem or if Animesh has a different problem that generates a similar response. See the "Connecting to MySQL on Linux from a Windows machine." thread for more details on my situation. Thanks, --Will > -Original Message- > From: Animesh [mailto:animesh@;deeproot.co.in] > Sent: Friday, October 18, 2002 4:53 PM > To: [EMAIL PROTECTED] > Subject: ERROR 2013: Lost connection to MySQL server during query > > > Hi All,, > > I am getting this error and mysqld is dying out while tring to access a > particular table in a particular databae while others don't fail.. > > ERROR 2013: Lost connection to MySQL server during query > > Plz Help as early as possible. > Regards, > Animesh > > [EMAIL PROTECTED] > DeepRoot Linux Pvt. Ltd. > Bangalore, India > > - > 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: ERROR 2013: Lost connection to MySQL server during query
Thanks for the reply. -rw-rw 1 mysql mysql 12766 Oct 10 12:16 bob-bin.072 -rw-rw 1 mysql mysql 506213 Oct 15 09:11 bob-bin.073 -rw-rw 1 mysql mysql 40391597 Oct 17 12:52 bob-bin.074 -rw-rw 1 mysql mysql 98 Oct 17 12:53 bob-bin.075 -rw-rw 1 mysql mysql 264824 Oct 18 09:57 bob-bin.076 I have been running with this in my my.cnf log log-slow-queries log-bin But the logs stop/starts of new files don't correspond to the lost connection errors at all. Eric - 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: ERROR 2013: Lost connection to MySQL server during query
Hi, Run mysqld_safe with the --log-bin switch (it will recreate a new bin log at each crash, so it's much more simple to see which query is responsible for the crash). Regards, Jocelyn Fournier - Original Message - From: "Eric" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 6:37 PM Subject: Re: ERROR 2013: Lost connection to MySQL server during query > Hi, > > I know there is more than one reason that this error can occur, but I have > not seen a good guide to debuging. > It might help, if you are using DBI to do a trace to a log file. I have > this happen every once in a while, but can't track it down because it is > one query out of hundreds and I can't reproduce it. The same query > executing over and over and over, but sometimes it chokes with the Lost > connection error. Isn't there a way to make the mysql error log a LOT more > verbose? > > Eric > > At 11:56 AM 2002-10-18 -0400, //mikezero/ wrote: > >[EMAIL PROTECTED] > > > - > 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: ERROR 2013: Lost connection to MySQL server during query
Hi, I know there is more than one reason that this error can occur, but I have not seen a good guide to debuging. It might help, if you are using DBI to do a trace to a log file. I have this happen every once in a while, but can't track it down because it is one query out of hundreds and I can't reproduce it. The same query executing over and over and over, but sometimes it chokes with the Lost connection error. Isn't there a way to make the mysql error log a LOT more verbose? Eric At 11:56 AM 2002-10-18 -0400, //mikezero/ wrote: [EMAIL PROTECTED] - 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: ERROR 2013: Lost connection to MySQL server during query
are you getting this problem with an API like php or perl cgi.. or is this command line. i was having a similar problem, but i couldn't access anything. i was trying to remotely connect to the mysql via command line and it would boot me. even on the server itself if i included the '-h hostname' flag it would boot me, they only way i could get in was with out the '-h'. Animesh wrote: Hi All,, I am getting this error and mysqld is dying out while tring to access a particular table in a particular databae while others don't fail.. ERROR 2013: Lost connection to MySQL server during query Plz Help as early as possible. Regards, Animesh [EMAIL PROTECTED] DeepRoot Linux Pvt. Ltd. Bangalore, India - 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
ERROR 2013: Lost connection to MySQL server during query
Hi All,, I am getting this error and mysqld is dying out while tring to access a particular table in a particular databae while others don't fail.. ERROR 2013: Lost connection to MySQL server during query Plz Help as early as possible. Regards, Animesh [EMAIL PROTECTED] DeepRoot Linux Pvt. Ltd. Bangalore, India - 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
Error 2013: Lost connection to MySQL server during query
Tim, Tuesday, February 19, 2002, 9:57:07 PM, you wrote: TW> Hopefully someone out there can help me as I haven't been able to find any TW> documentation on this that applies. TW> I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting TW> "Error 2013: Lost connection to MySQL server during query" when I run the TW> following query: TW> select distinct Product.MFG_ID, TW> MFG.Name TW> fromProduct, TW> Cat_link, TW> MFG TW> where MFG.ID=Product.MFG_ID TW> and Product.ID=Cat_link.PROD_ID TW> and Cat_link.CAT_ID="3" TW> and Product.Status="A" TW> order by MFG.Name; TW> Does anyone have any ideas? Thanks! "Connection lost" error occurs when communication bug or bug in the client take place. Look at: http://www.mysql.com/doc/G/o/Gone_away.html http://www.mysql.com/doc/P/a/Packet_too_large.html TW> TW -- For technical support contracts, goto https://order.mysql.com/ 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
Error 2013: Lost connection to MySQL server during query
Hopefully someone out there can help me as I haven't been able to find any documentation on this that applies. I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting "Error 2013: Lost connection to MySQL server during query" when I run the following query: select distinct Product.MFG_ID, MFG.Name fromProduct, Cat_link, MFG where MFG.ID=Product.MFG_ID and Product.ID=Cat_link.PROD_ID and Cat_link.CAT_ID="3" and Product.Status="A" order by MFG.Name; Does anyone have any ideas? Thanks! TW - 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
ERROR 2013: Lost connection to MySQL server during query
Dear all I have a problem when I specified my host in order to connect to my mysql server : mysql -h p204 ERROR 2013: Lost connection to MySQL server during query I have just installed the server and set a pass for the root user. In hope of your help Guillaume - 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: ERROR 2013: Lost connection to MySQL server during query
Hi, Here's a bit of a followup: I've narrowed my problem down to one of our servers, the one running mySQL 3.22.27. The server is listening to port 3306, but is taking a very long time to respond to requests sent to that port. It seems to hang but it eventually responds after a few minutes. Any ideas why it would be taking so long? This is on a RH 6.0 system. Thank you! Kurt Hansen [EMAIL PROTECTED] > > Subject: ERROR 2013: Lost connection to MySQL server during query > > > > > > Hello, > > > > I'm getting the error message above whenever I try to connect from a > remote > > host to a MySQL server. I issue the following command: > > > > mysql --host=host_name -u user_name -ppass_word > > > > and get the ERROR 2013 back as a response. > > > > We have two servers, both running MySQL. I get the same message going both > > ways. I have all the privileges set up properly. When I don't, I just get > > the "host_name not set up for access" message. I've duplicated the setup > on > > our local LAN, and I connect with no problem. It is only our Web servers > > that are having this problem. > > > > We are only having this problem after our ISP moved our servers to a new, > > "better" network and gave us new IPs. The servers have been talking to > each > > other with no problems for almost 1.5 years, but have not been able to > since > > the move. I've updated the privilege information, but it appears that the > > client is not getting a complete response from the server. > > > > Any ideas on what to do to fix this? Troubleshooting clues? The request > from > > the remote server is not showing up in the log; anyway I could capture > this? > > > > I can telnet between the systems so I'm pretty sure the TCP/IP is working. > > > > MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. > > The mysqld variables are set to their default except for > max_allowed_packet, > > which has been increased to 10048512 on the 3.22.21 system in a vain > attempt > > to solve the error. > > > > Thanks! > > > > Kurt Hansen > > [EMAIL PROTECTED] ` - 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: ERROR 2013: Lost connection to MySQL server during query
Hi Milos, Thanks for responding! I had updated the /etc/hosts files already, but went and checked it after getting your message. Still no luck. Any other troubleshooting clues? Thanks! Kurt Hansen [EMAIL PROTECTED] - Original Message - From: Milos Rackov <[EMAIL PROTECTED]> To: Kurt Hansen <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 09, 2001 8:59 AM Subject: RE: ERROR 2013: Lost connection to MySQL server during query > I had a similar problem recently. Try checking the /etc/hosts file to see if > the hosts/IPs are matching the current config. > > Regards, > > Milos Rackov > > -Original Message- > From: Kurt Hansen [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 4:58 PM > To: [EMAIL PROTECTED] > Subject: ERROR 2013: Lost connection to MySQL server during query > > > Hello, > > I'm getting the error message above whenever I try to connect from a remote > host to a MySQL server. I issue the following command: > > mysql --host=host_name -u user_name -ppass_word > > and get the ERROR 2013 back as a response. > > We have two servers, both running MySQL. I get the same message going both > ways. I have all the privileges set up properly. When I don't, I just get > the "host_name not set up for access" message. I've duplicated the setup on > our local LAN, and I connect with no problem. It is only our Web servers > that are having this problem. > > We are only having this problem after our ISP moved our servers to a new, > "better" network and gave us new IPs. The servers have been talking to each > other with no problems for almost 1.5 years, but have not been able to since > the move. I've updated the privilege information, but it appears that the > client is not getting a complete response from the server. > > Any ideas on what to do to fix this? Troubleshooting clues? The request from > the remote server is not showing up in the log; anyway I could capture this? > > I can telnet between the systems so I'm pretty sure the TCP/IP is working. > > MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. > The mysqld variables are set to their default except for max_allowed_packet, > which has been increased to 10048512 on the 3.22.21 system in a vain attempt > to solve the error. > > Thanks! > > Kurt Hansen > [EMAIL PROTECTED] > > > - > 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: ERROR 2013: Lost connection to MySQL server during query
I had a similar problem recently. Try checking the /etc/hosts file to see if the hosts/IPs are matching the current config. Regards, Milos Rackov -Original Message- From: Kurt Hansen [mailto:[EMAIL PROTECTED]] Sent: Monday, July 09, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: ERROR 2013: Lost connection to MySQL server during query Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the "host_name not set up for access" message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, "better" network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - 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
ERROR 2013: Lost connection to MySQL server during query
Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the "host_name not set up for access" message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, "better" network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [EMAIL PROTECTED] - 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
ERROR 2013: Lost connection to MySQL server during query
I could not find a reference in the manual to this error message. What could be happening? It is the first problem I have with the database since installation two years ago- well almost three. Thanks, --- Claudia M. Castaneda Phone 301 286 3397 - 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
