Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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
    All Pink Floyd Fan Network
    http://www.pinkfloydfan.net

  • #2
    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!
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X