dbforge mysql 5.0.60 hangs every 5 minutes

[vkimura]

This version is hanging and the only way to kill it is to kill the process via Windows Task Manager. The previous version was working fine. This version does not work properly.

Windows Home Prem Vista, 3 GB ram, dual core 1.73 Ghz.

Please provide links to previous versions because the latest versions may have bugs in it. Please provide these link ASAP.

[alexa]

Could you please provide us the version of the MySQL server and connection settings that you're using.

Please note that you can always download previous versions of dbForge Studio for MySQL in the user registered area where there is a link to the page with previous product builds.

[vkimura]

The MySQL version is 5.5.8-log.

The connection settings I've tried and was using previously was:

1) SSH. These settings were tested because I could login via Putty. I had to downgrade to dbforge 4.5.314 because it was the last known version to work. Now this does not work. Also, all my ftp settings were erased. I looked in the registry too. The old settings are not there.

I test SSH settings in dbforge and it states Bad Handshake. So with the latest version 5.x) there were several "hangs" after 5 minutes of use but the connection worked.

After the downgrade, the connections do not work and I get a "Bad Handshake" but there are no "hangs".

Frustrating to say the least.

You should have several versions that people can use rather than overwriting the previous as this is causing several problems and several fronts. Doing this I believe would have avoided alot of these problems now.

Here is a snapshot of the settings page:
http:/mysql.tutorialref.com/dbforge-mysql-ssh-settings.jpg

Here is the General tab settings with SSH enabled:
http:/mysql.tutorialref.com/dbforge-mysql-ssh-general-settings.jpg

Here is the General tab settings without SSH:
http:/mysql.tutorialref.com/dbforge-mysql-regular-settings-without-ssh.jpg

I've tested all the settings in either Putty or WS-FTP with SFTP and FTP and they all work.

[alexa]

We were not able to reproduce the issue with hanging on dbForge Studio for MySQL, v.5.0.60 and will keep further correspondence with you on this issue via our support system.

[dp1795]

I have been having UI hanging problems with the various versions of 4 and 5 dbforge releases over the past year.

The problem seem intermittent (although I dont know where any log files or debug log files if they exist to check).

The result of the problem, is that the UI hangs (first with waiting cursor, and then arrow cursor but app is completely unresponsive to mouse/keyboard focused input.

It requires an end task from task manager. The end task alway causes dbforge to respond by asking to save files (and this actually at least lets me save tabs/files). But if I cancel the exit in dbforge save dialog, dbforge goes back to its prior state of hanging / frozen UI input.

This happens to me at least 2-3 times a day when using the application for a few hours.

Details about my environment:
Windows 7 SP1 x64 - 16GB RAM - AMD X6 CPU

I use 1 to 3 connections defined. All connections are ssh, default everything.

MySQL versions connecting to are:
5.0.92 x86_64
and recently
5.2 and 5.3.3 mariadb (just few days ago, same problems exist before/after)

From my developers perspective a state is entered that UI is waiting/hung on and their is no timeout or oppty to stop/cancel whatever op is hanging. From other post, and looking through previous version changelog, there has been hanging problems that have been found and corrected in the past. I think the one(s) that I have, have been around for a while and in several back versions as well.

I really like the product for mysql development, but the hanging multiple times a day is a complete productivity killer and I have lost work to many times due to it as well.

What can I do to help diagnose the problem, log files, debug/trace options I can turn on?

Thanks,
Darren

[alexa]

We are currently investigating the issue. In the meanwhile, could you please send us the result of the following query:

SHOW VARIABLES LIKE 'wait_timeout'

[dp1795]

The variable is set to: 28800
on the 2 main connections I use.

It is set to: 120 and 3600 for the occasional 2 production connections that I use (problems existed before these 2 connections were created/used)

-Darren

[alexa]

Please try to perform the procedure below for all the connections where you're experiencing such problems:

1. Right-click the connection in Database Explorer and select 'Modify Connection' from the popup menu. The Connection Properties dialog box opens.
2. Switch to the 'Advanced' tab and select the 'Keep connection alive' option.
3. In the 'Ping timeout' field, enter, let's say, 100.

Please let us know if it helps.

[dp1795]

I changed the settings referenced and within 30 mins, had same hang problem again.

One thing I noticed this time (not sure if all the time is there), is UI status bars says:
building code completion...

while it is hung.
What else can I try?
Is there any diagnostic logging I can turn on to see where problem happens?
Thanks,
Darren

[alexa]

We would like to let you know that the new version 5.0.67 of dbForge Studio for MySQL has been released and is available for downloading: http://www.devart.com/dbforge/mysql/stu ... nload.html

Please install this new version and contact us in case the issue still persists.

[effetb]

Hi,

Same problem Here with 5.0.72
When I'm not using dbForge for a moment (5-10 minutes), if I try to execute a request the soft is hanging. If I kill it with the task manager dbForge ask me to save open Sql windows but if I cancel the kill, dbforge stay frozen...

It's really a nice soft but this problem is really annoying...
What could I do to solve this issue ?

Thanks

[alexa]

We will continue investigating this problem.

[walbeben]

Using 5.0.82 here; is hanging when I open a SQL file for executing (inserting into tables) - what's strange is that after clicking "End process" and cancelling the "Windows is searching for a solution" alert, even when killing the process (tree) from Task Manager, it refuses to die for at least 2-3 minutes. I'm using Win7.

[alexa]

You are using an old version of the product. Please install the latest build 5.0.97 of dbForge Studio for MySQL: http://www.devart.com/dbforge/mysql/stu ... nload.html

Please send us the SQL file you are opening to supportATdevartDOTcom in case the problem still persists.