Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [timeout]

86 questions
46
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
  • 571
  • 1
  • 4
  • 3
11
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
  • 111
  • 1
  • 1
  • 3
7
votes
3 answers

Azure SQL Managed Instance: 1. excessive initial compile times leading to app timeouts and 2. partition maintenance: long-running, bloats data file

We are having a couple of issues preventing us from going live with an on-prem SQL 2016 Std Ed to Azure SQL Managed Instance Business Critical tier re-platform, and I was wondering if anyone had similar issues and had advice for us. Our issues…
Mike Petrak
  • 436
  • 6
  • 16
7
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
  • 379
  • 2
  • 4
  • 11
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
  • 483
  • 4
  • 11
5
votes
1 answer

Frequent Statistics updates in SQL Server 2022 Enterprise Edition

We recently migrated our database from SQL Server 2014 to SQL Server 2022 Enterprise Edition. Our compatibility level is set for 160. After migration we observed few stored procedures started timing out frequently. The main symptom we identified is…
Jaffer Mumtaz
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…
Sybil
  • 2,578
  • 6
  • 34
  • 61
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
  • 343
  • 3
  • 10
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
  • 201
  • 1
  • 4
  • 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
  • 856
  • 2
  • 8
  • 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
4
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
  • 41
  • 1
  • 1
  • 3
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
  • 705
  • 3
  • 12
  • 16
1
2 3 4 5 6