Forum crpas outut quite often

Community forum for discussions completely unrelated to MediaMonkey.

Moderator: Gurus

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Forum crpas outut quite often

Post by dtsig » Sat Dec 02, 2017 9:20 pm

Regardless number of users I have been getting a lot of "SQL too many connections" messages. For example I just spent the last couple of minutes trying to get to this message. It says I am the only user and 0 guests
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

Peke
Posts: 11201
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: Forum crpas outut quite often

Post by Peke » Tue Dec 05, 2017 10:31 pm

Hi,
In some cases "SQL too many connections" error is caused by some badly written Index BOT script which manifest itself as "SQL too many connections" that can be normal SQL server response to DDOS calls or being classified as such. As a result like you pointed it can happen that few minutes pass till normal traffic re established.

We are monitoring such cases and actively working on prevention and system upgrade.
Best regards,
Pavle
MediaMonkey lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add Images to forum

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Re: Forum crpas outut quite often

Post by dtsig » Wed Dec 06, 2017 10:40 am

Thanks man .. great response
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

olivechicago
Posts: 52
Joined: Sat Oct 26, 2013 11:57 am

Forum SQL errors

Post by olivechicago » Fri Jan 05, 2018 12:42 am

I don't visit this forum on a daily or even weekly basis, so maybe this isn't all that new. Over the past week or so I'm often getting phpBB errors. I can screen cap if needed. Something about too many connections. Refreshing several times, I can usually continue using this site within a minute.

Just a heads up. I've never encountered this over the three or four years I've been a member here until recently
Last edited by Lowlander on Mon Jan 08, 2018 1:24 pm, edited 1 time in total.
Reason: Merged with existing post

MMuser2011
Posts: 1225
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Forum SQL errors

Post by MMuser2011 » Fri Jan 05, 2018 8:34 am

I see the same SQL error result occasionally too, accessing the website from Central Europe.

I got this two minutes ago (21:50 MEZ)

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB® Forum Software © phpBB Group 
Magic Nodes v4.2 (2011-07-01) SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.3 (2011-07-06)

popsmike
Posts: 172
Joined: Thu Oct 05, 2006 11:02 am
Location: Hull,UK

Re: Forum crpas outut quite often

Post by popsmike » Sat Jan 20, 2018 4:55 pm

Peke wrote:Hi,
In some cases "SQL too many connections" error is caused by some badly written Index BOT script which manifest itself as "SQL too many connections" that can be normal SQL server response to DDOS calls or being classified as such. As a result like you pointed it can happen that few minutes pass till normal traffic re established.

We are monitoring such cases and actively working on prevention and system upgrade.
Any news on this yet as I'm constantly having to wait a few minute between opening pages.
I keep getting this error.

Image
Windows 10 Pro x64 2TB USB3 External Hdd with Quad Core 3600Mhz CPU and 10GB Ram
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012

pushpull
Posts: 225
Joined: Mon Aug 14, 2006 9:01 pm
Location: Formerly WNY, now Portlandia
Contact:

Re: Forum crpas outut quite often

Post by pushpull » Sun Feb 04, 2018 10:01 pm

I have discovered that when this happens to me, if I go to the home MM web page and use the forum link there I am able to get right onto the forum page without any issue.

Peke
Posts: 11201
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: Forum crpas outut quite often

Post by Peke » Sun Feb 04, 2018 10:33 pm

Hi,
Do you still observe SQL errors and how often?
Best regards,
Pavle
MediaMonkey lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add Images to forum

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Re: Forum crpas outut quite often

Post by dtsig » Mon Feb 05, 2018 11:16 am

For me ..it is less often
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

popsmike
Posts: 172
Joined: Thu Oct 05, 2006 11:02 am
Location: Hull,UK

Re: Forum crpas outut quite often

Post by popsmike » Mon Feb 05, 2018 2:46 pm

Peke wrote:Hi,
Do you still observe SQL errors and how often?
They appear to be less often now.
Windows 10 Pro x64 2TB USB3 External Hdd with Quad Core 3600Mhz CPU and 10GB Ram
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012

Peke
Posts: 11201
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: Forum crpas outut quite often

Post by Peke » Tue Feb 06, 2018 8:29 am

Hi,
Great, we changes some SQL server settings, limits and filters so it should be better.

Now we wait and collect statistics.
Best regards,
Pavle
MediaMonkey lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add Images to forum

Post Reply