Recovery Pending not fixed by Restarting SqlClone Agent

We have two clones remaining in "Recovery Pending" after a system reboot. According to SQL Cloned DB goes into recovery state after reboot. — Redgate forums (red-gate.com), this would be fixed by restarting the SQL Clone Agent service on the server. Doesn't make a difference. The Clone Dashboard no longer reports this server's clones as "Successfully deleted".

How do I resolve this issue. Can I delete the clones manually?

Windows logs report:

Could not get list of clonesSystem.ObjectDisposedException: Cannot access a disposed object.Object name: 'System.Net.Http.HttpClient'.   at System.Net.Http.HttpClient.CheckRequestBeforeSend(HttpRequestMessage request)   at RedGate.SqlClone.Agent.ManagementServiceClient.ManagementServiceClient.JsonHttpClient.Get[T](String requestUri)   at RedGate.SqlClone.Agent.Monitoring.CloneMonitor.TryGetClones()
Faulting application name: RedGate.SqlClone.Agent.Service.exe, version: 5.4.17.6024, time stamp: 0x64b06dc8Faulting module name: KERNELBASE.dll, version: 10.0.17763.4720, time stamp: 0xbbeed0d7Exception code: 0xe0434352Fault offset: 0x00000000000349b9Faulting process id: 0x26d4Faulting application start time: 0x01d9faf7ef44a533Faulting application path: C:\Program Files\Red Gate\SQL Clone Agent\5.4.17.6024\RedGate.SqlClone.Agent.Service.exeFaulting module path: C:\Windows\System32\KERNELBASE.dllReport Id: 83c119c2-e585-4e18-8ad0-5eca21d121efFaulting package full name: Faulting package-relative application ID: 
Application: RedGate.SqlClone.Agent.Service.exeCoreCLR Version: 7.0.1023.36312.NET Version: 7.0.10Description: The process was terminated due to an unhandled exception.Exception Info: System.ObjectDisposedException: The CancellationTokenSource has been disposed.   at System.Threading.CancellationTokenSource.Cancel()   at RedGate.SqlClone.Agent.Service.AgentService.<OnStop>b__19_0()   at RedGate.SqlClone.Common.EventLogExtensions.DoServiceActionAndRecordErrors(Action`1 logInfo, Action`1 logError, Action serviceAction, String fallbackLogFolder)   at RedGate.SqlClone.Common.EventLogExtensions.DoServiceActionAndRecordErrors(ILogger logger, Action serviceAction, String fallbackLogFolder)   at RedGate.SqlClone.Agent.Service.AgentService.OnStop()   at RedGate.SqlClone.Agent.Service.AgentService.<ExecuteAsync>b__17_0(Object _, EventArgs __)
Failed to send unhandled exception to serverSystem.ObjectDisposedException: Cannot access a disposed object.Object name: 'System.Net.Http.HttpClient'.   at System.Net.Http.HttpClient.CheckRequestBeforeSend(HttpRequestMessage request)   at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken)   at System.Net.Http.HttpClientExtensions.PostAsync[T](HttpClient client, String requestUri, T value, MediaTypeFormatter formatter, MediaTypeHeaderValue mediaType, CancellationToken cancellationToken)   at System.Net.Http.HttpClientExtensions.PostAsync[T](HttpClient client, String requestUri, T value, MediaTypeFormatter formatter, CancellationToken cancellationToken)   at System.Net.Http.HttpClientExtensions.PostAsync[T](HttpClient client, String requestUri, T value, MediaTypeFormatter formatter)   at RedGate.SqlClone.Agent.ManagementServiceClient.ManagementServiceClient.JsonHttpClient.Post[T](String requestUri, T body)   at RedGate.SqlClone.Agent.Service.AgentService.ReportUnhandledException(Object sender, UnhandledExceptionEventArgs e)
UNHANDLED EXCEPTIONSystem.ObjectDisposedException: The CancellationTokenSource has been disposed.   at System.Threading.CancellationTokenSource.Cancel()   at RedGate.SqlClone.Agent.Service.AgentService.<OnStop>b__19_0()   at RedGate.SqlClone.Common.EventLogExtensions.DoServiceActionAndRecordErrors(Action`1 logInfo, Action`1 logError, Action serviceAction, String fallbackLogFolder)   at RedGate.SqlClone.Common.EventLogExtensions.DoServiceActionAndRecordErrors(ILogger logger, Action serviceAction, String fallbackLogFolder)   at RedGate.SqlClone.Agent.Service.AgentService.OnStop()   at RedGate.SqlClone.Agent.Service.AgentService.<ExecuteAsync>b__17_0(Object _, EventArgs __)
Category: RedGate.SqlClone.Agent.Service.AgentServiceEventId: 0
The CancellationTokenSource has been disposed.
Exception: System.ObjectDisposedException: The CancellationTokenSource has been disposed.   at System.Threading.CancellationTokenSource.Cancel()   at RedGate.SqlClone.Agent.Service.AgentService.<OnStop>b__19_0()   at RedGate.SqlClone.Common.EventLogExtensions.DoServiceActionAndRecordErrors(Action`1 logInfo, Action`1 logError, Action serviceAction, String fallbackLogFolder)

Tagged:

Answers

Sign In or Register to comment.