Error while commiting transaction

[Vincent Fiot]

Hi everyone,

I'm using wildfly-25.0.1.Final.

In some external applications, we are using RemoteUserTransaction.

Sometimes, we have an exception:

This is exception trace in the application, and the exception in server.log of WildFly can be find in the attached file "server.log".

Is someone has an idea of the issue?

Best regards

[Manuel Finelli]

Hi Vincent, I believe I could assist you better if I had more context. Could you please provide a reproducer? This could be a git repository or a zip file containing a WildFly configuration that reproduces your environment, along with all the necessary commands to reproduce the exception you reported. Thank you!

--
You received this message because you are subscribed to the Google Groups "WildFly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wildfly+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/2b8c0c42-caf8-44a0-bd08-2e18f5edcd86n%40googlegroups.com.

[Vincent Fiot]

Hi Manuel,

We are using a private application on WildFly, so I cannot provide any reproducer.

I'll try to explain the most the architecture.

On WildFly, we have our own application. This app is using SQL Server as database.

To import/export data into this application, we have external applications, using private API.

It's within those external applications that we have sometimes transactions exceptions.

Here is an example of code, using transactions:

Here is the code for "getTransaction()" method:

Sometimes, for any reason, an exception occured when the method "commit(transaction)" is called (please see previous attachment and server.log files).

Here is the code for commit() method:

Let me know if you see something, or need more information.

Best Regards

[Michael Musgrove]

From my cursory glance at the stack trace, it shows that the remote end has rolled it back so when you try to commit it at your end you get the error since it cannot be committed twice.

I would check your timeouts and also look at the logs in the "remote peer" to get its view of why it rolled it back. Remark, the code that  issues the rollback will be WildFly Transaction Client.

To view this discussion on the web visit https://groups.google.com/d/msgid/wildfly/214182cf-49d9-4bf5-957b-cd223bedf9a3n%40googlegroups.com.

--

Michael Musgrove

mmus...@redhat.com

JBoss, by Red Hat
Registered Address: Red Hat Ltd, 6700 Cork Airport Business Park, Kinsale Road, Co. Cork.
Registered in the Companies Registration Office, Parnell House, 14 Parnell Square, Dublin 1, Ireland, No.304873
Directors:Michael Cunningham (USA), Vicky Wiseman (USA), Michael O'Neill, Keith Phelan, Matt Parson (USA)

[Vincent Fiot]

Hi,

I set up 900 as timeout.

Where can I find the "remote peer" logs ?

[Vincent Fiot]

Hi everyone,

Just before the server transaction error, here is the stack I got:

2023-09-06 10:02:24,970 WARN  [org.infinispan.transaction.impl.TransactionTable] (blocking-thread--p8-t7) ISPN000100: Stopping, but there are 1 local transactions and 0 remote transactions that did not finish in time

Any idea ?