pharmadata / sql-snap Goto Github PK

2016-12-23 10:29:00 [Information] Preparing to restore "PharmaData"
2016-12-23 10:29:01 [Debug] Creating virtual device "sqlsnap-6207298c-48d1-4072-
9278-7a730929f45a"
2016-12-23 10:29:01 [Debug] Executing SQL query: "RESTORE DATABASE [PharmaData]
FROM VIRTUAL_DEVICE='sqlsnap-6207298c-48d1-4072-9278-7a730929f45a' WITH SNAPSHOT
, NORECOVERY"
2016-12-23 10:29:01 [Debug] Waiting for virtual device to be ready
2016-12-23 10:29:01 [Debug] Receiving commands from virtual device
2016-12-23 10:29:04 [Information] Beginning snapshot
2016-12-23 10:29:04 [Information] Snapshot completed successfully
2016-12-23 10:30:18 [Information] Metadata has been written successfully
2016-12-23 10:30:18 [Debug] Waiting for query to finish
2016-12-23 10:39:01 [Error] Unable to complete the restore
System.AggregateException: One or more errors occurred. ---> System.Data.SqlClie
nt.SqlException: Timeout expired.  The timeout period elapsed prior to completio
n of the operation or the server is not responding. ---> System.ComponentModel.W
in32Exception: The wait operation timed out
   --- End of inner exception stack trace ---
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult a
syncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyn
cResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar,
Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchron
ization)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
   at SqlSnap.Core.Operation.<ExecuteAsync>d__18.MoveNext() in C:\BuildAgent\wor
k\9d25945f9fec8378\src\SqlSnap.Core\Operation.cs:line 195
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
   at SqlSnap.Core.Server.<RestoreAsync>d__4.MoveNext() in C:\BuildAgent\work\9d
25945f9fec8378\src\SqlSnap.Core\Server.cs:line 37
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceled
Exceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationTo
ken cancellationToken)
   at SqlSnap.Cli.Program.Restore(RestoreOptions options) in C:\BuildAgent\work\
9d25945f9fec8378\src\SqlSnap.Cli\Program.cs:line 84
---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Timeo
ut expired.  The timeout period elapsed prior to completion of the operation or
the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004
005): The wait operation timed out
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult a
syncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyn
cResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar,
Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchron
ization)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
   at SqlSnap.Core.Operation.<ExecuteAsync>d__18.MoveNext() in C:\BuildAgent\wor
k\9d25945f9fec8378\src\SqlSnap.Core\Operation.cs:line 195
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNot
ification(Task task)
   at SqlSnap.Core.Server.<RestoreAsync>d__4.MoveNext() in C:\BuildAgent\work\9d
25945f9fec8378\src\SqlSnap.Core\Server.cs:line 37
ClientConnectionId:12a3bec9-beec-4dcb-9250-efbe0220815a
Error Number:-2,State:0,Class:11<---