Shinobi Legends Forum
System => Bugreports => Topic started by: Eric on June 24, 2012, 02:22:52 AM
-
I was RPing in Konoha when suddenly, while I was refreshing, the whole thing hung up!
After trying to load for awhile, and even trying to just plain get back onto the site by re-typing the address in another tab, I got this:
SELECT acctid,name,superuser FROM accounts WHERE locked=0 AND loggedin=1 AND laston>'2012-06-24 00:09:12' ORDER BY level DESC
MySQL server has gone away
Call Stack:
1: db_query("SELECT acctid,name,superu...") called from /var/www/html/naruto/modules/alteredcharlist.php on line 78
2: alteredcharlist_dohook("onlinecharlist", Array()) called from /var/www/html/naruto/lib/modules.php on line 517
3: modulehook("onlinecharlist", Array()) called from /var/www/html/naruto/lib/pageparts.php on line 739
4: charstats() called from /var/www/html/naruto/lib/pageparts.php on line 139
5: page_footer() called from /var/www/html/naruto/home.php on line 144
Had this in my URL for some weird reason: http://www.shinobilegends.com/home.php?
Problem seems fixed though when I removed the question mark.
*I have no idea what happened. I think it was a server lag or something. O.o
-
I reported the exact same error message yesterday through petition. I am not certain what it is but Ace said Neji would look at it.
Anyway, the lags are not over as there was a huge one at the dawning of the new day just a bit ago. I had hoped that it was over.
-
According to the MoTD Google is up to no good. And I think it's up to no good once again. O_O
-
We shall smite google like a thousand bolts of lightning! :twisted:
-
Lightning would actually be a good thing to use... Except it's satellites are beyond lightning's reach. :(
-
D: Solar storms!
-
"Mysql server gone away" is a hint that the workload on the server was quite high.
Do you know how many people were online at that time?
As we are facing quite a few load issues in the last 3 weeks (which part is being heavily crawled by google bots) I might have to look at the new sql server version, too.
-
I don't know how many were online at the time, it's been quite the while... but the next time things start slowing down I'll check the front page to see how many are online.
We may need one of those anti-bot things that require a wierdly shaped code for login. Or maybe a well worded complaint to the search engine?
-
Google wont look at the complaint unless there is a legal notice attached to it.
-
Hopefully better now.
-
No complaints here so far.
-
Happened again.
1:38p.m EST, 33 warriors online when I got the chance to check again.
Quickly got back into game though.
SELECT objid,value AS title FROM module_objprefs WHERE modulename='clanranks' AND objtype='clanranks_title' AND setting='1564' GROUP BY objid;
MySQL server has gone away
Call Stack:
1: db_query("SELECT objid,value AS tit...") called from /var/www/html/naruto/modules/clanranks/func.php on line 41
2: clanranks_getallranks("1564", Array(
0=>"`!Applicant`0", 10=>"`#Member`0", 20=>"`^Officer`0", 30=>"`&Leader`0", 31=>"`$Founder"
)) called from /var/www/html/naruto/modules/clanranks.php on line 52
3: clanranks_dohook("clanranks", Array(
"ranks"=>Array(
0=>"`!Applicant`0", 10=>"`#Member`0", 20=>"`^Officer`0", 30=>"`&Leader`0", 31=>"`$Founder"
), "clanid"=>"1564"
)) called from /var/www/html/naruto/lib/modules.php on line 517
4: modulehook("clanranks", Array(
"ranks"=>Array(
0=>"`!Applicant`0", 10=>"`#Member`0", 20=>"`^Officer`0", 30=>"`&Leader`0", 31=>"`$Founder"
), "clanid"=>"1564"
)) called from /var/www/html/naruto/bio.php on line 60
-
Is it happening on the same page? Or only on that one.
I get only moderate to low load around that time.
-
There is hardly anyone on (relatively) around that time so I was confused too.
Not quite. Both times it happened, if I"m reading the pasted reports right, happened in the clan halls to a degree. ONe when I was checking the listings (as in seeing who is online for either my clan or global), the other more recently occuring on the "view members" section of the clan halls.
It also happened for a shorter time, so I'm even more confused than you are most likely.
-
When the server backups (not around that time) it might cause some database connections to disconnect - something I cannot manage without another server (which would also make the page slower at all non-backup-times).
I'll wait for more info =)
-
SELECT name,CAST((goldinbank+gold+round((((rand()*10)-5)/100)*(goldinbank+gold))) as signed) AS data1 FROM accounts WHERE (locked=0 AND (superuser & 526817) = 0) ORDER BY data1 DESC, level DESC, experience DESC, acctid DESC LIMIT 0,50
BIGINT UNSIGNED value is out of range in '(`naruto`.`accounts`.`goldinbank` + `naruto`.`accounts`.`gold`)'
Call Stack:
1: db_query("SELECT name,CAST((goldinb...") called from /var/www/html/naruto/hof.php on line 108
2: display_table("The richest warriors in t...", "SELECT name,CAST((goldinb...", false, "(Gold Amount is accurate ...", Array(
0=>"Estimated Gold"
), Array(
0=>"gold"
)) called from on line
3: call_user_func_array("display_table", Array(
0=>"The richest warriors in t...", 1=>"SELECT name,CAST((goldinb...", 2=>false, 3=>"(Gold Amount is accurate ...", 4=>Array(
0=>"Estimated Gold"
), 5=>Array(
0=>"gold"
)
)) called from /var/www/html/naruto/hof.php on line 232
-
Thanks, nice catch.
Mysql 5.5 is stricter than 5.1 in some queries ;)