LoadSchedulerService.LoadDashboardData

// Job ID: #5750
using photobooth.alerts.Application.Services.Hangfire;

var loadSchedulerService = Activate<LoadSchedulerService>();
await loadSchedulerService.LoadDashboardData(null);

Parameters

CurrentCulture
""
CurrentUICulture
""
RecurringJobId
"BGLoadDashData"
RetryCount
1
Time
1703791814

State

12/28/2023 19:31:12 (+3.427s) Failed

An exception occurred during performance of the job.

System.InvalidOperationException

An exception has been raised that is likely due to a transient failure.

System.InvalidOperationException: An exception has been raised that is likely due to a transient failure.
 ---> Npgsql.PostgresException (0x80004005): 53300: remaining connection slots are reserved for non-replication superuser connections
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|213_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|193_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.<Get>g__RentAsync|31_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  Exception data:
    Severity: FATAL
    SqlState: 53300
    MessageText: remaining connection slots are reserved for non-replication superuser connections
    File: postinit.c
    Line: 833
    Routine: InitPostgres
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at photobooth.alerts.Data.Repository.PhotoboothHistoryRepository.CreateOrUpdate(List`1 photoboothData) in /src/src/photobooth.alerts.Data/Repository/PhotoboothHistoryRepository.cs:line 47
   at photobooth.alerts.Application.Services.Loader.DashboardLoaderService.CreatePhotoboothData(List`1 Photobooths, DateTime StartDate, DateTime EndDate, List`1 photoboothListData) in /src/src/photobooth.alerts.Application/Services/Loader/DashboardLoaderService.cs:line 140
   at photobooth.alerts.Application.Services.Loader.DashboardLoaderService.LoadData(Int32 minutesAgo) in /src/src/photobooth.alerts.Application/Services/Loader/DashboardLoaderService.cs:line 105
   at photobooth.alerts.Application.Services.Hangfire.LoadSchedulerService.LoadDashboardData(PerformContext context) in /src/src/photobooth.alerts.Application/Services/Hangfire/LoadSchedulerService.cs:line 49
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

+24ms Processing

Server:
dashboard photobooth alerts loader:1
Worker:
eae78a23
+3.399sOCORREU UM ERRO DE PROCESSAMENTO DE DADOS. ERRO: An exception has been raised that is likely due to a transient failure.

+42.971s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+92ms Scheduled

Retry attempt 1 of 1: An exception has been raised that is likely due t…

Enqueue at:
12/28/2023 19:30:54

+11.109s Failed

An exception occurred during performance of the job.

System.InvalidOperationException

An exception has been raised that is likely due to a transient failure.

System.InvalidOperationException: An exception has been raised that is likely due to a transient failure.
 ---> Npgsql.PostgresException (0x80004005): 53300: sorry, too many clients already :: proc.c:362
   at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|213_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at Npgsql.Internal.NpgsqlConnector.Authenticate(String username, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.Internal.NpgsqlConnector.<Open>g__OpenCore|193_1(NpgsqlConnector conn, SslMode sslMode, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.Internal.NpgsqlConnector.Open(NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.OpenNewConnector(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.ConnectorPool.<Get>g__RentAsync|31_0(NpgsqlConnection conn, NpgsqlTimeout timeout, Boolean async, CancellationToken cancellationToken)
   at Npgsql.NpgsqlConnection.<Open>g__OpenAsync|45_0(Boolean async, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(Boolean errorsExpected, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationToken cancellationToken, Boolean errorsExpected)
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(AsyncEnumerator enumerator, CancellationToken cancellationToken)
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
  Exception data:
    Severity: FATAL
    SqlState: 53300
    MessageText: sorry, too many clients already :: proc.c:362
    File: proc.c
    Line: 362
    Routine: InitProcess
   --- End of inner exception stack trace ---
   at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func`4 operation, Func`4 verifySucceeded, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at photobooth.alerts.Data.Repository.PhotoboothHistoryRepository.CreateOrUpdate(List`1 photoboothData) in /src/src/photobooth.alerts.Data/Repository/PhotoboothHistoryRepository.cs:line 47
   at photobooth.alerts.Application.Services.Loader.DashboardLoaderService.CreatePhotoboothData(List`1 Photobooths, DateTime StartDate, DateTime EndDate, List`1 photoboothListData) in /src/src/photobooth.alerts.Application/Services/Loader/DashboardLoaderService.cs:line 140
   at photobooth.alerts.Application.Services.Loader.DashboardLoaderService.LoadData(Int32 minutesAgo) in /src/src/photobooth.alerts.Application/Services/Loader/DashboardLoaderService.cs:line 105
   at photobooth.alerts.Application.Services.Hangfire.LoadSchedulerService.LoadDashboardData(PerformContext context) in /src/src/photobooth.alerts.Application/Services/Hangfire/LoadSchedulerService.cs:line 49
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodInvoker.Invoke(Object obj, IntPtr* args, BindingFlags invokeAttr)

+29ms Processing

Server:
dashboard photobooth alerts loader:1
Worker:
7980c495
+11.010sOCORREU UM ERRO DE PROCESSAMENTO DE DADOS. ERRO: An exception has been raised that is likely due to a transient failure.

+11ms Enqueued

Triggered by recurring job scheduler

Queue:
default

12/28/2023 19:30:14 Created