Re: help please : ERROR 2006: MySQL server has gone away
Hello. 4.0.17 is old enough. You may switch to the debug version and attempt to find the clues in debug or trace files. Can you reproduce an error on the latest release (4.1.9 now)? Do you lost connection to the server with other statements, than 'SHOW DATABASES'? Please answer on this questions: -What operating system do you use? -Do you use official binaries? [snip] We still have the problem... In the error log, I have nothing about problem. I only have that: 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 If I do show variables, I have max_allowed_packet = 16776192 IF I log into mysql with :mysql -uroot --max_allowed_packet=16M -p After I do:show databases; and I receive the answer. After I wait 30 sec and launch the command show databases; again and now I have the error: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Marois, David [EMAIL PROTECTED] wrote: [snip] Marois, David [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: help please : ERROR 2006: MySQL server has gone away
Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be you have some ulimits which cause such behaviour? [snip] And max_allowed_packet = 16776192 David Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks !Marois, David [EMAIL PROTECTED] wrote: [snip] -- 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]
help please : ERROR 2006: MySQL server has gone away
We still have the problem... In the error log, I have nothing about problem. I only have that: 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 If I do show variables, I have max_allowed_packet = 16776192 IF I log into mysql with :mysql -uroot --max_allowed_packet=16M -p After I do:show databases; and I receive the answer. After I wait 30 sec and launch the command show databases; again and now I have the error: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... David Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be you have some ulimits which cause such behaviour? -Message d'origine- De : Marois, David Envoyé : 2 février, 2005 09:16 À : 'mysql@lists.mysql.com' Objet : Re: help please : ERROR 2006: MySQL server has gone away And max_allowed_packet = 16776192 David Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks ! David Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: [EMAIL PROTECTED] Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: help please : ERROR 2006: MySQL server has gone away
So far, you have only showed us the client-view of the problem.. look in you data directories on the server machine... there is likely an error file there which should give you some insight (unless permissions for that directory are seriously messed up). IF there is no error file, determine which user MySQL is running as (default: mysql) and confirm that user has read/write permissions to that directory and subdirectories. There are a few misconfigurations which take MySQL a bit of time to fail on.. I know I had similar results last summer doing a manual source-install of MySQL 4.1 which was related to the data-directory permissions.. Having sorted it out, the server has been extremely stable under heavy load for several continuous months now. - michael dykman On Thu, 2005-02-03 at 08:38, Marois, David wrote: We still have the problem... In the error log, I have nothing about problem. I only have that: 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 If I do show variables, I have max_allowed_packet = 16776192 IF I log into mysql with :mysql -uroot --max_allowed_packet=16M -p After I do:show databases; and I receive the answer. After I wait 30 sec and launch the command show databases; again and now I have the error: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... David Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be you have some ulimits which cause such behaviour? -Message d'origine- De : Marois, David Envoy : 2 fvrier, 2005 09:16 : 'mysql@lists.mysql.com' Objet : Re: help please : ERROR 2006: MySQL server has gone away And max_allowed_packet = 16776192 David Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks ! David Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: [EMAIL PROTECTED] Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE : help please : ERROR 2006: MySQL server has gone away
Hi Michael, Yesterday, I restarted the server and the mysql database. And In the errorlog, I only have 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 Also, I verified and my mysql user have access to write into my errorlog file and in my directories. David David Marois -Message d'origine- De : Michael Dykman [mailto:[EMAIL PROTECTED] Envoyé : 3 février, 2005 10:02 À : Marois, David Cc : MySQL List Objet : Re: help please : ERROR 2006: MySQL server has gone away So far, you have only showed us the client-view of the problem.. look in you data directories on the server machine... there is likely an error file there which should give you some insight (unless permissions for that directory are seriously messed up). IF there is no error file, determine which user MySQL is running as (default: mysql) and confirm that user has read/write permissions to that directory and subdirectories. There are a few misconfigurations which take MySQL a bit of time to fail on.. I know I had similar results last summer doing a manual source-install of MySQL 4.1 which was related to the data-directory permissions.. Having sorted it out, the server has been extremely stable under heavy load for several continuous months now. - michael dykman On Thu, 2005-02-03 at 08:38, Marois, David wrote: We still have the problem... In the error log, I have nothing about problem. I only have that: 050203 00:34:14 mysqld started /u01/mysql/libexec/mysqld: ready for connections. Version: '4.0.17-log' socket: '/tmp/mysql.sock' port: 3306 If I do show variables, I have max_allowed_packet = 16776192 IF I log into mysql with :mysql -uroot --max_allowed_packet=16M -p After I do:show databases; and I receive the answer. After I wait 30 sec and launch the command show databases; again and now I have the error: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... David Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be you have some ulimits which cause such behaviour? -Message d'origine- De : Marois, David Envoyé : 2 février, 2005 09:16 À : 'mysql@lists.mysql.com' Objet : Re: help please : ERROR 2006: MySQL server has gone away And max_allowed_packet = 16776192 David Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks ! David Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: [EMAIL PROTECTED] Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help please : ERROR 2006: MySQL server has gone away
Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html Marois, David [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: iso-8859-1, 19 lines --] Hi, I have this error when I am connected in mysql: ERROR 2006: MySQL server has gone away. No connection. Trying to reconnect... I only did this command: show databases; and received the error. I noticed that if I don't send a command since 25 sec, I have the error. Also, my variable wait_timeout = 3600. Any ideas ? David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- 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: help please : ERROR 2006: MySQL server has gone away
-Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: mysql@lists.mysql.com Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help please : ERROR 2006: MySQL server has gone away
Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: mysql@lists.mysql.com Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark -- 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: help please : ERROR 2006: MySQL server has gone away
Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks ! David Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: [EMAIL PROTECTED] Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
Re: help please : ERROR 2006: MySQL server has gone away
And max_allowed_packet = 16776192 David Hi, my interactive_timeout variable is interactive_timeout 3600 Thanks ! David Hello. I've asked you about interactive_timeout, not wait_timeout. Mark [EMAIL PROTECTED] wrote: -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 12:46 To: [EMAIL PROTECTED] Subject: Re: help please : ERROR 2006: MySQL server has gone away Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html I believe he already answered that in part: Also, my variable wait_timeout = 3600. 1 hour, that is, instead of the default 8 (28800). - Mark David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
help please : ERROR 2006: MySQL server has gone away
Hi, I have this error when I am connected in mysql: ERROR 2006: MySQL server has gone away. No connection. Trying to reconnect... I only did this command: show databases; and received the error. I noticed that if I don't send a command since 25 sec, I have the error. Also, my variable wait_timeout = 3600. Any ideas ? David Marois mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
ERROR 2006: MySQL server has gone away
Hi Gurus, I'm relatively new to MySQL - been studying it for the past 2 months. So far, so good (or Great). I recently moved from MySQL 3.23.22 to 4.0.2-alpha-debug-log on our 4.6.1-RELEASE-p10 FreeBSD server. Using the mysql client, I noticed an annoying message immediately after every query: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:13 I checked in the error log file and find this repeated, for every occurance of this error on my screen: /usr/local/libexec/mysqld: read looped with error 35, aborting thread I've checked the variables and settings. All of the timeouts are default. +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 30| | delayed_insert_timeout | 300 | | flush_time | 0 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | long_query_time | 10| | net_read_timeout | 120 | | net_write_timeout| 180 | | slave_net_timeout| 3600 | | slow_launch_time | 2 | | timezone | EDT | | wait_timeout | 28800 | +--+---+ If I type queries real fast, immediately after eachother, I don't get this error. The error gets logged in the log file exactly 5 seconds after a query if I dont' type anything. 5 seconds!!! I've checked the /etc/my.cnf file and its default. No .my.cnf files to worry about. Any thoughts? Is this info useful at all: mysql status; -- mysql Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386) Connection id: 10 Current database: samp_db Current user: blairwag@localhost SSL:Not in use Current pager: stdout Using outfile: '' Server version: 4.0.2-alpha-debug-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 20 min 22 sec Threads: 1 Questions: 90 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 8 Queries per second avg: 0.074 Memory in use: 46839K Max memory used: 46902K -- William Blair Wagner : Education is not always knowing the answer, [EMAIL PROTECTED] : ...but rather knowing where to look for it! - 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 2006:MySQL server has gone away
Anil, Friday, June 28, 2002, 8:57:06 PM, you wrote: AG I have a table with the following description: AG mysql describe xoops_groups_modules_link; AG +-+-+--+-+-+---+ AG | Field | Type| Null | Key | Default | Extra | AG +-+-+--+-+-+---+ AG | groupid | int(5) | | MUL | 0 | | AG | mid | int(5) | | | 0 | | AG | type| char(1) | | | | | AG +-+-+--+-+-+---+ AG with the folloing contents in it: AG mysql select * from xoops_groups_modules_link; AG +-+-+--+ AG | groupid | mid | type | AG +-+-+--+ AG | 1 | 1 | A| AG | 1 | 2 | A| AG | 1 | 1 | R| AG | 1 | 2 | R| AG | 2 | 1 | R| AG | 2 | 2 | R| AG | 3 | 1 | R| AG | 3 | 2 | R| AG +-+-+--+ AG Now, when i run the following query: AG mysql select * from xoops_groups_modules_link where type='R' and mid=2 and AG groupid=3 ; AG ERROR 2006: MySQL server has gone away AG No connection. Trying to reconnect... AG Connection id:1 AG Current database: xoops AG ERROR 2013: Lost connection to MySQL server during query AG I cant find out why its happening so!! AG Can someone plz help me. AG Infact this table is dumped from a dump. If i create a same table by myself AG and then run the same query it executes fine. Isn't that strange!! Check your table with CHECK TABLE statement, is there any error in the output? -- 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 2006: MySQL Server Has Gone Away
I am having a problem reading a SQL script to recreate a database. I am runing mysql 3.23 on Redhat linux 7.2. The SQL file contains 35 megs worth of data. Everytime i try running it to recreate my database from a backup i get the following error: ERROR 2006: MySQL server has gone away. I beleive that it is failing in the same spot. I have one very large table that has over 1 meg worth of data in a single row. I beleive that is where the SQL is failing. Is there anything I can do to modify the configuration to allow large SQL statements like that to run. Emil Diego Web Coordinator University of Miami School of Business [EMAIL PROTECTED] ph: 305.284.5449 fx: 305.284.3404 - 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 2006: MySQL Server Has Gone Away
Hello Emil You need to increase the max packet size that mysql can handle... try putting this in your my.cnf file under [mysqld]: set-variable = max_allowed_packet=5M and restarting your server (obv. if you're starting mysql from the command line use the switch --max_allowed_packet) james At 10:35 04/03/2002 -0500, Diego, Emil wrote: I am having a problem reading a SQL script to recreate a database. I am runing mysql 3.23 on Redhat linux 7.2. The SQL file contains 35 megs worth of data. Everytime i try running it to recreate my database from a backup i get the following error: ERROR 2006: MySQL server has gone away. I beleive that it is failing in the same spot. I have one very large table that has over 1 meg worth of data in a single row. I beleive that is where the SQL is failing. Is there anything I can do to modify the configuration to allow large SQL statements like that to run. Emil Diego Web Coordinator University of Miami School of Business [EMAIL PROTECTED] ph: 305.284.5449 fx: 305.284.3404 - 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 James Carrier Bullet Online :: Aim Higher [http://www.bulletonline.com] 41b Beavor Lane, London W6 9BL Tel +44 (0) 20 8834 3442 Fax +44 (0) 20 8741 2790 - 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
