Bug #70325 Query history not restored after restart of MySQL Workbench
Submitted: 13 Sep 2013 7:50 Modified: 5 Nov 2013 4:32
Reporter: Roman Illin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S5 (Performance)
Version:6.0.7.11215 OS:Windows
Assigned to: CPU Architecture:Any
Tags: query, snapshot

[13 Sep 2013 7:50] Roman Illin
Description:
In the previous version we used, 5.2.47 all query tabs has been restored after restart of MySQL Workbench. In the current it's not the case. In "Preferences - General - SQL Editor" option "Save snapshot of open editors on close" is checked, Auto-save scripts interval is set to 30 seconds. But all tabs for all connections are gone. 

How to repeat:
Enable option "Save snapshot of open editors on close" in "Preferences - General - SQL Editor", set auto-save scripts interval to a certain value.
Create several tabs for queries, make some queries, execute them. Restart MySQL Workbench. All query tabs are gone.
[13 Sep 2013 11:36] MySQL Verification Team
Thank you for the bug report. Please check for duplicate: http://bugs.mysql.com/bug.php?id=69234 . Thanks.
[13 Sep 2013 11:56] Roman Illin
it's not quite duplicate, because the problem I described happens not only after crashes but even if we close Workbench in a normal way. In case 69234 tabs are there but have default names. In my case there are no tabs at all. Though I am not so familiar with rules to define if these reports are full duplicates
[13 Sep 2013 15:42] MySQL Verification Team
Thank you for the feedback.
[27 Sep 2013 22:50] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=70456 duplicate of this one.
[9 Oct 2013 11:38] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=70559 duplicate of this one.
[10 Oct 2013 23:40] Joe Brown
I've noticed that if you have several saved connections (from a previous version of workbench), it will remember your old tabs the first time that connection is loaded. After that they're lost and it never remembers any more tabs for that connection.
[30 Oct 2013 15:23] Armando Lopez Valencia
Posted by developer:
 
FIXED.
Verified in:
Windows 7x64
Ubuntu 12.04x64
MySQL Server 5.6
WB 6.0.8.11345
The tabs are persistent after close open WB (with a 10 sec. auto-save configuration).
[5 Nov 2013 4:32] Philip Olson
Fixed as of MySQL Workbench 6.0.8, and here's the changelog entry:

Open query tabs were not persistent (reopened) after reopening
MySQL Workbench.

Thank you for the bug report.