The wait operation timed out. ASP

Question

I created an internal website for our company. It run smoothly for several months and then I made a major update due to user suggestion. When I run in live, it run normally. Then suddenly one of my user from japan sending me an "The Wait operation timed out." error. When I check access that certain link, It run normally for me and some other who I ask to check if they access that page. I already update the httpRuntime executionTimeout but still no luck. Is it the error come from database connection? If I increase the timeout in the database connection it will be fix the problem?

Quittance

Answer 1

If you found the exact error "The wait operation timed out" then it is likely you have a database call that took longer than expected. This could be due to any number of things:

1. Transient network problem
2. High SQL server load
3. Problem with SAN, RAID, or storage device
4. Deadlock or other form of multiprocess contention

You haven't shared enough information to troubleshoot. The way I would manage this would be to check for other occurrences of the problem and see if there is a pattern, e.g. if the problem occurs at a certain time of day.

Certainly increasing the timeout is not a bad idea (if it is currently set pretty low) and may resolve the problem in and of itself.

Whisenant

Answer 2

Remember to increase the connection timeout AND the command timeout:

SqlConnection(@"Data Source=SQLSERVER;Initial Catalog=MYCATALOG;Integrated Security=True;Connection Timeout=1000");//huge timeout

and then:

com.CommandTimeout = 950;//or whatever

Sind

is it mandatory if I increase the connection timeout in sqlconnection need also to increase the commandtimeout? – Quittance

No, it won't throw an error message, but one doesn't do much good without the other. If your connection timeout is set at 30, it does no good to increase your command timeout to 60 or vice-versa. The whole she-bang will cancel and timeout when the lower of the two numbers is reached. – Sind

At least in Sql Server, the connection timeout is how long it takes to establish a connection. It doesn't have anything to do with the lifetime of the connection. Command timeout has to do with how long the command takes to execute. – Biblioclast

@Shannon If the connection times out, the command won't be executed and value of the command timeout doesn't matter. If the command executes, obviously the connection timeout is fine; it's irrelevant to how long the command executes. They're independent values. – Hirai

Answer 3

I fixed this error by finding the exact procedure in event viewer where timeout was happening.

Connected to the same Database in SSMS and ran:

exec sp_recompile 'Procedure name'

It showed the below message:

Object 'Procedure name' was successfully marked for recompilation.

Strew

Answer 4

It can also be another issue. For instance, if you run a lot of queries during one connection opened and it exceeds the connection lifetime. Then you need to set Connection Lifetime property in your connection string. Here is the description:

When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. This is useful in clustered configurations to force load balancing between a running server and a server just brought online. A value of zero (0) causes pooled connections to have the maximum connection timeout.

Remediable

Answer 5

In my case, it was fixed by turning on Named Pipes from SQL Server Configuration Manager

Obeng

Answer 6

In my case it had to do with memory issues. Whenever there were other applications open, SQL Server memory gets over-rationed thus preventing complex queries from executing succesfully. To fix this I went to SQL Server Management Studio, logged in to the local server, right clicked on the server, went to properties and set the minimum server memory to about 2 Gig.

Rhinestone

Answer 7

Strangely, for me it was fixed by adding Trust Server Certificate=True; to the connection string. I'm on .NET 8 and Microsoft.Data.SqlClient version 5.1.4.

Scansorial

Answer 8

In the web.config file go to connections String and add this: ;Integrated Security=True;Connect Timeout=120"

Toledo