Re: MySQL server has gone away

2017-04-04 Thread Reindl Harald
Am 03.04.2017 um 21:22 schrieb Mahmood N: well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! on a proper server you have a local smtpd like postfix listening on 127.0.0.1 and hence you can send thousands of messages within seconds

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>well, who did set it that low? ِDon't know. Maybe the previous admin hadn't used mysql for sending emails!! Anyway, thanks.  Regards, Mahmood On Monday, April 3, 2017 11:37 PM, Reindl Harald wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: > Good news! > > I

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. well, who did set it that low?

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. Regards, Mahmood On Monday, April 3, 2017 10:32 PM, Mahmood N wrote: Dear reindl, I tested with both 5 and 1 and see the log

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear reindl, I tested with both 5 and 1 and see the log files are empty. I am really confused about that error and it is taking more than 2 weeks about that! Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains >

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty.  Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>since when is phpinfo() - the *real* active configuration be it changed >by some config snippet, vhost-configuration or even ini_set() - the same >than a random file in /etc? Sorry I totally didn't understand that sentence... Regards, Mahmood

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
>given that a reasonable server should be able to >handle hunredts to thousands of requests per second anything above 1 >second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit the email test, the refresh time for that

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 18:11 schrieb Mahmood N: The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5 character-set-client-handshake = FALSE thread_concurrency = 8

Re: MySQL server has gone away

2017-04-03 Thread Reindl Harald
Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one terminal and at the same time, submit a test

Re: MySQL server has gone away

2017-04-03 Thread shawn l.green
On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end with

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 30912

Re: MySQL server has gone away

2017-04-03 Thread Johnny Withers
using Moodle which itself uses SQL for the database. Problem is > >that, when I run the email plugin and execute the command, the refresh > >time of the page becomes high (in the order of 3-5 minutes) and at the > >end, I see this message > >Debug info: MySQL server

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = ? [array ( 0 => 'jqfbgd5b0q6e2l81bb5gb87mn3', )] Error code: dmlrea

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
email plugin and execute the command, the refresh >time of the page becomes high (in the order of 3-5 minutes) and at the >end, I see this message >Debug info: MySQL server has gone away >SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM >mdl_sessions

MySQL server has gone away

2017-04-03 Thread Mahmood N
Hi,I am using Moodle which itself uses SQL for the database. Problem is that, when I run the email plugin and execute the command, the refresh time of the page becomes high (in the order of 3-5 minutes) and at the end, I see this message Debug info: MySQL server has gone away SELECT id, sid

Re: MySQL server has gone away

2011-05-31 Thread ars k
which will give more error messages in error log. This is the basic step for this error, if it is not working then we should check for other options then. Regards, Vinodh.k On Fri, May 27, 2011 at 11:05 AM, Claudio Nanni claudio.na...@gmail.comwrote: 'MySQL server has gone away' Can

Re: MySQL server has gone away

2011-05-31 Thread chandrudba
, Claudio Nanniclaudio.na...@gmail.comwrote: 'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, Prabhat Kumaraim.prab...@gmail.com wrote: I had experience with such type of error, It was due lack of resources available to MySql, max

Re: MySQL server has gone away

2011-05-31 Thread chandrudba
Are you using connection pooling in your application? Regards, Chandru On 5/27/2011 11:05 AM, Claudio Nanni wrote: 'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, Prabhat Kumaraim.prab...@gmail.com wrote: I had experience

Re: MySQL server has gone away

2011-05-26 Thread Prabhat Kumar
WHERE cluster = ?: MySQL server has gone away The error MySQL server has gone away is the error from the db handle. Can anyone give me any pointers on why that happens? I looked up the documentation in MySQL docs and the most common reason seems to be that it happens if the query

Re: MySQL server has gone away

2011-05-26 Thread Claudio Nanni
'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, Prabhat Kumar aim.prab...@gmail.com wrote: I had experience with such type of error, It was due lack of resources available to MySql, max connections exceeds on the server. you can

MySQL server has gone away

2011-05-25 Thread Aveek Misra
Hi, We are seeing intermittent errors of the type: failed to execute SELECT * FROM cluster_info WHERE cluster = ?: MySQL server has gone away The error MySQL server has gone away is the error from the db handle. Can anyone give me any pointers on why that happens? I looked up

Re: MySQL server has gone away

2011-05-25 Thread Rik Wasmus
failed to execute SELECT * FROM cluster_info WHERE cluster = ?: MySQL server has gone away The error MySQL server has gone away is the error from the db handle. Can anyone give me any pointers on why that happens? I looked up the documentation in MySQL docs and the most common

Re: MySQL server has gone away

2011-05-25 Thread Aveek Misra
Nothing in the error log or the slow query log that suggests that the query size is too large or us taking too much time to execute. Thanks Aveek On May 25, 2011, at 3:53 PM, Rik Wasmus wrote: failed to execute SELECT * FROM cluster_info WHERE cluster = ?: MySQL server has gone away

Re: MySQL Server has gone away

2010-08-20 Thread Ananda Kumar
/10, Prabhat Kumar aim.prab...@gmail.com wrote: From: Prabhat Kumar aim.prab...@gmail.com Subject: Re: MySQL Server has gone away To: Krishna Chandra Prajapati prajapat...@gmail.com Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com Date: Thursday, 19 August, 2010, 4:56 PM

Re: MySQL Server has gone away

2010-08-20 Thread jitendra ranjan
The account has full permission on all the databases. --- On Fri, 20/8/10, Ananda Kumar anan...@gmail.com wrote: From: Ananda Kumar anan...@gmail.com Subject: Re: MySQL Server has gone away To: jitendra ranjan jitendra_ran...@yahoo.com Cc: Krishna Chandra Prajapati prajapat...@gmail.com

Re: MySQL Server has gone away

2010-08-20 Thread Shawn Green (MySQL)
, Prabhat Kumar aim.prab...@gmail.com wrote: From: Prabhat Kumar aim.prab...@gmail.com Subject: Re: MySQL Server has gone away To: Krishna Chandra Prajapati prajapat...@gmail.com Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com Date: Thursday, 19 August, 2010, 4:56 PM

Re: MySQL Server has gone away

2010-08-19 Thread Krishna Chandra Prajapati
of the below error message : ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:264550 Current database: *** NONE *** Thanks in advance

Re: MySQL Server has gone away

2010-08-19 Thread Prabhat Kumar
error message : ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:264550 Current database: *** NONE *** Thanks in advance -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http

Re: MySQL Server has gone away

2010-08-19 Thread jitendra ranjan
: Prabhat Kumar aim.prab...@gmail.com Subject: Re: MySQL Server has gone away To: Krishna Chandra Prajapati prajapat...@gmail.com Cc: jitendra ranjan jitendra_ran...@yahoo.com, mysql@lists.mysql.com Date: Thursday, 19 August, 2010, 4:56 PM there is high chance of corruption of any data files

MySQL Server has gone away

2010-08-18 Thread jitendra ranjan
Hi,   Whenever i run any commnd on mysql it gives message as below then gives the result successfully. What is the reason of the below error message :   ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:    264550 Current database: *** NONE

PHP Warning: mysql_query(): MySQL server has gone away

2009-11-26 Thread René Fournier
: PHP Warning: mysql_query(): MySQL server has gone away However, the same query executes fine when run at the mysql command prompt, or from within Sequel Pro -- can execute it with a LIMIT clause of 2 million. So, it appears I'm exhausting some MySQL limit or system resource, but before I

Re: Error msg: MySQL server has gone away

2009-04-16 Thread Moon's Father
Can you tell me which version of mysql you use in you test? On Thu, Apr 16, 2009 at 12:43 AM, Pete Wilson p...@pwilson.net wrote: Hi folks -- New to MySQL. I'm developing C-language connector software and, while debugging, I often get the error message MySQL server has gone away if, say

Error msg: MySQL server has gone away

2009-04-15 Thread Pete Wilson
Hi folks -- New to MySQL. I'm developing C-language connector software and, while debugging, I often get the error message MySQL server has gone away if, say, I've stopped at a breakpoint and then issued a call that resembles: mysql_query(pmysql, insert into usrs(usr,email) values(\pete

Re: MySQL server has gone away...

2009-03-25 Thread Walter Heck - OlinData.com
: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once the pool issues the bad connection multiple issuances of the same connection will probably result in the same error.if yoi birst to 20 connections then drop to 10

MySQL server has gone away...

2009-03-24 Thread Jesse
server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL server has gone away...

2009-03-24 Thread drydell
this means that your connection has timed out... there's a mysql_ping command you can use to reconnect.- Original Message -From: Jesse Date: Tuesday, March 24, 2009 11:44 amSubject: MySQL server has gone away...To: mysql@lists.mysql.com We are running MySQL Server version 5.0.67

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
Persistent connections that are dropped when the service is restarted OR the idle timeout has passed. if this is a connection pool and it hasn't been used in a long time the server can drop the connection but the pool will still thinkbits open and pass it out. Thus the server has gone away

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
Go into the my.cnf and increase the connection timeout and see if that fixes it. Remember. Connection pooling is about reuse and sometimes when the server is using less connections its using the same ones over and over again. Then you get a burst and then connections that haven't been used

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
An update on this issue. It just happened again, and the first error was: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to MySQL server during que Then, after that, I got a BUNCH of [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
? Thanks, Jesse - Original Message - From: Gary Smith g...@primeexalia.com To: Jesse j...@msdlg.com; mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 2:55 PM Subject: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once

Re: Re[2]: ERROR 2006 (HY000): MySQL server has gone away

2008-11-17 Thread Uma Bhat
Tried increasing the wait_timeout variable and restart the instance? http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Let us know - 1) your my.ini settings. 2) the options you are giving while taking the dump. Regards, Uma On 11/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello

ERROR 2006 (HY000): MySQL server has gone away

2008-11-16 Thread mikesz
. The Table is 360megs and this error occurred about three times in the import. I even tried using bigdump to import it but soon after it started, it did a binary dump to the screen and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12

Re: ERROR 2006 (HY000): MySQL server has gone away

2008-11-16 Thread Ananda Kumar
and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:13 Current database: worldrac_forum

Re: ERROR 2006 (HY000): MySQL server has gone away

2008-11-16 Thread Uma Bhat
tried using bigdump to import it but soon after it started, it did a binary dump to the screen and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away

Re: mysql server has gone away

2007-01-16 Thread Chris White
If I fire a lot of querries, I get an error mysql server has gone away/lost connection with the server . I've seen this error for the second reason you've mentioned, wrong queries. You'll need to show us the query so we can see any possible issues. -- MySQL General Mailing List For list

mysql server has gone away

2007-01-16 Thread imre
Subject: mysql server has gone away do u knw any othr circumstances in which such an error occurs? n whts the best poss soln here- to do a reconnect If you are using version 5.* and get a FUNCTION does not exist error before loosing the connection, than patch your source as described

mysql server has gone away

2007-01-15 Thread Nishant Gupta
If I fire a lot of querries, I get an error mysql server has gone away/lost connection with the server . I tried to use mysql_ping() to reconnect, but tht also fails... So shud i call real_connect again? I mean will it be gud practice tht way? I looked for such an error to have occured. I found

Re: MySQL server has gone away. Suddenly.

2006-05-10 Thread Sander Smeenk
Hello everyone, This problem seems to be solved... The problem i'm experiencing is that at certain moments, the connection between my perlscripts and the database gets disconnected. [...] I thought the query at that spot would be wrong, but it turns out that this alone is not causing the

Re: MySQL server has gone away. Suddenly.

2006-05-06 Thread Sander Smeenk
Quoting sheeri kritzer ([EMAIL PROTECTED]): Do a show status like 'uptime' after the script runs. See if the server crashed (if so, uptime will be low) -- if the server crashed you might get that error. The server itself does not crash. Uptime shows that, besides the fact that this would

Re: MySQL server has gone away. Suddenly.

2006-05-06 Thread Sander Smeenk
Quoting Kishore Jalleda ([EMAIL PROTECTED]): What is happening is that when you start you perl script which contains a lot of queries, you are first establishing a connection to MySQL, and then you are running some queries, and somewhere in between you are losing connection to the server,

MySQL server has gone away. Suddenly.

2006-05-05 Thread Sander Smeenk
Hi, I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual Opteron250 64 bit machine with 4gb memory. The problem i'm experiencing is that at certain moments, the connection between my perlscripts and the database gets disconnected: | DBI connect('products','beheerv',...) failed:

Re: MySQL server has gone away. Suddenly.

2006-05-05 Thread Kishore Jalleda
On 5/5/06, Sander Smeenk [EMAIL PROTECTED] wrote: Hi, I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual Opteron250 64 bit machine with 4gb memory. The problem i'm experiencing is that at certain moments, the connection between my perlscripts and the database gets

Re: MySQL server has gone away. Suddenly.

2006-05-05 Thread Sander Smeenk
Quoting Kishore Jalleda ([EMAIL PROTECTED]): Can anyone shed any light on this issue? This might shed more light into your problem http://dev.mysql.com/doc/refman/5.0/en/gone-away.html I've read that :) But still, the query returns the same data, if I run it alone, or in the complete stats

Re: MySQL server has gone away. Suddenly.

2006-05-05 Thread sheeri kritzer
Do a show status like 'uptime' after the script runs. See if the server crashed (if so, uptime will be low) -- if the server crashed you might get that error. show variables like %connections should show you how many connections you can have per user and total. That shouldn't be the problem;

Re: MySQL server has gone away. Suddenly.

2006-05-05 Thread Kishore Jalleda
On 5/5/06, Sander Smeenk [EMAIL PROTECTED] wrote: Quoting Kishore Jalleda ([EMAIL PROTECTED]): Can anyone shed any light on this issue? This might shed more light into your problem http://dev.mysql.com/doc/refman/5.0/en/gone-away.html I've read that :) But still, the query returns the

Re: DBD::mysql::st execute failed: MySQL server has gone away

2006-03-30 Thread Luke Vanderfluit
Ravi Prasad LR wrote: Luke, Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating

Re: DBD::mysql::st execute failed: MySQL server has gone away

2006-03-27 Thread sheeri kritzer
What happens if you try to connect to the database on the commandline? -Sheeri On 3/24/06, Luke Vanderfluit [EMAIL PROTECTED] wrote: Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:*DBD::mysql::st execute failed: MySQL server has

Re: DBD::mysql::st execute failed: MySQL server has gone away

2006-03-27 Thread Luke Vanderfluit
has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if ($self-{lock}) { *67:* local $self-{dbh}-{RaiseError} = 1; *68:* *69:* my $sth = $self-{dbh}-prepare_cached(q{SELECT RELEASE_LOCK(?)}, {}, 1); *70:* $sth-execute

Re: DBD::mysql::st execute failed: MySQL server has gone away

2006-03-27 Thread Ravi Prasad LR
Luke, Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating system error number 5 in a

DBD::mysql::st execute failed: MySQL server has gone away

2006-03-24 Thread Luke Vanderfluit
Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:* DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if ($self

Re: MySQL server has gone away ??

2006-01-04 Thread Gleb Paharenko
this error: mysql select * from mytable; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 1045 (28000): Access denied for user 'username'@'my.ip.addr' (usi= ng=20 password: YES) ERROR: Can't connect to the server mysql quit Bye $ mysql -h

MySQL server has gone away ??

2006-01-03 Thread Jørn Dahl-Stamnes
I have been using mysql client for some time when I got this error: mysql select * from mytable; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 1045 (28000): Access denied for user 'username'@'my.ip.addr' (using password: YES) ERROR: Can't connect

RE: MySQL server has gone away

2005-11-18 Thread Kraer, Joseph
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 4:39 PM To: Kraer, Joseph Cc: mysql@lists.mysql.com Subject: Re: MySQL server has gone away Kraer, Joseph [EMAIL PROTECTED] wrote on 11/16/2005 04:17:17 PM: First let me say that I'm

MySQL server has gone away

2005-11-16 Thread Kraer, Joseph
First let me say that I'm a newbie and that I've seen a few instances of this error in the list, but I haven't seen my case. I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4 backup done with mysqldump in a LAMP machine. The restoration process invariably stops at line 517.

Re: MySQL server has gone away

2005-11-16 Thread SGreen
Kraer, Joseph [EMAIL PROTECTED] wrote on 11/16/2005 04:17:17 PM: First let me say that I'm a newbie and that I've seen a few instances of this error in the list, but I haven't seen my case. I'm running WAMP5, v. 1.4.4. I'm trying to restore an Eventum v. 1.4 backup done with mysqldump in a

Re: MySQL server has gone away error?

2005-06-20 Thread Gleb Paharenko
to handle this much data in a single query I guess. I was getting a *max allowed packet error so I raised that. Now I get a MySQL server has gone away error. Can anyone tell me which setting I probably need to change to make this work? Thanks. * -- Michael [EMAIL PROTECTED] http

MySQL server has gone away error?

2005-06-19 Thread Michael
I'm using PHP with MySQL to save files uploaded by users (up to 50MB) to a database. I'm having problems getting MySQL to handle this much data in a single query I guess. I was getting a *max allowed packet error so I raised that. Now I get a MySQL server has gone away error. Can anyone tell

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-04 Thread Gleb Paharenko
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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-03 Thread Gleb Paharenko
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

help please : ERROR 2006: MySQL server has gone away

2005-02-03 Thread Marois, David
= 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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-03 Thread Michael Dykman
--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

RE : help please : ERROR 2006: MySQL server has gone away

2005-02-03 Thread Marois, David
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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-02 Thread Gleb Paharenko
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

RE: help please : ERROR 2006: MySQL server has gone away

2005-02-02 Thread Mark
-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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-02 Thread Gleb Paharenko
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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-02 Thread Marois, David
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

Re: help please : ERROR 2006: MySQL server has gone away

2005-02-02 Thread Marois, David
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

help please : ERROR 2006: MySQL server has gone away

2005-02-01 Thread Marois, David
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

MySQL server has gone away

2004-01-19 Thread goblin
Hello mysql, the message MySQL server has gone away appears during upload to db mediumblob file of size 2M i tried to set max_allowed_packet=16M in my.cnf (and it shows me 16M in mysqladmin variables), but error still appears any ideas? used mysql4.1 (mysql3.23.58) on FreeBSD -- Best regards

Re: [Error] Mysql server has gone away

2002-12-23 Thread David BORDAS
hi, I always have my problem and i didn't find any solution pour the moment. Please, if somone have an idea ... :( Thanks David Subject: [Error] Mysql server has gone away 3.23.53a Date: Thu, 19 Dec 2002 17:23:31 +0100 I've some problem with my Mysql servers since the beginning of this week

[Error] Mysql server has gone away 3.23.53a

2002-12-19 Thread David Bordas
Hi all, I've some problem with my Mysql servers since the beginning of this week. I've got plenty of error like this : Failed to connect to database: Error: Access denied for user: ´[EMAIL PROTECTED]´ to database ´DB1´ MySQL server has gone away Error Nø1, please contact webmaster ... In fact

ERROR 2006: MySQL server has gone away

2002-09-24 Thread William Blair Wagner
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

Re: ERROR 2006:MySQL server has gone away

2002-07-01 Thread Egor Egorov
| 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

ERROR 2006: MySQL Server Has Gone Away

2002-03-04 Thread Diego, Emil
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

Re: ERROR 2006: MySQL Server Has Gone Away

2002-03-04 Thread James Carrier
: 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

MySQL server has gone away

2001-10-27 Thread Pablo Monti
Hi, people ! I'm having a trouble with a program written in C. This program try to create a record on a table, and it receives the 2006 error code, MySQL server has gone away. I've looked at the MySQL manual, searched the Web but the solutions posted doesn't worked for me. I've checked

MySQL server has gone away

2001-06-14 Thread mackenziej
date='$date'); Script Output: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172. MYSQL Logs: /usr/libexec/ld-elf.so.1: /usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld: Undefined symbol

MySQL server has gone away error

2001-01-11 Thread Sean Conley
and wait_timeout values to 10M and 32 hours respectively as is suggested in the manual, but this has had no effect. Here are the specifics from the error logs: DBD::mysql::st execute failed: MySQL server has gone away at /cgi-bin/common/utility.pl line 85. 010109 14:37:27 Aborted connection