Web appliction is getting hanged.... 2004-07-12 - By Tim Wood
Back
At 09:22 PM 07/11/04, you wrote:
>Hi,
>Im working on WEB Application and server is WAS5.1.
>Im doing load testing on my applciation but unfortunately it failed.
>And the results are also abrupt. Like some times it hanged after 10
>simultaneous request. Some time goes upto 20 users an then hanged.
>The use / work of the tested screen is to insert data in the Oracle 9i
>tables. And no heavy searching is going on. But before inserting it fires a
>select query to check that the data which needs to be inserted is already
>present or not. If not then insert data.
Sounds like a classic deadlock situation; user A selects within a transaction
and sharelocks some tables; user B does his select, then attempts an insert,
which blocks on A's locks. Then A tries the insert and it blocks on B's locks:
deadlock. I say this not knowing the specific locking behavior or how your
Oracle instance is set to handle deadlocks so it could be off the mark. I
would also look at checking for the existing row in the insert qualification,
not a separate select.
TW
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
|
|
