Solved

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

  • 28 February 2023
  • 3 replies
  • 192 views

Badge +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”

 

 

icon

Best answer by Padmakumar 28 February 2023, 11:24

View original

3 replies

Userlevel 7
Badge +13

Hi @Tayyab 1511 ,

 

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

Badge +1

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?

 

Userlevel 7
Badge +13

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