MySQL Bugs: #21748: Unable to load any saved model

Bug #21748	Unable to load any saved model
Submitted:	21 Aug 2006 9:42	Modified:	29 Dec 2006 7:04
Reporter:	michael hinge	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S1 (Critical)
Version:	1.1.5 alpha	OS:	MacOS (Mac OS X 10.4.8)
Assigned to:		CPU Architecture:	Any
Tags:	crash, load, model

Description:
After saving a model it is not possible to open it.
Application hang up (rainbow cursor). 

Workbench Version is delivered within the GUI-Tools Version "Universal Binary for Mac OS X 10.4) 5.0r1

How to repeat:
Save a model in the workbench. Use the "open"-command in the file menu. Application will hang up (rainbow cursor).

Tested on Powerbook G4 / OS X 10.4.7, Powermac G5 / OS X 10.4.7
with files created by the workbench (No matter if it was created by the reverse engineer or by drag & drop of objects into the model.)

Suggested fix:
Perhaps problems with the written files?

Thank you for a problem report. Please, try to repat with a newr version, 1.1.4 alpha (or 1.1.3, at least), and inform about the results.

I was re-installing the newer version 1.1.3 a, now I can open a created file but only if there are less then 10 objects! There is still the problem with reverse engineering a database (the same DB runs with the windows version - reverse engineer - fine!) I think there is a problem with the number of objects - there is also a reported bug with this problem

I was also testing it with 10.4.7, and after updating to DB 5.0.26 - same result

Also the same problems with version 1.1.4 alpha

See also bug #18205, bug #21931: Mentioning that more then 10 Objects causing problems with the reverse-engineer or workbench

Also with the latest version it is still impossible to load a saved model with more the 10 objects inside. No matter if it was created manually or with the reverse engineer. The same DB is used for testing with the win version, there is no such problem.

Thank you for the report.

I can not repeat it using current MySQL Workbench 1.1.5 alpha and mysql database.

Please could you provide dump of database structure with about 10 - 20 tables causes crash?

There is similar bug #24319

The error will apear with ANY database I used with the reverse engineer, but also when you create a model with more than 10 objects - without the reverse engineer.

Do You really have no problems with opening larger files? Consider that the same process runs without errors on Win, and that I have tested on 2 diffrent PPC-Mac's with 10.4.8, 10.4.7, 10.4.6 - everytime the same error. the diffrence between 1.1.4 and 1.1.5 is only that I can open a file that I have created with <10 objects. Before that, any "open" command causes the program to hang up (freeze), but without affecting the OS, so just nothing happens.

So there must be a bug in the file structure that makes the loading impossible when containing more then 10 objects.

Yes, I really have no problem with opening large files in MySQL Workbench.

So, please, provide dump of structure of any of your databases you can catch the error.

Win Version 115a with 5.0.27

Attachment: Test_115a_Rev12-plus-3_winXP.mwb (application/octet-stream, text), 197.27 KiB.

the same sample with Mac ver. 116a & 5.0.27

Attachment: Test_116a_Rev12-plus-3_Mac10-4-8.mwb (application/octet-stream, text), 195.98 KiB.

the sql file for the sample (12 Tables)

Attachment: Migration_Test.sql (application/octet-stream, text), 6.02 KiB.

Note that it is not only this sample that doesn't work: ALL DB's DONT RUN, EVEN MANUALLY CREATED SAMPLES WITHIN THE WORKBENCH.

I have tested the version 1.1.6a of the workbench but there is the error also when creating 3 objects manually (in version 1.1.5a it was possible to create, save and open again models until 10 objects)

I was able to reproduce this with a testcase as simple as follows:
1) Create new file (File -> New).
2) Use table tool to add one table.
3) Save the file.
4) Close MWB and open it again.
5) Open the file.
6) Enjoy the app's hang.

In fact, I wasn't able to open a single file, the only things that works for me is importing the old DBDesigner4 model which cannot be re-opened once it was saved.

As this makes MWB absolutely unusable for me, I'm willing to do whatever supply whatever information needed to help get this fixed. So - is there any? :)

(Sorry for the bug spam, I forgot to add that I am using a version self built few hours ago from SVN.)

Please confirm if you all use PowerPC: crash is not repeatable on Intel Mac even with provided .mwb files.

Yes, of course I use PowerPC-Machines: as I wrote once before, the error was on both Powerbook G4 / OS X 10.4.7, Powermac G5 / OS X 10.4.7
G4 and G5 are PowerPC and are very common for Mac Users. They will be used - for sure - the next 5 years and are still faster then the Intel Macs.
I cannot believe they are not supported, all Univesal Binary Programms running fine with no problems on PowerPC Macs. Consider that MySQL provide special versions only for PowerPC Macs, the 32 Bit for G4's and the 64 Bit Version for the G5

Repeated the behaviour on PPC based MacOSX 10.4.8

$ uname -a
Darwin Vigor10 8.8.0 Darwin Kernel Version 8.8.0: Fri Sep  8 17:18:57 PDT 2006; root:xnu-792.12.6.obj~1/RELEASE_PPC Power Macintosh powerpc

After loading the attached .mwb file, Workbench hangs infinitely.

Well, I'm actually using Linux on a regular Intel PC, and I am also seeing this bug. It's probably cross-platform.