Questions tagged [timeout]
The timeout tag has no usage guidance.
83
questions
0
votes
1
answer
27
views
Troubleshooting - Timeout from database without a specific procedure
I've got a performance degradation without a specific stored procedure being timeout.
there are some errors here it is listed from most to least:
Execution Timeout Expired. The timeout period elapsed ...
- 47
0
votes
0
answers
229
views
TCP Provider, error: 0 - The wait operation timed out
I have a system where many users connect to a database SQL Server through an application, everything works as it should, but sometimes, very rarely, an error occurs.
Message: A network or instance-...
- 1
0
votes
0
answers
97
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/...
- 11
0
votes
3
answers
308
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 ...
- 11
0
votes
0
answers
112
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 ...
7
votes
3
answers
1k
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 ...
- 416
0
votes
1
answer
48
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 ...
- 341
1
vote
1
answer
100
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 ...
- 43
0
votes
1
answer
82
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 ...
- 11
0
votes
0
answers
23
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
1
vote
2
answers
158
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 ...
- 11
0
votes
1
answer
382
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
329
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 ...
- 29
0
votes
0
answers
158
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
)
...
- 190
0
votes
0
answers
397
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
-1
votes
1
answer
356
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 ...
- 9
1
vote
0
answers
97
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 ...
- 9
1
vote
0
answers
657
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 ...
- 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) :
...
- 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 ...
- 646
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).
...
- 473
0
votes
2
answers
375
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. ...
- 2,191
0
votes
1
answer
474
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
693
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 ...
- 3
0
votes
0
answers
377
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-...
1
vote
1
answer
670
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 ...
- 11
0
votes
0
answers
946
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 ...
- 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 ...
- 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 ...
- 141
1
vote
1
answer
600
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 ...
- 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 ...
- 177
0
votes
1
answer
140
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?
- 1,303
0
votes
1
answer
192
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 ...
- 430
1
vote
1
answer
173
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 ...
- 437
0
votes
1
answer
897
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 ...
- 21
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 ...
- 11
2
votes
1
answer
454
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:...
- 439
1
vote
1
answer
678
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 ...
- 111
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 ...
- 101
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 ...
Leon
1
vote
2
answers
26k
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 ...
- 111
0
votes
0
answers
390
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 ...
- 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 ...
- 11
0
votes
1
answer
386
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 ...
- 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. -...
- 1,335
0
votes
1
answer
192
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)
- 125
2
votes
1
answer
9k
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 ...
- 125
1
vote
3
answers
232
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]
...
- 13
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 ...
- 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 ...
- 157