Questions tagged [timeout]
The timeout tag has no usage guidance.
71
questions
0
votes
1
answer
136
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
161
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
70
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
312
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
214
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
79
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
490
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
4k
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) :
...
- 358
3
votes
1
answer
1k
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 ...
- 606
6
votes
1
answer
3k
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).
...
- 453
0
votes
2
answers
288
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,151
0
votes
1
answer
341
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
575
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
280
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
524
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
749
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
3k
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 ...
- 127
1
vote
1
answer
517
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
880
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
125
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,253
0
votes
1
answer
170
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 ...
- 421
1
vote
1
answer
144
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
817
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 ...
- 11
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 ...
- 11
2
votes
1
answer
411
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:...
- 429
1
vote
1
answer
597
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
34
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
24k
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
319
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
306
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
356
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
3k
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,295
0
votes
1
answer
180
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
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 ...
- 125
1
vote
3
answers
226
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 ...
- 353
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 ...
- 157
2
votes
3
answers
16k
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 ...
- 121
1
vote
1
answer
619
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 ...
- 113
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. ...
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 ...
- 2,484
7
votes
2
answers
24k
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 ...
- 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 ...
- 644
1
vote
1
answer
727
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 ...
2
votes
1
answer
12k
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,...
- 4,757
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 ...
- 103
4
votes
1
answer
4k
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....
- 203
45
votes
3
answers
167k
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 ...
- 561