MySQL error :MySQL Connection Failed: Lost connection to MySQL server during query

[The Piper]

I installed vBulletin a few weeks ago and yesterday finished upgrading from phpBB 1.4.4 to vBulletin 2.5.5. Everything was working smoothly, but when I got home tonight I had several e-mails from my users saying they could not retrieve their passwords. So I tried that myself, I typed my e-mail address, and got two errors (the "There seems to have been a slight problem with the All Pink Floyd Fan Network database...." error)

Looking at the source code of that page, I got this for the first error:

<!-- Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO useractivation VALUES (NULL,'1','1020133520','22381263',1)
mysql error: Lost connection to MySQL server during query

mysql error number: 2013

Date: Monday 29th of April 2002 10:25:20 PM
Script: http://www.pinkfloydfan.net/forums/forums/member.php
Referer: http://209.51.141.97/forums/member.php?action=lostpw
-->

And for the second error:

<!-- Database error in vBulletin 2.2.5:

Invalid SQL: UPDATE session SET lastactivity=1020133520,location='/forums/member.php' WHERE sessionhash='c6e235b92703e0ecb88f274052e8d589'
mysql error: MySQL server has gone away

mysql error number: 2006

Date: Monday 29th of April 2002 10:25:20 PM
Script: http://www.pinkfloydfan.net/forums/forums/member.php
Referer: http://209.51.141.97/forums/member.php?action=lostpw
-->

I have no clue of why this is happening, but every time I try to recover a lost password, by typing my e-mail address, it seems MySQL crashes. At least that's what I got by looking at the mysql uptime, it's always only a few seconds after I get that error.

To check my MySQL and system stats, please use this URL:

http://209.51.141.97/phpSysInfo-2.0/index.php

http://209.51.141.97/stats.php

I'd really, really appreciate your help. This is not the time for me to get this error, since only a few of my users managed to get a new password. Most of them are still trying to do so and are getting this error....

Thanks,
Paulo

[Steve Machol]

The MySQL server stopped running or restarted during this operation. Usually this is an isolated event but if it continues contact your host about it. Good luck!

[George L]

http://www.mysql.com/doc/G/o/Gone_away.html

http://www.mysql.com/doc/C/o/Common_errors.html

http://www.mysql.com/doc/S/e/Server_parameters.html

http://www.mysql.com/doc/O/p/Option_files.html

http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html

The most common reason for the MySQL server has gone away error

1. Is that the server timed out and closed the connection. By default, the server closes the connection after 8 hours or 28800 seconds if nothing has happened. You can change the time limit by setting the wait_timeout variable when you start mysqld via your server's /etc/my.cnf as well.

2. Another common reason to receive the MySQL server has gone away error is because you have issued a ``close'' on your MySQL connection and then tried to run a query on the closed connection. You can check that the MySQL hasn't died by executing mysqladmin version and examining the uptime.

i.e. to check mysql uptime, in shell as root user type:

mysqladmin -u root -p version

3. You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M) or via max_allowed_packet variable in your /etc/my.cnf file and restarting mysql after you edited your /etc/my.cnf file. The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row

4. or simply your host restarted mysql.. i'd contact your web host