lubosl Posted September 25, 2012 Share Posted September 25, 2012 Hi, I'm facing problem with server overload message: The application has reached reserved amount of server's systemresources. Please contact server administrator. This message appears is some customer is creating order and other customers are watching page content. Error message appears even on page are 3 connections only. Do you have some idea if the problem can come from prestashop configuration? Thanks for your help. Regards, Lubos Link to comment Share on other sites More sharing options...
vekia Posted September 25, 2012 Share Posted September 25, 2012 Hi, I'm facing problem with server overload message: This message appears is some customer is creating order and other customers are watching page content. Error message appears even on page are 3 connections only. Do you have some idea if the problem can come from prestashop configuration? Thanks for your help. Regards, Lubos Problem isn't with prestashop but your server configuration. in reference to the number of visits your store - the server is too weak for such traffic. Tthere is also the possibility that you have disabled the cache, force compile enable or poorly written modules. Check performance tab in back office to turn on cache and turn off force compile Link to comment Share on other sites More sharing options...
lubosl Posted September 25, 2012 Author Share Posted September 25, 2012 Problem isn't with prestashop but your server configuration. in reference to the number of visits your store - the server is too weak for such traffic. Tthere is also the possibility that you have disabled the cache, force compile enable or poorly written modules. Check performance tab in back office to turn on cache and turn off force compile Hi vekia, for sure is not a problem of: turn on cache and turn off force compile The shop is running in this configuration form begining. I already contacted Web hosting provider, but he is only offering to me transfer to virtual server and of course pay more money... Link to comment Share on other sites More sharing options...
vekia Posted September 25, 2012 Share Posted September 25, 2012 Hi vekia, for sure is not a problem of: The shop is running in this configuration form begining. I already contacted Web hosting provider, but he is only offering to me transfer to virtual server and of course pay more money... What is the specification of your hosting? You have a big store? How big is the shop database? And how about number of visits or users online? Link to comment Share on other sites More sharing options...
lubosl Posted September 25, 2012 Author Share Posted September 25, 2012 (edited) What is the specification of your hosting? You have a big store? How big is the shop database? And how about number of visits or users online? Total disk space 15GB Servers connectivity: SIX 10 Gbps, NIX 10 Gbps, tranzit 1 Gbps HTML, XHTML, VRML, Flash, SSI, Javascript support Scripting support PHP 4, 5, 5.3 Scripting support ASP Scripting support ASP.NET 1.1 - 4.0 Scripting support CGI, Perl Support WAP (scripts WML) TurckMMCache, eAccelerator, Zend, ionCube Support .htaccess & mod_rewrite WebCron (automatic scripts execution) Disk quota for web pages 4GB MySQL, PostgreSQL support SQLite databases support Max. numbers of databases MySQL, PostgreSQL - 5 Disk quota for databases 7GB - Current Database size: 16390.8MB (quite big, not?) - Online max 10 visitors at the same moment, but the problem is occuring even 3 visitors are online Edited September 25, 2012 by lubosl (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted September 25, 2012 Share Posted September 25, 2012 16390.8MB omg! I think that the database affects on server overload Link to comment Share on other sites More sharing options...
lubosl Posted September 25, 2012 Author Share Posted September 25, 2012 (edited) 16390.8MB omg! I think that the database affects on server overload what to do? I'm not a DB expert.... pls HELP! ---- update: I log in to my phpMyAdmin and found that DB size is 16,0MB not 16GB... so it will be not a DB problem.... Edited September 25, 2012 by lubosl (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted September 25, 2012 Share Posted September 25, 2012 Hello, thank you for the message. A16 MB DB should not cause a server to overload. However, this is definitely a server side issue. Who is your hosting provider? What is making the server overload?? Maybe you can ask your hosting provider to investigate the situation. 1 Link to comment Share on other sites More sharing options...
modules Posted September 25, 2012 Share Posted September 25, 2012 Hello, thank you for the message. A16 MB DB should not cause a server to overload. However, this is definitely a server side issue. Who is your hosting provider? What is making the server overload?? Maybe you can ask your hosting provider to investigate the situation. exactly. 16 mb is ok. In last post he said that his database weight about 16GB I think exactly the same as you, problem is with some server side issues 1 Link to comment Share on other sites More sharing options...
lubosl Posted September 26, 2012 Author Share Posted September 26, 2012 so I discuss with the hosting provider and I did not get exact explanation why problem occured, only some possible reasons like: - database backup (did not do) - running scripts which are no need - running statistics with host resolving (is off) - wrongly tuned php scripts and I got recomandation to check scripts which are running most frequently. Also they noticed that server is able to cover 300 standard presentations without protection activation... how to check scripts which are running most frequently? LL Link to comment Share on other sites More sharing options...
lubosl Posted October 2, 2012 Author Share Posted October 2, 2012 Hi, do somebody know how many system resources is consuming backoffice? Is it possible that problem will occure only during time when I'm logged in BO? THX Lubos Link to comment Share on other sites More sharing options...
benjamin utterback Posted October 2, 2012 Share Posted October 2, 2012 Dear lubosl, I think the best way would be contact your Hosting Provider again about this. PrestaShop is not a large software and should not be giving your Server an overload. You should also ask your hosting provider to increase your memory_limit setting in your php.ini file. Link to comment Share on other sites More sharing options...
lubosl Posted October 3, 2012 Author Share Posted October 3, 2012 OK let me check, Thank you for your answers. Lubos Link to comment Share on other sites More sharing options...
lubosl Posted October 3, 2012 Author Share Posted October 3, 2012 (edited) Guys, as much I'm studying this problem with server overload, I'm more and more sure it is the prestashop problem... if some customer will start to place new order in step 2, I found this in access log repeated more than 700x this from the same IP address: "GET /order.php?step=2 HTTP/1.1" 302 xxxxx "http://xxx/order.php" "Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB7.4)" This is probably causing server overload. If you will add another customers who are browsing web pages it will crash down for sure. But why this is repeating??? PLS HELP! Edited October 3, 2012 by lubosl (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted October 3, 2012 Share Posted October 3, 2012 Hello lubosl, that access log report, even when repeated more than 700x from the same IP, should not cause any server overload, if that was happening with thousands of people at the same time, then maybe. It seems like a redirection loop most likely. These are still "server side" issues I can suggest to do do a test install on a subdomain and see if it reacts the same way. Link to comment Share on other sites More sharing options...
lubosl Posted October 4, 2012 Author Share Posted October 4, 2012 Dear lubosl, I think the best way would be contact your Hosting Provider again about this. PrestaShop is not a large software and should not be giving your Server an overload. You should also ask your hosting provider to increase your memory_limit setting in your php.ini file. Hello Benamin, Regarding the memory limit, reply from provider is: Memory limit is aprox. 200-250 MB for php. Link to comment Share on other sites More sharing options...
lubosl Posted October 4, 2012 Author Share Posted October 4, 2012 Hello lubosl, that access log report, even when repeated more than 700x from the same IP, should not cause any server overload, if that was happening with thousands of people at the same time, then maybe. It seems like a redirection loop most likely. These are still "server side" issues I can suggest to do do a test install on a subdomain and see if it reacts the same way. Provider sent me some details about the overload. He says is about CPU timing, in every 10min CPU time is set for 200sec. If this time is reached protection will be activated. Normaly the timing is 0,4 - 4sec. I did not mention is shared server for more domains, not only one. So can be related to redirection loops? How to check / improve? many thanks! Link to comment Share on other sites More sharing options...
lubosl Posted October 7, 2012 Author Share Posted October 7, 2012 Found this: I have same problem. Unofficial solution is here: open file controllers/OrderController.php and delete line 110 ($this->_assignAddress() After deleting everything will work. can be related to my problem?? LL Link to comment Share on other sites More sharing options...
phrasespot Posted October 7, 2012 Share Posted October 7, 2012 - Current Database size: 16390.8MB (quite big, not?) 16390.8MB omg! Too right. A16 MB DB should not cause a server to overload. Re-read it. It is a 16GB database, not 16MB. A shop with about 100K products with as many sales and customers should not even reach 1GB. There is some serious bloat with your DB. That is probably stats, visits, pages, carts that have been accumulating during its operation. Find someone qualified to help you to clean it. That should go a long way in restoring sane performance. Link to comment Share on other sites More sharing options...
lubosl Posted October 8, 2012 Author Share Posted October 8, 2012 Too right. Re-read it. It is a 16GB database, not 16MB. A shop with about 100K products with as many sales and customers should not even reach 1GB. There is some serious bloat with your DB. That is probably stats, visits, pages, carts that have been accumulating during its operation. Find someone qualified to help you to clean it. That should go a long way in restoring sane performance. Hello phrasespot, The DB is 16MB. I posted correction. This was a problem on web service provider side. I was checking on web administration page and the information about DB size was 16GB. But when I connect to DB admin I found DB size is 16MB. I pointed this problem to web service provider and he made correction to his admin page. So no problem with DB size. Is 16MB and this is correct. L. Link to comment Share on other sites More sharing options...
modules Posted October 20, 2012 Share Posted October 20, 2012 you've solved this issue? Link to comment Share on other sites More sharing options...
shallowsleep Posted November 9, 2012 Share Posted November 9, 2012 can they solved this i have this problem too with version 1.3.1 Link to comment Share on other sites More sharing options...
giasemis Posted November 15, 2012 Share Posted November 15, 2012 I face the same issue. I am using prestashop 1.4.9 and the store has 70.000 products, since I increase number of products I face server overload problem twice a day. I assume search or updating product cause the error but I don;t have a clue why any suggestions? Link to comment Share on other sites More sharing options...
giasemis Posted November 15, 2012 Share Posted November 15, 2012 We have to restart MySQL in order store start working again every time. Below are Mysql queries from the last time server was overloaded, Any suggestions much appreciated Thank you | 224172 | giasemis_sbay | localhost | giasemis_sbay | Query | 17183 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 224175 | giasemis_sbay | localhost | giasemis_sbay | Query | 17183 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 224177 | giasemis_sbay | localhost | giasemis_sbay | Query | 17182 | Sending data | SELECT p.*, pl`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 224181 | giasemis_sbay | localhost | giasemis_sbay | Query | 17182 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl | | 224182 | giasemis_sbay | localhost | giasemis_sbay | Query | 17182 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 224185 | giasemis_sbay | localhost | giasemis_sbay | Query | 17181 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cllink_rewrite crewrite, pl.link_rewrit | | 224186 | giasemis_sbay | localhost | giasemis_sbay | Query | 17181 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 224188 | giasemis_sbay | localhost | giasemis_sbay | Query | 17180 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 224204 | giasemis_sbay | localhost | giasemis_sbay | Query | 17178 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 224207 | giasemis_sbay | localhost | giasemis_sbay | Query | 17178 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 277251 | giasemis_sbay | localhost | giasemis_sbay | Query | 3170 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277252 | giasemis_sbay | localhost | giasemis_sbay | Query | 3170 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 277254 | giasemis_sbay | localhost | giasemis_sbay | Query | 3170 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277255 | giasemis_sbay | localhost | giasemis_sbay | Query | 3170 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 277256 | giasemis_sbay | localhost | giasemis_sbay | Query | 3170 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277282 | giasemis_sbay | localhost | giasemis_sbay | Query | 3160 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277369 | giasemis_sbay | localhost | giasemis_sbay | Query | 3132 | Sending data | SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 277379 | giasemis_sbay | localhost | giasemis_sbay | Query | 3128 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277383 | giasemis_sbay | localhost | giasemis_sbay | Query | 3128 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 277416 | giasemis_sbay | localhost | giasemis_sbay | Query | 3120 | Sending data | SELECT DISTINCT pid_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrit | | 277417 | giasemis_sbay | localhost | giasemis_sbay | Query | 3120 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 285128 | giasemis_sbay | localhost | giasemis_sbay | Query | 1040 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 285129 | giasemis_sbay | localhost | giasemis_sbay | Query | 1040 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 285130 | giasemis_sbay | localhost | giasemis_sbay | Query | 1040 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl. | | 287070 | giasemis_sbay | localhost | giasemis_sbay | Query | 562 | Sending data | SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl | Link to comment Share on other sites More sharing options...
nish Posted November 15, 2012 Share Posted November 15, 2012 We are having very similar issue on a dedicated server with 4GB RAM, every now and then, server overlaod happends 4-5 times per day dpending on traffic. Anyone has found why this is happening on some servers ? 1 Link to comment Share on other sites More sharing options...
giasemis Posted November 15, 2012 Share Posted November 15, 2012 From the queries it seems like that searching function is crashing the server Link to comment Share on other sites More sharing options...
giasemis Posted November 16, 2012 Share Posted November 16, 2012 As a solution I put the smallest search string to be at least 5 chars in the BO --> preference --> search so far we didn't experienced server overload Link to comment Share on other sites More sharing options...
nish Posted November 16, 2012 Share Posted November 16, 2012 (edited) my CPU usage is high and it is poting to category.php file ? I am using Prestashio 1.4.9 and tried every possible solution suggested on the forum still no luck, any help or suggestion is much appreciated ? Thank you Edited November 16, 2012 by nish (see edit history) Link to comment Share on other sites More sharing options...
wonderland-wigs Posted November 16, 2012 Share Posted November 16, 2012 Hay GUYS, when will you be looking at my high CPU problem? Link to comment Share on other sites More sharing options...
phrasespot Posted November 19, 2012 Share Posted November 19, 2012 Hay GUYS, when will you be looking at my high CPU problem? Zero point in making the same post multiple times and wasting people's time. Link to comment Share on other sites More sharing options...
Recommended Posts