Questions tagged [timeout]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
29 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 ...
1
vote
0answers
22 views

“The wait operation timed out” after 120secs of CREATE INDEX called from SMO TransferData method [migrated]

Recently created a C# tool using SMO class to automate the refactor and merge of SQL Server databases for migration into Azure. The TransferData method successfully adheres to the BulkCopyTimeout for ...
0
votes
1answer
51 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
0answers
25 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
0answers
22 views

Execute SQL Task timeout setting is being ignored for Redshift ODBC Connection

When I run an SSIS SQL Task (VS 2017) against an ODBC Amazon Redshift (32 bit) connection, the timeout setting is not being respected and the Task/SQL continues to run endlessly.
0
votes
0answers
326 views

large dump: mysqldump: Got error: 2013: Lost connection to MySQL server

I need to dump to a text file a large database, which comprises one laaaarge table. I'm ding it like this: # mysqldump -p --single-transaction --quick --max-allowed-packet=2147483648 --tab=/mnt/...
0
votes
2answers
538 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 ...
0
votes
0answers
47 views

Usage of KeepAlive property in PostgreSQL Connection string

I just resolved my following PostgreSQL server connection timeout problem by using KeepAlive property in Connection String. Exception while reading from stream My proper working postgreSQL ...
0
votes
0answers
54 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
0answers
58 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 ...
0
votes
1answer
42 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 ...
2
votes
1answer
508 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. -...
0
votes
1answer
49 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)
0
votes
1answer
1k 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 ...
1
vote
3answers
100 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] ...
0
votes
0answers
354 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 ...
1
vote
1answer
3k 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 ...
0
votes
3answers
2k 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 ...
1
vote
1answer
286 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 ...
1
vote
1answer
1k 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. ...
0
votes
1answer
402 views

Sql Server 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 ...
1
vote
2answers
7k 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 ...
0
votes
1answer
519 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 ...
1
vote
1answer
249 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 ...
0
votes
0answers
5k 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
1answer
725 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 ...
3
votes
1answer
1k 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....
14
votes
3answers
35k 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 ...
5
votes
1answer
5k 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 . ...
0
votes
1answer
148 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?
6
votes
2answers
17k 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 ...
1
vote
1answer
2k 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 ...
0
votes
2answers
2k 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 ...
3
votes
2answers
1k 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 ...
1
vote
1answer
6k views

SQL Server slow response when accessed from a remote client [closed]

We have a SQL Server in a remote location. If we access the server from the same location (internal IP, same IP as the server is using) the performance is good. We don't face any problem with ...
4
votes
2answers
1k views

DBCC Usage on production system

We have a system running SQL Server 2008 R2 on a Hyper-V VM (64GB RAM and 16 virtual cores). Another VM (the application server) within the system accesses the db server quite intensively for both ...
5
votes
3answers
10k views

How to reduce huge CXPACKET & LATCH_EX (ACCESS_METHODS_DATASET_PARENT) wait times?

Problem We have been experiencing high levels of user disruption due to SQL timeouts accross our systems since the beginning of the year. The SQL-Server instance in question has very high CPU usage (...
4
votes
1answer
930 views

Mongodb incremental oplog Dump not working

I am not able to take an incremental oplog dump. I am not getting any error messages the connection happens fine and also there is a operation recorded(shows up in db.currentOp()), but still nothing ...
1
vote
1answer
893 views

Got timeout reading communication packets vs Got error reading communication packets

I felt "Got error reading communication packets" is related to max_allowed_packet variable and "Got timeout reading communication packets" is related 'net_read_timout' parameter or network issues. ...
2
votes
2answers
3k 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 ...
2
votes
1answer
2k views

Does SQL Server Clustering Enhance Performance?

I'm not experienced with SQL Server, I'm a novice. I'm a developer, and i think the question is more related to a Database Administrator. I'm working on an old legacy system where over time the ...
1
vote
0answers
50 views

Will longer DB transactions make calls to other DB wait?

I have a fundamental question but unable to find precise information online. I opened up a DB transaction (SQL Server) and making multiple inserts, updates, delete etc; the entire process takes about ...
1
vote
1answer
1k views

PostgreSQL database connection time [closed]

how to check how much time PostgreSQL database takes for making connection?
0
votes
1answer
825 views

How to handle lock timeout error in MySQL?

I am getting below listed error many times in my application log. 2015-05-19 10:27:57,842 ERROR [Timer-3] [org.hibernate.util.JDBCExceptionReporter] Lock wait timeout exceeded; try restarting ...
1
vote
0answers
103 views

MySQL Cluster 7.4.6 - Analyze table failure on 15m reference table

I'm running MySQL Cluster 7.4.6 on Azure VM's with the following infrastructure: 2 x Mgmt Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x MySQL API Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x Data ...
4
votes
1answer
1k views

How to perform server-side transaction timeout if COMMIT TRANSACTION will never arrive?

How can SQL Server terminate one of its transactions if it exceeds preset timeout? Imagine the following transaction performed by traveling salesman's SQL client application, which is submitted ...
2
votes
2answers
8k 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
1answer
82 views

Transaction Rollback

I have a purging process that runs to delete old data from table to avoid table growth. My delete statement would be a simple delete based on join something like below Delete FROM TABLE_A A JOIN ...
3
votes
1answer
3k views

mongodb: maxTimeMS ignored

After trying with different drivers and clients, we suffer with mongodb timeout on find query. Even Profiling logs the settings and issue well. 2014-08-13T23:46:43.218+0200 [conn80] query ...
0
votes
1answer
825 views

Is is possible to handle a UserAbort or ClientTimeOut within a Stored Procedure?

An example: create proc [dbo].[usp_SlowProc] as begin try set xact_abort on; -- Ensures rollback on some errors that bypass the try/catch mechanism raiserror('Waiting...', 0, 1) ...