MySQL Bugs: #56275: MySQL failed to synch database after it was restored form a backup

Bug #56275	MySQL failed to synch database after it was restored form a backup
Submitted:	26 Aug 2010 0:07	Modified:	28 Sep 2010 12:14
Reporter:	Joshua Levin	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.26 CE Revision 6432	OS:	Windows (Vista)
Assigned to:		CPU Architecture:	Any
Tags:	"Refresh State of Database Structures", Backup

Description:
I had saved my main database to backup, and then "restored" the two test databases from that backup.  WI went to hit the button to "Refresh State of Database Structures Schemata/Tables/Views/Routines", it soft crashed.

The stack trace is:

Exception = MySQL.Grt.BackendException
Message = Invalid node
FullText = MySQL.Grt.BackendException: Invalid node
   at MySQL.Workbench.WbContext.flush_idle_tasks()
   at MySQL.GUI.Workbench.Program.timer_Tick(Object send

How to repeat:
I have often restored this test database from backups for the main database, and this happened only once before.

Suggested fix:
Better monitoring if the database has been restored.

WI --> I  (typo)

Didn't get full stack trace.  It is:

Exception = MySQL.Grt.BackendException
Message = Invalid node
FullText = MySQL.Grt.BackendException: Invalid node
   at MySQL.Workbench.WbContext.flush_idle_tasks()
   at MySQL.GUI.Workbench.Program.timer_Tick(Object sender, EventArgs e)

Please add a linefeed right before the end of the file so this doesn't happen again.

Thank you for the report.

Please provide step-by-step description about how do you backup and restore.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/119682

3083 Joerg Bruehe	2010-10-01
      Next attempt at bug#56275: Use "cmake -D" and no env var.