Skip to main content

Questions tagged [timeout]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
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/...
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 ...
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 ...
0 votes
0 answers
32 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 ...
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:.*:...
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 ...
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 ...
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 ...
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: ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ) ...
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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) : ...
2 votes
1 answer
2k views

PostgreSQL database connection time [closed]

How much Time does psql client takes to connect to PostgreSQL server ?
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). ...
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. ...
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 ...
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 ...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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?
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 ...
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 ...
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:...
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....
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...