Page 1 of 2
Unusually persistent SQL error
Posted: May 13th, 2015, 9:15 am
by barbaz
Return to index page
General Error
SQL ERROR [ mysql4 ]
User 'mozine_forums_rw' has exceeded the 'max_user_connections' resource (current value: 20) [1226]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB® Forum Software © phpBB Group
I've seen this some before, but it's happening every 3rd link I click now... and it can take up to 3 reloads (and getting worse) to get the actual page I want...
Is this just another George sighting or something more significant?
Just FYI. I suppose I can live with it...
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 9:20 am
by LIMPET235
Yes. It's happening at random now as well.
Cannot do much but wait 'n' see.
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:07 pm
by rsx11m
Same here now, fairly persistent. System load is below 1.0, so can't be that (in theory).
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:10 pm
by barbaz
Just noticed this
Who is online
In total there are 996 users online :: 8 registered, 986 guests (based on users active over the past 1 minute)
Most users ever online was 1683 on 13 May 2015, 02:46
I think that would explain it, no?
sorry about this
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:15 pm
by rsx11m
Yeah, that may be it - 724 right now. Apparently the load is low given that not all of those requests actually make it...
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:15 pm
by LoudNoise
Likely, it seems we are getting hammered by something. The lowest I have seen it today 370 "Guests" and it has gone as high as 1000.
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:21 pm
by barbaz
I probably can't investigate further, but you guys as Mods can click "WHO IS ONLINE" to view where these guests are and what they're doing... and if kerz has allowed you, you also see the IP and user-agent (if not, he can)...
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:24 pm
by LoudNoise
Who is online only lists members (and searchbots), not guests.
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:28 pm
by barbaz
LoudNoise wrote:Who is online only lists members (and searchbots), not guests.
see PM
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:28 pm
by rsx11m
kerz could probably tell from the access logs, or just log into the VM and monitor network connections.
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:31 pm
by barbaz
They got scared...
Who is online
In total there are 90 users online :: 7 registered, 80 guests (based on users active over the past 1 minute)
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:33 pm
by rsx11m
Apparently, found the "Display Guests" function and it gave me something like 3 pages only with IP ranges and UA strings all over the place. Thus, nothing suspicious (at the moment, that is).
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:39 pm
by barbaz
It's creeping back up...
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 12:52 pm
by LoudNoise
Except that almost everyone is "Reading topic in MozillaZine Tech"
Re: Unusually persistent SQL error
Posted: May 13th, 2015, 1:34 pm
by Frank Lion
LoudNoise wrote:Except that almost everyone is "Reading topic in MozillaZine Tech"
That'll be this post -
viewtopic.php?p=14152127#p14152127Nothing else pulls in the punters as good as Frank the Pug.