Unusually persistent SQL error

Talk about stuff specific to the site -- bugs, suggestions, and of course praise welcome.
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Unusually persistent SQL error

Post 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...
User avatar
LIMPET235
Moderator
Posts: 39956
Joined: October 19th, 2007, 1:53 am
Location: The South Coast of N.S.W. Oz.

Re: Unusually persistent SQL error

Post by LIMPET235 »

Yes. It's happening at random now as well.
Cannot do much but wait 'n' see.
[Ancient Amateur Astronomer.]
Win-10-H/64 bit/500G SSD/16 Gig Ram/450Watt PSU/350WattUPS/Firefox-115.0.2/T-bird-115.3.2./SnagIt-v10.0.1/MWP-7.12.125.

(Always choose the "Custom" Install.)
rsx11m
Moderator
Posts: 14404
Joined: May 3rd, 2007, 7:40 am
Location: US

Re: Unusually persistent SQL error

Post by rsx11m »

Same here now, fairly persistent. System load is below 1.0, so can't be that (in theory).
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Re: Unusually persistent SQL error

Post 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 :oops:
rsx11m
Moderator
Posts: 14404
Joined: May 3rd, 2007, 7:40 am
Location: US

Re: Unusually persistent SQL error

Post 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... :?
User avatar
LoudNoise
New Member
Posts: 39900
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Re: Unusually persistent SQL error

Post 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.
Post wrangler
"Choose between the Food Select Feature or other Functions. If no food or function is chosen, Toast is the default."
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Re: Unusually persistent SQL error

Post 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)...
User avatar
LoudNoise
New Member
Posts: 39900
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Re: Unusually persistent SQL error

Post by LoudNoise »

Who is online only lists members (and searchbots), not guests.
Post wrangler
"Choose between the Food Select Feature or other Functions. If no food or function is chosen, Toast is the default."
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Re: Unusually persistent SQL error

Post by barbaz »

LoudNoise wrote:Who is online only lists members (and searchbots), not guests.

see PM
rsx11m
Moderator
Posts: 14404
Joined: May 3rd, 2007, 7:40 am
Location: US

Re: Unusually persistent SQL error

Post by rsx11m »

kerz could probably tell from the access logs, or just log into the VM and monitor network connections.
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Re: Unusually persistent SQL error

Post 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)
rsx11m
Moderator
Posts: 14404
Joined: May 3rd, 2007, 7:40 am
Location: US

Re: Unusually persistent SQL error

Post 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).
barbaz
Posts: 1504
Joined: October 1st, 2014, 3:25 pm

Re: Unusually persistent SQL error

Post by barbaz »

It's creeping back up...
User avatar
LoudNoise
New Member
Posts: 39900
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Re: Unusually persistent SQL error

Post by LoudNoise »

Except that almost everyone is "Reading topic in MozillaZine Tech"
Post wrangler
"Choose between the Food Select Feature or other Functions. If no food or function is chosen, Toast is the default."
User avatar
Frank Lion
Posts: 21178
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom
Contact:

Re: Unusually persistent SQL error

Post by Frank Lion »

LoudNoise wrote:Except that almost everyone is "Reading topic in MozillaZine Tech"

That'll be this post - viewtopic.php?p=14152127#p14152127

Nothing else pulls in the punters as good as Frank the Pug.
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)
.
Post Reply