Bug #55833 Workbench Dump Views results in unhandled exception
Submitted: 9 Aug 2010 7:41 Modified: 1 Sep 2010 13:59
Reporter: Giuseppe Maxia Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.26pre3, 5.2.26 OS:Any
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: Backup, dump, exception, VIEW, workbench

[9 Aug 2010 7:41] Giuseppe Maxia
If you select "Dump views" with any backup, you get the alert:

"Unhandled exception: global name 'views_by_schema' is not defined"

After that, the dump feature is not available anymore, until you restart the administrative tab.

How to repeat:
1) from the "admin" tab, select "data dump".
2) choose any database
3) check the "Dump View" box
[9 Aug 2010 7:42] Giuseppe Maxia
screen shot of unhandle exception with "dump views"

Attachment: bug55833.png (image/png, text), 179.02 KiB.

[9 Aug 2010 7:51] Giuseppe Maxia
Output from Console after the unhandled exception

Attachment: bug555833_trace.txt (text/plain), 992 bytes.

[9 Aug 2010 7:53] Roel Van de Paar
Verified as described (Win7 HP x64)
[9 Aug 2010 7:59] Roel Van de Paar
Note I used symbols from 5.2.25 to resolve stack.

Attachment: bug_55833_backtrace.txt (text/plain), 36.54 KiB.

[9 Aug 2010 8:00] Roel Van de Paar
Note you have to click "Start Export" for bug to occur.
[9 Aug 2010 22:52] Chris Murtagh
This has also been confirmed on Gentoo amd64 with the 5.2.26 build.
[11 Aug 2010 12:03] Sandro Nakaguma
This also happens in Ubuntu 10.04 LTS released in April 2010
[12 Aug 2010 8:45] Johannes Taxacher
Bug #55940 has been marked as duplicate of this one
[18 Aug 2010 13:57] Wolfgang Jacques
I confirm the bug as described.
MySQL Workbench 5.2.26 CE Rev. 6432 on WIN 7 Ultimate, trying to Dump a very small Schema. The views were created via OOO Base 3.2 on a mySQL 5.1.49 on Windows.
[25 Aug 2010 17:56] Johannes Taxacher
fix confirmed in repository
[26 Aug 2010 13:50] Alfredo Kojima
Marked bug #55992 as duplicate
[1 Sep 2010 13:59] Tony Bedford
An entry has been added to the 5.2.27 changelog:

If "Dump views" was selected for a backup, the following error was generated:

Unhandled exception: global name 'views_by_schema' is not defined

It was necessary to restart the Administrator in order to enable the dump facility again.