Hướng dẫn connect timeout expired mysql - kết nối hết thời gian chờ mysql hết hạn

@bgrainger - Vâng, nó chắc chắn là không.Đường ống của chúng tôi không thành công vì chúng tôi không mong đợi lỗi này.Chúng tôi bắt được những ngoại lệ này từ đầu nối và bọc chúng cho phù hợp, đây là một ngoại lệ bên trong cho ngoại lệ tùy chỉnh của chúng tôi, trong đó chúng tôi kết thúc nó.

Đây là một ngoại lệ đầy đủ để tham khảo, một lần nữa nó được gói thêm trong một vài ngoại lệ khác, do đó, loại bỏ điều đó:

Inner exception type: Microsoft.Migration.DataMovement.Core.MySql.Contracts.MySqlDataMovementWriterUnhandledException
Message: 
    A batch could not be written to the table 
Stack: 
    at Microsoft.MySql.Data.Movement.DataMovementWriter.WriteBatch[IQueryTableDataRangeResult queryResult, DatabaseObjectName targetTableName, Guid activityId, Boolean useTableLock, Action`1 callback, Action`2 leakedConnectionCallback, Action`1 batchRetryCallback, CancellationToken cancelToken] in D:\GitHub\swjain\OSSDBDataMovementCommon\Product\Source\MySql.Data.Movement\DataMovementWriter.cs:line 203
    at Microsoft.SqlServer.Migration.Data.Movement.Steps.WriteDataRangeBatchStep.c__DisplayClass3_0.b__0[WriteDataRangeBatchWorkItem workItem]
    at Microsoft.SqlServer.Migration.Data.Movement.Steps.DataMovementErrorObservablePipelineStep`2.TryProcessWorkItem[WorkItemType][WorkItemType workItem, Action`1 workItemAction, Func`3 errorEventFactory, Func`2 canHandleExceptionPredicate]
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
    at Microsoft.SqlServer.Migration.Data.Movement.Steps.DataMovementErrorObservablePipelineStep`2.TryProcessWorkItem[WorkItemType][WorkItemType workItem, Action`1 workItemAction, Func`3 errorEventFactory, Func`2 canHandleExceptionPredicate]
    at Microsoft.SqlServer.Migration.Data.Movement.Steps.WriteDataRangeBatchStep.OnNext[WriteDataRangeBatchWorkItem writeDataRangeBatchWorkItem]
Inner exception type: System.ObjectDisposedException
    Message: 
        Cannot access a disposed object.
        Object name: 'System.Net.Sockets.Socket'.
    HResult : 0x80131622
        FacilityCode : 19 [013]
        ErrorCode : 5666 [1622]
    Stack: 
        at System.Net.Sockets.Socket.SetSocketOption[SocketOptionLevel optionLevel, SocketOptionName optionName, Int32 optionValue]
        at MySqlConnector.Core.ServerSession.d__91.MoveNext[] in /_/src/MySqlConnector/Core/ServerSession.cs:line 1036
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at MySqlConnector.Core.ServerSession.d__76.MoveNext[] in /_/src/MySqlConnector/Core/ServerSession.cs:line 407
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at MySqlConnector.Core.ConnectionPool.d__21.MoveNext[] in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 376
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult[]
        at MySqlConnector.Core.ConnectionPool.d__10.MoveNext[] in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 107
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at MySqlConnector.Core.ConnectionPool.d__10.MoveNext[] in /_/src/MySqlConnector/Core/ConnectionPool.cs:line 137
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult[]
        at MySqlConnector.MySqlConnection.d__117.MoveNext[] in /_/src/MySqlConnector/MySqlConnection.cs:line 873
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1.ConfiguredValueTaskAwaiter.GetResult[]
        at MySqlConnector.MySqlConnection.d__27.MoveNext[] in /_/src/MySqlConnector/MySqlConnection.cs:line 414
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at MySqlConnector.MySqlConnection.Open[] in /_/src/MySqlConnector/MySqlConnection.cs:line 380
        at Microsoft.Migration.Queries.Execution.QueryBase`4.c__DisplayClass57_0.d.MoveNext[]
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at Microsoft.Migration.Queries.Execution.QueryBaseRetryHandler.d__9`1.MoveNext[]
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at Microsoft.Migration.Queries.Execution.QueryBase`4.d__57.MoveNext[]
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at Microsoft.Migration.Queries.Execution.QueryBase`4.d__47`1.MoveNext[]
        --- End of stack trace from previous location where exception was thrown ---
        at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw[]
        at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification[Task task]
        at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult[]
        at Microsoft.MySql.Data.Movement.Writer.MySqlWriteRows.d__7.MoveNext[] in 

Bài Viết Liên Quan

Chủ Đề