[jboss-user] [Beginner's Corner] - Is this a timeout issue or something different..

[Jeremiah Twidwell]

Jeremiah Twidwell [http://community.jboss.org/people/jeremy0] created the discussion

"Is this a timeout issue or something different.."

To view the discussion, visit: http://community.jboss.org/message/614743#614743

--------------------------------------------------------------
I have an issue with a large delete transaction, on the postgres database there exists quite a bit of data and the query runs long.

I increased the timeout to 15 minutes, however the issue that happens remains the same. (I did this after searching for the error message generated by jboss).  

The error follows:


2011-07-12 11:36:09,223 INFO  [STDOUT] Tue Jul 12 17:36:09 GMT 2011: Begin method BusVolCatTimeSeries.deleteSite()...
2011-07-12 11:36:09,328 INFO  [STDOUT] Tue Jul 12 17:36:09 GMT 2011: BusVolCatTimeSeries.deleteSite() finished.
2011-07-12 11:36:09,328 INFO  [STDOUT] Tue Jul 12 17:36:09 GMT 2011: DeleteCorporateConfiguration.deleteSite() begins...
2011-07-12 11:41:09,202 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_58] - Abort of action id -53ea638d:c83b:4e1c76d2:414 invoked while multiple threads active within it.
2011-07-12 11:41:09,202 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.CheckedAction_2] - CheckedAction::check - atomic action -53ea638d:c83b:4e1c76d2:414 aborting with 1 threads active!
2011-07-12 11:41:10,003 ERROR [STDERR] ******************** DBConnection.makeConnection(07/12/2011 17:41:10:003 GMT -> WFMScheduleActDO:removeAllByAlternates()) Error getting connect java:jdbc/jboss602: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >)
2011-07-12 11:41:10,035 ERROR [STDERR] 07/12/2011 17:41:10:003 GMT -> WFMScheduleActDO.removeAllByAlternates() SQLException.b: (0) Error connecting to java:jdbc/jboss602 Exception: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >)
2011-07-12 11:41:10,036 ERROR [STDERR] java.sql.SQLException: Error connecting to java:jdbc/jboss602 Exception: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -53ea638d:c83b:4e1c76d2:414 status: ActionStatus.ABORTING >)
 
 
 


I hope someone has the answer, I'm out of ideas..  thanks for any assistance.
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/614743#614743]

Start a new discussion in Beginner's Corner at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2075]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110712/71ef91b0/attachment.html