MozillaZine

Unusually persistent SQL error

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

Post Posted May 13th, 2015, 9:15 am


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...
*Always* check the changelogs BEFORE updating that important software!

LIMPET235
Moderator

User avatar
 
Posts: 37481
Joined: October 19th, 2007, 1:53 am
Location: The South Coast of N.S.W. Oz.

Post Posted May 13th, 2015, 9:20 am

Yes. It's happening at random now as well.
Cannot do much but wait 'n' see.
Ancient Amateur Astronomer
Win-7-HP/Intel® DualCore-2.0GHz/500G HDD/4 Gig Ram/550Watt PSU/350WattUPS/Firefox-20.0-50.0-56.0.1/T-bird-2.0.0.24/SnagIt-v10.0.1/MWP-7.11.0.
RadioYachting. Conficker Test. (Always choose the "Custom" Install.)

rsx11m
Moderator
 
Posts: 14415
Joined: May 3rd, 2007, 7:40 am
Location: US

Post Posted May 13th, 2015, 12:07 pm

Same here now, fairly persistent. System load is below 1.0, so can't be that (in theory).

barbaz
 
Posts: 1667
Joined: October 1st, 2014, 3:25 pm

Post Posted May 13th, 2015, 12:10 pm

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:
*Always* check the changelogs BEFORE updating that important software!

rsx11m
Moderator
 
Posts: 14415
Joined: May 3rd, 2007, 7:40 am
Location: US

Post Posted May 13th, 2015, 12:15 pm

Yeah, that may be it - 724 right now. Apparently the load is low given that not all of those requests actually make it... :?

LoudNoise
Moderator

User avatar
 
Posts: 40048
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Post Posted May 13th, 2015, 12:15 pm

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: 1667
Joined: October 1st, 2014, 3:25 pm

Post Posted May 13th, 2015, 12:21 pm

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)...
*Always* check the changelogs BEFORE updating that important software!

LoudNoise
Moderator

User avatar
 
Posts: 40048
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Post Posted May 13th, 2015, 12:24 pm

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: 1667
Joined: October 1st, 2014, 3:25 pm

Post Posted May 13th, 2015, 12:28 pm

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

see PM
*Always* check the changelogs BEFORE updating that important software!

rsx11m
Moderator
 
Posts: 14415
Joined: May 3rd, 2007, 7:40 am
Location: US

Post Posted May 13th, 2015, 12:28 pm

kerz could probably tell from the access logs, or just log into the VM and monitor network connections.

barbaz
 
Posts: 1667
Joined: October 1st, 2014, 3:25 pm

Post Posted May 13th, 2015, 12:31 pm

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)
*Always* check the changelogs BEFORE updating that important software!

rsx11m
Moderator
 
Posts: 14415
Joined: May 3rd, 2007, 7:40 am
Location: US

Post Posted May 13th, 2015, 12:33 pm

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: 1667
Joined: October 1st, 2014, 3:25 pm

Post Posted May 13th, 2015, 12:39 pm

It's creeping back up...
*Always* check the changelogs BEFORE updating that important software!

LoudNoise
Moderator

User avatar
 
Posts: 40048
Joined: October 18th, 2007, 1:45 pm
Location: Next door to the west

Post Posted May 13th, 2015, 12:52 pm

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."

Frank Lion

User avatar
 
Posts: 19360
Joined: April 23rd, 2004, 6:59 pm
Location: ... The Exorcist....United Kingdom

Post Posted May 13th, 2015, 1:34 pm

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.
Metal Lion latest SeaMonkey & Thunderbird Themes - Sea Monkey and Silver Sea Monkey
"The only thing necessary for the triumph of evil, is for good men to do nothing." - Edmund Burke (attrib.)

Return to MozillaZine Site Discussion


Who is online

Users browsing this forum: No registered users and 4 guests