Questions tagged [timeout]

The tag has no usage guidance.

18 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
2answers
4k 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
979 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. ...
1
vote
0answers
110 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
1answer
554 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
1answer
6k 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,...
1
vote
0answers
51 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
0answers
104 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 ...
0
votes
1answer
28 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
0answers
25 views

MongoDB connection initialisation delay on certain Windows 10 devices

System info OS Name: Microsoft Windows 10 Enterprise OS Version: 10.0.17134 N/A Build 17134 MongoDB Version MongoDB 4.2.1 x64 Windows. Overview When forming a ...
0
votes
0answers
42 views

PowerBI ReportServer: Deviceinfo Name already exists Parameter name: deviceinfoName

We have a few reports that autorefresh. On occasion users get the following error: Deviceinfo Name already exists Parameter name: deviceinfoName This sounds like the same problem described here: ...
0
votes
0answers
44 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
460 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
5k 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
175 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
72 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 ...
0
votes
1answer
86 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
0answers
719 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 ...
0
votes
1answer
103 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 ...