Skip to main content
Solved

Data Base error. mysql odbc 5.3(w) driver mysqld-5.7.33 query execution was interrupted

  • February 28, 2023
  • 3 replies
  • 285 views

Forum|alt.badge.img+1

 

Hi, All I am facing this issue continuously in the V11 environment, below is the error, i have checked my database connection as well everything is working properly. Below is the error. I am using Workbench db.

“mysql odbc 5.3(w) driver mysqld-5.7.33 query execution was interrupted”

 

 

Best answer by Padmakumar

Tayyab 1511 wrote:
Padmakumar wrote:

Hi @Tayyab 1511 ,

 

Try to add Maximum execution time along with the Query. (Will work only for Read-only SELECT statement)

How can i add this in my query??? can you please give me an example?

 

 

Below is a sample query for reference.

 

select /*+ MAX_EXECUTION_TIME(1000) */ * from [Sheet1$$]

View original
Did this topic help answer your question?

3 replies

Padmakumar
Forum|alt.badge.img+14
  • Flight Specialist | Tier 4
  • 792 replies
  • February 28, 2023

Hi @Tayyab 1511 ,

 

Try to add Maximum execution time along with the Query. (Will work only for Read-only SELECT statement)


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 1 reply
  • February 28, 2023
Padmakumar wrote:

Hi @Tayyab 1511 ,

 

Try to add Maximum execution time along with the Query. (Will work only for Read-only SELECT statement)

How can i add this in my query??? can you please give me an example?

 


Padmakumar
Forum|alt.badge.img+14
  • Flight Specialist | Tier 4
  • 792 replies
  • Answer
  • February 28, 2023
Tayyab 1511 wrote:
Padmakumar wrote:

Hi @Tayyab 1511 ,

 

Try to add Maximum execution time along with the Query. (Will work only for Read-only SELECT statement)

How can i add this in my query??? can you please give me an example?

 

 

Below is a sample query for reference.

 

select /*+ MAX_EXECUTION_TIME(1000) */ * from [Sheet1$$]


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings