Toad for MySQL - Community for development, administration, tuning, tips and tricks

SQL_Jockey

Posts: 7
Registered: 11/15/12

Unresponsive TOAD for MySQL
Posted: Nov 15, 2012 1:00 PM

Reply

Is it just me???

Whenever I leave my Toad for MySQL open on my desktop for a long time it becomes somewhat non-responsive.

"A long time" is roughly 1 hour, but I'm not sure exactly.

"somewhat non-responsive" means that I can type in the editor, click on menus/toolbars, but when I try to execute a query the program does not respond.

My work around is to use Windows Task Manager and end task the TOAD application.

I do this several times a day.

Any ideas, help, and/or workarounds would be appreciated.

I really enjoy using this product, but I'm really getting tired of using task manager.

Thanks!

thorin

Posts: 7
Registered: 2/6/12

Re: Unresponsive TOAD for MySQL
Posted: Nov 28, 2012 7:20 AM

in response to: SQL_Jockey

Reply

Does it only happen when you're connected to a certain database or set of databases?
Does it only happen when you're connected to local databases?
Does it only happen when you're connected to a DB via SSH, etc....
Does it matter if you're actually connected to a DB? (i.e.: what if you just start Toad and leave it running but not connected to anything?)

What are RAM and CPU usage like when you have to kill it?

Does this occurrence co-inside with use of any of the Collaboration/FTP/Browser/etc components?

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 2, 2012 11:27 AM

in response to: thorin

Reply

Does it only happen when you're connected to a certain database or set of databases?
-- It does not seem to matter.

Does it only happen when you're connected to local databases?
-- I don't use local databases, only DBs across the network.

Does it only happen when you're connected to a DB via SSH, etc....
-- I only connect via standard MySQL port.

Does it matter if you're actually connected to a DB? (i.e.: what if you just start Toad and leave it running but not connected to anything?)
-- I will try that and report back.

What are RAM and CPU usage like when you have to kill it?
-- CPU at 10%, RAM 66% consumed.

Does this occurrence co-inside with use of any of the Collaboration/FTP/Browser/etc components?
-- Not sure. When it happened today, I was using IE, Chrome, Outlook, Padre, Jedit, vSphere Client, and Putty.

At this moment, when I click the close button on TOAD, I get the following error:

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
   at DevExpress.XtraBars.BarManager.DevExpress.Utils.Serializing.IXtraSerializable.OnStartSerializing()
   at DevExpress.Utils.Serializing.Helpers.SerializeHelper.CallStartSerializing(Object obj)
   at DevExpress.Utils.Serializing.Helpers.SerializeHelper.RaiseStartSerializing(Object obj)
   at DevExpress.Utils.Serializing.Helpers.SerializeHelper.SerializeObject(Object obj, XtraSerializationFlags parentFlags, OptionsLayoutBase options)
   at DevExpress.Utils.Serializing.Helpers.SerializeHelper.SerializeObject(Object obj, OptionsLayoutBase options)
   at DevExpress.Utils.Serializing.Helpers.SerializationContext.SerializeObjectsCore(SerializeHelper helper, IList objects, OptionsLayoutBase options)
   at DevExpress.Utils.Serializing.XtraSerializer.SerializeObjects(Object rootObject, IList objects, Stream stream, String appName, OptionsLayoutBase options)
   at DevExpress.Utils.Serializing.XtraSerializer.SerializeObjects(XtraObjectInfo[] objects, Stream stream, String appName)
   at DevExpress.XtraBars.BarManager.SaveLayoutCore(XtraSerializer serializer, Object path)
   at DevExpress.XtraBars.BarManager.SaveLayoutToStream(Stream stream)
   at Quest.Toad.Gui.MainForm.SaveCustomization(XmlNode root)
   at Quest.Toad.Gui.MainForm.SaveSession(SessionSettings session)
   at Quest.Toad.Gui.MainForm.MainForm_Closing(Object sender, CancelEventArgs e)
   at System.Windows.Forms.Form.OnClosing(CancelEventArgs e)
   at System.Windows.Forms.Form.WmClose(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
   at Quest.Toad.Gui.MainForm.WndProc(Message& msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

The only way out for me that I know of is Task Manager - End Task.

Thanks!

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 3, 2012 7:11 AM

in response to: thorin

Reply

I left TOAD up and running overnight. I simply opened TOAD and did not connect to any database.

This morning I was able to close the application without any errors.

It seems that the error only happens if I am connected to a DB.

lubo08

Posts: 4
Registered: 12/3/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 3, 2012 8:12 AM

in response to: thorin

Reply

Hi

I have same problem but when Im connected over ssh, and just short time. I thing probably when my connection is reconnected or Im swtiching betwen more connections. Toad stop reacting at all a have to kill it.

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 3, 2012 12:59 PM

in response to: thorin

Reply

This time I made a connection, and selected a view and clicked on ALTER view. An editor window opened showing the code for the view.

Then I left the program alone for a few hours.

Now when I go to close, there is no immediate response. After a while the screen turns pink, then I get the following error:

System.NullReferenceException
Object reference not set to an instance of an object.
Stack Trace:
   at bi.a(DockManager A_0, XmlTextWriter A_1, Boolean A_2)
   at ActiproSoftware.UIStudio.Dock.DockManager.SaveToolWindowLayoutToFile(String path, Boolean saveTextProperties)
   at Quest.Toad.Editor.EditorForm.EditorForm_Closed(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at Quest.Toad.Gui.DocumentForm.RaiseClosed()
   at Quest.Toad.Gui.MainForm.dockManager_WindowClosed(Object sender, TabbedMdiWindowEventArgs e)
   at ActiproSoftware.UIStudio.Dock.DockManager.OnWindowClosed(TabbedMdiWindowEventArgs e)
   at ActiproSoftware.UIStudio.Dock.DockManager.b(TabbedMdiWindowEventArgs A_0)
   at ActiproSoftware.UIStudio.Dock.DockManager.a(TabbedMdiWindow[] A_0, Boolean A_1, TabbedMdiWindowCloseReason A_2)
   at ActiproSoftware.UIStudio.Dock.DockManager.CloseAllActiveDocuments(Boolean force, TabbedMdiWindowCloseReason reason)
   at ActiproSoftware.UIStudio.Dock.DockManager.CloseAllActiveDocuments(Boolean force)
   at ActiproSoftware.UIStudio.Dock.DockManager.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at System.ComponentModel.Container.Dispose(Boolean disposing)
   at System.ComponentModel.Container.Dispose()
   at Quest.Toad.Gui.MainForm.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at System.Windows.Forms.Form.WmClose(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at DevExpress.XtraEditors.XtraForm.WndProc(Message& msg)
   at Quest.Toad.Gui.MainForm.WndProc(Message& msg)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Now I will end-task so that I can get back to work using Toad.

lubo08

Posts: 4
Registered: 12/3/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 4, 2012 2:13 AM

in response to: SQL_Jockey

Reply

Hi

When I'm connected over ssh, and on the server is set disconnection after some time of inactive user, because of that server broke conncection and TOAD get stuck and I have to kill it with task manager.

lubo08

Posts: 4
Registered: 12/3/12

Re: Unresponsive TOAD for MySQL
Posted: Dec 7, 2012 12:39 AM

in response to: SQL_Jockey

Reply

Hi

Could anybody from developers tell us if this will be fixed in next version of TOAD for mysql?

Thank you.

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Jan 3, 2013 12:14 PM

in response to: lubo08

Reply

So is this a bug, and not something that I am doing wrong?

mpp4manu

Posts: 2
Registered: 1/4/13

Re: Unresponsive TOAD for MySQL
Posted: Jan 4, 2013 3:11 PM

in response to: SQL_Jockey

Reply

I just wanted to add my voice to this. I'm experiencing the same thing.

I am running Toad via SSH over a corporate VPN. The only way out appears to be manually killing Toad. I too was connected to a database.

One thought here, there may be a messed up "modal" dialog box sitting somewhere. Essentially, you're supposed to click it in response to some event, but you can't get to it, so the application refuses to respond.

The only reason I think this is I seem to remember a situation like this occurring where the dialog box got hidden, but when I found it and clicked on it, everything worked again.

Perhaps it's warning about loss of connection or something. Perhaps the dialog box is popping up behind the main screen, which you can minimize or move out of the way to get to the box.

For what it's worth, there is no process that appears to be a dialog box in Task Manager.

One other thing, I am using Windows 7, with multiple displays, one of which is attached to a USB display extended (Display Link).

I'd be happy to perform any diagnostics anyone can suggest.

mpp4manu

Posts: 2
Registered: 1/4/13

Re: Unresponsive TOAD for MySQL
Posted: Jan 4, 2013 3:16 PM

in response to: mpp4manu

Reply

Now I remember where this idea came from.

When I use task manager to kill Toad, the dialog box asking if I want to save my editor files never comes into the foreground. In this case, the main application in on the main center display.

This is what prompted me to consider the dialog box as an issue.

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Jan 8, 2013 6:48 AM

in response to: mpp4manu

Reply

I like the theory about the "modal" box sitting somewhere.

This happened when I was using Windows 7, and is now still happening with Windows 8. I too am using multiple displays (2), one VGA and one DVI.

Another symptom is that the editor window turns PINK while the app is refusing to respond.

SQL_Jockey

Posts: 7
Registered: 11/15/12

Re: Unresponsive TOAD for MySQL
Posted: Jan 10, 2013 7:50 AM

in response to: SQL_Jockey

Reply

One more thing...

When I do attempt to close the form - my editor windows will sometimes change color (like a red salmon color).

Is there a bugzilla area where I should go post this "bug"? Or has someone already done this?

Z6ePO

Posts: 7
Registered: 5/21/12

Re: Unresponsive TOAD for MySQL
Posted: Jan 14, 2013 1:25 AM

in response to: SQL_Jockey

Reply

I've got the problem too
I'm trying to desactivate notifications :
-Options / Environnement / General
-> Background Process Notifications and disable 'Show taskbar notification'

I'll give you feedback...

[ - update - ]
No more unresponsive TOAD for the moment since i've disabled "Show taskbar notification"
Message was edited by: Z6ePO

[ - update - ]
Still unresponsive if you let a connection opened
Message was edited by: Z6ePO

joe b

Posts: 3
Registered: 2/6/13

Re: Unresponsive TOAD for MySQL
Posted: Feb 6, 2013 10:23 AM

in response to: SQL_Jockey

Reply

I noticed this thread in the popular discussions section and thought I'd give it a nudge.

I'm experiencing the same thing. Toad either becomes fully or partially non-responsive, or it crashes, after being open for more than an hour or so, and connected to a database (tcp).

I also have to use task manager to kill toad.

Lately I've taken to just restarting Toad every hour or so, as a workaround.

I'm running Toad 6.3 for MySQL.

Windows 7 Enterprise
Service Pack 1, 64 bit

Toad World

Downloads

Welcome, Guest