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!
Unable to push nuget symbols package
-
Hey,
I'm unable to push nuget symbols packages to my feed. When I do so I get a sql exception:
Postgres logs
proget-postgres_1 | 2019-02-07 13:41:56.160 UTC [364] ERROR: invalid input syntax for integer: "" proget-postgres_1 | 2019-02-07 13:41:56.160 UTC [364] CONTEXT: SQL statement "INSERT INTO "NuGetPackageSymbolsV2" proget-postgres_1 | ( proget-postgres_1 | "Feed_Id", proget-postgres_1 | "Symbol_Id", proget-postgres_1 | "SymbolFileName_Text", proget-postgres_1 | "Package_SymbolFilePath_Text", proget-postgres_1 | "Symbol_Age", proget-postgres_1 | "NuGetPackageV2_Id", proget-postgres_1 | "Package_Version_Text" proget-postgres_1 | ) proget-postgres_1 | SELECT "@Feed_Id", proget-postgres_1 | decode(array_to_string(xpath('@Id', S), ''), 'base64'), proget-postgres_1 | array_to_string(xpath('@FileName', S), ''), proget-postgres_1 | array_to_string(xpath('@Path', S), ''), proget-postgres_1 | CAST(array_to_string(xpath('@Age', S), '') AS INT), proget-postgres_1 | "@NuGetPackageV2_Id", proget-postgres_1 | "@Version_Text" proget-postgres_1 | FROM unnest(xpath('/SymbolFiles/SymbolFile', "@SymbolFiles_Xml")) S" proget-postgres_1 | PL/pgSQL function "NuGetPackagesV2_CreateOrUpdatePackage"(integer,character varying,character varying,character varying,timestamp with time zone,bigint,bytea,bytea,character varying,bytea,ynindicator,ynindicator,yni ndicator,ynindicator,integer,character varying,character varying,xml,ynindicator,integer,username) line 97 at SQL statementStack trace
Npgsql.PostgresException (0x80004005): 22P02: invalid input syntax for integer: "" at Npgsql.NpgsqlConnector.DoReadMessageAsync (System.Threading.CancellationToken cancellationToken, Npgsql.DataRowLoadingMode dataRowLoadingMode, System.Boolean isPrependedMessage) [0x002d7] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlConnector.ReadMessageWithPrependedAsync (System.Threading.CancellationToken cancellationToken, Npgsql.DataRowLoadingMode dataRowLoadingMode) [0x001c3] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlDataReader.NextResultInternalAsync (System.Threading.CancellationToken cancellationToken) [0x0070a] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlDataReader.NextResultAsync (System.Threading.CancellationToken cancellationToken) [0x0014a] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlCommand.ExecuteAsync (System.Threading.CancellationToken cancellationToken, System.Data.CommandBehavior behavior) [0x003d8] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlCommand.ExecuteDbDataReaderInternalAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x000f1] in <4985dea8374f4819bebb7847d95ad483>:0 at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x000a7] in <4985dea8374f4819bebb7847d95ad483>:0 at Inedo.Postgres.WrappedPgCommand.ExecuteDbDataReaderAsync (System.Data.CommandBehavior behavior, System.Threading.CancellationToken cancellationToken) [0x001db] in <ea20532795e64ea18852ec006a228cde>:0 at Inedo.Data.DatabaseContext+DbResult.CreateAsync (System.Data.Common.DbCommand command, Inedo.Data.DatabaseContext context, System.DateTimeOffset startTime, System.Diagnostics.Stopwatch stopwatch) [0x00082] in <647507080523420180e9f186fe046588>:0 at Inedo.Data.DatabaseContext.ExecuteInternalAsync (System.String storedProcName, Inedo.Data.GenericDbParameter[] parameters) [0x0021e] in <647507080523420180e9f186fe046588>:0 at Inedo.Data.DatabaseContext.ExecuteNonQueryAsync (System.String storedProcName, Inedo.Data.GenericDbParameter[] parameters) [0x0007b] in <647507080523420180e9f186fe046588>:0 at Inedo.ProGet.Feeds.NuGet.NuGetFeed.InstallOrUpdatePackageAsync (System.IO.Stream stream, System.Boolean calculateHash, System.Boolean cached, System.Boolean install, System.Boolean overwrite, System.Nullable`1[T] publishDate, System.Nullable`1[T] listed, System.Nullable`1[T] downloadCount, System.Boolean promoted) [0x00b20] in <dd1843234460462097fc07427b3e0889>:0 at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi+PutHandler.ProcessPutRequestAsync (System.Web.HttpContext context, Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi+RequestData urlData, Inedo.ProGet.Feeds.NuGet.NuGetFeed feed) [0x00170] in <2bc106c38f86445894485c967c113a09>:0 at Inedo.ProGet.WebApplication.FeedEndpoints.NuGet.NuGetApi.ProcessRequestAsync (System.Web.HttpContext context, Inedo.ProGet.Feeds.NuGet.NuGetFeed feed, System.String relativeUrl) [0x0019b] in <2bc106c38f86445894485c967c113a09>:0 at Inedo.ProGet.WebApplication.FeedEndpoints.FeedEndpointHandler+FeedRequestHandler.ProcessRequestAsync (System.Web.HttpContext context) [0x000a4] in <2bc106c38f86445894485c967c113a09>:0Pushing the 'normal' package (i.e. not the symbols one) it works fine.
I'm running proget inside a docker container and tried various versions, 5.1.22, 5.1.12, 5.1.11, 5.1.6
Kind regards,
Joël LuijmesProduct: ProGet
Version: 5.1.22
-
Unfortunately we can't figure out any reason that Age would be returning an empty string. We're thinking there must be something else... can you share the entire NUSPEC file so we can reproduce it better.