Brief description of system environment:
-----------------------------------------
1. Environment: Websphere 5.1, Struts, EJB 2.0, Sun Solaris
2. Database: SQL Server 2000, Windows server 2003
3. Using EJB's CMP and only 1 report using JDBC Call
4. Live condition:
a) Users do data entry : 10 ppls
b) Users using barcode scanners to capture data (via EJB): 3ppls (each trans
action around 100 data scans)
c) Users using barcode scanners to capture data (via web-services - another 
application)

Problems:
----------
1. System slows down for every half/ an hour.

I discovered there was deadlocks happened on both application logs/ database
 logs.

Below are message from websphere:
----------------------------------
[5/6/06 23:06:52:626 SGT]   1b3f1a SystemErr     R 	at com.ibm.CORBA.iio
p.UtilDelegateImpl.mapSystemException(UtilDelegateImpl.java:162)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at com.ibm.CORBA.iio
p.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:684)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at javax.rmi.CORBA.U
til.wrapException(Util.java:277)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.ejb.facade._CutPieceRequestLineFacade_Stub.getAllCutPiece
 RequestLineByCuttingScheduleCutPieceRequ
est(_CutPieceRequestLineFacade_Stub.
java:330)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.delegate.ejb.CutPieceRequestLineEJBDelegateImpl.getAllCut
 PieceRequestLineByCuttingScheduleCutPiec
eRequest(CutPieceRequestLineEJBDeleg
ateImpl.java:150)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.web.actions. CutPieceRequestLineBuyerPOColorSizeListA
ction.execute(
 CutPieceRequestLineBuyerPOColorSizeListA
ction.java:68)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at org.apache.struts
.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[5/6/06 23:06:52:627 SGT]   1b3f1a SystemErr     R 	at org.apache.struts
.action.RequestProcessor.process(RequestProcessor.java:274)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at org.apache.struts
.action.ActionServlet.process(ActionServlet.java:1482)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at org.apache.struts
.action.ActionServlet.doGet(ActionServlet.java:507)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at javax.servlet.htt
p.HttpServlet.service(HttpServlet.java:740)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at javax.servlet.htt
p.HttpServlet.service(HttpServlet.java:853)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:11
0)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:1
74)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
[5/6/06 23:06:52:628 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:11
6)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.ServletInstance.service(ServletInstance.java:283)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceStat
e.java:42)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.ja
va:40)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:76)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.filter.URLAccessFilter.doFilter(URLAccessFilter.java:200)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:132)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:71)
[5/6/06 23:06:52:629 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDisp
atcher.java:1010)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:
592)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:2
04)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.j
ava:71)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.jav
a:182)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
[5/6/06 23:06:52:630 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.webcon
tainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.http.H
ttpConnection.readAndHandleRequest(HttpConnection.java:615)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.http.H
ttpConnection.run(HttpConnection.java:439)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.util.T
hreadPool$Worker.run(ThreadPool.java:912)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R Caused by: java.rmi.R
emoteException:  ; nested exception is:
java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Tr
ansaction (Process ID 64) was deadlocked on lock resources with another proc
ess and has been chosen as the deadlock victim. Rerun the transaction.
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.RemoteExceptionMappingStrategy. mapEJBException(RemoteExceptionMappingSt

rategy.java:379)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.RemoteExceptionMappingStrategy. mapException(RemoteExceptionMappingStrat

egy.java:112)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.RemoteExceptionMappingStrategy. setUncheckedException(RemoteExceptionMap

pingStrategy.java:202)
[5/6/06 23:06:52:631 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.EJSDeployedSupport. setUncheckedException(EJSDeployedSupport
.java:296)
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.ejb.facade. EJSRemoteStatelessCutPieceRequestLineFac
ade_8c
ceab46. getAllCutPieceRequestLineByCuttingSchedu
leCutPieceRequest(EJSRemoteSt
atelessCutPieceRequestLineFacad
e_8cceab46.java:125)
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.ejb.facade._CutPieceRequestLineFacade_Stub.getAllCutPiece
 RequestLineByCuttingScheduleCutPieceRequ
est(_CutPieceRequestLineFacade_Stub.
java:323)
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R 	... 31 more
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R Caused by: java.sql.S
QLException: [IBM][SQLServer JDBC Driver][SQLServer]Transaction 
(Process ID 64) was deadlocked on lock resources with another process and ha
s been chosen as the deadlock victim. Rerun
the transaction.
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.base.BaseExceptions.createException(Unknown Source)
[5/6/06 23:06:52:632 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.base.BaseExceptions.getException(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.processReplyToken(Unknown Sou
rce)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.getRow(Unknown Source)
[5/6/06 23:06:52:633 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.tds.TDSRPCCursorExecuteRequest.fetchNext(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.sqlserver.SQLServerImplResultSetServerSideCursor.next(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbc.base.BaseResultSet.next(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.websphere
.jdbcx.base.BaseResultSetWrapper.next(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.rsadap
ter.cci.WSRdbResultSetImpl.next(WSRdbResultSetImpl.java:3004)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.ejbper
sistence.dataaccess.RawBeanData.next(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.ejbper
sistence.dataaccess.ResultCollectionImpl.processRow(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.ejbper
sistence.dataaccess.AbstractResultCollection.get(Unknown Source)
[5/6/06 23:06:52:634 SGT]   1b3f1a SystemErr     R 	at com.ibm.ws.ejbper
sistence.dataaccess.ResultCollectionIteratorImpl.next(Unknown Source)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultServerImpl.nextPrimaryKey(FinderResultServerImpl.jav
a:930)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultServerImpl.getWrapperBase(FinderResultServerImpl.jav
a:542)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultServerImpl.getNextWrapper(FinderResultServerImpl.jav
a:681)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultClientBase_Local.readAheadNextElement(FinderResultCl
ientBase_Local.java:161)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultClientBase_Local.<init>(FinderResultClientBase_Local
.java:86)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultClientIterator_Local.<init>(FinderResultClientIterat
or_Local.java:46)
[5/6/06 23:06:52:635 SGT]   1b3f1a SystemErr     R 	at com.ibm.ejs.conta
iner.finder.FinderResultClientCollection_Local.iterator(FinderResultClientCo
llection_Local.java:128)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.appservice.CutPieceRequestLineAppServiceImpl.getTotalOthe
 rRequestedQuantity(CutPieceRequestLineAp
pServiceImpl.java:1808)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.appservice.CutPieceRequestLineAppServiceImpl.getRequestSt
atus(CutPieceRequestLineAppServiceImpl.java:1738)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.appservice.CutPieceRequestLineAppServiceImpl.getAllCutPie
 ceRequestLineByCuttingScheduleCutPieceRe
quest(CutPieceRequestLineAppServiceI
mpl.java:870)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.ejb.facade.CutPieceRequestLineFacadeBean.getAllCutPieceRe
 questLineByCuttingScheduleCutPieceReques
t(CutPieceRequestLineFacadeBean.java
:51)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	at com.oceanskyintl.
optimizer.business.ejb.facade. EJSRemoteStatelessCutPieceRequestLineFac
ade_8c
ceab46. getAllCutPieceRequestLineByCuttingSchedu
leCutPieceRequest(EJSRemoteSt
atelessCutPieceRequestLineFacad
e_8cceab46.java:115)
[5/6/06 23:06:52:636 SGT]   1b3f1a SystemErr     R 	... 32 more

Thank you.

Keem

[ Post a follow-up to this message ]