I have a drupal site hosted with site ground and I recieved the following
I was monitoring the server that hosts your account jovialdesigns.com and noticed that your website was consuming a very high percentage of the server resources, thus endangering the overall performance of all the sites on the server. To keep the server at normal CPU load, we had to limit the shared server resources your account may use. This may result in occasional "Resource temporary unavailable" error messages, shown on your website.
I have conducted an investigation and it turned out that one of your scripts spawned too many processes and loops. The processes pile up and increase the server's load to critical limits. Upon further investigation, I found out that a specific script in your account loops and causes the whole problem. The script that references itself is:
http://jovialdesigns.com/files/imagecache/portfolio/
For additional information, you may see the server log below:
209.62.39.14 - - [30/Sep/2007:17:53:07 -0500] "GET /files/imagecache/portfolio/ HTTP/1.0" 200 - "-" "Drupal (+http://drupal.org/)" 209.62.39.14 - - [30/Sep/2007:17:53:07 -0500] "GET /files/imagecache/portfolio/ HTTP/1.0" 200 - "-" "Drupal (+http://drupal.org/)"
So in order to try and resolve the problem i deleted the file location and also deleted the image cache module. I did not remove the module through the admin since my ".htaccess" was put to deny from all as a result of the overload. Rash desicoin no doubt but I was desperate, i even deleted another database, it was actually after i deleted another databass that the .htaccess was cleared but i dont know if that was coincidental
After removing the files I contacted the site support people and recieved this message:
By the time we have logged your case your script spawned more than 10 PHP loop processes + more than 10 slow mysql queries that were runnig for 30+ seconds:
+----------+----------------+-----------+----------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----------+----------------+-----------+----------------+---------+------+-------+------------------+
| 14357533 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 52 | | |
| 14357535 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 47 | | |
| 14357536 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357537 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357540 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357542 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357544 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357546 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357548 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357551 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357552 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357554 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357555 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357556 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 46 | | |
| 14357557 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357558 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357559 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357560 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 11 | | |
| 14357561 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357562 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357564 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 41 | | |
| 14357565 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 45 | | |
| 14357567 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 41 | | |
| 14357568 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 41 | | |
| 14357569 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 41 | | |
| 14357570 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 6 | | |
| 14357572 | jovialde_drpl4 | localhost | jovialde_drpl4 | Sleep | 51 | | |As you know all mysql queries that take more than 1 second are considered as slow and they overheating the CPU and memory resources on the machine.
I need to resole the issue as quickly as possible and one of my addon domains is for a client who is about to have an art show. Her business card references the site So I REALLY need for this to be resolved. Can any one please!!!!! Help me?
Comments
Comment #1
vm commentedare you actuallly using the head release?
I'd think for a production site you should be using the public release and avoiding the head as code there is being actively worked on by the dev/s
Comment #3
j11t commentedNot sure what you mean, Woul you be able to review my script and optimize it?
Comment #4
toma commentedI get the same problem and i get my server down any solution for that ? or we just remove that module!?
Comment #5
dopry commentedCan you explain why you assume this is an infinite loop? Can you provide additionl debugggin details? It seems like the problem is someone is requesting an non-existant file from imagecache... that doesn't look like a complete imagecache url... normally there is a filepath on the end... Have you tried using version 1.3?
Comment #6
dopry commentedComment #7
sfks commentedI'm having semblable problem using 5.x-1.x dev. When imagecache is operating our server consumes a lot of resources.
We have been monitoring the server and we have noticed that the server resources increases using FireFox2, on the other hand, if we navigate with IE7 the resources consumption is stable. If it may help...We are really confused.
Comment #8
decipheredI also get this issue, but only when I upgrade my copy of ImageField 5.x-2.0-rc1 to 5.x-2.0-rc2. I had presumed that the Issue was realted to ImageField not ImageCache, but if others are having the issue with ImageCache then I guess I was wrong.
I posted an Issue on ImageField a while back which can be found at http://drupal.org/node/205782 (as dopry has already seen). I attached a file containing the 690 lines of errors that I finally received after waiting for about 10minutes for my server to finally respond.
I hope this information helps, and I would be more than happy to supply more information if I can.
Edit: Just checked and I'm actually running ImageCache 5.x-2.0-beta, so it may not be the same issue, but the description (which now appears to be missing?? - Edit2: It's back now.) sound's very much like me own issue.
Comment #9
dopry commentedAre you using 2.x or 1.x? I fixed some issues with 2.x that would impact image generation with private files. and initial image generation.
Comment #10
dopry commentedno update.. adios.