Application stops working after 1-2 days #12142

gekko created 3 months ago

Hello, we have an application using ASP.NET CORE MVC & jQuery. It is hosted on Azure AppService (Windows), and also the database is on Azure. Recently we updated from dotnet 6 to dotnet 8, with your version 13.2.0 . After we pushed the update to Azure, the application is crashing after ca. 2 days. We have to restart the Application to get it running again. From the log we can see that it cannot connect to the Host database when the issue occurs.

ERROR 2024-08-28 19:09:41,023 [19 ] .EntityFrameworkCore.Database.Connection - An error occurred using the connection to database 'Host' on server 'xxx'. WARN 2024-08-28 19:09:41,041 [19 ] Abp.BackgroundJobs.BackgroundJobManager - System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exception e)

In the forum we found other people having same or similar problems: https://support.aspnetzero.com/QA/Questions/12096/API-Application-Crashing-Randomly https://support.aspnetzero.com/QA/Questions/12003/Site-stopped-working-after-every-1-2-days As considered in these similar issues, we already checked if all our Abp Nuget Packages are > 6.4, they are on version 9.2.2 in all projects in the solution.

1 Answer(s)