Bug #5443 MySQL Administrator - Error on close of 'UNOPENED' - when selecting catalog
Submitted: 7 Sep 2004 8:24 Modified: 30 May 2005 18:02
Reporter: Roger Wallace Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.12 OS:Windows (Windows 2000)
Assigned to: Michael G. Zinner CPU Architecture:Any

[7 Sep 2004 8:24] Roger Wallace 
Description:
May be related to: Bug #2759 (fixed in 1.0.2)

The following error message is displayed when selecting a catalog with a VIEW:

  "Error whle fetching Schema Table Status."
  "MySQL Error Nr. 4"
  "Error on close of 'UNOPENED' (Errcode: 9)"

The database schema is not displayed and cannot continue to work with that
catalog. Selecting another catalog works as expected.

How to repeat:
1 Create a simple VIEW using a script (run using JDBC).
2 Launch MySQL Administrator and expand catalog section
3 Select the catalog with the new VIEW.
[8 Sep 2004 10:23] Tim Stephenson 
This works using any Windows client, and seems to break both Mysql Administrator & the Query Tool.

Simply create a view, then try to refresh the schema / catlogue view in MySQL Administrator.
[8 Sep 2004 10:23] Tim Stephenson 
Dropping the view resolves the problem.
[14 Nov 2004 13:18] Ron Borkent 
In windows, from the command line, I can do a select on the view. The problem starts with the show keys from 'view_name'. phpmyadmin shows the same error and points to the show key command.

Ron
[16 Jan 2005 7:23] Steffen Reinecke 
Maybe the bug is fixed in the next version of phpmyadmin:

http://www.phpmyadmin.net/ChangeLog.txt

Steffen
[30 May 2005 18:02] Michael G. Zinner 
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/