Pool Statistics error / Connection leak - Wildfly 10

[Ariel Carrera]

Hi, Im new here, I have a problem while I am testing a jboss quickstart project on Wildfly 10 with the ironjacamar pool.

When I download and run a test project (camel-jpa-binding) from Jboss Switchyard repository and run it in Wildfly 8. The pool is working good, but when I try to run the same application it on Wildfly 10, has a connection leak.

I have debugged the code, put enable statistics and logs.

I see in the logs that the connection was released but in the pool state/statistics still exists the connection in use.

Why even though the entity manager factory is closed, the connection remains on use in the connection pool? What can be the cause of this?

Wildfly 8.1.0.Final 's ironjacamar implemenentation is 1.1.5.Final and Wildfly 10.0.Final 's ironjacamar implemenentation is 1.3.2.Final. Between this versions, does it have critical changes?

Regards,

[Ariel Carrera]

Sorry, when I refer to the "entity manager factory", I wanto to refer to the "entity manager" instead.

[Stefano Maestri]

Hi,

thanks for your interest. Can you provide me few more details about your environment: are you testing the quickstart on a WF10 w/ switchyard installed using the switchyard-installer-wildfly-2.0.0.Final.zip bundle? Or what else? AFAIK switchyard 2.0.0 supports Wildfly 8 not 10. A lot of things are changed from 8 to 10, so the problem could be hide in some compatibility issues.

Anyway as soon I have the full information on your environment I'll try to reproduce the problem myself and I'll get back to you.

regards

S.

[Ariel Carrera]

Hi Stefano, thanks for your reply.

I am trying with switchyard 2.1.0-SNAPSHOT because it has been upgraded to Wildfly 10. By the way, I only have some minor changes into the security module to provide compatibility with Keycloak and Wildfly 10 security because there are some dependencies that has been changed from Wildfly 8 to Wildfly 10 (last year i pushed some changes to the "switchyard project" about it).

I have found a workaround to this problem using a shared entity manager factory (it is not a default configuration to the switchyard camel jpa component but it is possible to do it). But it is extreamly rare what happens when the default configuration is used and I think that it should work like it does in wildfly 8.

In some point, connection is supplied but never is commited/closed/released to the pool again, dying when the timeout happen.

If somebody want I can give an overlay layer for wildfly 10.0.0.Final to reproduce the quickstart project quickly.

My dev environment is composed of:

-Windows 10

-Java 8

-Wildfly 10.0.0.Final

-Switchyard 2.1.0.SNAPSHOT with minor changes

Regards

[Stefano Maestri]

Yes please, provide me the overlay layer, and I'll get a look to the issue.

If it easiest you can activate trace log for ironjacamar and send me the log as first step. Having a reproducer locally would be the best though.

Thanks in advance

S.

--
You received this message because you are subscribed to the Google Groups "IronJacamar Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ironjacamar-us...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ariel Carrera]

Hi Stefano, I talked to Tomaz about it in Wildfly's forum (https://developer.jboss.org/message/959052). He think that can be a problem with switchyard component or something else (camel/spring code).

By the way, I sent you a log file almost complete (I cut some initialization lines that I not considered necessary).

If you also want, I send the overlay so you can give your look why the same code seems to work well in a version of wildfly and not the last.

[Stefano Maestri]

Hi Ariel,

​I agree w/ Tomaz, b​ut if you send me your overlay I can give it a look and (maybe) spot the problem for switchyard guys, and follow up here and on forum post w/ Tomaz

I'm a bit busy those day, I'll give it a look next week at some point. Do you confirm me you have a workaround for this and it's not a blocker for you?

regards

S.

[Ariel Carrera]

Thanks Stefano! Yes, It's not blocker for me, I will send you a link to download the overlay as soon as possible.

Regards!