M
Hello,
I'm seeing the same issue with ProGet 2023.31 (Build 5). Once the policy preview feature is enabled, every single request to the nuget packages fail with the same error.
Even accessing the web page of a specific version for any nuget package fails.
The error report in this case is:
Message:
An error occurred in the web application: 547`16`0`FeedPackageVersions_SetAnalysis`26`Die INSERT-Anweisung steht in Konflikt mit der FOREIGN KEY-Einschränkung "FK__FeedPackageAnalyses__FeedPackageVersions". Der Konflikt trat in der ProGet-Datenbank, Tabelle "dbo.FeedPackageVersions" auf.
Details:
URL: <nugetfeed>/Stub.System.Data.SQLite.Core.NetFramework/1.0.118
Referrer: <nugetfeed>/Stub.System.Data.SQLite.Core.NetFramework/versions
User: <me>
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36
Stack trace: at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, TaskCompletionSource`1 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.StandardPackageFeed`3.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.<ToListAsync>g__Core|424_0[TSource](IAsyncEnumerable`1 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](IAsyncEnumerable`1 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)
Once the feature is disabled again, everything works fine.
Best regards,
Martin