I am performing scalability tests for my project where a huge number of simultaneous inserts/updates happen. The total number of records considering all the tables together are more than a million records. Though all the these records are not simultaneously being updated/inserted. I set the connection pool size to 500 and I still get errors related to running out of connections. Below is a stack trace.
2003-04-04 23:21:44,821 INFO [org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalConnectionEventListener] Could not enlist XAResource!
javax.transaction.RollbackException: Already marked for rollback
This is turining out to be a show stopper. Any way of getting out of this?
I wrote some multi threaded test programs to access
a whole lot of connections on the server side and jboss
didn't give any errors. While going through the jboss source code according to the stack trace, I noticed that I got this error because of an earlier transaction time out. I guess I will have to play around with the transaction attributes to fix this.