Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-21 Thread Giulio Speri - MpStyle Srl
Hi Michael, thanks for the suggestions. I think I have something: I added try-catch block around the commit statement within the internal transaction and I find out that at a certain point, a transaction for a page X, goes time out but since that was inside a loop without exiting (that's my

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-20 Thread Michael Brohl
Hi Giulio, are there any other ressources in play except OFBiz and a direct connection to the MariaDB database? Like another database for e.g. audit data or else being part of the XA transaction? It seems that one of the participants of the transaction does not respond during the two phase

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-20 Thread Giulio Speri - MpStyle Srl
Hello Michael, I tried to increase a larger timeout on the parent transaction on the parent transaction, but the result was the same, but I could debug a little bit more the service, and the error is raised in the method commit() of TransactionUtil and searching between all the debug objects I

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-19 Thread Giulio Speri - MpStyle Srl
Hello Michael, thank You for the reply, I will check it for sure. But this bring me another question: if the parent transaction timeout is low, when I resume it, shouldn't it fail with a "Error committing transaction: Transaction has timed out" error? I would expect it. Giulio On Thu, Feb 18,

Re: System error, could not commit transaction XAException (null) on resuming transaction

2021-02-18 Thread Michael Brohl
Hi Giulio, have you checked that the transaction timeout is set high enough for the parent transaction? Regards, Michael Brohl ecomify GmbH - www.ecomify.de Am 17.02.21 um 01:08 schrieb Giulio Speri - MpStyle Srl: Hello everyone, I hope you are all doing well. I write because I am

System error, could not commit transaction XAException (null) on resuming transaction

2021-02-16 Thread Giulio Speri - MpStyle Srl
Hello everyone, I hope you are all doing well. I write because I am facing an exception not so clear to me while writing a Java service. In this service I am using a paged list (EntityUtil.getPagedList(..)) with an iterator object retrieved using delegator.find(..) method, to process and delete