Skip to main content
71 votes

Is it possible to limit timeout on Postgres server?

Yes, it's possible There are two settings mentioned in the docs (idle_in_transaction_session_timeout is new to version 9.6x) statement_timeout (integer) Abort any statement that takes more than ...
Evan Carroll's user avatar
  • 63.7k
7 votes

Connection pool Error

Is there any way to track the connections opened and relate it to a connection pool created from database side. Set the Application Name in your config and you can monitor from the server side in sys....
David Browne - Microsoft's user avatar
7 votes

Postgres could not receive data from client: Connection timed out

A few possibilities: Your application closes connections without telling the PostgreSQL server it's doing so, by simply closing the network socket. It should send a PQclose(conn) if using libpq, or ...
Craig Ringer's user avatar
  • 56.8k
6 votes
Accepted

Timeout error after SQL Server upgrade from 2008R2 to SQL Server 2014

I finally find out the problem. After days of straggling I checked the SQL Server report and noticed that there were very large occasions of autogrowth on temp db database. The cause of the problem ...
Hailegziabher Dechassa's user avatar
6 votes

Timeout error after SQL Server upgrade from 2008R2 to SQL Server 2014

The Cardinality Estimation logic was updated for SQL Server 2014 and could potentially be a reason. You would have to test the same queries with the old cardinality estimator and compare performance ...
Andy Jones's user avatar
  • 1,381
6 votes

Is it possible to limit timeout on Postgres server?

Not out of the box. It would be pretty easy to compile a custom server that ignored your settings, though. But much more likely is that your connections are being severed by a firewall or gateway ...
jjanes's user avatar
  • 40.2k
6 votes

For a complex query how do i increase the time SQL Server searches for the best execution plan

There are some undocumented trace flags that allow one to increase or remove some of the limits that the optimizer uses when determining whether a "good enough" plan has been found. However, all of ...
Josh Darnell's user avatar
  • 29.4k
6 votes

Will Blocking cause timeout issue

There are two type of timeouts. One is when the client application (API) aborts the batch after a certain amount of time. Called "attention" in a SQL server trace. Default in many APIs is 30 ...
Tibor Karaszi's user avatar
6 votes
Accepted

SQL Server timeout on DB and into connection string

This is not for regular connections, it is outgoing queries to linked servers. I.e., when your SQL Server is acting as a client towards other engines. The sp_configure setting is named "remote ...
Tibor Karaszi's user avatar
4 votes
Accepted

Configure Mysql client timeout?

There are a number of ...timeout... parameters that can be configured for a MySQL instance. Here are a few selected parameters (Ver. 8.x) for your convenience: Reference: 5.1.7 Server System ...
John K. N.'s user avatar
4 votes

How to avoid lock wait timeout exceed and improve MySQL InnoDB write speed

We have identified the root cause: it's the innodb_autoinc_lock_mode = 1 . Here is the summary from the official doc: 0: traditional lock mode, provided for backward compatibility, performance ...
Dio Phung's user avatar
  • 379
4 votes

How to reduce huge CXPACKET & LATCH_EX (ACCESS_METHODS_DATASET_PARENT) wait times?

As mentioned, the CXPACKET is often a misleading wait type in sense that high values are not always bad, and quite often these high values are just the indicator but not the real problem. So, ...
Mspaja's user avatar
  • 219
4 votes
Accepted

DBCC CHECKDB on a user database: Time-out occurred while waiting for buffer latch type 2 for page (X:XXX), database ID 2

However, the buffer latch timeout reported was in TempDB (database ID 2). TempDB is used with CheckDB, most likely there was a set of items waiting on the latch (or a single item, can't say with the ...
Sean Gallardy's user avatar
4 votes
Accepted

Does client timeout send the execution of a stored procedure from the TRY block to the CATCH block?

When the client aborts execution, it does so by sending an Attention signal to SQL Server. Aborting execution this way rolls back the current statement and ends execution completely. The only thing ...
Paul White's user avatar
  • 86.4k
4 votes
Accepted

How to set execution timeout in SSMS

On SSMS20 this works for me: Before pressing 'Connect', navigate to 'Connection Properties'. Here you can change the field 'Execution time-out' to the value in seconds you want to have as a time-out....
Peter's user avatar
  • 2,362
3 votes
Accepted

MongoDb max timeout for all queries

As at MongoDB 3.4, the $maxTimeMS value is a cursor option that needs to be set by the client/driver making the request. There is currently no equivalent server configuration directive, but there is ...
Stennie's user avatar
  • 10.3k
3 votes
Accepted

Why shouldn't I increase SQL Server's timeout globally everywhere?

So we decided to increase database timeout for queries globally. But I have this feeling that this is wrong. Yet I'm not able to bring forward any reasons. Is it bad to increase timeout everywhere?...
Dan Guzman's user avatar
  • 28.3k
3 votes

Proof that the SQL Server is not at fault for the timeout

FWIW, SQL Server doesn't timeout, by design. Only the calling client can issue a timeout. SQL Server will happily chug away for years on the same query, if the calling client doesn't issue a ...
J.D.'s user avatar
  • 38.1k
2 votes

Why shouldn't I increase SQL Server's timeout globally everywhere?

First of all there is noting like query timeout, it's "remote query timeout". Increasing it affects remote query execution (query executed by remote database server using linked server). By default it'...
Rajesh Ranjan's user avatar
2 votes

Timeout expired error. Is it because of a query or server settings?

Timeout settings are a configuration of the client connection, so are either set by the client application, or via the connection string. Look at how your applications is instantiating the database ...
BradC's user avatar
  • 10k
2 votes
Accepted

Is it a parameter sniffing problem?

If it's the first UPDATE that times-out then I'd look closer at your physical reads. If [staffid] isn't indexed then you'll be performing a full table scan and pulling the entire table from the IO ...
pacreely's user avatar
  • 1,098
2 votes

Large Table Times out - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

The code doesn't have a specific Time-out set in the Connection String to the Database but on the SQL Server, the Time-out is set to 10 minutes. You are most probably reaching a client timeout ...
Alexei's user avatar
  • 1,271
2 votes

This failure occured while attempting to connect to the Principle server

You mention two key things in your post: Mirroring Work is being performed against the failover-server I suspect what is going on is actually expected behavior. Mirroring connection strings define ...
John Eisbrener's user avatar
2 votes
Accepted

SQLServer Query Store not saving failed queries run by SP_ExecuteSQL

does this somehow cheat the querystore into thinking it is ok, no matter what the result ? Queries executed with sys.sp_executesql can definitely be logged in the Query Store as "Aborted" ...
Josh Darnell's user avatar
  • 29.4k
2 votes

How to resolve INSERT contention in Azure SQL Database?

I would definitely suggest modifying your PK to use OPTIMIZE_FOR_SEQUENTIAL_KEY (as suggested by Erik in the comments. Enabling Optimize For Sequential Key is pretty straightforward. This makes it a ...
AMtwo's user avatar
  • 16.2k
2 votes

How to set execution timeout in SSMS

The query timeout works just fine for me (SSMS 18). What I did was: File, New, Database Engine Query. In that dialog, the Connection Properties Tab: Execution timeout: 10 And then I executed below T-...
Tibor Karaszi's user avatar
1 vote

What settings control the maximum number of connections per user in Oracle 12c?

You might want to check the SESSIONS parameter, which controls the maximum number of sessions for the system: SELECT name, value FROM v$parameter WHERE name = 'sessions'; https://docs.oracle.com/...
John A's user avatar
  • 126
1 vote

Is it a parameter sniffing problem?

Nah, I would guss that StaffID is unique and if estimated row is 1 then it it pretty much on target. Perhaps blocking is the cause for the timeouts?
Tibor Karaszi's user avatar
1 vote

Oracle Client sessions keep disconnecting

The name "Dead Connection Detection" (DCD) is kind of self explanatory. DCD does not kill working connections, even if they are idle. DCD removes sessions from Oracle when they no longer respond. ...
Jared Still's user avatar
1 vote

Oracle Client sessions keep disconnecting

Check if sqlnet_expire_time is set in any of the sqlnet.ora files on the machine that hosts the DB, using some variant of find / -name sqlnet.ora -exec grep -i sqlnet_expire_time {} \; If it's not ...
Dave the Sax's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible