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 f

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 changed wait_timeout=30 t

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? https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_ti

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 files are empty. I am reall

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 th

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 pa

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 character-set-client-ha

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 query_ca

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 te

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 em

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

Re: MySQL server has gone away

2017-04-03 Thread Mahmood N
f 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: dmlreadexceptionStack trace: - li

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
ommand, 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 WHERE sid = ? >[array ( > 0 =&g

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 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 Kumar" wrote: I had experience wit

Re: MySQL server has gone away

2011-05-31 Thread chandrudba
, Claudio Nanniwrote: 'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: I had experience with such type of error, It was due lack of resources available to MySql, max connections exceeds on

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 wrote: > 'MySQL server has gone away' > Can be a network

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" wrote: > I had experience with such type of error, It was due lack of resources > available to MySql, max connections exceeds on the server

Re: MySQL server has gone away

2011-05-26 Thread Prabhat Kumar
e "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 loo

Re: MySQL server has gone away

2011-05-25 Thread Aveek Misra
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 >

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

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

Re: MySQL Server has gone away

2010-08-20 Thread Shawn Green (MySQL)
relay log '/var/run/mysqld/mysqld-relay-bin.01' (relay_log_pos 4) 100817 6:42:11 [ERROR] Could not find target log during relay log initialization 100817 6:42:11 [ERROR] Failed to initialize the master info structure 100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections. Vers

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 wrote: From: Ananda Kumar Subject: Re: MySQL Server has gone away To: "jitendra ranjan" Cc: "Krishna Chandra Prajapati" , "Prabhat Kumar" , mysql@lists.mysql.com Date: Fr

Re: MySQL Server has gone away

2010-08-20 Thread Ananda Kumar
ead_cache_size': unsigned value > 33554432 adjusted to 16384 > 100817 6:42:10 InnoDB: Started; log sequence number 0 44054 > 100817 6:42:11 [Warning] Neither --relay-log nor --relay-log-index were > used; so replication may break when this MySQL server acts as a slave and > has hi

Re: MySQL Server has gone away

2010-08-19 Thread jitendra ranjan
y-bin.01' (relay_log_pos 4) 100817 6:42:11 [ERROR] Could not find target log during relay log initialization 100817 6:42:11 [ERROR] Failed to initialize the master info structure 100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.77-log' socket: '/va

Re: MySQL Server has gone away

2010-08-19 Thread Prabhat Kumar
; 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 *** > > > > > > Thanks in

Re: MySQL Server has gone away

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

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 bef

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 wrote: > > > Hi folks -- > > New to MySQL. I'm developing C-language connector software and, while > debugging, I often get the error message "MySQL server ha

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 in

Re: MySQL server has gone away...

2009-03-25 Thread Walter Heck - OlinData.com
; > How do I tell what the TTL is? > > I'm not too familiar with perfmon.  How do I set it up to watch MySQL > connections? > > Thanks, > Jesse > > - Original Message - From: "Gary Smith" > To: "Jesse" ; > Sent: Tuesday, March 24, 20

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
tions? Thanks, Jesse - Original Message - From: "Gary Smith" To: "Jesse" ; 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 the pool issu

Re: MySQL server has gone away...

2009-03-24 Thread Jesse
suddenly loose connection? Jesse - Original Message - From: "Jesse" To: Sent: Tuesday, March 24, 2009 11:41 AM Subject: MySQL server has gone away... We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (someti

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 are

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 mess

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

MySQL server has gone away...

2009-03-24 Thread Jesse
MySQL 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 unsubscrib

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

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

2008-11-16 Thread Uma Bhat
he 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 rec

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

2008-11-16 Thread Ananda Kumar
dump 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

ERROR 2006 (HY000): MySQL server has gone away

2008-11-16 Thread mikesz
the MySQL CLI. 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... Connec

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

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

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 erro

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 th

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,

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

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

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 disconnecte

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: Lo

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 syste

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

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

2006-03-27 Thread Luke Vanderfluit
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->{lock}) { *67:* local $self->{dbh}->{RaiseError} = 1; *68:* *69:* my $sth = $self->{dbh}-

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

2006-03-27 Thread sheeri kritzer
ecute 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->{lock}) { > *67:* local $self->{dbh}->{RaiseError} = 1; > *68:* > *69:* my $sth = $sel

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 (

Re: MySQL server has gone away ??

2006-01-04 Thread Gleb Paharenko
t 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 ''@'' (usi= > ng=20 > password: YES) > ERROR: > Can't

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 ''@'' (using password: YES) ERROR: Can't

RE: MySQL server has gone away

2005-11-18 Thread Kraer, Joseph
Mortgage Corp 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

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 mysqld

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

Re: "MySQL server has gone away" error?

2005-06-20 Thread Gleb Paharenko
blems 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 me which setting I > probably need to change to make this work? Than

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

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

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

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

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

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

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

help please : ERROR 2006: MySQL server has gone away

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

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 yo

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

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

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

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

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

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

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 interact

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

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

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 var

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 Fre

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 begi

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

ERROR 2006: MySQL server has gone away

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

Re: ERROR 2006:MySQL server has gone away

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

Re: ERROR 2006: MySQL Server Has Gone Away

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

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

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 work

MySQL server has gone away

2001-06-14 Thread mackenziej
packet1='$packetloss{1}' and resp1='$response{1}' where 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

"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