Bug #42356 Workbench becomes unusable after it saves its settings into wb_state.xml file
Submitted: 26 Jan 2009 19:57 Modified: 8 Jun 2009 13:01
Reporter: Rudy Guzman Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.29 OSS OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any
Tags: crash, settings, wb_state.xml

[26 Jan 2009 19:57] Rudy Guzman
Description:
One day all of sudden my workbench completely stopped working.  At that time I was using version 5.0.27.  So I installed latest version of 5.0.29 and same problem continued to happen.
The crash occurred during startup (while flash screen was displayed).
The error was:
"MySQL Workbench has encountered a problem and needs to close..."

Finally, I figured out that the crash occurred because the last time MySql saved "wb_state.xml" file.  Whatever it did, caused it to crash MySql.

How to repeat:
Edit the file "wb_state.xml" located at:
"C:\Document and Settings\[Profile]\Application Data\MySQL\Workbench

And replace it's contents with:

<?xml version="1.0"?>
<data grt_format="2.0" document_type="MySQL Workbench Application State" version="1.0.0">
  <value _ptr_="04551690" type="dict">
    <value _ptr_="045512D0" type="dict" key="Logical-overview">
      <value type="int" key="EER Diagrams-expanded">1</value>
      <value type="int" key="EER Diagrams-mode">0</value>
      <value type="int" key="Model Notes-expanded">0</value>
      <value type="int" key="Model Notes-mode">0</value>
      <value type="int" key="Physical Schemata-expanded">1</value>
      <value type="int" key="Physical Schemata-mode">4</value>
      <value type="int" key="SQL Scripts-expanded">0</value>
      <value type="int" key="SQL Scripts-mode">0</value>
    </value>
    <value _ptr_="045513F0" type="dict" key="MySQL Server-overview">
      <value type="int" key="EER Diagrams-expanded">1</value>
      <value type="int" key="EER Diagrams-mode">0</value>
      <value type="int" key="Model Notes-expanded">0</value>
      <value type="int" key="Model Notes-mode">0</value>
      <value type="int" key="Physical Schemata-expanded">1</value>
      <value type="int" key="Physical Schemata-mode">4</value>
      <value type="int" key="SQL Scripts-expanded">0</value>
      <value type="int" key="SQL Scripts-mode">0</value>
    </value>
    <value _ptr_="04551420" type="dict" key="mainform">
      <value type="string" key="activedocument">EER Diagram</value>
      <value type="int" key="height">743</value>
      <value type="int" key="left">84</value>
      <value type="int" key="outputvisible">0</value>
      <value type="int" key="shellvisible">0</value>
      <value type="int" key="splitpos">879</value>
      <value type="int" key="top">11</value>
      <value type="int" key="width">930</value>
      <value type="int" key="windowstate">0</value>
    </value>
  </value>
</data>
>

Suggested fix:
Delete wb_state.xml.
[26 Jan 2009 21:27] MySQL Verification Team
Thank you for the bug report.
[1 Jun 2009 21:09] Alfredo Kojima
I get no crash replacing wb_state.xml with the provided data in 5.1
Please check again and close if acceptable.
[8 Jun 2009 7:44] Mike Lischke
Please check with version 5.1 of Workbench. We are focussing on WB 5.1 and would like to fix this problem there if it still exists, rather than WB 5.0. Thank you.
[8 Jun 2009 13:01] MySQL Verification Team
I couldn't repeat anymore with version 5.1.