1. Home
  2. Categories
  3. Support
  4. Database Error

Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Database Error

  • R

    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)

    0 atripp 1 Reply
  • atripp
    inedo-engineer

    Hi @redbaron2_9872 ,

    This error is unrelated to removing packages.

    Based on the stack trace, it's coming from the Package Policies Preview Feature that was introduced in ProGet 2023.30. Not sure exactly how that's possible, but that code should not be running unless the feature was enabled under Admin > Policies.

    Please let us know if that was the source of the error.

    Best,
    Alana

    0
  • V

    Hi,

    I got the same error, after disabling the preview feature it works again.

    An error occurred processing a GET request to https://packages.vicrea.nl/nuget/VicreaNuGet/v3/flatcontainer/system.management.automation.dll/10.0.10586/system.management.automation.dll.10.0.10586.nupkg: 547`16`0`FeedPackageVersions_SetAnalysis`26`The INSERT statement conflicted with the FOREIGN KEY constraint "FK__FeedPackageAnalyses__FeedPackageVersions". The conflict occurred in database "ProGet", table "dbo.FeedPackageVersions".
    0
  • 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

    0 atripp 1 Reply
  • atripp
    inedo-engineer

    Hello, just letting you know we're aware of the issue and plan to investigate/fix soon! And we hope then to get your feedback on the preview feature :)

    0 atripp 1 Reply
  • atripp
    inedo-engineer

    FYI - we plan to fix this in ProGet 2023.32 via PG-2613

    0
Log in to reply
 
Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation