Base solution for your next web application
Open Closed

Connection leaks because of Background Jobs in postgresql: Latest version (ASPNET 13.2,0) #12070


User avatar
0
epicadmin created

Background Jobs are consuming connections and keeping them in an "idle in transaction" state, leading to exhausted database connections.

<br> <br> When the application is idle for more than 10mins and if we perform any action after that we are getting below error message in API.

When we verify the DB, the connections are exhausted.

When we further investigated, we see Background Job manager is opening connections and not closing them.

<br> NPGSQL : 8.0.4 .NET 8 PostgresSQL Version 13.0


1 Answer(s)
  • User Avatar
    0
    m.aliozkaya created
    Support Team

    Hi @epicadmin,

    The problem is resolved in the next version. If you have an emergency regarding the issue, you can fix it in your project based on the pr.

    https://github.com/aspnetboilerplate/aspnetboilerplate/issues/6950