Mantis - Resin
Viewing Issue Advanced Details
3581 minor always 06-26-09 10:42 01-21-11 15:33
alex  
ferg  
normal  
closed 3.0.25  
fixed  
none    
none  
0003581: java.lang.IllegalStateException: Transactions must have a commit() or rollback() in a finally block
[01:36:08.627] Rolling back dangling transaction. All transactions must
have a commit() or rollback() in a finally block.
[01:36:08.658] java.lang.IllegalStateException: Transactions must have a
commit() or rollback() in a finally block.
[01:36:08.658] at
com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.
java:456)
[01:36:08.658] at
com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProx
y.java:184)
[01:36:08.658] at
com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.ja
va:193)
[01:36:08.658] at
com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.j
ava:229)
[01:36:08.658] at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[01:36:08.658] at
com.caucho.server.port.TcpConnection.run(TcpConnection.java:514)
[01:36:08.658] at
com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[01:36:08.658] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[01:36:08.658] at java.lang.Thread.run(Thread.java:595)
[03:08:00.889] closing pool item from active
timeout:PoolItem[jdbc/oracle,524669,com.caucho.sql.ManagedConnectionImpl
@164ab4
7]
[03:58:09.851] closing pool item from active
timeout:PoolItem[jdbc/oracle,544560,com.caucho.sql.ManagedConnectionImpl
@10d046
3]
[04:14:12.685] closing pool item from active
timeout:PoolItem[jdbc/oracle,549619,com.caucho.sql.ManagedConnectionImpl
@95bc71
]
[04:44:17.987] closing pool item from active
timeout:PoolItem[jdbc/oracle,558129,com.caucho.sql.ManagedConnectionImpl
@1308c5
a]
more info requested
? OS
? JDK Version and build number (can be usually seen in resin's logs, but just in case)
? Database and JDBC Driver version, configuration that's used to acquire connection
? How transactions are started (is it user managed transactions or container managed)
? EJB's participants if any, and what they are (can be as simple as a stateless session bean calls to another session bean which inserts / updates 2 Entity Beans)
? Resource Participants in the transaction, if there are more then one participant (more then one DB, a JMS or a JCA resource)

Notes
(0004088)
alex   
06-26-09 10:52   
Aarthi email-subject: Rolling back dangling transaction
? OS (Solaris 10)
? JDK Version and build number (can be usually seen in resin's logs, but just in case) (1.5.0_16; build 1.5.0_16-b02)
? Database and JDBC Driver version, configuration that's used to acquire connection (Oracle 10g ? 10.2.0.4.0; OCI driver)
? How transactions are started (is it user managed transactions or container managed) (Container managed ? starts off a stateless session bean)
? EJB's participants if any, and what they are (can be as simple as a stateless session bean calls to another session bean which inserts / updates 2 Entity Beans) (stateless session bean calls the container managed entity bean. The entity bean is mapped to the table that gets 4 of its columns updated (table1), and does a SQL to insert into another table (table2). Please note that the SQL insert that happens in a private method in the bean is within a try/catch/finally block and the connection that the application code opens, does get closed.)
? Resource Participants in the transaction, if there are more then one participant (more then one DB, a JMS or a JCA resource) (none)
(0004090)
alex   
06-30-09 15:02   
[10:57:11.606] Rolling back dangling transaction. All transactions must have a commit() or rollback() in a fi
nally block.
[10:57:11.606] begin-local-XA: com.caucho.sql.ManagedConnectionImpl$LocalTransactionImpl@296836a8
[10:57:11.606] allocate PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b]
[10:57:11.607] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.607] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.608] connection pool rollback XA: PoolItem[OracleDS,850031,com.caucho.sql.ManagedConnectionImpl@1f27d605]
[10:57:11.608] connection pool rollback XA: PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b]
[10:57:11.609] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.609] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.610] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.610] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.611] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.612] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.613] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.613] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.615] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.615] JNDI lookup `java:comp/UserTransaction' -> UserTransactionProxy[]
[10:57:11.616] begin-local-XA: com.caucho.sql.ManagedConnectionImpl$LocalTransactionImpl@5114fa96
[10:57:11.616] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee]
[10:57:11.618] idle PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b]
[10:57:11.618] idle PoolItem[OracleDS,850031,com.caucho.sql.ManagedConnectionImpl@1f27d605]
[10:57:11.618] java.lang.IllegalStateException: Transactions must have a commit() or rollback() in a finally block.
[10:57:11.618] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java:456)
[10:57:11.618] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:184)
[10:57:11.618] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:193)
[10:57:11.618] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
[10:57:11.618] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274)
[10:57:11.618] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:514)
[10:57:11.618] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520)
[10:57:11.618] at com.caucho.util.ThreadPool.run(ThreadPool.java:442)
[10:57:11.618] at java.lang.Thread.run(Thread.java:595)
[10:57:11.618] [31] no-keepalive
[10:57:11.618] closing connection TcpConnection[id=resin-tcp-connection-*:8001-63,socket=JniSocketImpl$2070585933[27032400],port=Port[null:8001]], total=134
[10:57:11.619] commit-local: com.caucho.sql
(0004992)
ferg   
01-21-11 15:33   
4.0.14