Skip to main content

Questions tagged [timeout]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
45 votes
3 answers
177k views

Is it possible to limit timeout on Postgres server?

I set connection and command timeout to 10 minutes in my application (client side). Than my application runs a simple query: SELECT pg_sleep(65) On some servers it works fine, but other servers ...
Andrzej Gis's user avatar
11 votes
2 answers
45k views

Postgres could not receive data from client: Connection timed out

Am a sql DBA, learning postgres..In postgres logs i often receive "could not receive data from client: Connection timed out" I do not have any other logs other than this Am not sure how to ...
Spinach's user avatar
  • 111
7 votes
2 answers
25k views

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

I ran a multi-threaded client spawning 25 threads to make concurrent API calls and insert data to AWS Aurora server. After some time, I started to see timeout error: lock wait timeout exceeded try ...
Dio Phung's user avatar
  • 379
6 votes
1 answer
4k views

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

Our Ola Hallengren IntegrityCheck job failed due to a buffer latch timeout while running DBCC CHECKDB on a user database. However, the buffer latch timeout reported was in TempDB (database ID 2). ...
Eitan Blumin's user avatar
5 votes
3 answers
17k views

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

Problem We have been experiencing high levels of user disruption due to SQL timeouts accross our systems since the beginning of the year. The SQL-Server instance in question has very high CPU usage (...
matskm's user avatar
  • 53
5 votes
1 answer
7k views

installed SQL Server on RHEL7 and received - Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : TCP Provider: Error code 0x2AF9

I installed SQL Server on RHEL7 VM msodbcsql-13.1.1.0-1.x86_64 mssql-server-14.0.100.187-1.x86_64 mssql-tools-14.0.2.0-1.x86_64 # ls -al /opt/ total 4 drwxr-xr-x. 5 root root 52 Jan 13 08:31 . ...
Sybil's user avatar
  • 2,518
4 votes
2 answers
2k views

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

We had a SQL Server 2008R2 Enterprise edition for our database to support a front-end application. We never had any timeout issues before. Recently the company decided to upgrade the database in to ...
Hailegziabher Dechassa's user avatar
4 votes
2 answers
2k views

DBCC Usage on production system

We have a system running SQL Server 2008 R2 on a Hyper-V VM (64GB RAM and 16 virtual cores). Another VM (the application server) within the system accesses the db server quite intensively for both ...
Fernando's user avatar
4 votes
1 answer
2k views

Mongodb incremental oplog Dump not working

I am not able to take an incremental oplog dump. I am not getting any error messages the connection happens fine and also there is a operation recorded(shows up in db.currentOp()), but still nothing ...
Prashanth Kumar B's user avatar
4 votes
1 answer
3k views

How to perform server-side transaction timeout if COMMIT TRANSACTION will never arrive?

How can SQL Server terminate one of its transactions if it exceeds preset timeout? Imagine the following transaction performed by traveling salesman's SQL client application, which is submitted ...
miroxlav's user avatar
  • 343
4 votes
1 answer
4k views

Connection Timeouts and Failed Database Connections on AWS RDS

Environment details - Amazon RDS running PostgreSQL 9.3.14, db.r3.xlarge, IOPS 2000, 500 GB Issue - Numerous java.sql.SQLTimeoutException: Timeout after 30000ms of waiting for a connection and java....
gvatreya's user avatar
  • 203
4 votes
2 answers
11k views

MySQL: How to decrease sleep process's time out?

When I run 'show processlist;', then I get so many sleep processes. I set wait_timeout and interactive_timeout to 60 in my.cnf. But, sleep process is not died when time 60 on processlist. I found ...
WitchOfCloud's user avatar
3 votes
1 answer
11k views

MongoDb max timeout for all queries

I am using MongoDb/PHP on a Linux server. The problem is that, if a query takes too long to execute, the mongo server stop (apache keeps running). So is there any way ,so that I can limit the time for ...
Mohammad Qasim's user avatar
3 votes
1 answer
4k views

mongodb: maxTimeMS ignored

After trying with different drivers and clients, we suffer with mongodb timeout on find query. Even Profiling logs the settings and issue well. 2014-08-13T23:46:43.218+0200 [conn80] query ...
ledy's user avatar
  • 695
3 votes
1 answer
2k views

Users time out (or it's very slow) authenticating to SQL Server, but RDP authenticates immediately

The authentication timeouts and slowness happen for both local SQL logins and Windows authentication using AD. Rebooting "masks" the problem for a while, but after 6-8 hours, we see them ...
RonJohn's user avatar
  • 647
2 votes
1 answer
4k views

Connection pool Error

I am getting the below error from my .net application. Source: xxx.Services.xxx.xxx.xxxx.xxxx.xxxxRequest --- System.Data.Entity.Core.EntityException: The underlying provider failed on Open. -...
user9516827's user avatar
  • 1,315
2 votes
1 answer
5k views

SQL Server timeout on DB and into connection string

Recently i have discovered (i have to premit i am not a DBA) that there is the possibility to configure a timeout into SQL Serve property (which apply to all DB into the SQL Server instance) : ...
Skary's user avatar
  • 368
2 votes
1 answer
8k views

Configure Mysql client timeout?

Is there a way to configure the timeout for inactive clients with mysql? Example: A MySQL DB has a limit of 100 client connections but some clients are not using the connection any more. I assume ...
benji's user avatar
  • 125
2 votes
2 answers
9k views

SQL Server Timeout Expired in ASP.NET C# WebForms application

I have the following issue on my database which is used by a c# ASP.NET application: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding....
Rob's user avatar
  • 121
2 votes
1 answer
4k views

Does SQL Server Clustering Enhance Performance?

I'm not experienced with SQL Server, I'm a novice. I'm a developer, and i think the question is more related to a Database Administrator. I'm working on an old legacy system where over time the ...
user avatar
2 votes
1 answer
8k views

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

I am getting SQL Server timeout error in my production server, every hour (~ for 5 minutes or more) during night time. This SQL server database is supporting a .NET application. I have scheduled an ...
sparktech's user avatar
  • 157
2 votes
3 answers
17k views

Oracle Client sessions keep disconnecting

We recently moved our Oracle server from a remote location to a local server and now the Oracle clients keep disconnecting. It does not seem to be a timeout issue because it happens while we are ...
Steve Lloyd's user avatar
2 votes
1 answer
438 views

Some timeout in query store but get all SP:Starting and SP:Completed in profiler

I have a report SP running. The user complaint report timeout sometimes. And I do get some canceled execution plan in my query store. But in my profiler tracing file, every SP:Starting has its SP:...
DBALUKE HUANG's user avatar
2 votes
1 answer
2k views

Query timeouts when duration is under a second

We are getting the following exception in an application: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. So, I looked at ...
Vaccano's user avatar
  • 2,496
2 votes
1 answer
13k views

Non-yielding Scheduler Error with dump caused by heavy queries on SQL 2016

After bringing our databases to new servers with new hardware and new os (2012 server) and new SQL Server version (2016 sp1) we face the following issue: During nightly reporting database update runs,...
Magier's user avatar
  • 4,797
2 votes
1 answer
11k views

SQL Server slow response when accessed from a remote client [closed]

We have a SQL Server in a remote location. If we access the server from the same location (internal IP, same IP as the server is using) the performance is good. We don't face any problem with ...
U1_R's user avatar
  • 21
2 votes
1 answer
1k views

Got timeout reading communication packets vs Got error reading communication packets

I felt "Got error reading communication packets" is related to max_allowed_packet variable and "Got timeout reading communication packets" is related 'net_read_timout' parameter or network issues. ...
kasi's user avatar
  • 419
2 votes
1 answer
2k views

PostgreSQL database connection time [closed]

How much Time does psql client takes to connect to PostgreSQL server ?
Hina Parmar's user avatar
1 vote
1 answer
585 views

Will Blocking cause timeout issue

When I check in sys.sysprocesses in SQL 2008R2, a number of blocking sessions are there. Most of them are insert, update, and delete statements, with lock-related wait types. Will this cause time out ...
kumar's user avatar
  • 161
1 vote
1 answer
162 views

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

Our system generates SQL with a very large number of tests. I suspect on some occasions it is taking too long to find the ideal execution plan. So SQL just picks the best plan it has found so far ...
SQLMIKE's user avatar
  • 437
1 vote
2 answers
130 views

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

We have been experiencing (perceived) issues with the write performance of our MS SQL Server for some time. As I believe it might be on the client side, I am looking for evidence to refute the ...
Martin's user avatar
  • 11
1 vote
3 answers
231 views

Is it a parameter sniffing problem?

I have a stored procedure which is called by Console Application (C#), the sp do nothing much just checking the existing of the record and update it: ALTER PROCEDURE [dbo].[sp_Update_StaffTable] ...
Jay Chen's user avatar
1 vote
1 answer
1k views

SQLServer Query Store not saving failed queries run by SP_ExecuteSQL

We are on SQL Server 2016 Query Store is activated on the database in question. We have had some timeout problems reported on a nightly batchjob, and we have located the query in question. The query ...
Peter Tilsted's user avatar
1 vote
1 answer
659 views

This failure occured while attempting to connect to the Principle server

One of our clients recently came to us with a problem he's facing while working with our application. The error in the log file is the next: System.Data.SqlClient.SqlException (0x80131904): Timeout ...
Paul Karam's user avatar
1 vote
1 answer
637 views

Disabling the recycle timeout settings in SSRS

In order to prevent periodic recycling of the SSRS service it's been suggested to disable the <RecycleTime> setting in the RS server's config file. I believe disabling would require setting ...
MikeDubya's user avatar
1 vote
1 answer
4k views

Query to Linked Server Ignores Configured Timeout Connection

I need to know where to set the timeout for a login or a query to a linked server. If the server is down I don't want to waste too much time waiting for a timeout. (Our servers are on the same network ...
Robbie's user avatar
  • 61
1 vote
2 answers
25k views

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

We have some software that is throwing an exception "Pooled connection request timed out" I know the reason for this and i know the fix. I just need to buy some time on the production server until i ...
CathalMF's user avatar
  • 111
1 vote
1 answer
662 views

HA SQL AlwaysOn backup using Copy Only + Logs from secondary replica

I'm hoping to elicit some guidance from your collective DBA experiences. Here's our problem: Full backups of our larger databases (around 3TB) are consuming too much resources such that we are ...
Jaans's user avatar
  • 113
1 vote
1 answer
4k views

Oracle database connection instant timeout

I have to check automatically if a connection to another database in oracle is vaild. I want a trigger to perform different actions based on whether the connection is vaild while it's running or not. ...
Gandalf The Gay's user avatar
1 vote
1 answer
768 views

Nothing changed; always get connection timeout on alter table in MariaDB

I have a MariaDB 10.1.21 database running in Fedora 25. I successfully ran alter table statements on auto_incrementcolumns in the past. After updating MariaDB to 10.1.21, but without changing any ...
Douglas Myers-Turnbull's user avatar
1 vote
1 answer
474 views

Timeout in SSIS package running DBCC CHECKDB

I have created an SSIS package to run DBCC CHECKDB on all the databases on the server and send error messages by email. But for several of the databases, I get an exception running my script: ...
Morten Nilsen's user avatar
1 vote
0 answers
93 views

MSSQL - Diagnosing Timeouts, Blocks

We found a scenario where a large delete in one table causes hanging across seemingly unrelated transactions and tables in the same the database (but not other databases on the same server). The good ...
breckit's user avatar
1 vote
0 answers
606 views

Avoid pgAdmin4 timeout that prevents disconnect

Connecting to PostgreSQL servers through pgAdmin4 will time out after some short period of time (2-5 min). When this happens I cannot reset the connection or disconnect from the server. The interface ...
Conor's user avatar
  • 111
1 vote
0 answers
4k views

mysql - importing large Tablespace: Lost connection during query

iam trying to recover innodb table which has 1.5M rows from ibd file ( 5.5 GB ) this is the exact steps i do: getting create table query using mysqlfrm command create the table Alter Table discard ...
Amr Ahmed's user avatar
1 vote
0 answers
36 views

SQLNCLI11 for linked server "my linked server" returned message "Query timeout expired." [duplicate]

We have two separate sql servers. On one server we have a datawarehouse DWH, on the other we have sales information. Now on the DWH server there is an ETL job that collects the information from the ...
user avatar
1 vote
0 answers
309 views

A transport-level error has occurred when receiving results from the server [duplicate]

Our application is made from asp.net webforms using framework 4.5. And since migrating to Amazon AWS from an inhouse server. We've been flooded by this error through out our system. On the software ...
Mark's user avatar
  • 11
1 vote
0 answers
106 views

Will longer DB transactions make calls to other DB wait?

I have a fundamental question but unable to find precise information online. I opened up a DB transaction (SQL Server) and making multiple inserts, updates, delete etc; the entire process takes about ...
CodeMad's user avatar
  • 111
1 vote
0 answers
117 views

MySQL Cluster 7.4.6 - Analyze table failure on 15m reference table

I'm running MySQL Cluster 7.4.6 on Azure VM's with the following infrastructure: 2 x Mgmt Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x MySQL API Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x Data ...
user3575333's user avatar
0 votes
2 answers
4k views

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

I have an application in which some reports time out before getting data. We started increasing timeout througout our code in different places, and as our database is growing bigger and bigger, we see ...
Saeed Neamati's user avatar
0 votes
1 answer
58 views

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

What happens when a client timeout occurs during the execution of a stored procedure that raises XACT_ABORT and wraps its body in TRY/CATCH blocks? I am looking at a bunch of procedures that generally ...
Betty Liv's user avatar