Server Overflow

Author Message

Mark Gilbert

Friday 02 January 2004 7:44:37 am

Hi

I installed eZ Publish 3.2 - 2 and then upgraded to release 3.2 - 3. When version 3.3-1 came out on Dec 23 I upgraded to it as well.

When trying to run the SQL's to upgrade the database I did get a few errors because of fields that were already in my database. Any way since I upgraded to 3.3 - 1 I have been getting some system overflow issues and my hositng company is not happy about it. The hosting compnay has not been able to trace it. down and neither have I.

Do you have any ideas??

I have not set up the "runcronjob" could that be causing part of the problem? Form the documentation it looks like "runcronjobs" is used for some functions that I am not using (ie notifications and workflows).

Marco Zinn

Friday 02 January 2004 9:32:56 am

Can you be more precise about your "some system overflow issues"?

NOT running the cronjob should not do you any harm.
I think, there is one table ("eznotificationevents" or so), which gets one entry every time one object is published or updates. This is used for the notication system. When you do not run the cronjob, this table will never get emptied. But as long as you don't publish thousands of objects every day, this should be no problem.
Other tables grow faster and bigger.

Marco
http://www.hyperroad-design.com

Mark Gilbert

Friday 02 January 2004 10:40:07 am

I wish I could be more specific. My Hosting company has not been able to trace it down so that we could get more specific. I can tell you that when it happens all the web sites on the server grind to a halt.

I have two web sites on this server - one for development and the other is for production. The only site on the server using eZ is my development site. What happens is you try to access a web page it will never load. The server is so busy proccessing something for eZ that it can not do anything else.

I am not the only one who has a web site on this server. My hosting company is not very happy with me because I brought down all of the other sites on this server as well.

After awhile the server will come back to normal. But as soon as I start accessing a page from the eZ site it starts happening all over again.

Janie Mehew

Monday 05 January 2004 4:41:44 am

I am running 3.2-3 and have been having similar issues. I haven't really tracked down exactly what is causing them but I have shed some light on it. We got kicked off our last host, but all they would say was we were overloading the server with "too many simultaneous SQL queries".

We moved to a new, virtual dedicated server so we could keep a better eye on what is happening. I haven't noticed an inordinate amount of sql queries, but I have noticed that our apache proccesses are rather large (10-15M) and that periodically the server gets overloaded, apache starts to spawn like crazy, the server eats up all its memory and swap space and then it becomes extremely unresponsive. This seems to generally happen just after we've cleared the cache, which makes sense since it has to re-create all the pages and we get quite a few hits.

The only solution we have come up with so far is to throw more memory at it. It was crashing once every few hours at 64 megs of ram, now it has 128 megs and crashes every few days. If it keeps happening we'll throw more memory at it. Generally what I see happening in our case is that apache/php/ezpublish are unable to recover when they've used up the available memory.

Mark Gilbert

Monday 05 January 2004 2:09:32 pm

Hi Janie

I wonder if it has anything to do with template compiling. Do you have yours turned on or off?

I have mine on. But eZ has a comment in the INI file how the Template Compiling is still experimental. I wonder if that has changed? Of if we should look elsewhere for the solution??

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.