Issue ID:
Type
Bug
Title:
FIX: Value too long for character type error on NuGet Connectors [PostgreSQL]
Created:
8/21/2025 11:18:06 AM by Dean H
Status:
Open
Last pulled:
8/25/2025 8:26:26 PM
Description:
``` An error occurred processing a GET request to https:///nuget/nuget/v3/flatcontainer/harfbuzzsharp/7.3.0/harfbuzzsharp.7.3.0.nupkg: 22001: value too long for type character varying(255) Npgsql.PostgresException (0x80004005): 22001: value too long for type character varying(255) at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder1.StateMachineBox1.System.Threading.Tasks.Sources.IValueTaskSource.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.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken) at Inedo.ProGet.Data.PostgresDatabaseContext.PostgresCommand.ExecuteReaderAsync(CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\Data\PostgresDatabaseContext.cs:line 391 at Inedo.Data.DatabaseContext.DbResult.CreateAsync(IGenericDbCommand command, DatabaseContext context, DateTimeOffset startTime, Stopwatch stopwatch) at Inedo.Data.DatabaseContext.ExecuteInternalAsync(String storedProcName, GenericDbParameter[] parameters, DatabaseCommandReturnType returnType) at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync(String storedProcName, GenericDbParameter[] parameters) at Inedo.ProGet.Feeds.PackageFeed5.AddPackageAsync(Stream stream, InstallPackageOptions options, PackageInstallContext context, Nullable1 publishDate, Boolean listed, CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\Feeds\PackageFeed.PackageAdd.cs:line 119 at Inedo.ProGet.Feeds.PackageFeed5.AddPackageAsync(Stream stream, InstallPackageOptions options, PackageInstallContext context, Nullable1 publishDate, Boolean listed, CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\Feeds\PackageFeed.PackageAdd.cs:line 145 at Inedo.ProGet.Feeds.PackageFeed`5.DownloadPackageAsync(TPackage package, IPackageDownloadContext context, OpenPackageOptions options, PackageInstallContext installContext, CancellationToken cancellationToken) at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi.GetHandler.TransmitPackageAsync(AhHttpContext context, WebApiContext apiContext, ICanonicalNuGetPackage package, String packageFileName, Boolean includeSymbols, Boolean includeSource, Boolean includeSignature, NuGetFeed feed) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\WebApplication\FeedEndpoints\NuGet\NuGetApi.GetHandler.cs:line 65 at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi.GetHandler.ProcessGetRequestAsync(AhHttpContext context, WebApiContext apiContext, RequestData urlData, NuGetFeed feed) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\WebApplication\FeedEndpoints\NuGet\NuGetApi.GetHandler.cs:line 60 at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.V3.PackageBaseAddressHandler.ProcessRequestAsync(NuGetFeed feed, AhHttpContext context, WebApiContext apiContext, String relativeUrl) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\WebApplication\FeedEndpoints\NuGet\V3\PackageBaseAddressHandler.cs:line 50 at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetFeedHandler.ProcessRequestAsync(AhHttpContext context, WebApiContext apiContext, NuGetFeed feed, String relativeUrl) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\WebApplication\FeedEndpoints\NuGet\NuGetFeedHandler.cs:line 23 at Inedo.ProGet.WebApplication.FeedEndpoints.FeedEndpointHandler.FeedRequestHandler.ProcessRequestAsync(AhHttpContext context) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp_E584854\Src\src\ProGet\WebApplication\FeedEndpoints\FeedEndpointHandler.cs:line 194 Exception data: Severity: ERROR SqlState: 22001 MessageText: value too long for type character varying(255) Where: SQL statement "INSERT INTO "NuGetFeedPackageVersions" ( "Feed_Id", "PackageVersion_Id", "Symbols_Indicator", "Source_Indicator", "TargetFrameworks_Text" ) VALUES ( "@Feed_Id", "@PackageVersion_Id", "@Symbols_Indicator", "@Source_Indicator", "@TargetFrameworks_Text" ) ON CONFLICT ("Feed_Id", "PackageVersion_Id") DO UPDATE SET "Symbols_Indicator" = "@Symbols_Indicator", "Source_Indicator" = "@Source_Indicator", "TargetFrameworks_Text" = "@TargetFrameworks_Text"" PL/pgSQL function "NuGet_CreateOrUpdatePackageVersion"(integer,integer,boolean,boolean,character varying,jsonb) line 4 at SQL statement File: varchar.c Line: 637 Routine: varchar ```