Zikula Community

• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 03:59 AM

  I have decided to create a new post for this issue. The history of this issue can be found at http://community.zik…-58078-start-75.htm
  
  My web host (HostPapa.com) has suspended my account for TOS violation (excessive resources usage) and sent me the following message.
  
  Your account has been suspended for TOS violation (excessive resources usage) to preventother users on the server from being negatively affected.
  
  PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
  24120 nort7357 18 0 205m 33m 7912 R 97.4 0.4 0:01.06 /usr/bin/php /home/nort7357/public_html/index.php
  23333 nort7357 17 0 204m 32m 7888 R 74.5 0.4 0:00.76 /usr/bin/php /home/nort7357/public_html/index.php
  23305 nort7357 18 0 0 0 0 Z 9.8 0.0 0:01.62 [PHP]
  
  I'm running Zikula 1.2.4 with PHP 5.2.13 and MySQL 5.1.48-log
  
  In a previous forum post, when I was having the same issue with my previous host,

  Code

  <!--[modulestylesheet]-->

  presented itself as a possible culprit. I remember going in and removing every instance of that bit of code. Is there any way that this could have resurfaced after I upgraded?
  
  Also, I do recall that while modifying Blocks, a message from the website popped up that said "No text area found with the given identifier (ID:Blocks)." Could this also be a possible culprit? Would reinstalling Zikula 1.2.4 help or would that just be a waste of time?
  
  If you could let me know what I can do I would appreciate it.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• mazdev
  
  

  • Rank: Softmore
  • Registered: Sep 13, 2010
  • Last visit:
  • Posts: 105

  Posted: Sep 15, 2010 - 05:07 AM

  Sniffer
  safeHTML enabled
  spamfree
  Bad_Behaviour
  MUtransport
  
  could be modules using a lot of resources as they are running many queries on the database.
  
  In your older tread rgasch wrote this:
  
  

  Quote

  I disagree. Zombie processes are crashed processes which can not be recovered by the system. IMHO they are indicative of a bad/buggy PHP installation. No matter what your PHP script does, it should not crash the PHP/http process.
  
  This is similar a buggy application crashing your operating system. Yes, your application may be buggy, but if it crashes the OS, this points to an underlying flaw in the OS ...

  
  
  What he meant is that maybe your host didn't installed his server properly. You should contact your host. Sure Zikula is running a lot database queries, but any server should be able to handle it. So the bug could be with the host.
  
  eg.
  Apache can be a big memory user. Apache runs a number of 'servers' and shares incoming requests among them. The memory used by each server grows, especially when the web page being returned by that server includes PHP or Perl that needs to load in new libraries. It is common for each server process to use as much as 10% of a
  server's memory.
  
  Java processes can often consume more memory than any other application running on a server.
  
  Are you running a spam Assassin 'daemon'? It can create multiple (typically 5) threads/processes and each of those threads can use a very large amount of memory
  
  --
  Carl Georg aka Mazdev
  

  Jerindo.net - Ruminations of an Expat in Indonesia & Webdevelopment

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 05:58 AM

  Sniffer, spamfree, Bad_Behaviour, MUtransport have all been disabled
  safeHTML has been switched to the internal output filter
  I also disabled Medicula since I wasn't using it anymore.
  I'm not running spam Assassin
  
  So here's what I have Active right now:
  
  AboutMe 1.1
  Admin 1.8
  Admin_Messages 2.2
  Blocks 3.6
  Categories 1.1
  content 3.1.0
  cotype 1.0.0
  Errors 1.1
  EZComments 2.0.0
  FAQ 2.3.1
  Formicula 2.2
  Groups 2.3
  Header_Footer 1.1
  ifs 1
  legal 1.2
  Mailer 1.3
  Modules 3.6
  MultiHook 5.2
  MyMap 1.5
  myProfile 2.2
  News 2.6.2
  Newsletter 2.1.0
  ObjectData 1.03
  PageLock 1.1
  Pages 2.4.1
  PendingContent 1.1
  Permissions 1.1
  pnForm 1.1
  pnRender 1.1
  PostCalendar 6.1.0
  PostWrap 2.5
  Profile 1.5.2
  scribite 4.1
  Search 1.5
  SecurityCenter 1.3
  Settings 2.9.1
  SimpleGallery 1.2
  SysInfo 1.1
  Theme 3.3
  Thumbnail 1.2.1
  Topics 1
  Tour 1.2
  UserDeletion 1
  UserPictures 1.1
  Users 1.13
  Workflow 1.1
  
  Legacy Module Support is Off. As is all of the caching options in Theme Options.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• HalbrookTech
  
  

  • Rank: Developer
  • Registered: Dec 31, 1969
  • Last visit: Jun 01, 2010
  • Posts: 6859

  Posted: Sep 15, 2010 - 07:59 AM

  How many users do you have? Could be that your site is just too active for a shared environment.
  
  --
  Home Page | Find on Facebook | Follow on Twitter
  

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 08:06 AM

  A grand total of 36 users, including myself.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 08:24 AM

  Even disabling EZComments didn't help.
  
  The latest from my host:
  
  "There are no improvements.
  Please set up a testing environment on non hostpapa server, we won't be able to assist you with troubleshooting it further."
  
  I have xampp set up on my computer and I'll try downloading everything to see if I can figure it out. What should I use to check the usage?
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• HalbrookTech
  
  

  • Rank: Developer
  • Registered: Dec 31, 1969
  • Last visit: Jun 01, 2010
  • Posts: 6859

  Posted: Sep 15, 2010 - 08:35 AM

  That's the problem, it's gonna be hard to find the culprit in a non-mirror of their environment. How many page views does your site get per day? Are you sure ALL modules are as current as possible?
  
  --
  Home Page | Find on Facebook | Follow on Twitter
  

  • 
  •  
• rgasch
  
  

  • Rank: Team Member
  • Registered: Jan 05, 2003
  • Last visit: May 28, 2010
  • Posts: 776

  Posted: Sep 15, 2010 - 08:35 AM

  Well, the first step is to reproduce the problem. Once you've done that, try figuring out *what* exactly triggers the problem. Then try to determine whether it's PHP or MySql operation which causes the excessive load. Once you know all of this, you can try to fix/improve things.
  
  Greetings
  R

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 08:57 AM

  On average, about 12,000 pageviews, 1,100 uniques, and about 25,000 hits per day.
  The only module that hasn't been updated is PostWrap 2.5 (Incorporate other sites, pages or web apps into your PostNuke site). I could manage to work around it if that was the culprit.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 09:23 AM

  The biggest issue for me is the fact that they've given me until 5:00pm EST to resolve the issue or else they'll take the site down again. It's just frustrating.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 10:13 AM

  This has only been happening since I updated Zikula from 1.1.2 to 1.2.4. The update went smoothly so I'm not sure what could have happened. My host has taken by site down again and I'm still in the process of downloading my site via FTP.
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• rgasch
  
  

  • Rank: Team Member
  • Registered: Jan 05, 2003
  • Last visit: May 28, 2010
  • Posts: 776

  Posted: Sep 15, 2010 - 10:56 AM

  So the first step it to run a load test and see if the you can reproduce the problem. Then when you have the slowdown reproduced, try changing the following in your config.php
  
  

  Quote

  $PNConfig['Debug']['debug'] = 1; //
  $PNConfig['Debug']['pagerendertime'] = 1; // display page render time, 0 to disable
  $PNConfig['Debug']['sql_adodb'] = 0; // adodb debug flag, generates lots of print output
  $PNConfig['Debug']['sql_count'] = 1; // count SQL statements, 0 to disable
  $PNConfig['Debug']['sql_time'] = 1; // time SQL statements, 0 to disable
  $PNConfig['Debug']['sql_detail'] = 1; // collect executed SQL statements, 0 to disable
  $PNConfig['Debug']['sql_data'] = 0; // collect selected data, 0 to disable
  $PNConfig['Debug']['sql_user'] = 0;

  
  
  and then call up a page. On the bottom of the page you'll see gathered SQL info. See if you can identify any exceedingly slow queries. Also, can we see your page somewhere (the main account has been disabled, do you have a mirror)?
  
  Greetings
  R

  • 
  •  
• eledril
  
  

  • Rank: Softmore
  • Registered: Jul 10, 2006
  • Posts: 315

  Posted: Sep 15, 2010 - 10:56 AM

  So... now the FTP has been shut off, I can't finish downloading the site to see what the problem is and I don't know if they're going to turn my account back on so I can turn off my site...
  
  --
  Christopher Pelletier
  NorthumberlandView.ca
  A View Like No Other

  • 
  •  
• mazdev
  
  

  • Rank: Softmore
  • Registered: Sep 13, 2010
  • Last visit:
  • Posts: 105

  Posted: Sep 15, 2010 - 02:44 PM

  Did you do your upgrade on the server? The excessive resource usage could have been during the upgrade.
  
  I recommend doing the upgrade or a new install on your Local machine like xampp (I use Wamp, as I like the possibilty switching my Apache, MySQL and PHP Versions with a click of a button) and later upload everything.
  
  I usually install Zikula with Cpanel/ Fantastico, upload then the other modules and the database.
  
  If you are able to recover all your files, install everything on your local machine and then use the config script mentioned by rgasch. If everything seems ok to you, I would recommend changing your host.
  
  --
  Carl Georg aka Mazdev
  

  Jerindo.net - Ruminations of an Expat in Indonesia & Webdevelopment

  • 
  •  
• craigh
  
  

  • Rank: Developer
  • Registered: Jun 16, 2003
  • Last visit: May 29, 2010
  • Posts: 1966

  Posted: Sep 15, 2010 - 03:15 PM

  It sounds to me like you need a better host. At least one willing to work with you to resolve problems.

  • 
  •  
•  
•  

Users on-line

• eledril

This list is based on users active over the last 60 minutes.