PageController.RecurringDbSave

// Job ID: #1381617
using CDR.Hangfire.Areas.Panel.Controllers;

var pageController = Activate<PageController>();
await pageController.RecurringDbSave(
    FromJson<UserConnectionDto>("{\"Id\":2080,\"IpAddress\":\"medilinkconsultingltd.3cx.co.uk\",\"Port\":\"5432\",\"DbName\":\"database_single\",\"DbUsername\":\"phonesystem\",\"DbPassword\":\"z4dv50xlrXMCkxmTxjs8TA==\"}"));

Parameters

CurrentCulture
""
CurrentUICulture
""
RecurringJobId
"medilinkconsultingltd.3cx.co.uk"
Time
1721901655

State

07/25/2024 10:09:33 (+1m 23.987s) Failed

Failed to change state to a 'Succeeded' one due to an exception after 10 retry attempts

System.Data.SqlClient.SqlException

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)

System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Hangfire.SqlServer.SqlServerStorage.CreateAndOpenConnection()
   at Hangfire.SqlServer.SqlServerConnection.AcquireLock(String resource, TimeSpan timeout)
   at Hangfire.SqlServer.SqlServerConnection.AcquireDistributedLock(String resource, TimeSpan timeout)
   at Hangfire.Storage.StorageConnectionExtensions.AcquireDistributedJobLock(IStorageConnection connection, String jobId, TimeSpan timeout)
   at Hangfire.States.BackgroundJobStateChanger.ChangeState(StateChangeContext context)
   at Hangfire.Server.Worker.TryChangeState(BackgroundProcessContext context, IStorageConnection connection, IFetchedJob fetchedJob, IState state, String[] expectedStates, CancellationToken initializeToken, CancellationToken abortToken)

+1m 39.133s Processing

Server:
3ccecc3a22cc:1
Worker:
424b21c0

+5m 35.030s Processing

Server:
3ccecc3a22cc:1
Worker:
aaf718c0

+3ms Enqueued

Triggered by recurring job scheduler

Queue:
default

07/25/2024 10:00:55 Created