MySQL Unity TLS error #816
Comments
|
Full error log |
|
Another one |
|
I experience a similar issue, however, I register EF Core db without openmod API, but doing same thing. Server shutdown shouldn't cause this since I pass cancellation tokens everywhere where possible is. EDIT: This exception appears randomly at some point, not at the start or smth. Logs: Exception message: An error occured in "PendingEntitiesWorker"
System.InvalidOperationException: An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure()' to the 'UseMySql' call. ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
at MySqlConnector.Core.ServerSession.ConnectAsync (MySqlConnector.Core.ConnectionSettings cs, System.Int32 startTickCount, MySqlConnector.Core.ILoadBalancer loadBalancer, MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x002d4] in /_/src/MySqlConnector/Core/ServerSession.cs:378
at MySqlConnector.Core.ConnectionPool.GetSessionAsync (MySql.Data.MySqlClient.MySqlConnection connection, System.Int32 startTickCount, MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x005a3] in /_/src/MySqlConnector/Core/ConnectionPool.cs:111
at MySqlConnector.Core.ConnectionPool.GetSessionAsync (MySql.Data.MySqlClient.MySqlConnection connection, System.Int32 startTickCount, MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x007e5] in /_/src/MySqlConnector/Core/ConnectionPool.cs:141
at MySql.Data.MySqlClient.MySqlConnection.CreateSessionAsync (MySqlConnector.Core.ConnectionPool pool, System.Int32 startTickCount, System.Nullable`1[T] ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00120] in /_/src/MySqlConnector/MySql.Data.MySqlClient/MySqlConnection.cs:729
at MySql.Data.MySqlClient.MySqlConnection.OpenAsync (System.Nullable`1[T] ioBehavior, System.Threading.CancellationToken cancellationToken) [0x0016d] in /_/src/MySqlConnector/MySql.Data.MySqlClient/MySqlConnection.cs:404
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnectionAsync (System.Boolean errorsExpected, System.Threading.CancellationToken cancellationToken) [0x0012b] in <04749dad1c80429287c0de883da70092>:0
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnectionAsync (System.Boolean errorsExpected, System.Threading.CancellationToken cancellationToken) [0x00286] in <04749dad1c80429287c0de883da70092>:0
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync (System.Threading.CancellationToken cancellationToken, System.Boolean errorsExpected) [0x0017b] in <04749dad1c80429287c0de883da70092>:0
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlRelationalConnection.OpenAsync (System.Threading.CancellationToken cancellationToken, System.Boolean errorsExpected) [0x0007b] in <971e410b2fc64eaba9c11dae2dfe083d>:0
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync (Microsoft.EntityFrameworkCore.Storage.RelationalCommandParameterObject parameterObject, System.Threading.CancellationToken cancellationToken) [0x000f8] in <04749dad1c80429287c0de883da70092>:0
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1+AsyncEnumerator[T].InitializeReaderAsync (Microsoft.EntityFrameworkCore.DbContext _, System.Boolean result, System.Threading.CancellationToken cancellationToken) [0x000bd] in <04749dad1c80429287c0de883da70092>:0
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult] (TState state, System.Func`4[T1,T2,T3,TResult] operation, System.Func`4[T1,T2,T3,TResult] verifySucceeded, System.Threading.CancellationToken cancellationToken) [0x00089] in <971e410b2fc64eaba9c11dae2dfe083d>:0
--- End of inner exception stack trace ---
at Pomelo.EntityFrameworkCore.MySql.Storage.Internal.MySqlExecutionStrategy.ExecuteAsync[TState,TResult] (TState state, System.Func`4[T1,T2,T3,TResult] operation, System.Func`4[T1,T2,T3,TResult] verifySucceeded, System.Threading.CancellationToken cancellationToken) [0x000c6] in <971e410b2fc64eaba9c11dae2dfe083d>:0
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1+AsyncEnumerator[T].MoveNextAsync () [0x002fe] in <04749dad1c80429287c0de883da70092>:0
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource] (System.Linq.IQueryable`1[T] source, System.Threading.CancellationToken cancellationToken) [0x000cc] in <25b3d70e4fdd45f7a2d848578491534a>:0
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource] (System.Linq.IQueryable`1[T] source, System.Threading.CancellationToken cancellationToken) [0x0016b] in <25b3d70e4fdd45f7a2d848578491534a>:0
at UnturnedGuard.Database.Entities.MySql.MySqlEntitiesRepository+<>c__DisplayClass9_0.<GetByLogLevelAsync>b__0 () [0x002f9] in <5430c01670224847be6fae7b81697ef2>:0
at UnturnedGuard.Shared.Threading.Dispatchers.ThreadPoolDispatcher+<>c__DisplayClass9_0`1[T].<Enqueue>b__0 () [0x00102] in <4effa5d7de8044c5b501bec44e26c8a9>:0
at UnturnedGuard.Shared.Threading.Dispatchers.ThreadPoolDispatcher.<ProcessQueue>b__11_0 () [0x000bd] in <4effa5d7de8044c5b501bec44e26c8a9>:0 |
|
Someone might have forgotten to put |
|
Currently use the fix made by CyberAndrii in one of the my plugins, and it seems like annoying exception is gone now ! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
At one point all DB operations start falling with the following exception:
System.InvalidOperationException: An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure()' to the 'UseMySql' call. ---> MySql.Data.MySqlClient.MySqlException: SSL Authentication Error ---> System.Security.Authentication.AuthenticationException: Authentication failed, see inner exception. ---> Mono.Security.Interface.TlsException: Handshake failed - error code: UNITYTLS_INTERNAL_ERROR, verify result: UNITYTLS_X509VERIFY_NOT_DONEOnly server restart brings the DB back to life
The text was updated successfully, but these errors were encountered: