0 Replies Latest reply on Jul 12, 2011 1:56 PM by Jeremiah Twidwell

    Is this a timeout issue or something different..

    Jeremiah Twidwell Newbie

      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.