Stimulsoft Connection Leak Issue

[ruen]

Hello,

I have been using Stimulsoft with ASP.NET MVC for some time and have observed a critical issue related to database connections.
(.Net 8 and Stimulsoft.Reports.Web.NetCore 2025.1.5)

When the RequestParameters property of a report is set to false, everything functions as expected. The database connection enters an idle state and is eventually released according to the Connection Idle Lifetime value defined in the connection string.

However, when RequestParameters is set to true, Stimulsoft does not release the database connection—even after the idle timeout period has passed. Upon inspecting active connections via pg_stat_activity in PostgreSQL, I noticed that these connections remain in an idle state indefinitely. Furthermore, each time the user refreshes the report (e.g., by refreshing the iframe), a new connection is opened, and none of the previous ones are closed.

Summary of Observations:
• When RequestParameters = false:
• Connection state is set to idle and is eligible for reuse.
• After the configured idle timeout, the connection is properly closed and removed from the pool.
• When RequestParameters = true:
• Connection state remains idle, but it is never released.
• These connections accumulate over time and cannot be reused.

This behavior causes the connection pool to fill up rapidly. For example, if a user refreshes the page 100 times (assuming a default maximum pool size of 100), the pool limit is reached, and no further reports can be executed.

I would appreciate any guidance or solutions to ensure connections are properly released when using RequestParameters = true.

Note: I fixed this issue with workaround but its a bug.

[Lech Kulikowski]

Hello,

We require some time to investigate the issue thoroughly. Rest assured, we will keep you informed about the outcome as soon as possible.

Thank you.
#18120