Forum crpas outut quite often
Moderatore: Gurus
Forum crpas outut quite often
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
Reporting Bugs
Where tags are stored
Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig
Re: Forum crpas outut quite often
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.
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,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts
Re: Forum crpas outut quite often
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
Reporting Bugs
Where tags are stored
Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig
-
olivechicago
- Messaggi: 58
- Iscritto il: sab ott 26, 2013 11:57 am
Forum SQL errors
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
Just a heads up. I've never encountered this over the three or four years I've been a member here until recently
Ultima modifica di Lowlander il lun gen 08, 2018 1:24 pm, modificato 1 volta in totale.
Motivazione: Merged with existing post
Motivazione: Merged with existing post
-
MMuser2011
- Messaggi: 1308
- Iscritto il: lun ott 17, 2011 8:28 am
Re: Forum SQL errors
I see the same SQL error result occasionally too, accessing the website from Central Europe.
I got this two minutes ago (21:50 MEZ)
I got this two minutes ago (21:50 MEZ)
Codice: Seleziona tutto
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.3.3 (2018-10-03) last free version ● 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.4.9 (2018-10-03) last free version
● ExternalTools v1.4 (2011-05-09) ● iTunesMonkey 1.0 + Acoustid
● Calculate Cover Size v1.7 (2012-10-23) ● RegExp Find & Replace v4.4.9 (2018-10-03) last free version
Re: Forum crpas outut quite often
Any news on this yet as I'm constantly having to wait a few minute between opening pages.Peke ha scritto: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.
I keep getting this error.

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
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012
Re: Forum crpas outut quite often
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.
Re: Forum crpas outut quite often
Hi,
Do you still observe SQL errors and how often?
Do you still observe SQL errors and how often?
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts
Re: Forum crpas outut quite often
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
Reporting Bugs
Where tags are stored
Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig
Re: Forum crpas outut quite often
They appear to be less often now.Peke ha scritto:Hi,
Do you still observe SQL errors and how often?
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
MM 4.1.21.1871 Portable on External Hdd
TESTING MM 5.0.0.2113
Numerous Addons
User Since 2006 (Lifetime License) since 2012
Re: Forum crpas outut quite often
Hi,
Great, we changes some SQL server settings, limits and filters so it should be better.
Now we wait and collect statistics.
Great, we changes some SQL server settings, limits and filters so it should be better.
Now we wait and collect statistics.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying



How to attach PICTURE/SCREENSHOTS to forum posts