MySQL random connection errors that clear up on their own
Hi, I'm hosting a custom web app based on Umbraco, current version 7.12.4 (but had the same problem with 7.6.1). The database is MySQL server version 5.6.39.
So randomly the app stops being able to connect to the database, giving the yellow screen of death with the message:
"Umbraco cannot start. A connection string is configured but Umbraco cannot connect to the database."
This will clear up on its own after random amounts of time, from a few minutes to over an hour. The logs under App_Data show this detail:
WARN Umbraco.Core.Persistence.DbConnectionExtensions - Configured database is reporting as not being available! Server: localhost, Database: dbname. Exception: MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'localhost' for user 'username' using method 'mysqlnativepassword' failed with message: Reading from the stream has failed. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine
The host support team is claiming that my application is not closing the database connection, and linking me to this: https://bugs.mysql.com/bug.php?id=76597. They say I should try the Ping workaround in this bug article. Does this seem on the right track or not? I don't see how I can try this without access to the internals of Umbraco, and I'm skeptical it would be a problem with Umbraco's connection methods anyway.
I did look into modifying the version of the MySql.Data package to see if it could be a bug in there, but Umbraco seems to want a very specific version (v6.9.9) and when I attempt to change it, it can no longer find the library.
Any help or ideas would be greatly appreciated. This is a huge blocker for us since it makes the entire app unreliable, with no clear solution other than drastic horrifying ones like switching to SQL Server and having to recreate all of the content we currently have in our MySQL database. I'd really like to avoid that one!
MySQL random connection errors that clear up on their own
Hi, I'm hosting a custom web app based on Umbraco, current version 7.12.4 (but had the same problem with 7.6.1). The database is MySQL server version 5.6.39.
So randomly the app stops being able to connect to the database, giving the yellow screen of death with the message:
This will clear up on its own after random amounts of time, from a few minutes to over an hour. The logs under App_Data show this detail:
The host support team is claiming that my application is not closing the database connection, and linking me to this: https://bugs.mysql.com/bug.php?id=76597. They say I should try the Ping workaround in this bug article. Does this seem on the right track or not? I don't see how I can try this without access to the internals of Umbraco, and I'm skeptical it would be a problem with Umbraco's connection methods anyway.
I did look into modifying the version of the MySql.Data package to see if it could be a bug in there, but Umbraco seems to want a very specific version (v6.9.9) and when I attempt to change it, it can no longer find the library.
Any help or ideas would be greatly appreciated. This is a huge blocker for us since it makes the entire app unreliable, with no clear solution other than drastic horrifying ones like switching to SQL Server and having to recreate all of the content we currently have in our MySQL database. I'd really like to avoid that one!
is working on a reply...