Navigation

    Inedo Community Forums

    Forums

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. jfullmer_7346
    J
    • Profile
    • Following
    • Followers
    • Topics
    • Posts
    • Best
    • Groups

    jfullmer_7346

    @jfullmer_7346

    0
    Reputation
    18
    Posts
    2
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online

    jfullmer_7346 Follow

    Best posts made by jfullmer_7346

    This user hasn't posted anything yet.

    Latest posts made by jfullmer_7346

    • RE: Packages with Noncanonical Names errors on internalized packages

      @atripp What's odd is that 6.5.3 and 6.5.2 shouldn't be duplicate I think? The powershell module version (WinSCP) is still 6.3.6 so it shouldn't be seen as a duplicate version I would think.

      Could it be because we have dev versions of these repos and we promote the packages? Though we do that for all our packages, so I imagine we'd see it way more often.

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      Is it actually getting upset not because of canonical names and case differences, but because they're both nuget packages (in different repos) with the same name?

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      @atripp I'm fairly experienced with postgres and had originally tried troubleshooting at that level so I already have connections for running sql commands all setup.
      Ran that stored procedure

      SELECT public."PackageVersionIds_GetDuplicates"();
      PackageVersionIds_GetDuplicates|
      -------------------------------+
      (8401,563,6.5.3,)              |
      (8334,562,6.5.3,)              |
      (8235,563,6.5.2,)              |
      (8225,562,6.5.2,)              |
      (8336,562,6.3.6,)              |
      (6107,563,6.3.6,)              |
      (629,563,5.21.7,)              |
      (613,562,5.21.7,)              |
      (630,563,5.21.8,)              |
      (614,562,5.21.8,)              |
      

      Also ran this one

      SELECT public."PackageNameIds_GetDuplicates"();
      PackageNameIds_GetDuplicates                                  |
      --------------------------------------------------------------+
      (562,nuget,,winscp,8336)                                      |
      (563,nuget,,WinSCP,8401)                                      |
      (1383,nuget,,jquery,)                                         |
      (1591,nuget,,magick.net-q16-anycpu,)                          |
      (1592,nuget,,magick.net-q16-hdri-anycpu,)                     |
      (1593,nuget,,magick.net-q16-x64,)                             |
      (1594,nuget,,magick.net-q8-anycpu,)                           |
      (1595,nuget,,magick.net-q8-openmp-x64,)                       |
      (1596,nuget,,magick.net-q8-x64,)                              |
      (2822,nuget,,mongodb.driver,)                                 |
      (3191,nuget,,Umbraco.CMS,)                                    |
      (6487,nuget,,Microsoft.NetCore.App.Runtime.win-arm,)          |
      (6488,nuget,,Microsoft.NetCore.App.Runtime.win-arm64,)        |
      (6489,nuget,,Microsoft.NetCore.App.Runtime.win-x64,)          |
      (6490,nuget,,Microsoft.NetCore.App.Runtime.win-x86,)          |
      (6493,nuget,,Microsoft.NETCore.App.Runtime.linux-arm,)        |
      (6494,nuget,,Microsoft.NETCore.App.Runtime.linux-arm64,)      |
      (6495,nuget,,Microsoft.NETCore.App.Runtime.linux-musl-arm,)   |
      (6496,nuget,,Microsoft.NETCore.App.Runtime.linux-musl-arm64,) |
      (6497,nuget,,Microsoft.NETCore.App.Runtime.linux-musl-x64,)   |
      (6498,nuget,,Microsoft.NETCore.App.Runtime.linux-x64,)        |
      (6504,nuget,,Microsoft.NetCore.App.Runtime.osx-arm64,)        |
      (6505,nuget,,Microsoft.NetCore.App.Runtime.osx-x64,)          |
      (7315,nuget,,monero,)                                         |
      (8613,nuget,,Umbraco.Cms.Web.BackOffice,)                     |
      (9133,nuget,,SSCMS,)                                          |
      (9404,nuget,,CefSharp.OffScreen.NETCore,)                     |
      (9405,nuget,,CefSharp.WinForms.NETCore,)                      |
      (9406,nuget,,CefSharp.Wpf.NETCore,)                           |
      (9895,nuget,,UmbracoCms,)                                     |
      (10001,nuget,,UmbracoCMS.Core,)                               |
      (10906,nuget,,UmbracoCms.Web,)                                |
      (28650,nuget,,jQuery,)                                        |
      (28651,nuget,,Microsoft.NETCore.App.Runtime.osx-arm64,)       |
      (28652,nuget,,Microsoft.NETCore.App.Runtime.osx-x64,)         |
      (28653,nuget,,Microsoft.NETCore.App.Runtime.win-arm,)         |
      (28654,nuget,,Microsoft.NETCore.App.Runtime.win-arm64,)       |
      (28655,nuget,,Microsoft.NETCore.App.Runtime.win-x64,)         |
      (28656,nuget,,Microsoft.NETCore.App.Runtime.win-x86,)         |
      (28657,nuget,,UmbracoCMS,)                                    |
      (28658,nuget,,Microsoft.NetCore.App.Runtime.linux-arm,)       |
      (28659,nuget,,Microsoft.NetCore.App.Runtime.linux-arm64,)     |
      (28660,nuget,,Microsoft.NetCore.App.Runtime.linux-musl-arm,)  |
      (28661,nuget,,Microsoft.NetCore.App.Runtime.linux-musl-arm64,)|
      (28662,nuget,,Microsoft.NetCore.App.Runtime.linux-musl-x64,)  |
      (28663,nuget,,Microsoft.NetCore.App.Runtime.linux-x64,)       |
      (28664,nuget,,sscms,)                                         |
      (28665,nuget,,MongoDB.Driver,)                                |
      (28666,nuget,,UmbracoCMS.Web,)                                |
      (29225,nuget,,UmbracoCms.Core,)                               |
      (31198,npm,,rambox,)                                          |
      (39678,npm,,Rambox,)                                          |
      (51673,nuget,,Monero,)                                        |
      (55232,npm,,vvvebJs,)                                         |
      (55420,nuget,,Umbraco.Cms,)                                   |
      (55500,npm,,vvvebjs,)                                         |
      (69073,cargo,,surrealdb,)                                     |
      (69127,cargo,,deno,)                                          |
      (69135,cargo,,tauri,)                                         |
      (69283,cargo,,Deno,)                                          |
      (69315,cargo,,Tauri,)                                         |
      (69475,cargo,,mdbook,)                                        |
      (69476,cargo,,mdBook,)                                        |
      (75720,nuget,,Umbraco.Cms.Web.Backoffice,)                    |
      (77034,nuget,,CefSharp.OffScreen.NetCore,)                    |
      (77035,nuget,,CefSharp.WinForms.NetCore,)                     |
      (77036,nuget,,CefSharp.Wpf.NetCore,)                          |
      (19805812,nuget,,Magick.NET-Q16-AnyCPU,)                      |
      (19805814,nuget,,Magick.NET-Q16-HDRI-AnyCPU,)                 |
      (19805823,nuget,,Magick.NET-Q16-x64,)                         |
      (19805825,nuget,,Magick.NET-Q8-AnyCPU,)                       |
      (19805828,nuget,,Magick.NET-Q8-OpenMP-x64,)                   |
      (19805829,nuget,,Magick.NET-Q8-x64,)                          |
      (48480969,cargo,,SurrealDB,)                                  |
      

      There are versions that I thought were deleted in that first result as I only have 1 version listed for each nuget repo, only keeping the latest one for internalized packages.

      c03d3950-7d08-480e-a804-b96bcbd39ffd-image.png

      a1a1e959-588b-42a1-8518-3fb09171d548-image.png

      So maybe some old ids didn't get fully deleted from the database and they're caught as dupes? Maybe they're kept on purpose for historical data as that id isn't going to be reused? Maybe the duplicate check should also make sure it's an active version that is listed in the UI? Just spitballing, hopefully it helps

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      Also, should the integrity check be taking 30 minutes?
      I figure it's because it's a chocolatey repo where the files for packages are embedded in the package, so there are some very large packages.
      The powershell module repo runs through the check and the reindex in more reasonable time frames like 30 seconds.

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      I can re-index without the deduplicate option and it comes back as clean, though I imagine it will turn into a loop when I run the integrity check again.

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      @atripp Finally had some time to look at this again.
      Updated to 2025.10 and gave the reindex a go.
      Looked like it was gonna work but then it threw this error at the end of re-index

      Performing reindex for PowerShell feed 2: ArrowPS
      Deactivating feed.
      There are 31 duplicated PowerShell name sets...
      pkg:nuget/winscp (ID=562) is the canonical name in the set of 2...
      Deduplicating pkg:nuget/WinSCP (ID=563)...
      Re-activating feed.
      Unhandled exception: Npgsql.PostgresException (0x80004005): P0001: Cannot deduplicate given nameid
         at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
         at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
         at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
         at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
         at Npgsql.NpgsqlDataReader.NextResult()
         at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
         at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
         at Inedo.ProGet.Data.PostgresDatabaseContext.PostgresCommand.ExecuteReader()
         at Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters, DatabaseCommandReturnType returnType)
         at Inedo.Data.DatabaseContext.ExecuteNonQuery(String storedProcName, GenericDbParameter[] parameters)
         at Inedo.ProGet.Data.DB.Context.PackageNameIds_DeduplicateId(Nullable`1 Canonical_PackageName_Id, Nullable`1 Duplicate_PackageName_Id)
         at Inedo.ProGet.Data.DB.PackageNameIds_DeduplicateId(Nullable`1 Canonical_PackageName_Id, Nullable`1 Duplicate_PackageName_Id)
         at Inedo.ProGet.Feeds.PackageFeed`5.ReindexFeedAsync(IReindexFeedExecutionContext context, CancellationToken cancellationToken)
         at Inedo.ProGet.Executions.ReindexFeedExecution.ExecuteAsync(IManualExecutionContext context)
         at Inedo.ProGet.Executions.ReindexFeedExecution.ExecuteAsync(IManualExecutionContext context)
         at Inedo.ProGet.Service.Executions.ActiveManualExecution.ExecuteAsync()
        Exception data:
          Severity: ERROR
          SqlState: P0001
          MessageText: Cannot deduplicate given nameid
          Where: PL/pgSQL function "PackageNameIds_DeduplicateId"(integer,integer) line 27 at RAISE
          File: pl_exec.c
          Line: 3925
          Routine: exec_stmt_raise
      
      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      @atripp If there's anything I can do to help with troubleshooting or debugging, I am happy to help.

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      @stevedennis Is there anything extra that needs to be done on my side to fix this with the recent fix. I'm still getting the error for this package. I've tried forcing the case to be the same but no dice thus far.

      posted in Support
      J
      jfullmer_7346
    • RE: Packages with Noncanonical Names errors on internalized packages

      I have tried deleting the packages from my feeds completely, running the package re-index, and then pushing them again and the problem still persists.

      posted in Support
      J
      jfullmer_7346
    • Packages with Noncanonical Names errors on internalized packages

      So we internalize the chocolatey package WinSCP from the chocolatey community repository along with the matching version of the Powershell module of WinSCP from the PSGallery.

      In both cases, proget 2025 is giving us a feed error on our powershell and chocolatey repos that this package has a "Noncanonical Name."

      It gets indexed in the repo as winscp but the nuspec/psd1/psgetmoduleinfo.xml of the package has the id and (file names for nuspec and psd1) as WinSCP.

      I am pushing the package via a drop path after some internal processes repackage the nupkg to our internalized format.
      The WinSCP.nupkg we put in the drop path has the WinSCP case in the nupkg file name and the same for the nuspec within.

      I've tried fully deleting all versions of the package in the gui but re-pushing it has it still coming back as winscp in the proget side list of the package and giving this unhealthy feed error.

      I feel like I'm just missing something simple to fix this.
      03c5bd9b-f96d-47e3-936a-b693656aeb35-image.png

      posted in Support
      J
      jfullmer_7346