[JBoss-user] [Persistence,JBoss/CMP, Hibernate, Database] - How to prevent ApplicationDeadlockException with READ-ONLY m

[aparaapara <nu...@jb...>]

I am running jboss 3.2.7 on Linux.

I have examined my application and marked all read-only method with a tag (=
in jboss.xml):

<method-attributes>
 =20
    <method-name>get*</method-name>
    <read-only>true</read-only>
 =20
</method-attributes>

I also added similar tags for is* and any other read-only operations.  I ha=
ve added these to the Remote Session and Local Entity objects.

But I am still getting ApplicationDeadlockException during what should be r=
ead-only operations.  To avoid multiple SELECT statements from the database=
, I am using standard Requires or Supports TX attributes as far as standard=
 J2EE is concerned. =20

Can someone help me understand or tell me how to trace this issue?  What el=
se should I check? =20

Here is the exception which I get:

06:36:50,406 ERROR [LogInterceptor] TransactionRolledbackLocalException in =
method: public abstract boolean com.myprofiles.model.profile.ProfileEntity.=
isPrivateProfile(), causedBy:
org.jboss.util.deadlock.ApplicationDeadlockException: Application deadlock =
detected, resource=3Dorg.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock@3b=
5a5b, bean=3DProfile, id=3Dcom.standardset.ejb.common.base.EntityKey@311dac=
f id: 65581, refs=3D4, tx=3DTransactionImpl:XidImpl [FormatId=3D257, Global=
Id=3Dcp//14782, BranchQual=3D], synched=3DThread[http-0.0.0.0-8080-Processo=
r49,5,jboss], timeout=3D5000, queue=3D[TXLOCK waitingTx=3DTransactionImpl:X=
idImpl [FormatId=3D257, GlobalId=3Dcp//14786, BranchQual=3D] id=3D0 thread=
=3DThread[http-0.0.0.0-8080-Processor39,5,jboss] queued=3Dtrue, TXLOCK wait=
ingTx=3DTransactionImpl:XidImpl [FormatId=3D257, GlobalId=3Dcp//14784, Bran=
chQual=3D] id=3D0 thread=3DThread[http-0.0.0.0-8080-Processor2,5,jboss] que=
ued=3Dtrue], holder=3DTransactionImpl:XidImpl [FormatId=3D257, GlobalId=3Dc=
p//14788, BranchQual=3D], waitingResource=3Dorg.jboss.ejb.plugins.lock.Queu=
edPessimisticEJBLock@1ef5dfc, bean=3DPictureValue, id=3Dcom.standardset.ejb=
.common.base.EntityKey@311de71 id: 65671, refs=3D2, tx=3DTransactionImpl:Xi=
dImpl [FormatId=3D257, GlobalId=3Dcp//14773, BranchQual=3D], synched=3Dnull=
, timeout=3D5000, queue=3D[TXLOCK waitingTx=3DTransactionImpl:XidImpl [Form=
atId=3D257, GlobalId=3Dcp//14782, BranchQual=3D] id=3D0 thread=3DThread[htt=
p-0.0.0.0-8080-Processor37,5,jboss] queued=3Dtrue], waitingResourceHolder=
=3DTransactionImpl:XidImpl [FormatId=3D257, GlobalId=3Dcp//14773, BranchQua=
l=3D]
=09at org.jboss.util.deadlock.DeadlockDetector.deadlockDetection(DeadlockDe=
tector.java:48)
=09at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.waitForTx(QueuedP=
essimisticEJBLock.java:301)
=09at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(Queued=
PessimisticEJBLock.java:236)
=09at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.schedule(QueuedPe=
ssimisticEJBLock.java:183)
=09at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockIntercep=
tor.java:85)
=09at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreation=
Interceptor.java:54)
=09at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte=
rceptor.java:84)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep=
torCMT.java:343)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1=
50)
=09at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.=
java:111)
=09at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
=09at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto=
ryFinderInterceptor.java:122)
=09at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:484=
)
=09at org.jboss.ejb.Container.invoke(Container.java:709)
=09at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalPro=
xyFactory.java:419)
=09at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:44)
=09at $Proxy171.isPrivateProfile(Unknown Source)
=09at com.myprofiles.model.security.SecuritySessionBean.assertMemberCanSeeC=
omponent(SecuritySessionBean.java:272)
=09at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
=09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sorImpl.java:25)
=09at java.lang.reflect.Method.invoke(Method.java:324)
=09at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(S=
tatelessSessionContainer.java:683)
=09at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo=
ke(CachedConnectionInterceptor.java:186)
=09at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat=
elessSessionInstanceInterceptor.java:72)
=09at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte=
rceptor.java:84)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep=
torCMT.java:343)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1=
50)
=09at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.=
java:111)
=09at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
=09at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto=
ryFinderInterceptor.java:122)
=09at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessi=
onContainer.java:331)
=09at org.jboss.ejb.Container.invoke(Container.java:709)
=09at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalPro=
xyFactory.java:419)
=09at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSes=
sionProxy.java:83)
=09at $Proxy211.assertMemberCanSeeComponent(Unknown Source)
=09at com.myprofiles.service.component.MemberComponentServiceBean.getPictur=
eComponentData(MemberComponentServiceBean.java:624)
=09at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source)
=09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sorImpl.java:25)
=09at java.lang.reflect.Method.invoke(Method.java:324)
=09at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(S=
tatelessSessionContainer.java:683)
=09at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invo=
ke(CachedConnectionInterceptor.java:186)
=09at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(Stat=
elessSessionInstanceInterceptor.java:72)
=09at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInte=
rceptor.java:84)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep=
torCMT.java:317)
=09at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1=
50)
=09at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.=
java:111)
=09at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
=09at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto=
ryFinderInterceptor.java:122)
=09at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessi=
onContainer.java:331)
=09at org.jboss.ejb.Container.invoke(Container.java:709)
=09at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
=09at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces=
sorImpl.java:25)
=09at java.lang.reflect.Method.invoke(Method.java:324)
=09at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.=
java:60)
=09at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
=09at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
=09at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
=09at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.=
java:198)
=09at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
=09at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
=09at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerIntercepto=
r.java:115)
=09at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.jav=
a:101)
=09at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.=
java:46)
=09at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:5=
5)
=09at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessi=
onInterceptor.java:100)
=09at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86)
=09at $Proxy218.getPictureComponentData(Unknown Source)
=09at com.myprofiles.client.web.picture.PictureAction.execute(PictureAction=
.java:75)
=09at org.apache.struts.action.RequestProcessor.processActionPerform(Reques=
tProcessor.java:484)
=09at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja=
va:274)
=09at org.apache.struts.action.ActionServlet.process(ActionServlet.java:148=
2)
=09at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
=09at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
=09at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
=09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:252)
=09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF=
ilterChain.java:173)
=09at com.standardset.web.filter.JBossTomCatPrincipalFilter.doFilter(JBossT=
omCatPrincipalFilter.java:114)
=09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:202)
=09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF=
ilterChain.java:173)
=09at com.standardset.web.filter.UserLoginTriggerFilter.doFilter(UserLoginT=
riggerFilter.java:134)
=09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:202)
=09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF=
ilterChain.java:173)
=09at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi=
lter.java:75)
=09at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl=
icationFilterChain.java:202)
=09at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF=
ilterChain.java:173)
=09at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV=
alve.java:214)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard=
ContextValve.java:198)
=09at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV=
alve.java:152)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc=
ipalValve.java:66)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit=
yAssociationValve.java:162)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica=
torBase.java:462)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j=
ava:137)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j=
ava:118)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:=
535)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:102)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal=
ve.java:109)
=09at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv=
eContext.java:104)
=09at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav=
a:520)
=09at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
=09at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16=
0)
=09at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java=
:799)
=09at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce=
ssConnection(Http11Protocol.java:705)
=09at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java=
:577)
=09at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP=
ool.java:684)
=09at java.lang.Thread.run(Thread.java:534)


View the original post : http://www.jboss.org/index.html?module=3Dbb&op=3Dv=
iewtopic&p=3D3888662#3888662

Reply to the post : http://www.jboss.org/index.html?module=3Dbb&op=3Dpostin=
g&mode=3Dreply&p=3D3888662