I do have a cluster configured, but I happen to be running only 1 server in it for this test so there is no distributed transaction involved.
Thanks, Matt Cleveland ----- Original Message ----- From: "Igor Fedorenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 5:46 PM Subject: Re: [JBoss-dev] 3.2RC1 Oracle XA Problem > One more thing. I've noticed that you are using HA invoker. Do you have > a clustered configuration? Is there a chance that bean A calls an > instance of bean B from a different node? > > Matt Cleveland wrote: > > I'm running into a problem with Oracle XA in 3.2RC1. I'm asking here > > first because I know there are a bunch of frequent problems with the > > Oracle XA driver and I know some of them are supposed to be fixed in > > 3.2RC1 and I want to see if anyone has experience with this problem. > > > > I have a really simple test. I have a client that starts up N threads. > > Each thread calls bean A. Bean A calls bean B and bean B gets an Oracle > > connection (from an XA pool) and inserts a record into the database and > > then closes the connection and returns. This all works fine under lower > > load, but gets the stack trace below occasionally under heavy load. In > > some cases I then start getting "ORA-01591: lock held by in-doubt > > distributed transaction" on Oracle calls after the error. > > > > I've tried with and without TrackConnectionByTx. My oracle-xa-ds.xml is > > pasted below the stack trace. Is this a bug or am I missing something? > > > > 2003-01-21 21:42:09,141 WARN [org.jboss.tm.TransactionImpl] > > XAException: tx=Tra > > nsactionImpl:XidImpl [FormatId=257, GlobalId=malt//1809, BranchQual=] > > errorCode= > > XAER_RMERR > > oracle.jdbc.xa.OracleXAException > > at > > oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157 > > ) > > at > > oracle.jdbc.xa.client.OracleXAResource.commit(OracleXAResource.java:5 > > 90) > > at > > org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.commit(XAManag > > edConnection.java:140) > > at > > org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:142 > > 0) > > at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:349) > > at > > org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCM > > T.java:361) > > at > > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep > > torCMT.java:247) > > at > > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1 > > 01) > > at > > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor. > > java:130) > > at > > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204) > > at > > org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownIn > > terceptor.java:265) > > at > > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto > > ryFinderInterceptor.java:154) > > at > > org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContai > > ner.java:303) > > at org.jboss.ejb.Container.invoke(Container.java:680) > > at > > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > > at > > org.jboss.invocation.jrmp.server.JRMPInvokerHA.invoke(JRMPInvokerHA.j > > ava:163) > > 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:4 > > 60) > > at > > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport > > .java:701) > > at java.lang.Thread.run(Thread.java:479) > > > > oracle-xa-ds > > ------------------ > > <?xml version="1.0" encoding="UTF-8"?> > > > > <datasources> > > <xa-datasource> > > <jndi-name>XaOracleDS</jndi-name> > > <track-connection-by-tx>true</track-connection-by-tx> > > > > <managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XA OracleManagedConnectionFactory</managedconnectionfactory-class> > > > > <!--xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasou rce-class--> > > <xa-datasource-property > > name="URL">jdbc:oracle:thin@server:port:sid</xa-datasource-property> > > <xa-datasource-property name="User">scott</xa-datasource-property> > > <xa-datasource-property name="Password">tiger</xa-datasource-property> > > <min-pool-size>0</min-pool-size> > > <max-pool-size>50</max-pool-size> > > <blocking-timeout-millis>20000</blocking-timeout-millis> > > <idle-timeout-minutes>15</idle-timeout-minutes> > > </xa-datasource> > > </datasources> > > > > Thanks, > > Matt Cleveland > > -- > Igor Fedorenko > Think smart. Think automated. Think Dynamics. > www.thinkdynamics.com > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Scholarships for Techies! > Can't afford IT training? All 2003 ictp students receive scholarships. > Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. > www.ictp.com/training/sourceforge.asp > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > ------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
