Questions tagged [query-timeout]
The query-timeout tag has no summary.
47 questions
0
votes
1
answer
300
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 ...
- 23
0
votes
1
answer
95
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
348
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
1
answer
655
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 ...
- 67
1
vote
0
answers
124
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
666
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 ...
- 73
0
votes
1
answer
1k
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 ...
- 375
1
vote
1
answer
1k
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?
- 55
8
votes
2
answers
24k
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?
5
votes
1
answer
14k
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 ...
- 195
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,601
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
2k
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
4
votes
2
answers
21k
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 ...
- 143
0
votes
0
answers
575
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 ...
- 343