Last post Jul 27, 2016 01:14 PM by Chris Zhao
Jul 27, 2016 07:16 AM|jfr|LINK
Let me translate an error what I 'm getting every 5-6 days. Timeout. The timeout period elapsed prior to completion of the operation or the server is not responding.
All of my websites are showing this error. And if I want to login to my sql server I can't login, but I'm getting the same error. No any error number. If I restart my server then it'll be okay. But I would like not to get this error every 5-6 days. Can you
please help me to solve the problem.
Jul 27, 2016 07:41 AM|newLearner_asp|LINK
Check these things:
This is not an .net related issue. For better help contact go to MySQL forums.
Jul 27, 2016 07:54 AM|Nasser Malik|LINK
It usually happen on running long queries or any query which is taking longer time. Seems like once you got this error, you are no longer to execute any query on the database. It can be due to you started some transaction but forgot to mark in commit/rollback
in your query. This can be happened if you are running some transaction and got exception on that transaction but you are not rolling back on the exception.
You can also try some other options mentioned in the following thread
Jul 27, 2016 08:26 AM|jfr|LINK
Tell me please,
is possible to find out which query is this?
Or is it possible automatically to cancel such queries?
Jul 27, 2016 01:14 PM|Chris Zhao|LINK
Timeout. The timeout period elapsed prior to completion of the operation or the server is not responding.
The error can come because of two kind of timeouts: Query Timeout, Connection Timeout. You could refer to the following links.
Typical Causes of This Error
Timeout expired. The timeout period elapsed prior to completion of the operation
or the server is not responding.
SQL Server performance monitoring with Data Collector