Is this a timeout issue or something different..
jeremy0 Jul 12, 2011 1:56 PMI 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.