Re: Instance gets down after approx 500 hits; Database backup; Connection pooling with Single Database Context
Re: Instance gets down after approx 500 hits; Database backup; Connection pooling with Single Database Context
- Subject: Re: Instance gets down after approx 500 hits; Database backup; Connection pooling with Single Database Context
- From: Chuck Hill <email@hidden>
- Date: Fri, 23 Apr 2010 09:05:20 -0700
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden