My situation is that occasionally I get the Error:
Server Error in Application.
An established connection was aborted by the software in your host machine.
Diving deeper I see:
MySqlException (0x80004005): Reading from the stream has failed
and
MySqlException (0x80004005): Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Reading from the stream has failed.
After looking up what seems to be the first error I found: https://stackoverflow.com/a/57501160/11035837
So here's the question:
If I get this error and then immediately refresh and the screen populates as if I had no error, is this Solution 3 to the above?
Not every time a user logs in do they get this error, but they consistently get this error when they haven't used the application in awhile or when I have made a change to the application (and always when one has cleared the browser cache). So I get the impression that it's page caching related - like it might take too long to pull the web page from the server into the cache and as a result the MySQL times out. But once the page is in browser cache, the data can be re-transmitted and received more rapidly.
However, after reading the linked, could CTL update or server identity importance cause a connection to behave this way?
I'm using c#, aspx, javascript, and MySQL
Appears to be a similar issue to https://www.reddit.com/r/mysql/comments/916l2x/mysqlexception_0x80004005_reading_from_the_stream/?utm_source=share&utm_medium=web2x but that one was never resolved satisfactorily.
User contributions licensed under CC BY-SA 3.0