Stack Overflow
Stack Overflow

Questions tagged [query-timeout]

26 questions
6
votes
1 answer

Need help diagnosing SQL Server strange query timeouts from C#

I have developed many .NET / SQL Server applications but I'm suffering from SQL query timeouts that I can't get to the bottom of. I have lots of experience in this area of finding the offending queries and re-indexing / re-writing them. My web app…
Stu Price
  • 163
  • 12
3
votes
1 answer

Changing QueryTimeout from sqlsrv_query

I'm experiencing problems with a slow running query that takes more than 30 seconds to execute at times, I would therefore like to increase my sqlsrv_query timeout. Fatal error: Maximum execution time of 30 seconds exceeded I'm having trouble with…
BernardV
  • 640
  • 10
  • 28
3
votes
4 answers

How to improve ColdFusion MySQL query time?

I have 15 queries that generate data for a table on a page dynamically for the purpose of reports. Each query takes between 250 and 900ms which means a page loading time of 4 to 13 seconds depending on server load. The loading time is causing some…
blarg
  • 3,773
  • 11
  • 42
  • 71
2
votes
2 answers

How to debug query timeout in SQL Server?

I'm getting an SQL query timeout for a simple query: delete from Prices where Id=123 Id is a PK column. The server is not under high load - something is wrong with few other queries. How can I debug this situation? I use SQL Server Express…
Nikolay R
  • 957
  • 2
  • 11
  • 22
2
votes
0 answers

@Transactional with timeout is not working in Springboot Application for value other than 1 (timeout=1)

I am using spring-boot-starter-data-jpa from Spring Boot 2.0.2.RELEASE, using spring-data-jpa. DB is Oracle. JDK 1.8. I am using @Transactional on top of a method that is calling a long-running query. When the transaction timeout is set to 1, the…
raqm
  • 41
  • 4
2
votes
1 answer

jdbcTemplate setQueryTimeout value type

I would like to know what is the type of value which we need to pass in public void setQueryTimeout(int queryTimeout) in jdbcTemplate. The document says > Set the query timeout for statements that this JdbcTemplate executes. >

Default is -1,…

Alex Man
  • 4,746
  • 17
  • 93
  • 178
1
vote
1 answer

ADFv2 Lookup Activity timeout after 2 hours even after increasing query timeout value

I have a lookup activity that timeouts after the 2 hours (120 mins) which is the default (could be just a coincidence) even after increasing the query timeout to 720 mins. The lookup activity executes a Proc based on an expression. This is the…
Geezer
  • 513
  • 5
  • 17
1
vote
0 answers

how to set timeout of query in codeigniter

I want to set query timeout if it takes more than 5 seconds. I have tried $db['default']['options'] = array(PDO::ATTR_TIMEOUT => 5); code but it closes the connection. Is there any workaround?
angularjsBeginner
  • 43
  • 1
  • 8
1
vote
1 answer

Troubles setting up query time-out connection in spring application

I'm having issues setting up the query time out of my application. I'm using spring-boot, we implemented a Jdbc template to handle the connections (connections pool, Hikari, disabled). I've tried setting up the query time-out connection in my…
martinc
  • 13
  • 4
1
vote
1 answer

MS Access 2013, SQL Server 2012 Express, query timeout

I have an app using SQL Server 2012 Express on the local with a Microsoft Access 2016 frontend with forms, macros and modules. It is used in the field to gather inspection data, including many photographs. The problem is that when inserting to the…
DLWyer
  • 21
  • 4
1
vote
0 answers

Oracle Select query : ORA-01013: user requested cancel of current operation

In my code a long select statement gives this exception: ORA-01013: user requested cancel of current operation. I am using Jboss 4 and ojdbc6 . Jboss/java terminates this query after 5 minutes, but when I execute this query in Toad it takes more…
gifpif
  • 4,507
  • 4
  • 31
  • 45
1
vote
1 answer

DB2 Mainframe: queryTimeout does not work on SqlTransactionRollbackException: SQLCODE=-911, SQLSTATE=40001

We have been seeing this following exception from DB2 Mainframe. We do have CallableStatement.querytimeout set, but it never really works in this case. Any suggestions? Thanks. DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, …
user3692238
  • 13
  • 4
1
vote
1 answer

Query Timeout when running t-sql save or update statements compiled in vba and run in SQL Server

My company is currently running SQL Server 2000, and about to make the jump to SQL Server 2012, but before we move the upgrade, we want to try and clear up a performance issue that has recently cropped up and is plaguing our ability to do…
user3083114
  • 11
  • 3
1
vote
1 answer

how to solve time-out HYT00 teraData

i have been working on asp.net and charts and i want to run a query that would display data in charts. however, the query takes a lot of time and every time the error comes that time-out. the query is : select Colum, SUM(CASE WHEN column1 = 1…
user1901398
  • 61
  • 1
  • 3
  • 7
0
votes
1 answer

SQL Server query times out

I have created a SQL query that runs on SQL Server 2008. For some reason it takes a long time and times out incomplete. This is my query modified for test purposes. The column FileData is a varbinary(max) and the primary key is ContentFileId. As you…
johna
  • 10,540
  • 14
  • 47
  • 72
1
2