Issue ID:
Type
Bug
Title:
FIX: DateTime error with pypi replication (PostgreSQL)
Created:
7/29/2025 2:31:20 PM by Steve Dennis
Status:
Awaiting Release on 7/29/2025 6:13:08 PM
Last pulled:
7/30/2025 1:52:52 PM
Description:
``` Feed replication connection attempt failed for feed pypi-test: Cannot write DateTime with Kind=Local to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array, range, or multirange. (Parameter 'value') Stack trace: System.ArgumentException: Cannot write DateTime with Kind=Local to PostgreSQL type 'timestamp with time zone', only UTC is supported. Note that it's not possible to mix DateTimes with different Kinds in an array, range, or multirange. (Parameter 'value') at Npgsql.Internal.Converters.DateTimeConverterResolver`1.Get(DateTime value, Nullable`1 expectedPgTypeId, Boolean validateOnly) at Npgsql.Internal.PgResolverTypeInfo.GetResolutionAsObject(Object value, Nullable`1 expectedPgTypeId) at Npgsql.NpgsqlParameterCollection.ProcessParameters(PgSerializerOptions options, Boolean validateValues, CommandType commandType) 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() in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\Data\PostgresDatabaseContext.cs:line 371 at Inedo.Data.DatabaseContext.ExecuteInternal(String storedProcName, GenericDbParameter[] parameters, DatabaseCommandReturnType returnType) at Inedo.Data.DatabaseContext.ExecuteNonQuery(String storedProcName, GenericDbParameter[] parameters) at Inedo.ProGet.Feeds.PackageFeed`5.CreateOrUpdatePackage(PUrl purl, Context db, Nullable`1 publishDate, String publishedBy, Nullable`1 packageSize, Nullable`1 cached, Nullable`1 listed, Nullable`1 allow, Byte[] manifest, Byte[] md5, Byte[] sha1, Byte[] sha256, Byte[] sha512, String fileName, String originUrl) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\Feeds\PackageFeed.PackageAdd.cs:line 171 at Inedo.ProGet.Feeds.PackageFeed`5.AddPackageAsync(Stream stream, InstallPackageOptions options, PackageInstallContext context, Nullable`1 publishDate, Boolean listed, CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\Feeds\PackageFeed.PackageAdd.cs:line 102 at Inedo.ProGet.Feeds.PackageFeed`5.AddPackageAsync(Stream stream, InstallPackageOptions options, PackageInstallContext context, Nullable`1 publishDate, Boolean listed, CancellationToken cancellationToken) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\Feeds\PackageFeed.PackageAdd.cs:line 145 at Inedo.ProGet.WebApplication.SimpleHandlers.FeedSync.FeedSyncHandler.HandlePossiblyChunkedPutRequestAsync(AhHttpContext context, Func`2 installAsync) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\WebApplication\SimpleHandlers\FeedSync\FeedSyncHandler.cs:line 441 at Inedo.ProGet.WebApplication.SimpleHandlers.FeedSync.FeedSyncHandler.ProcessRequestInternalAsync(AhHttpContext context) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\WebApplication\SimpleHandlers\FeedSync\FeedSyncHandler.cs:line 278 at Inedo.ProGet.WebApplication.SimpleHandlers.FeedSync.FeedSyncHandler.ProcessRequestInternalAsync(AhHttpContext context) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E578130\Src\src\ProGet\WebApplication\SimpleHandlers\FeedSync\FeedSyncHandler.cs:line 307 Request details: IP address: ::ffff:10.89.0. User agent: ProGet/25.0.6.7 (Unix 6.12.19.64) Headers: X-ProGet-ClientSyncMode: PushOnly ::Feed Replication Error on 07/29/2025 14:38:02:: ```