| Author |
Message |
GeneralPatton |
|
Post subject: MySQL Error?! Was reading fine yesterday
 Posted: Jul 13, 2008 - 11:59 AM
|
|
Priv. First Class
Joined: Feb 04, 2008
Posts: 37
Status: Offline
|
|
Database error: Invalid SQL: SELECT stats_players.GUID FROM stats_players WHERE stats_players.SERVERID = 4 GROUP BY stats_players.GUID
mysql error: MySQL server has gone away
mysql error number: 2006
Date: 13.07.2008 @ 04:55
Script: /UltraStats/admin/parser-core.php?op=updatestats&id=4
Referer: http://www.claneot.com/UltraStats/admin ... s&id=4
Database error: Invalid SQL: UPDATE stats_servers SET LastUpdate = 1215942937 WHERE ID = 4
mysql error: MySQL server has gone away
mysql error number: 2006
Date: 13.07.2008 @ 04:55
Script: /UltraStats/admin/parser-core.php?op=updatestats&id=4
Referer: http://www.claneot.com/UltraStats/admin ... s&id=4
Does anyone know what this means?! I have updated the stats last 2 days perfectly fine, this morning I goto do it and every line has this above statement after it? The stats seemed to have updated okay but oddly,
The "Presented By" Image on the stats page oddly changed back to the original image? |
|
|
| |
|
|
|
 |
|
eagleeye |
|
|
Post subject: MySQL Error?! Was reading fine yesterday
Posted: Jul 13, 2008 - 01:01 PM
|
|
Lance Corporal
Joined: Jun 18, 2006
Posts: 57
Status: Offline
|
|
mysql error 2006:
Found this through google:
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
So if you are not running the mysql server yourself but hosted through web provider then contact your provider I would say. |
|
|
| |
|
|
|
|
|
deltaray |
|
|
Post subject: MySQL Error?! Was reading fine yesterday
Posted: Jul 13, 2008 - 08:35 PM
|
|
Sitemast0r
Joined: Oct 22, 2005
Posts: 12339
Location: Terra - SOL System
Status: Offline
|
|
Quote: MySQL server has gone away
Your MYSQL Server is in serious trouble. |
_________________
 - For Support write into the forums pls ... btw u r a fag 
He Poops on you!
|
| |
|
|
|
|
|
Anzeigen |
|
|
Post subject: Google Ads
Posted:
|
|
Guest
Joined: Oct 22, 2005
Posts
Location
Status: Offline
|
|
|
|
|
|
|
GeneralPatton |
|
|
Post subject: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 13, 2008 - 08:41 PM
|
|
Priv. First Class
Joined: Feb 04, 2008
Posts: 37
Status: Offline
|
|
deltaray wrote: Quote: MySQL server has gone away
Your MYSQL Server is in serious trouble.
Can you be more detailed?
EDIT:
Problem seems to be fixed. |
|
|
| |
|
|
|
|
|
deltaray |
|
|
Post subject: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 13, 2008 - 08:50 PM
|
|
Sitemast0r
Joined: Oct 22, 2005
Posts: 12339
Location: Terra - SOL System
Status: Offline
|
|
| If this error occurs, this most likely means that your MYSQL was stopped while a query was performed, or it crashed for some reason. |
_________________
- For Support write into the forums pls ... btw u r a fag
He Poops on you!
|
| |
|
|
|
|
|
GeneralPatton |
|
|
Post subject: RE: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 15, 2008 - 01:15 AM
|
|
Priv. First Class
Joined: Feb 04, 2008
Posts: 37
Status: Offline
|
|
Hello,
Unfortunately you will need to reduce the size of your query. Anything that takes longer than 15 seconds will be killed by the server.
Sincerely,
Devon D.
Level 1 Linux Administrator
HostGator.COM
Thats what the support said when I opened a ticket through them. Anything I can do to make the query less? |
|
|
| |
|
|
|
|
|
fugly |
|
|
Post subject:
Posted: Jul 15, 2008 - 08:01 AM
|
|
Newbie
Joined: Oct 25, 2006
Posts: 4
Status: Offline
|
|
Smaller log file Pat?
Or ask you host nicely if they can extend the query time for you. |
|
|
| |
|
|
|
|
|
chukibu |
|
|
Post subject: RE: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 15, 2008 - 08:06 AM
|
|
Private
Joined: May 12, 2008
Posts: 23
Status: Offline
|
|
| I use HostGator also. And my main server stopped updating. I've been talking to them for weeks trying to figure it out, supposedly my ultrastats was white listed to last as long as needed. |
|
|
| |
|
|
|
|
|
GeneralPatton |
|
|
Post subject: Re: RE: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 15, 2008 - 06:15 PM
|
|
Priv. First Class
Joined: Feb 04, 2008
Posts: 37
Status: Offline
|
|
chukibu wrote: I use HostGator also. And my main server stopped updating. I've been talking to them for weeks trying to figure it out, supposedly my ultrastats was white listed to last as long as needed.
I contacted them asking about this, they said this...
Hello,
That is not true as the MySQL query killer is ubiquitous to queries. Anything that has been white listed is likely to due with opening the firewall to allow remote connections.
Sincerely,
Devon D.
Level 1 Linux Administrator
HostGator.COM
So I am still at a loss here. Somebody help!  |
|
|
| |
|
|
|
|
|
GeneralPatton |
|
|
Post subject: RE: Re: RE: Re: MySQL Error?! Was reading fine yesterday
Posted: Jul 16, 2008 - 02:52 PM
|
|
Priv. First Class
Joined: Feb 04, 2008
Posts: 37
Status: Offline
|
|
Okay, they white listed my stats so now I am able to update again  |
|
|
| |
|
|
|
|
|
|
Home
Forum
Downloads
News
Neueste Forum Posts
FAQ
Search
Register
Log in to check your private messages
Log in
Maximize
