Dumping leak connections in WildFly with IronJacamar

[bonanzaone]

Hi

After configuring IronJacamar to dump leak connections information, the "leaks.txt" file is nowhere to be found. I am using WildFly 10.1, and database is MySQL.

I am following IronJacamar documentation: http://www.ironjacamar.org/doc/userguide/1.2/en-US/html_single/index.html#configuration_ironjacamar_leakpool

According to the documentation:

The leak detector pool provides a stack trace of the leaked connection allocation either during shutdown of the pool, or once the pool is flush using a flush strategy which kills all active connections.

The steps I took was configure IronJacamar to use the leak pool:

"JAVA_OPTS=%JAVA_OPTS% -Dironjacamar.mcp=org.jboss.jca.core.connectionmanager.pool.mcp.LeakDumperManagedConnectionPool -Dironjacamar.leaklog=d:/leaks.txt"

After leaking some connections with a mock application, using CLI I've flushed all connections in the pool:

[standalone@localhost:9990 /] /subsystem=datasources/data-source=mysql-ds:flush-all-connection-in-pool

But the "leaks.txt" file is not being generated. Also stopping and starting the server did not generate the file.

What could be wrong? Am I missing any step?

[andey]

Hi,

Configure the following system properties

~~~

-Dironjacamar.mcp=org.jboss.jca.core.connectionmanager.pool.mcp.LeakDumperManagedConnectionPool

-Dironjacamar.leaklog=<filename>

~~~

These may be configured in various ways including the following:

- Add the properties to <JBOSS_HOME>/bin/<standalone|domain>.<sh|bat>

- Add the properties to the <system-properties> section of the<standalone|domain>.xml`

A stack trace for all connections still retained by application components will be written to the file specified when any of the following occur

EAP is shutdown

The relevant datasource pool is restarted

The relevant datasource pool is flushed using flush-all-connection-in-pool

Note that this action will terminate all connections including those which may have on-going operations initiated by application components

The Administration and Configuration Guide's discussion of the Java Connector Architecture (JCA) at[1]

The IronJacamar User's Guide's discussion of Pool Configuration at[2]

[1]https://access.redhat.com/documentation/en-US/JBoss_Enterprise_Application_Platform/6.4/html-single/Administration_and_Configuration_Guide/index.html#Java_Connector_Architecture_JCA

[2]http://www.ironjacamar.org/doc/userguide/1.2/en-US/html/ch04.html#configuration_ironjacamar_leakpool

[bonanzaone]

Please, check my question again. I already did those steps. I want to know why it is not working.

[spatwary04]

I am trying to generate the leak file on wildlfy 10.0 but not successful.Followed the same steps  as mentioned in the post.

[bonanzaone]

Shiva you might be able to workaround it using this post I made: https://stackoverflow.com/a/42809241/3231778

But the problem still happens, the file is still not generated. I have opened a bug in JIRA: [JBJCA-1360] Dumping leak connections in WildFly with IronJacamar not Working - JBoss Issue Tracker