Skip to main content

Questions tagged [timeout]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
78 views

How to set execution timeout in SSMS for SQL Server Programmatically

This is a follow up to my previous question How to set execution timeout in SSMS I want to set the execution timeout in SSMS Connection properties on the 'Connect to Server' page programmatically/...
RD Seeker's user avatar
0 votes
3 answers
139 views

How to set execution timeout in SSMS

I want to stop all the query that exceeds the given execution timeout value of an instance in SSMS. I tried to set the execution timeout in SSMS using multiple methods. Initially, I tried changing the ...
RD Seeker's user avatar
0 votes
0 answers
31 views

pgadmin connection to server error

I'm having a server-connection-error on pgadmin dashboard. I kept having a connection timeout error after prompting me to enter the password for user "postgres" after clicking on PostgreSQL ...
Alli Grace's user avatar
0 votes
1 answer
126 views

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 ...
Mike Petrak's user avatar
0 votes
1 answer
22 views

Pgbouncer: Can pgbouncer take reserve_pool_timeout in milliseconds?

Is it possible to specify pgbouncer reserve_pool_timeout in milliseconds, I have tried specifying it with '500 ms' but throwing an error and then tried specifying 0.5, this time no error but unable ...
mediocre's user avatar
  • 129
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
0 votes
1 answer
45 views

MSSQL Linked server login timeout

I have SQL running on several servers and I want to create DB links between the main server "A" and several other "child" servers (each one with their own SQL instance). I've ...
Daniel's user avatar
  • 11
0 votes
0 answers
15 views

OPC client trying to connect to OPC HDA server and end up in infinite waiting

I am quite new to OPC server/client. I have a service application serves as an OPC client, and trying to connect to OPC HDA server to data reading. There is a list of tags which their value at a ...
Zhang yy's user avatar
1 vote
2 answers
128 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
0 votes
1 answer
317 views

Many digest mismatches in debug.log, timeouts, read repairs

I am trying to understand the cause of many very short timeouts in my Cassandra cluster(8 nodes, version 3.11.5). The graph shows the following metric: org:apache:cassandra:metrics:clientrequest:.*:...
DisjunkteMenge's user avatar
0 votes
1 answer
268 views

Is it safe to configure Lock Escalation as 'AUTO' for partitioned tables

LOCK_ESCALATION= AUTO. In one of our Data warehousing product we use partitioned tables. They are partitioned based on an integer column. We have implemented partitioning here so we can easily switch ...
ishan verma's user avatar
0 votes
0 answers
126 views

PostgreSQL query times out when selecting a smaller amount of data (different query plan)

PostgreSQL 15.2. We have a table like this (simplified): create table behavior.event_59 ( event_id integer not null primary key, second_offset integer not null, -- ... more columns ) ...
EM0's user avatar
  • 190
0 votes
0 answers
377 views

MySQL losing connection after few minutes while waiting

I have an annoying problem. I think the connection is lost when there is no operation in mysql for a while. I've added a video to make it more explanatory. I tried the solutions on the internet but ...
Dream59's user avatar
-1 votes
1 answer
320 views

Diagnosing Timeouts and Blocks on SQL Server [duplicate]

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
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
605 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
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
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
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
0 votes
2 answers
351 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. ...
Mark Freeman's user avatar
  • 2,181
0 votes
1 answer
441 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 ...
Kravennagen's user avatar
0 votes
1 answer
657 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 ...
Actarus's user avatar
0 votes
0 answers
351 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-...
Alexey  Usharovski's user avatar
1 vote
1 answer
636 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
0 votes
0 answers
893 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 ...
Carol.Kar's user avatar
  • 135
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
0 votes
1 answer
2k 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 ...
chittybang's user avatar
1 vote
1 answer
584 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
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
0 votes
1 answer
134 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?
Rauf Asadov's user avatar
  • 1,273
0 votes
1 answer
180 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 ...
Mikhail Aksenov's user avatar
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
0 votes
1 answer
871 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 ...
user3865748's user avatar
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
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
1 vote
1 answer
658 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
0 votes
1 answer
3k 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 ...
SamoanProgrammer'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
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
0 votes
0 answers
373 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 ...
Adder's user avatar
  • 126
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
0 votes
1 answer
380 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 ...
ArnauVJ's user avatar
  • 11
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
0 votes
1 answer
188 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)
benji's user avatar
  • 125
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
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
0 votes
0 answers
2k 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 ...
Krishn's user avatar
  • 373
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
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