Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
What is the possibe cause for MySql.Data.MySqlClient.MySqlException (0x80004005).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sachin Vettiyattil-FT
41
Reputation points
When running a job from a virtual machine on dotnet framework, we could see intermittent failure exceptions with the error message as mentioned below. The metrics for mysql server were all normal and no health events were detected during the time frame. The below exceptions could occur when the MySQL server can't be contacted, or the executing query get times out? Could there be any other possibilities for the failure? Can the error occur due to a client side issue?
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution.
---> System.IO.IOException: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host..
---> System.Net.Sockets.SocketException (10054): An existing connection was forcibly closed by the remote host.
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Security.SslStream.WriteSingleChunk[TWriteAdapter](TWriteAdapter writeAdapter, ReadOnlyMemory`1 buffer)
at System.Net.Security.SslStream.WriteAsyncInternal[TWriteAdapter](TWriteAdapter writeAdapter, ReadOnlyMemory`1 buffer)
at System.Net.Security.SslStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet)
at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket, Int32 paramsPosition)
at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p, Int32 paramsPosition)
at MySql.Data.MySqlClient.Statement.ExecuteNext()
at MySql.Data.MySqlClient.PreparableStatement.ExecuteNext()
at MySql.Data.MySqlClient.PreparableStatement.Execute()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.ISSchemaProvider.GetTable(String sql)
at MySql.Data.MySqlClient.ISSchemaProvider.Query(String tableName, String initialWhere, String[] keys, String[] values)
at MySql.Data.MySqlClient.ISSchemaProvider.GetProcedures(String[] restrictions)
at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions)
at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions)
at MySql.Data.MySqlClient.MySqlConnection.GetSchemaCollection(String collectionName, String[] restrictionValues)
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName)
at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
Azure Database for MySQL
Azure ISV (Independent Software Vendors) and Startups
Azure ISV (Independent Software Vendors) and Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.ISV (Independent Software Vendors) and Startups: A Microsoft program that helps customers adopt Microsoft Cloud solutions and drive user adoption.
91 questions
{count} votes
-
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee2023-02-11T03:14:35.99+00:00 Hi Sachin Vettiyattil-FT Thank you for reaching out.
This could be caused by a number of things, such as a firewall issue or a problem with the MySQL server itself.
One thing you can try is to check your firewall settings to ensure that the connection to the MySQL server is not being blocked.
You can also try to check the connection string and make sure that the server's name, database, user ID, and password are correct.
If the below does not resolve your issue. I would suggest raising a support ticket and our CSS team can take a look and diagnose with proper tool.
Regards,
Oury
-
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
2023-02-11T03:15:05.5833333+00:00 -
Sachin Vettiyattil-FT 41 Reputation points
2023-02-13T16:34:38.4933333+00:00 Hello @Oury Ba-MSFT , Thank you for your response.
I don't feel this is related for any firewall settings or connection strings, since the exception occur intermittently and not continuous. What worries me the socket exception mentioned in the exception trace? Is there a possibility that the sockets where the job is hosted is not free and used up?
---> System.Net.Sockets.SocketException (10054): An existing connection was forcibly closed by the remote host. at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size) -
Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
2023-02-13T19:39:50.8066667+00:00 I would suggest raising a support ticket for our team to further investigate. Please do let us know if you don't have a support plan.
Regards,
Oury
Sign in to comment