[Zope] Fwd: [Zope-DB] HEEELP! my zope has become virtually unusable

[Charlie Clark]

On 2003-04-02 at 21:13:15 [+0200], Tena Sakai wrote:
> Folks,
> 
> My zope (Zope-2.5.1-solaris-2.6-sparc) has become virtually unusable.
> 
> The peculiar behavior is that it takes forever to respond.  Maybe that 
> doesn't sound peculiar enough?  Please read on.
> 
> It has been going on for sometime, but last a day or so it became 
> unbearably slow.  The problem appears that it is unable to update icons 
> on client machines.  This morning, I stop'ed and (re-)start'ed it on the 
> server and when I logged on from a browser (mozilla) it gave me an 
> authentication dialog prompt instantly, but then the it took 17+ minutes 
> for the right-hand side window to get painted.  (It worried me sick!)  
> The left-hand side window (where it lists the "file structure" 
> iconically), I don't even know how long it took, but eventually it 
> finished showing icons.
> 
> I was watching Z2.log file in var directory (via "tail -f") and it showed 
> nothing at all for those 17+ minutes.  (I redirected start log and there 
> is nothing peculiar in it.)  And all of a sudden, the icons got painted 
> on the client machine and I noticed that a bunch of lines got into Z2.log 
> file.  The server load is very low, load average is in the neighborhood 
> of 0.02.  As I tried to "open" a folder from left-hand side window by 
> click- ing on a plus sign, it stalled again.  I stopped the request from 
> browser's stop button and then clicked on reload; it was able to show me 
> contents of that folder (instantly).  This "trick" has worked in the 
> past, except last a day or so it refused to cooperate.  I have tried with 
> mozilla as well as IE, but they seem to have the same behavior.  I have 
> tried things from different clients; there is little difference.
> 
> I want to point a finger at network because that's one place I have no 
> control.  (Sorry about this unacceptable trait of mine:)  But the usual 
> stuff (ping, telnet, ftp, etc) to and from the server all work.
> 
> Now I am able to go to /control_Panel/Database.  In fact, I am looking at 
> info under Cache Parameters tab:
>       Total number of objects in the database: 10561
>       Total number of objects in all caches: 2294
>       Target size: 400
>       Target max time between accesses: 60
> 
> Do they (bottom two, in particular) look reasonable?  Please tell me what 
> they mean or what they should be like.  And what are the units on these?  
> MB, KB?, seconds?, miliseconds?
> 
> Sorry for being verbose, but I am trying to put things on the table as 
> much as possible now.
> 
> Thank you.
> 
> Tena Sakai (tena.sakai.b@bayer.com)
> 
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db