Bugs item #588608, was opened at 2002-07-30 11:20
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=588608&group_id=22866

Category: JBossServer
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Joe Simone (jsimone)
Assigned to: Nobody/Anonymous (nobody)
Summary: transaction deadlock with 2 same clients

Initial Comment:
OS:  WinXP Pro
JDK:  1.3.1_04-b02

NOTE:  session facade has transaction 
attributes "RequiresNew" and all the entity beans 
behind the facade have "Required".   Client only calls 
the session facade remote interface.

This happes with 2 clients running side-by-side against 
a local JBoss server 3.0.0 final.  One client dies, the 
other lives.  This happens using eith Hypersonic DB or 
IBM DB2 as the CMP 2.0 persistence store.

All beans are Container managed.  Below is the console 
stack trace.

    [java] java.rmi.ServerException: RemoteException 
occurred in server thread; nested exception is:
    [java] createCourses(2) ...

    [java]     java.rmi.ServerException: application 
deadlock detected; nested exception is:
    [java] getCoursesAll() ...
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] Embedded Exception
    [java] application deadlock detected; nested 
exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected; nested exceptio
is:
    [java]     
javax.ejb.TransactionRolledbackLocalException: 
application deadlock detected; nested exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] Embedded Exception
    [java] application deadlock detected; nested 
exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] java.rmi.ServerException: application deadlock 
detected; nested exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] Embedded Exception
    [java] application deadlock detected; nested 
exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected; nested exceptio
is:
    [java]     
javax.ejb.TransactionRolledbackLocalException: 
application deadlock detected; nested exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] Embedded Exception
    [java] application deadlock detected; nested 
exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] 
javax.ejb.TransactionRolledbackLocalException: 
application deadlock detected; nested exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] Embedded Exception
    [java] application deadlock detected; nested 
exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java]     at 
sun.rmi.transport.StreamRemoteCall.exceptionReceived
FromServer(StreamRemoteCall.java:240)
    [java]     at 
sun.rmi.transport.StreamRemoteCall.executeCall
(StreamRemoteCall.java:215)
    [java]     at sun.rmi.server.UnicastRef.invoke
(UnicastRef.java:117)
    [java]     at 
org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invok
e(Unknown Source)
    [java]     at 
org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.i
nvoke(JRMPInvokerProxy.java:128)
    [java]     at 
org.jboss.invocation.InvokerInterceptor.invoke
(InvokerInterceptor.java:108)
    [java]     at 
org.jboss.proxy.TransactionInterceptor.invoke
(TransactionInterceptor.java:73)
    [java]     at org.jboss.proxy.SecurityInterceptor.invoke
(SecurityInterceptor.java:76)
    [java]     at 
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke
(StatelessSessionInterceptor.java:111)
    [java]     at org.jboss.proxy.ClientContainer.invoke
(ClientContainer.java:76)
    [java]     at $Proxy1.getCoursesAll(Unknown Source)
    [java]     at 
com.highnotes.ebu.client.util.GenerateSampleData.creat
eAll(GenerateSampleData.java:93)
    [java]     at 
com.highnotes.ebu.client.test.Stress_1.main
(Stress_1.java:92)
    [java] 
javax.transaction.TransactionRolledbackException: 
application deadlock detected; nested exception is:
    [java]     
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java] 
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
    [java]     <<no stack trace available>>




Below is the server.log error ...




2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDeleteRelationsCo
mmand.SpeakerEJB] Rows affected = 3
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.SessionEJB] Executing SQL: DELETE FROM 
SESSION WHERE ID=?
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.SessionEJB] Remove: Rows affected = 1
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDeleteRelationsCo
mmand.SpeakerEJB] Executing SQL: DELETE FROM 
SESS_SPKR_LINK WHERE (SPEAKER_ID=? AND 
SESSION_ID=?) OR (SPEAKER_ID=? AND 
SESSION_ID=?) OR (SPEAKER_ID=? AND 
SESSION_ID=?) OR (SPEAKER_ID=? AND 
SESSION_ID=?)
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCDeleteRelationsCo
mmand.SpeakerEJB] Rows affected = 4
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.SessionEJB] Executing SQL: DELETE FROM 
SESSION WHERE ID=?
2002-07-30 10:42:27,027 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.SessionEJB] Remove: Rows affected = 1
2002-07-30 10:42:27,047 ERROR 
[org.jboss.ejb.BeanLock] Application deadlock 
detected: TransactionImpl:XidImpl [FormatId=257, 
GlobalId=BJSLAP//2686, BranchQual=] has deadlock 
conditions
2002-07-30 10:42:27,057 ERROR 
[org.jboss.ejb.plugins.LogInterceptor] 
TransactionRolledbackException, causedBy:
org.jboss.ejb.plugins.lock.ApplicationDeadlockException
: application deadlock detected
        at 
org.jboss.ejb.plugins.lock.BeanLockSupport.deadlockDe
tection(BeanLockSupport.java:193)
        at 
org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.
waitForTx(QueuedPessimisticEJBLock.java:281)
        at 
org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.d
oSchedule(QueuedPessimisticEJBLock.java:188)
        at 
org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.s
chedule(QueuedPessimisticEJBLock.java:149)
        at 
org.jboss.ejb.plugins.EntityLockInterceptor.invoke
(EntityLockInterceptor.java:103)
        at 
org.jboss.ejb.plugins.EntityCreationInterceptor.invoke
(EntityCreationInterceptor.java:69)
        at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:96)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:167)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:61)
        at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:129)
        at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:166)
        at org.jboss.ejb.EntityContainer.invoke
(EntityContainer.java:493)
        at 
org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.in
voke(BaseLocalContainerInvoker.java:296)
        at 
org.jboss.ejb.plugins.local.EntityProxy.invoke
(EntityProxy.java:38)
        at $Proxy52.getName(Unknown Source)
        at 
com.highnotes.ebu.enrollment.eventmanager.EventMana
gerBean.copyCoursesToDataObjects
(EventManagerBean.java:166)
        at 
com.highnotes.ebu.enrollment.eventmanager.EventMana
gerBean.getCoursesAll(EventManagerBean.java:637)
        at java.lang.reflect.Method.invoke(Native 
Method)
        at 
org.jboss.ejb.StatelessSessionContainer$ContainerInter
ceptor.invoke(StatelessSessionContainer.java:664)
        at 
org.jboss.resource.connectionmanager.CachedConnecti
onInterceptor.invoke
(CachedConnectionInterceptor.java:186)
        at 
org.jboss.ejb.plugins.StatelessSessionInstanceIntercept
or.invoke(StatelessSessionInstanceInterceptor.java:77)
        at 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:96)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransacti
ons(TxInterceptorCMT.java:242)
        at 
org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:61)
        at 
org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:129)
        at org.jboss.ejb.plugins.LogInterceptor.invoke
(LogInterceptor.java:166)
        at 
org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
        at org.jboss.ejb.Container.invoke
(Container.java:705)
        at 
org.jboss.mx.server.MBeanServerImpl.invoke
(MBeanServerImpl.java:491)
        at 
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke
(JRMPInvoker.java:362)
        at java.lang.reflect.Method.invoke(Native 
Method)
        at sun.rmi.server.UnicastServerRef.dispatch
(UnicastServerRef.java:236)
        at sun.rmi.transport.Transport$1.run
(Transport.java:147)
        at java.security.AccessController.doPrivileged
(Native Method)
        at sun.rmi.transport.Transport.serviceCall
(Transport.java:143)
        at 
sun.rmi.transport.tcp.TCPTransport.handleMessages
(TCPTransport.java:460)
        at 
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.r
un(TCPTransport.java:701)
        at java.lang.Thread.run(Thread.java:479)
2002-07-30 10:42:27,057 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma
nd.CourseEJB] Executing SQL: SELECT ID,NAME, 
NUMBER, DESCRIPTION, ABSTRACT, LEVEL, 
OBJECTIVES, DURATION, FORMAT FROM COURSE 
WHERE (ID=?) OR (ID=?)
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.CourseEJB] Executing SQL: UPDATE COURSE 
SET TRACK_ID=? WHERE ID=?
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.CourseEJB] Rows affected = 1
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.CourseEJB] Executing SQL: UPDATE COURSE 
SET TRACK_ID=? WHERE ID=?
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.CourseEJB] Rows affected = 1
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.TrackEJB] Executing SQL: DELETE FROM 
TRACK WHERE ID=?
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCom
mand.TrackEJB] Remove: Rows affected = 1
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCom
mand.CourseEJB] Executing SQL: SELECT 
COURSE_ID, AUDIENCE_ID FROM COUR_AUD_LINK 
WHERE (COURSE_ID=?) OR (COURSE_ID=?)
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCom
mand.CourseEJB] Executing SQL: SELECT 
COURSE_ID, ID FROM MATERIAL WHERE 
(COURSE_ID=?) OR (COURSE_ID=?)
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCom
mand.CourseEJB] Executing SQL: SELECT 
COURSE_ID, ID FROM SESSION WHERE 
(COURSE_ID=?) OR (COURSE_ID=?)
2002-07-30 10:42:27,067 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma
nd.SessionEJB] Executing SQL: SELECT ID,NUMBER, 
DAY_OFFSET, TIME_SLOT, ROOM_CAPACITY, 
ROOM_NAME FROM SESSION WHERE (ID=?) OR 
(ID=?)
2002-07-30 10:42:27,077 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.SessionEJB] Executing SQL: UPDATE SESSION 
SET COURSE_ID=? WHERE ID=?
2002-07-30 10:42:27,077 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.SessionEJB] Rows affected = 1
2002-07-30 10:42:27,077 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.SessionEJB] Executing SQL: UPDATE SESSION 
SET COURSE_ID=? WHERE ID=?
2002-07-30 10:42:27,077 DEBUG 
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityComma
nd.SessionEJB] Rows affected = 1


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=588608&group_id=22866


-------------------------------------------------------
This sf.net email is sponsored by: Dice - The leading online job board
for high-tech professionals. Search and apply for tech jobs today!
http://seeker.dice.com/seeker.epl?rel_code=31
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to