Bug #32534 Error in Reverse engineering
| Submitted: | 20 Nov 2007 16:03 | Modified: | 23 Nov 2007 22:06 |
|---|---|---|---|
| Reporter: | Marcio Merlone | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S1 (Critical) |
| Version: | 5.0.9-beta | OS: | Windows (XP Professional) |
| Assigned to: | Johannes Taxacher | CPU Architecture: | Any |
[20 Nov 2007 16:03]
Marcio Merlone
[20 Nov 2007 16:26]
marc castrovinci
Worked fine for me. This might be a configuration problem. Is you MySQL version local to the Workbench? Does the user have permissions to get the routine schema?
[20 Nov 2007 16:26]
Sergei Tkachenko
Thanks for report. Could you check if following query performs well on your database: select * from information_schema.routines; There is a bug related to DBMS itself, that appears as server instance crash when executing mentioned query (http://bugs.mysql.com/bug.php?id=30891). AFAIK it's not fixed for now. If this bug is the case then the only workaround known so far is to recreate database dictionary. Otherwise please let us know.
[20 Nov 2007 16:30]
Marcio Merlone
That´s it. The server is a remote machine and as far as I know the user has been grated all permissions on the server (grant all on *.*). root@mercurio:/var/log# mysql -u mmerlone -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 65 to server version: 5.0.22-Debian_3 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from information_schema.routines; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> So, is not a Workbench bug.
[20 Nov 2007 16:39]
Marcio Merlone
BTW, could you point me on how to recreate the database dictionary?
[21 Nov 2007 12:48]
Sergei Tkachenko
Please run 'mysql_system_tables_fix.sql' script against your DBMS with root privileges. That script is located in 'share' subdir of your MySQL DBMS installation dir.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.