Posts:
1
Registered:
6/22/10
|
|
|
|
Toad Hangs - has to be terminated
Posted:
Jan 6, 2011 3:49 AM
|
|
|
I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software, and I can't quit and I have to terminate the process. This happens several times a day.
Running on Windows 7 x64. Anybody know what's going on and how to fix this/
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Jan 20, 2011 10:53 AM
in response to: andyd01
|
|
|
Is your machine low on memory? It sounds like Toad is swapped out of primary memory.
|
|
|
Posts:
4
Registered:
4/19/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Apr 19, 2011 12:02 PM
in response to: Mauritz
|
|
|
I also see this problem. I notice it most often when I leave for the day and leave Toad running, when I come back in the morning, Toad doesn't work properly, so I attempt to close and reopen it, and that doesn't work, so I have to kill the process from the Task Manager.
This will happen whether Toad is the only thing running or if there are other programs running as well. If needed, I will add more detail about exactly what happens when I come in tomorrow morning.
I am running Windows 7 Pro (32-bit) with 2GB of RAM. I'm using Toad for MySQL 5.0.0.345.
Travis
|
|
|
Posts:
4
Registered:
4/19/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Apr 20, 2011 3:56 PM
in response to: Travesty3
|
|
|
OK, if I leave it sitting for more than about 5-10 minutes, I see this problem.
After leaving it sitting, nothing on the screen appears to happen. There is no indication that any queries are running. The Cancel Execution button is grayed out and the last query finished executing a while ago.
If I attempt to run a new query, I get a message that says that a query is already running and it gives me the options for a new sub connection, cancel the query, or queue this query. It doesn't really matter which option I choose, nothing seems to work.
If I attempt to close the program, regardless of whether or not I've attempted to run another query (unsuccessfully, as described above), the program will not close. It just hangs, and I am forced to kill the process via the Task Manager.
If any other information would be helpful, please let me know and I will do my best to provide it.
Travis
|
|
|
Posts:
4
Registered:
6/29/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Jun 29, 2011 4:26 PM
in response to: Travesty3
|
|
|
I have a version of this and have discovered that there is an invisible Toad for MySQL popup waiting for a response. Use alt-tab to cycle through running programs and if this is your problem you'll see one program that has just the outline of the popup.
I usually can go to that using alt-tab and it then shows up and I can respond and my machine is freed. It doesn't always work try different ways of selecting the same popup.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Jun 29, 2011 4:38 PM
in response to: rallysport
|
|
|
The issue with dialogs showing and then making the product not show up in the tab list should have been fixed for the 6.0 beta I think.
|
|
|
Posts:
3
Registered:
5/18/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Jan 11, 2012 7:48 AM
in response to: andyd01
|
|
|
I have had the same problem for over a year. The issue has been brought up in other forum posts as well, and appears to remain unaddressed. So far I'm unable to resolve the problem, but it *has* prevented me from considering a paid TOAD license since the production version presumably has the same problems.
Win7 x64 with 48GB RAM. I don't think it's a memory problem.
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Jan 11, 2012 10:25 AM
in response to: jeb.stone_937
|
|
|
I am unaware of any ongoing issue in Toad for MySQL in regards to this.
Would you mind if I asked you about your environment. Lets start with:
* How many connections do you have defined in the connection manager
* How many connections do you usually have open when this issue occurs
* How many documents do you usually have opened when this issue occurs
Thank you!
PS. That said, there is no paid version of Toad for MySQL so you can stop wasting time thinking about that at least.  DS
|
|
|
Posts:
7
Registered:
3/22/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 9:19 AM
in response to: andyd01
|
|
|
Same here. I experience the same issue on any version for a year many time a day, even if I don't leave it idle.
Most of the time is related to an warming message Active queries are already running on this connection. Which is not true. The query that I ran on that tab finished and it has been idle
for a while.
I use between 5 and 10 tabs at the time, with open connections to the same server.
Running it o a 8 cores with 8GB of RAM laptop connecting to mysql 5.5 over VPN.
Love it and don't want to drop it in favor of something else.
Best,
Nic
Message was edited by: nic chidu
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 11:08 AM
in response to: nic chidu
|
|
|
Thanks for the extra information. One question about your setup. Are you generally working with auto commit on or off?
|
|
|
Posts:
7
Registered:
3/22/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 3:47 PM
in response to: Mauritz
|
|
|
I have autocommit on (the default setting). But this has no effect on any of the MySQL engines, does it?
INNODB commits all implicit trasactions automatcally.
I always wondered about this feature of TOAD for MySQL.
Thanks,
Nic
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 4:28 PM
in response to: nic chidu
|
|
|
Most table engines (Except InnoDB) doesn't support transactions at all. If you toggle auto commit off and use InnoDB you need to commit before any changes are actually committed just as you expect. If auto commit is on, then regardless of your table engine everything will be implicitly committed.
|
|
|
Posts:
7
Registered:
3/22/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 4:34 PM
in response to: Mauritz
|
|
|
Mauritz,
This is great to know. But just to make sure, in this scenario
INNODB table
Autocommit off
if I run
UPDATE Customer SET Name = 'NewCustomerName' WHERE Name = 'CustomerName'
isn't this automatically committed by INNODB? Do I have to issue a commit?
Thanks,
Nic
|
|
|
Posts:
313
Registered:
8/23/07
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 9, 2012 4:38 PM
in response to: nic chidu
|
|
|
Yes you will need to commit (Or use the commit button in Toad). Toad will also ask you if you want to commit or rollback when you close a connection in this case.
|
|
|
Posts:
7
Registered:
3/22/11
|
|
|
|
Re: Toad Hangs - has to be terminated
Posted:
Feb 10, 2012 7:32 AM
in response to: Mauritz
|
|
|
Mauritz,
Is this specific to TOAD? Is it wrapping the UPDATE statement in a transaction behind the scenes?
AFAIK INNODB will automatically commmit (or rollback if necessary) an UPDATE statement.
Thanks,
Nic
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
