Questions tagged [query-timeout]
The query-timeout tag has no usage guidance.
49
questions
0
votes
1
answer
66
views
sql server replication issue
My SQL Server version is 2012 R2. I have one publishing machine with several publications, one distribution machine, and several subscription machines. Everything is working fine.
However, when I try ...
- 21
0
votes
0
answers
31
views
Sql-Server Performance Degradation on a specific DB
I have a production Sql Server 2019.150.4316.3 instance (2 Core licence) which holds two mid active databaes (~200 concurrent users) along with low active DBs, installed on a VM (64 GB Ram).
...
0
votes
1
answer
70
views
making query more efficient when there is a millions of row
My table consists of the following columns:
job_id,
event_type,
timestamp,
client_type,
role_type,
Every job_id has record of which event_type (example login, edit, delete) , what timestamp, which ...
- 1
3
votes
0
answers
248
views
Execution Plan changes between good and bad query plans (Azure SQL Server)
I've done my best to follow Why is my query suddenly slower than it was yesterday?
The ShowPlanXML parses fine with SQL Sentry Plan Explorer but not via brentozar.com/pastetheplan (not sure why) so I ...
- 175
0
votes
0
answers
1k
views
AWS RDS always gives a lost connection timeout error for slightly long queries
I have a huge database with many million row tables.
I have been running a few joins on these talbes.
And the query is identical but I'm doing it over many different tables.
My query worked for like ...
- 1
0
votes
1
answer
512
views
SQL Server Timeout only on production
I have an API endpoint that runs a query. For some reason, when I hit the production endpoint the query times out (after 2 minutes) but when I hit the same endpoint locally with my local environment ...
- 57
1
vote
0
answers
97
views
Can DST transitions cause "random" query timeouts?
I have encountered a query timeout ("Execution Timeout Expired") on a sub-second query on a connection set to 30 seconds timeouts. Client side logging indicated that 4 days elapsed between ...
- 182
0
votes
0
answers
469
views
Sql Job Failing with Timeout Error
Recently I have noticed that a job is failing on our Production 2014 SQL Server with this error text:
Timeout error [258]. [SQLSTATE 42000] (Error 258) OLE DB provider "SQLNCLI11" for ...
- 83
0
votes
1
answer
792
views
Mysql - Set timeout for Alter table & Update scripts
On MySQL 5.7.
I would like to prevent all alter table scripts \ update scripts that are taking longer than 10 minutes to run.
Is it possible?
I've tried to set MAX_EXECUTION_TIME and it does work but ...
- 365
0
votes
1
answer
608
views
Is there a way to determine the command timeout for an executing spid
Is there a DMV or other mechanism available that returns the command timeout for an executing session_id?
- 45
8
votes
2
answers
16k
views
How to set statement timeout per user?
I have multiple users in Postgres. I would like to set up different statement timeouts for different users.
Eg: Guest 5 minutes and Admin 10 minutes.
Is it possible in Postgres 11.11?
4
votes
1
answer
10k
views
How to inquire about current value of MAX_EXECUTION_TIME
I understand that I can set the value of the global MAX_EXECUTION_TIME by running (from mysql client):
SET GLOBAL MAX_EXECUTION_TIME
But how do I just inquire its value?
GET instead of SET does not ...
- 85
1
vote
4
answers
2k
views
How to quantify or locate command timeouts in Azure SQL
I am trying to if confirm query timeout in Azure.
Our frontdoor is reporting a 503 response at 30 Seconds response, as its the SQL server default value, I am trying to confirm if these are indeed ...
- 2,591
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
1k
views
Catch OLE DB provider "SQLNCLI10" for linked server "[Some Server]" returned message "Query timeout expired"
Without changing the settings on servers, etc to the linked server connections, etc, is there a way to catch the dreaded?
"OLE DB provider "SQLNCLI10" for linked server "[Some ...
- 21
2
votes
2
answers
13k
views
Linked server returned message "Query timeout expired."
We have two separate SQL Servers. On one server we have a data warehouse (DWH), on the other we have sales information database.
Now on the DWH server there is an ETL job that collects the ...
- 123
0
votes
0
answers
544
views
MySQL connection timeout issues
We have a PXC environment with three nodes, and each node has 8GB of total RAM, with half of that (4G) dedicated to SWAP, and 3GB configured for Innodb-buffer_pool_size. Our developers have reported ...
- 333
4
votes
1
answer
2k
views
How to put an execution time limit for MySQL Temporary table creation
We can use SET MAX_EXECUTION_TIME=10; statement to stop the execution of a SELECT statement, if it took more than 10 milliseconds to execute the query. But the same wont work for other statements like ...
- 163
1
vote
3
answers
889
views
What happens if a delete query times out SQL Server for php?
Technology
I am using the mssql extension to php (on linux) to send queries to SQL Server.
The Setup.
I have a table that builds up disposable data rather quickly. It took me longer than expected ...
- 343
-1
votes
1
answer
391
views
Why would SQL queries that use reserved words suddenly start causing problems?
In the past couple of days we have experienced issues with 3 different applications that have been running fine for several years. Errors #1 and #2 were caused by reserved words in SQL queries. I am ...
- 1
3
votes
2
answers
17k
views
Execute Stored Procedure with SET LOCK_TIMEOUT
Is there anyway to execute stored procedure with SET LOCK_TIMEOUT explicitly?
E.g. I have sproc called dbo.LoadData. It just takes data from table dbo.Abc and insert them in table dbo.Xyz.
Now I ...
- 131
2
votes
3
answers
896
views
Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
I have a SQL Environment of which I am sysadmin. This Environment includes the Company data warehouse. I conduct many different jobs from this Environment, and it is also Another sysadmin which has ...
- 197
3
votes
1
answer
2k
views
wait_timeout kills session in SLEEP MODE or all connection ?`
Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?
- 669
0
votes
1
answer
175
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?
- 103
2
votes
1
answer
640
views
Complex views cause time out?
I have this view vw_RFQPartVendor that's based on these two views vw_requestVendor and vw_vendorEmail and various other tables.
Every few days, it will cause time out error in my ASP.Net website and ...
- 153
0
votes
2
answers
4k
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 ...
- 1,417
0
votes
0
answers
576
views
How to know why my query times out sometimes, but gets executed other times (random behavior)?
I look at my code's logs, and see that a query to delete something which occurs like 200 times a day, sometimes times-out. I have no clue to how to debug this. Because it's a very random behavior. ...
- 1,417
2
votes
1
answer
2k
views
Query Exceeding Query Timeout on Linked Server and Working
Currently we have a SQL Server Agent job that executes a stored procedure that reads data over a linked server.
Initially on our test server this was timing out at 10m:17s (617 seconds). We changed ...
- 123
1
vote
2
answers
10k
views
MySql timeouts waiting for table lock, no apparent deadlocks
I started having the following error on two different applications that write to the same database and table:
Lock wait timeout exceeded; try restarting transaction
At the beginning I thought it ...
- 111
1
vote
2
answers
1k
views
How can I narrow down the cause of a deadlock after the fact?
We're using a .Net 4.5 web application with SQL Server 2012 on the same machine. We will sporadically see a cluster of "Wait operation timed out" exceptions while using the site. Occasionally we will ...
- 145
4
votes
2
answers
2k
views
Timeout expired SqlException for complex Procedure
I use SQL Server 2008 R2 and ASP.NET 4.5.
Sometimes, I get this error when I executed a complex procedure:
System.Data.SqlClient.SqlException
Timeout expired. The timeout period elapsed prior to ...
- 145
4
votes
2
answers
16k
views
Which timeout(s) are causing my linked server query to time out?
We have two databases on linked SQL Servers that are partially synchronized. Occasionally, one side goes down for an upgrade, then the other goes down for an upgrade, and then we re-synchronize.
...
- 800
0
votes
1
answer
3k
views
What is the Cassandra setting for coordinator timeouts for schema change queries?
In my testing, I've found that the write_request_timeout_in_ms setting does not have any bearing on the timeouts for CREATE TABLE or ALTER TABLE statements in CQL. For instance, I have it set to ...
- 275
4
votes
1
answer
9k
views
SQL Server stored procedures fast in SQL but slow when called by ASP.NET
I am using ASP.NET with MVC3 with a SQL server database.
From time to time, one of our stored procedures become incredibly slow when called by the web platform, but stay as fast when called directly ...
14
votes
2
answers
21k
views
Why "SET LOCAL statement_timeout" does not work as expected with PostgreSQL functions?
My understanding is that PostgreSQL functions are executed similar to a transaction. However, when I tried to "SET LOCAL statement_timeout" within a function, it did not work. Here's how it works ...
- 243
13
votes
3
answers
29k
views
Tracking Down Application Timeout Errors in SQL Server
SQL Server 2008 SP3
How do I track down these timeout errors ?
The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a ...
- 9,630
0
votes
1
answer
84
views
Will my query pick up where it stopped due to connection timeout?
I am doing a rather large query that hits MySQL connection timeout. I know how to change the timeout parameter, but I'm also query from a laptop that can't be left running for long.
The database ...
- 135
3
votes
2
answers
2k
views
SQL Profiler Shows Update (EventClass) with No Errors, But Data in Table is Not Changed
I am trying to debug a web app that uses a database and I need a little help. The problem is that part of the code throws a timeout error. I started using SQL Server Profiler to check the ...
- 163
6
votes
1
answer
9k
views
SQL Timeout to Principle Server Error
I am seeing a timeout to the Pricincipel SQL server (2008 R2)
The exact error I am seeing is this:
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server ...
- 161
4
votes
1
answer
2k
views
Database under heavier load -- all SQL queries start timing out after a period of hours/days
I make a web application which has experienced heavy growth in the past week and it appears my database is seizing up because of it.
You can see that everything seemed to be OK until about 3AM this ...
- 141
1
vote
1
answer
4k
views
Cassandra: Request did not complete within rpc_timeout
i was working with Cassandra 1.2.4 probably, after restoring some key-space when i tried to query in a key-space it gave me Request did not complete within rpc_timeout
so i checked system.log & ...
- 129
2
votes
0
answers
257
views
Collect information about currently running queries only when client timeout occurs [duplicate]
We would like to be able to collect information about all currently running queries when (and only when) a client timeout occurs in SQL Server 2008.
I know I can collect information about the client ...
- 371
0
votes
2
answers
463
views
Unclear oracle problem with getting response of query
The problem is very unclear,
I have an application server, that constructs queries and sends it to Oracle to get response.
The Oracle database is installed on a high perfomance server:
Linux 2.6.18-...
1
vote
0
answers
1k
views
Merge Replication Update Statement Timeout
I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
- 111
1
vote
0
answers
459
views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
- 291
0
votes
1
answer
2k
views
Getting timeouts and backup errors after mirroring and log shipping is setup
OS is Windows Server 2003 32 bit. SQL Server is SQL Server 2008 SP3 32 bit
Today I finished configuring database mirroring and log shipping for 3 databases on this SQL instance and started receiving ...
- 401
13
votes
2
answers
41k
views
SQL Server - How many type of timeouts can happen, and how?
When working with SQL Server, there can be multiple application host accessing it, and each application can have one or multiple connections. Each connection can potentially have multiple transactions ...
- 729
0
votes
1
answer
2k
views
timeout on updating nvarchar(max) after converting datatype
I recently Upgraded to 2008 Enterprise and took the opportunity to change the biggest table in my db with the maintenance window.
ran the following to change my ntext field
ALTER TABLE ...
- 2,591
11
votes
2
answers
44k
views
Client times out, while MySQL query remains running?
We experienced an issue in which a read-only query, run through MySQL workbench, timed out from a user's UI perspective and remained running on the server (and apparently consuming more and more ...
- 243