Bug #60581 Workbench fails to load model after "error unserializing GRT data"

• Submitted: 22 Mar 2011 9:34
• Modified: 22 Mar 2011 17:14
• Reporter: Ian Hayes
• Status: Can't repeat
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.33
• OS: Windows (Windows7)
• CPU Architecture: Any
• Tags: loading model GRT data

[22 Mar 2011 9:34] Ian Hayes

Description:
I cannot load a model that was saved using r5.2.33

Originally the model was created using r5.2.32.  When I tried to reload the model I got the "error unserializing GRT" problem.

So I downloaded r5.2.33 and tried this again. First time this worked, I could load the model, make changes and then save it.

Today when I tried to load the model with r5.2.33 I get the same "error unserializing data" warning.

How to repeat:
Originally the model was created using r5.2.32.  When I tried to reload the model I got the "error unserializing GRT" problem.

So I downloaded r5.2.33 and tried this again. First time this worked, I could load the model, make changes and then save it.

Today when I tried to load the model with r5.2.33 I get the same "error unserializing data" warning.

Suggested fix:
The file format is a bizarre mix of header and zip file content.  Why bother? Why not store the data in a text readable simple xml file so that we can readily search for problems.

[22 Mar 2011 10:28] Valeriy Kravchuk

Please, send the problematic .mwb file. 

Had you tried to add any foreign key on 5.2.33 to this model created with 5.2.32?

[22 Mar 2011 10:42] Ian Hayes

Trying to load this file with r5.2.33 causes serialization problem

Attachment: berthier mysql schema 201103.mwb (application/x-zip-compressed, text), 25.99 KiB.

[22 Mar 2011 12:38] Valeriy Kravchuk

Verified with .mwb uploaded.

[22 Mar 2011 12:47] Valeriy Kravchuk

This can be a duplicate of Bug #60564 also.

[22 Mar 2011 13:52] Alfredo Kojima

Please update to 5.2.33b and see if it solves your problem.

[22 Mar 2011 16:43] Ian Hayes

This fixes the problem - thanks!

[22 Mar 2011 17:14] Valeriy Kravchuk

Not repeatable with current version, 5.2.33b.