@atripp said in ProGet Diagnostic Center: Delete All Messagses:

TRUNCATE LogMessages

Thank you worked perfectly yes there were a lot of logs.

The NuGet FindPackagesById Query is taking a long time. I would expect this to be every quick?

It is like there is a blocking query as they all clear in one go.

Hi Everyone,

We are running ProGet Version 2022.30 (Build 5) we have multiple feeds on our server mostly NPM and NuGet public connector feeds. We are getting exceptions on our ProGet server in the event log with the following:

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.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

On the diagnostic centre we are also getting errors with the following:

An error occurred processing a GET request to https://XXX/nuget/WTG-Internal/v3/index.json: 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.

Request URL: https://www.nuget.org/api/v2/FindPackagesById()?id='microsoft.net.sdk.macos.manifest-6.0.400.msi.x64'&semVerLevel=2.0.0
System.Net.WebException: The operation has timed out.

The SQL Server we are running on is SQL 2016 Enterprise Server with 2TB of RAM. The database has allow snapshot isolation and read committed snapshot enabled. What is happening is the server starts to return 503 service unavailable when the above starts happening. We have attempted to set the Max Pool's in the connection string which has not helped and the Web.NuGetRequestLimit. It appears that maybe the NPM feed could be causing this issue as well.

Regards Scott

Hi Forum,

We are attempting to delete all of the error messages in ProGet Version 2022.30 (Build 5). The actual delete fails with a timeout. We can see the POST on IIS for the delete and it is running but it always times out. Any advice would be great?

Regards Scott