Bug #7077 mysql doesn't load schemas
Submitted: 7 Dec 2004 14:15 Modified: 7 Dec 2004 15:11
Reporter: Martin Karch Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.2 OS:Microsoft Windows (Win2000 Server (SP4))
Assigned to: CPU Architecture:Any

[7 Dec 2004 14:15] Martin Karch
Description:
i've just upgraded from 5.0.1 to 5.0.2. i have only the mysql system database and one bigger database (still under construction; at the moment about 20 InnoDB tables (with a lot of references) and 2 views).

after the upgrade i started the new mysql service without any error. but if i try to watch my schemas (the mysql or my testing schema) my client-tool (MySQL Administrator and some others) trys about a minute to load, then i get an error #2013 "Lost connection..." and the mysql service has stopped.

there appears no error message somewhere and i tried a lot of settings, but without access.
with the console client a can do a "SELECT * FROM table" without any error...

when i'm using my backup of 5.0.1 everthing works fine again. i also extracted 5.0.2 into a new folder and copied my data there... with same results

How to repeat:
create a test database with about 20 InnoDB tables, 2 views in 5.0.1, upgrade to 5.0.2 and try to open the database with MySQL Adminstrator
[7 Dec 2004 15:11] Miguel Solorzano
This is related to the bug:

http://bugs.mysql.com/bug.php?id=6950