distal-attribute
distal-attribute
distal-attribute
distal-attribute

Application Locks Up on "Waiting for table metadata lock"

User, date Message
Written by billdanbury
1 year ago
Category: Feature discussion
3 posts since Mon, 04 Mar 13
While working on table modifications in multiple instances of HeidiSQL, the application sometimes freezes when the TreeNav UI triggers a DB request dependent on the table metadata lock. Sometimes the application white-screens, other times it prompts the debug window (continue, close, restart). Perhaps the application should check for necessary locks before making the data request. Maybe create an option to check before nav, to limit overhead for those running single sessions.
Written by ansgar
1 year ago
4973 posts since Fri, 07 Apr 06
What's exactly blocking *which* SQL command?
Written by billdanbury
1 year ago
3 posts since Mon, 04 Mar 13
It's usually the "SHOW" commands that trigger when you click the DBs and Tables in the TreeNav...
Written by ansgar
1 year ago
4973 posts since Fri, 07 Apr 06
And another instance is executing a command which blocks that SHOW command?
Written by billdanbury
1 year ago
3 posts since Mon, 04 Mar 13
That's how it appears to occur. Of course as I'm typing this, I can't seem to duplicate the issue :)
 

Please login to leave a reply, or register at first.