Questions tagged [timeout]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
308 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) : ...
user avatar
  • 287
3 votes
1 answer
117 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 ...
user avatar
  • 475
6 votes
1 answer
324 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). ...
user avatar
0 votes
0 answers
14 views

ORA-3136 but the client address is the dbserver itself

I keep observing ORA-3136 in the alert log of an Oracle database where the client ip corresponds to the dbserver itself. The port always changes and it's not the 1521. The customer is asking what ...
user avatar
0 votes
2 answers
77 views

How to resolve INSERT contention in Azure SQL Database?

I'm working with an Azure SQL Database that has a very hot logging table. Any time a row in any other table is inserted, updated, or deleted, the web application writes a row to this logging table. ...
user avatar
  • 2,048
0 votes
1 answer
39 views

UPDATE table IF data in another

I would like to retrieve some data from another table and put it in my first table. I used this query: UPDATE table_1 SET table_1.firstname = ( SELECT firstname FROM table_2 WHERE ...
user avatar
0 votes
1 answer
87 views

pg_settings.statement_timeout changing constantly between 0 and 30000?

When I run the following query constantly every few seconds over a 30 second time period, I sometimes get a value of 0 and other times a value of 30000. The value changes constantly and I don't know ...
user avatar
0 votes
0 answers
36 views

MongoDB restore. Recover after failure

Is it possible to resume mongo backup restoration after failure? I'm getting an error 2021-07-01T23:35:01.944+0200 Failed: dbname.collectionname_backup: error restoring from archive 'mongodb-db-...
user avatar
1 vote
1 answer
157 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 ...
user avatar
0 votes
0 answers
314 views

Got timeout reading communication packets

I am trying to create a ssh tunnel to my production database /usr/sbin/mysqld Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu)). When using my ssh-tunnel I get in my mysql error log file ...
user avatar
  • 135
1 vote
1 answer
1k 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 ...
user avatar
  • 61
0 votes
1 answer
743 views

The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted

One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes. End users are getting some error in the application that always point to the same error ...
user avatar
1 vote
1 answer
256 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 ...
user avatar
  • 151
1 vote
1 answer
407 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 ...
user avatar
0 votes
1 answer
76 views

What is difference between Lease Timeout and HealthCheck Timeout in AlwaysON?

this question was asked twice here but still there is no satisfied answer. Could someone explain the main difference between these two timeouts?
user avatar
  • 1,163
0 votes
1 answer
79 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
user avatar
1 vote
1 answer
80 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 ...
user avatar
  • 407
0 votes
1 answer
454 views

MySQL Lock Wait Time Out Exceeded upon Delete

I have a Delete Statement which fails with Below Exception com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction It waits for 50 ...
user avatar
1 vote
0 answers
3k 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 ...
user avatar
2 votes
1 answer
305 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:...
user avatar
1 vote
1 answer
413 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 ...
user avatar
0 votes
1 answer
2k views

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

We have a customer who is experiencing Time-outs in our .NET application which uses SQL Server as the backend. The table in question is the OrderLines table in a SQL Server Database that has 4155151 ...
user avatar
1 vote
0 answers
32 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
2 answers
19k 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 ...
user avatar
  • 111
0 votes
0 answers
201 views

Oracle: Replacing package body stuck

I have two schemas in my oracle database: XXX_MONITORING and XXX_MONITORING_CONFIGURATION. I had a script running on MONITORING_CONFIGURATION which is run with SQLPlus to update the database. I split ...
user avatar
  • 126
1 vote
0 answers
283 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 ...
user avatar
  • 11
0 votes
1 answer
271 views

Oracle 10g Database Locking Session Issue

I have a problem with locking and not timing out in one of my Oracle databases. This session locks occur on certain transactions that come from Oracle Forms users. For instance, when some user ...
user avatar
  • 11
2 votes
1 answer
2k 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. -...
user avatar
  • 1,295
0 votes
1 answer
116 views

telnet to mysql, which timeout is used?

When I telnet to a MySQL DB, the connection gets dropped quickly. Should I increase the interactive_timeout or the wait_timeout? (Background: trying to keep SSH port forwarding alive on 3306)
user avatar
  • 115
1 vote
1 answer
5k 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 ...
user avatar
  • 115
1 vote
3 answers
204 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] ...
user avatar
0 votes
0 answers
1k views

SQL 2014 Linked Server Login Timeout

I'm having an issue where an application (MS Nav 2015) invoked query (Select) on occasion is receiving a login timeout. This issue happen sporadically, and the query itself is run at 15 minute ...
user avatar
  • 333
2 votes
1 answer
7k 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 ...
user avatar
  • 157
1 vote
3 answers
13k 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 ...
user avatar
1 vote
1 answer
520 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 ...
user avatar
  • 113
1 vote
1 answer
3k 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. ...
user avatar
2 votes
1 answer
1k 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 ...
user avatar
  • 2,404
7 votes
2 answers
20k 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 ...
user avatar
  • 379
0 votes
1 answer
1k views

Connectivity timeout between cluster nodes

I lose communication between my clusters almost 1 am to 1.30 am and it shows errors like 35206 on primary, 976 on clusters, sometimes the cluster is removed due to lost heartbeat leading to 1135 error ...
user avatar
  • 634
1 vote
1 answer
599 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 ...
user avatar
1 vote
1 answer
10k 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,...
user avatar
  • 4,605
0 votes
1 answer
1k views

MySQL Query Timeout in PHP script, Upgrading to VPS

We've recently had to upgrade to a VPS from shared hosting because we were getting timeouts on a vital SQL query running from a PHP script. This PHP script runs hundreds of times a day at random ...
user avatar
  • 103
4 votes
1 answer
3k 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....
user avatar
  • 173
40 votes
3 answers
129k 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 ...
user avatar
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 . ...
user avatar
  • 2,198
0 votes
1 answer
160 views

MySQL: can deadlocks occur for a query not in a transaction

As title says. If a transaction is locking table X, during which another nono-transactional query tries to insert a record into X, do deadlocks or "lock wait timeout" issues still occur?
user avatar
  • 103
8 votes
2 answers
34k 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 ...
user avatar
  • 81
3 votes
1 answer
8k 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 ...
user avatar
0 votes
2 answers
3k 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 ...
user avatar
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 ...
user avatar