Due to the fact I have no paid licence of ProGet the kind people of inedo have suggested that the forum might be helpful. I do not know why removing packages to free-up space would cause the database to go wonky. I appreciate any help in this matter.
===What version does this affect?===
ProGet 2023.30 (Inedo Hub)
===Please add any details that might help us help you.===
(500) Server Error
547160FeedPackageVersions_SetAnalysis26`The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FeedPackageAnalyses__FeedPackageVersions". The conflict occurred in database "ProGet", table "dbo.FeedPackageVersions".
For more information, visit the Error Log Page.
---- Error Log page ----
Logged:3/7/2024 4:48:48 PM
Level:Error
Category:Web
Message:An error occurred in the web application: 547160FeedPackageVersions_SetAnalysis26The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FeedPackageAnalyses__FeedPackageVersions". The conflict occurred in database "ProGet", table "dbo.FeedPackageVersions". Details:URL: http://tech-pc:8624/feeds/CCiti-Chocolatey-Feed/chromium/124.0.6343.0-snapshots Referrer: http://tech-pc:8624/packages User: (unknown) User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0 Stack trace: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method) at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) at Inedo.Data.SqlServerDatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters) at Inedo.Data.DatabaseContext.ExecuteNonQuery(String storedProcName, GenericDbParameter[] parameters) at Inedo.ProGet.Feeds.StandardPackageFeed3.GetPackageAnalysisAsync(IStandardPackageMetadata package, Boolean alwaysReanalyze, CancellationToken cancellationToken)
at Inedo.ProGet.Feeds.BrowsablePackageInfo.GetPackageAnalysisAsync(Boolean alwaysReanalyze, CancellationToken cancellationToken)
at Inedo.ProGet.Feeds.BrowsablePackageInfo.GetBlockedMessageForUIAsync()
at Inedo.ProGet.WebApplication.Pages.Packages.FeedUrlProvider.GetDownloadControlAsync(BrowsablePackageInfo package, String url, Object text)
at Inedo.ProGet.WebApplication.Pages.Packages.FeedUrlProvider.NuGetUrlFactory.GetPackageLinksAsync(BrowsableNuGetPackageInfo package, CancellationToken cancellationToken)+MoveNext()
at Inedo.ProGet.WebApplication.Pages.Packages.FeedUrlProvider.NuGetUrlFactory.GetPackageLinksAsync(BrowsableNuGetPackageInfo package, CancellationToken cancellationToken)+System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult()
at System.Linq.AsyncEnumerable.g__Core|424_0[TSource](IAsyncEnumerable1 source, CancellationToken cancellationToken) in //Ix.NET/Source/System.Linq.Async/System/Linq/Operators/ToList.cs:line 36 at System.Linq.AsyncEnumerable.<ToListAsync>g__Core|424_0[TSource](IAsyncEnumerable1 source, CancellationToken cancellationToken) in //Ix.NET/Source/System.Linq.Async/System/Linq/Operators/ToList.cs:line 36
at Inedo.ProGet.WebApplication.Pages.Packages.PackageHeader.InitializeAsync()
at Inedo.Web.Controls.SimplePageControl.InitializeAsync()
at Inedo.Web.Controls.SimplePageControl.InitializeAsync()
at Inedo.Web.PageFree.SimplePageBase.InitializeAsync()
at Inedo.ProGet.WebApplication.Pages.ProGetSimplePage.InitializeAsync()
at Inedo.Web.PageFree.SimplePageBase.ExecutePageLifeCycleAsync()
at Inedo.Web.PageFree.SimplePageBase.ProcessRequestAsync(AhHttpContext context)
at Inedo.Web.AhWebMiddleware.InvokeAsync(HttpContext context)