MySQL Bugs: #62485: Crash - Action: 'Get schemata' - Message: 'Access Violation

Bug #62485	Crash - Action: 'Get schemata' - Message: 'Access Violation - No RTTI data!'
Submitted:	20 Sep 2011 22:00	Modified:	6 Jan 2012 6:52
Reporter:	jah boite	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.34, 5.2.35	OS:	Windows (XP SP3)
Assigned to:		CPU Architecture:	Any

Description:
I'd just created a table, in SQL Editor, for the schema currently set as default, on the server running on localhost with the following statements (probably not important)

CREATE TABLE rank (id INT UNSIGNED AUTO_INCREMENT, client_id INT UNSIGNED NOT NULL, nps FLOAT(18, 2), rank INT UNSIGNED, date DATE NOT NULL, INDEX client_id_idx (client_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = MyISAM;
ALTER TABLE rank ADD CONSTRAINT rank_client_id_client_client_id FOREIGN KEY (client_id) REFERENCES client(client_id);

About 8 minutes later I clicked the little 'refresh schemas' icon which appears to the left of the SCHEMAS heading in the Object Browser and the crash happened at this point.  After closing the Error dialog which appeared (reporting Access Violation - No RTTI data!) I see that the list of Schemas in the object browser is showing schema and table items, allows expansion/viewing of schemas, but is MISSING all labels except for the very first in the list (named '_bak') and won't allow expand tables.

The Output tab of the lower pane of the SQL editor reports the aforementioned message for the action: 'Get schemata'.

How to repeat:
I haven't attempted to reproduce.

Hello,

In order to reproduce can you please provide your system info?

On Workbench click on Help-> System Info

Thanks in advance.

MySQL Workbench CE for Windows version 5.2.34
Configuration Directory: C:\Documents and Settings\jah\Application Data\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 2.1.8918
OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)
CPU: 2x Intel(R) Core(TM)2 Duo CPU     E6550  @ 2.33GHz, 2.0 GiB RAM
Active video adapter: ATI Radeon HD 4350
Installed video RAM: 512 MB
Current video mode: 1280 x 1024 x 4294967296 colors
Used bit depth: 32
Driver version: 6.14.10.6999
Installed display drivers: ati2dvag.dll
Current user language: English (United Kingdom)

What exact server version, 5.x.y, are you working with?

MySQL reports its version as 5.1.33-community-log

I couldn't repeat on Vista 64-bit.

Please, check if the same problem still happens with a newer version, 5.2.35.

I found I could reliably reproduce the error by dropping and recreating a schema outside of Workbench and then going back to workbench and clicking the refresh icon.
I've just updated to 5.2.35 and can no longer reproduce the issue.  I'm hesitant to say this is fixed, however, unless someone can point me at the commit containing the fix.

Same Problem with:
MySQL Workbench CE for Windows version 5.2.35

Configuration Directory: C:\Dokumente und Einstellungen\xxx\Anwendungsdaten\MySQL\Workbench

Data Directory: C:\Programme\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 3.3.0

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 4x Intel(R) Core(TM)2 Quad CPU    Q6600  @ 2.40GHz, 3.5 GiB RAM

Active video adapter: NVIDIA GeForce 8600 GT 

Installed video RAM: 256 MB

Current video mode: 1920 x 1200 x 4294967296 Farben

Used bit depth: 32

Driver version: 6.14.12.6724

Installed display drivers: nv4_disp.dll

Current user language: Deutsch (Schweiz)

Server-Version: 5.1.40 (5.1.40-community-log, Win32)

I was working with statements of the type: create table some_db_name.some_table_name 
select * from some_other_table_name

then i clickt on the small refresh-symbol in the Object Browser on the right of the SCHEMAS title

I still couldn't repeat with 5.2.35.

Please, check if the same problem still happens in your environment with a newer version, 5.2.36.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".