Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [timeout]

63 questions
39
votes
3 answers

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 close the connection after 60 seconds. Could this be…
Andrzej Gis
  • 501
  • 1
  • 4
  • 3
7
votes
2 answers

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 troubleshoot? I check the application logs and DBs logs to…
Spinach
  • 71
  • 1
  • 1
  • 2
6
votes
1 answer

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). Output from the job: Date and time: 2022-01-22…
Eitan Blumin
  • 346
  • 2
  • 10
5
votes
2 answers

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 restarting transaction.We run the same test for a…
Dio Phung
  • 359
  • 2
  • 4
  • 11
5
votes
1 answer

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 . drwxr-xr-x. 17 root root 4096 Jan 13 07:55…
Josefine
  • 2,158
  • 3
  • 28
  • 55
5
votes
3 answers

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 (higher than 90% on all 16 cores all the time)…
matskm
  • 53
  • 1
  • 1
  • 3
4
votes
1 answer

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 command-by-command (i.e. not as single batch) and…
miroxlav
  • 333
  • 2
  • 9
4
votes
1 answer

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.lang.RuntimeException: Failed to get a database…
gvatreya
  • 173
  • 3
  • 8
4
votes
2 answers

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 SQL Server 2014 Enterprise edition with 2 node…
Hailegziabher Dechassa
  • 836
  • 2
  • 7
  • 22
4
votes
2 answers

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 querying and data updates. We have been experiencing…
Fernando
  • 41
  • 2
4
votes
1 answer

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 happens, not sure why? I have executed the same…
Prashanth Kumar B
  • 171
  • 6
3
votes
1 answer

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 mdb.fcol query: { $query: { unid:…
ledy
  • 695
  • 3
  • 11
  • 16
3
votes
1 answer

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 a query to execute, and kill the process…
Mohammad Qasim
  • 43
  • 1
  • 6
3
votes
2 answers

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 that sleep process is died when time is 7900. What…
WitchOfCloud
  • 31
  • 1
  • 3
2
votes
2 answers

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. I've tried sp_who and sp_who2 to check the cmd's…
Rob
  • 121
  • 1
  • 4
1
2 3 4 5