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&...]