[9.0.304] execute timeout gets ignored

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
michabbb
Posts: 217
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

[9.0.304] execute timeout gets ignored

Post by michabbb » Fri 29 May 2020 20:27

hi alex,

i am connection via ssh (public key) and since the last major update i noticed, i am no longer able to execute queries, that take more than 30seconds. dbforge always stops with an error after 30 seconds, even my "execute timeout" is 320.
the server is able to handle long-running queries, but dbforge always stops after 30 seconds. for me it looks like, the "execute timeout" in my settings get ignored.

please let your devs check this.

thanks,
micha

alexa

Re: [9.0.304] execute timeout gets ignored

Post by alexa » Tue 02 Jun 2020 08:21

We are aware of this issue and will fix it in the next product build.

FergusMcGee
Posts: 6
Joined: Tue 02 Jun 2020 15:32

Re: [9.0.304] execute timeout gets ignored

Post by FergusMcGee » Tue 02 Jun 2020 15:36

Hi,

I'm having the same issue and it's affecting my work quite badly.

I have to run long running queries in , *shudders*, MySql Workbench.

Any idea when this might be fixed?

I'm tempted to rollback to a previous version.

alexa

Re: [9.0.304] execute timeout gets ignored

Post by alexa » Wed 03 Jun 2020 11:50

The new build with the fix should be released within a week's time.

FergusMcGee
Posts: 6
Joined: Tue 02 Jun 2020 15:32

Re: [9.0.304] execute timeout gets ignored

Post by FergusMcGee » Tue 09 Jun 2020 10:10

Hi,

Any update on this issue?

[email protected]
Posts: 1
Joined: Tue 09 Jun 2020 11:41

Re: [9.0.304] execute timeout gets ignored

Post by [email protected] » Tue 09 Jun 2020 12:36

Here same problem.. please advise if we should rollback to previous version.

michabbb
Posts: 217
Joined: Mon 21 Nov 2011 02:35
Location: DE
Contact:

Re: [9.0.304] execute timeout gets ignored

Post by michabbb » Wed 10 Jun 2020 09:58

hi alex,

please give us some infos.

thanks.

kirankumar
Posts: 2
Joined: Thu 11 Jun 2020 17:55

Re: [9.0.304] execute timeout gets ignored

Post by kirankumar » Thu 11 Jun 2020 18:21

Hi Alex,

When will this issue be solved?

alexa

Re: [9.0.304] execute timeout gets ignored

Post by alexa » Fri 12 Jun 2020 10:11

Unfortunately, the new build with the fix is postponed for another week.

In the meanwhile, we will send you a custom build with the fix.

Sorry for the inconvenience.

dwill
Posts: 11
Joined: Mon 15 Jun 2020 16:58

Re: [9.0.304] execute timeout gets ignored

Post by dwill » Mon 15 Jun 2020 17:02

Hello...

I am encountering the same issue since renewed our dbForge subscription/licenses and upgraded to 9.0.304.
All of my interactive queries (that i run in dbforge studio) get cancelled after about 30 seconds. Nothing has changed on our MySQL database/servers. I checked the connection properties and increased the Connection timeout, Execution timeout, and the Keep Connection alive to their max value allowed (7200). And still, all of my queries that i used to run before we renewed our licence and upgraded to the latest version, all of them get cancelled after 30 seconds.

Do i need to revert to the previous version? This is a very frustrating and is causing delays with my work. Can someone please help?

thanks...d

alexa

Re: [9.0.304] execute timeout gets ignored

Post by alexa » Tue 16 Jun 2020 05:55

We sent you a custom build with the fix.

dwill
Posts: 11
Joined: Mon 15 Jun 2020 16:58

Re: [9.0.304] execute timeout gets ignored

Post by dwill » Tue 16 Jun 2020 14:56

alexa wrote: Tue 16 Jun 2020 05:55 We sent you a custom build with the fix.
Hi...unfortunately, you did not. Someone sent me an email, but there was no custom build attached or a link to get to it. Can someone please help? I have a production deployment today and i will not be able to complete it if all of my queries keep timing out.

thanks...d

dwill
Posts: 11
Joined: Mon 15 Jun 2020 16:58

Re: [9.0.304] execute timeout gets ignored

Post by dwill » Tue 16 Jun 2020 15:24

Hi Alexa..

I was wrong. I was checking my work email because I also submitted a case to support for help and whoever responded to me did not send me any link or reference to the custom build.

However..you did send a link to my personal email. Thank you so much!! i appreciate the help.

dwill
Posts: 11
Joined: Mon 15 Jun 2020 16:58

Re: [9.0.304] execute timeout gets ignored

Post by dwill » Tue 16 Jun 2020 15:26

Hi Alexa..

I was wrong. I was checking my work email because I also submitted a case to support for help and whoever responded to me did not send me any link or reference to the custom build.

However..you did send a link to my personal email. Thank you so much!! i appreciate the help.

kirankumar
Posts: 2
Joined: Thu 11 Jun 2020 17:55

Re: [9.0.304] execute timeout gets ignored

Post by kirankumar » Tue 16 Jun 2020 19:23

The issue was solved with the custom build, however, from today the query gets timed out after 17 seconds. Please do something to resolve this.

Post Reply