Application Locks Up on "Waiting for table metadata lock"
| User, date | Message |
|---|---|
|
Written by billdanbury
3 months 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
3 months ago 3977 posts since Fri, 07 Apr 06 |
What's exactly blocking *which* SQL command? |
|
Written by billdanbury
3 months 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
3 months ago 3977 posts since Fri, 07 Apr 06 |
And another instance is executing a command which blocks that SHOW command? |
|
Written by billdanbury
3 months 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. |