Kurt De Pauw Posted January 15, 2016 Share Posted January 15, 2016 After the update to the last version I have several problems The forum is extremely SLOW, and I say SLOOOOOWWWWW So slow that 9 of 10 times is get an error 504 Gateway Time-out nginx I have a VPS (not some shared hosting ) with 8 GB memory so .... that is not a problem Also sometimes the forum just stops working completely and throws me the error message An error occurred (500 Error) We're sorry, but a temporary technical error has occurred which means we cannot display this site right now. You can try again by clicking the button below, or try again later. Try again When I then go to the /admin URL I got below URL Quote admin/?adsess=samt8kv8v8cdd5bihji5ksqju1&app=core&module=system&controller=login&error=Too+many+connections&ref= then after some time it just works again .... I must say ... IPS has done a great job on the new look of the board and although I can't find anything anymore in the adminCP , I really like it. But the performance is just not that .... I can't imagine that I need to upgrade my VPS just by changing version. Regards, Kurt Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 You'd have to hunt down what is causing this in the first place. Might be a configuration error as-well. My site(s) are hosted on a 2GB VPS (4x3.3GHz/2x3.1GHz 2VPS' for different sites) and are pretty fast. Ram usage is ~900MB. Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 15, 2016 Author Share Posted January 15, 2016 LOL ( well actually it is not fun anymore ) Just when I post this message I have it again An error occurred (500 Error) We're sorry, but a temporary technical error has occurred which means we cannot display this site right now. You can try again by clicking the button below, or try again later. Try again Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 Check server logs (nginx). Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 15, 2016 Author Share Posted January 15, 2016 Is there somewhere in the new adminCP the option to do some checks .... like we'd have before in 3.X So I can see the errors there .... although not possible to access it due to the error Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 Other than running the support tool, no. But it does all the checks as-well (AFAIK). Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 15, 2016 Author Share Posted January 15, 2016 Okay ... just tried to open the PLESK to connect to the Server and I get below error ERROR: Zend_Db_Adapter_Exception: SQLSTATE[08004] [1040] Too many connections (Abstract.php:144) and this one ERROR: PleskDBException: Unable to connect to database: mysql_connect(): Too many connections (Error code: 1040) (Abstract.php:69) It will be indeed something to do with the connections to the SQL , but on the other hand it looks like that the upgrade changed something how it handels these connections or my forum just magically increased by users :-) Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 Might be a DoS attack maybe? Seen it before. Again, would have to check logs to see what is causing this Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 15, 2016 Author Share Posted January 15, 2016 changed the SQL connection to 500 :-) for now --> there was a max of 251 connections. set global max_connections = 500; Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 2 minutes ago, Kurt De Pauw said: changed the SQL connection to 500 :-) for now set global max_connections = 500; Not the best long-term solution but I guess it's fine for a temporary workaround. Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 15, 2016 Author Share Posted January 15, 2016 High MySQL usage Link to comment Share on other sites More sharing options...
Ahmad E. Posted January 15, 2016 Share Posted January 15, 2016 Yup, but you need to figure out what caused this. It's very unlikely that visitors increased so fast. Link to comment Share on other sites More sharing options...
bassangler Posted January 15, 2016 Share Posted January 15, 2016 What version of MySQL are you using? PHP version? Link to comment Share on other sites More sharing options...
tnn Posted January 16, 2016 Share Posted January 16, 2016 @Kurt De Pauw Did you optimize the database? With phpmyadmin what I do is optimize, then run a repair, then optimize again. I don't think that will cure it but it's something to look at for starters Link to comment Share on other sites More sharing options...
Marcher Technologies Posted January 16, 2016 Share Posted January 16, 2016 I actually had something similar happen working on something for a client, try turning *off* prefetching in your browser. Specifically, if you are using FireFox, it makes a literal ton of connections during normal browsing by default: https://support.mozilla.org/en-US/kb/how-stop-firefox-making-automatic-connections I mention this as I haven't seen another browser be this aggressive in prefetching by default, and it is so aggressive it will trigger a block from any sane CSF config. Link to comment Share on other sites More sharing options...
tnn Posted January 16, 2016 Share Posted January 16, 2016 And here's a tibit of information regarding the "ERROR: PleskDBException" http://talk.plesk.com/threads/error-pleskdbexception-unable.335861/ Link to comment Share on other sites More sharing options...
Kurt De Pauw Posted January 16, 2016 Author Share Posted January 16, 2016 i can now see for the last 24h that all is normal .... well the usage of the sql process is higher then version 3.4 but it is normal Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.