Hi, I work with Farrukh :)
The application was indeed not responding as I recall. Also, we do dispatch requests concurrently (WOAllowsConcurrentRequestHandling=true). I wonder if enabling ERXStatisticsStore would give us some useful information.... Daniel Roy [email protected] Software Developer On 2010-04-23, at 12:05 PM, Chuck Hill wrote: > > On Apr 23, 2010, at 12:29 AM, Farrukh Ijaz wrote: > >> Thanks Chuck for your response. >> >> On 2010-04-23, at 1:09 AM, Chuck Hill wrote: >> >>> >>> On Apr 22, 2010, at 2:17 PM, Farrukh Ijaz wrote: >>> >>>> Hi WOGurus, >>>> >>>> 1. We've few applications based on same database structure. What happens, >>>> one of the application after approximately 500 hits gets down. What can be >>>> the reason for that? (I know the question is too broad but would >>>> appreciate for any clues). >>> >>> What does "gets down" mean? Runs out of memory? The JVM process crashes? >>> Deadlocks? >> >> No, memory is not the issue. Instances stop responding and we need to use >> JavaMonitor to stop/start the instance or sometimes when JavaMonitor can't >> perform the operation need to kill the java process. Attached is the stack >> trace. >> >> <stack.txt> > > > I don't see any dead locks there. Was that application not responding when > you captured that? Are you dispatching requests concurrently? > > > >>>> 2. Sometimes the logs show message with Runtime Exception "Statement >>>> running too long" what can be the reason. >>> >>> The statement running too long? Un-optimized or sub-optimal SQL can cause >>> this. Which database? Using Wonder? >>> >> >> I'm sure there are indexes. Can you explain "sub-optimal SQL" in this >> context? We use PostgreSQL and completely dependent on Wonder extensions. > > Different databases optimize SQL differently. Things like sub-selects vs > joins, ANDs vs one IN can make a big difference on some databases. > > Chuck > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their overall > knowledge of WebObjects or who are trying to solve specific problems. > http://www.global-village.net/products/practical_webobjects > > > > > > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/daniel.roy%40fuegodigitalmedia.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
