Bug #62879 Does not refresh model stored procedures after synchronization with DB
Submitted: 22 Oct 2011 12:49 Modified: 27 Jul 2012 8:26
Reporter: Анатолий Кирсанов Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.35 OS:Any (Vista SP2 Home Basic Russian, Mac OS X)
Assigned to: CPU Architecture:Any

[22 Oct 2011 12:49] Анатолий Кирсанов
There was no any stored procedure before synchronization with DB. Database contained several stored procedure. Model updated successfully but stored procedure list in model was not refreshed.

How to repeat:
1. You need a model and database, containing several stored procedures. Model should not contain stored procedures at all.

2. Choose Database/Synchronize model ... menu item. Synchronize model with Database window opens.

3. Enter appropriate connection options, password and connect to DB.
4. Select schema prepared at step 1.
5. Fetch objects info.

6. Select changes to apply. 

In my situation a had several tables to create in database from model too. So Synchronization was bidirectional. 

I should see that several stored procedures are in database but not in model. 

Select Update model for each of them.

7. Review DB changes.

'Skip DB changes and update model only' checkbox should be unchecked (look at step 6 comments - bidirectional updates). 

8. Press Execute button to synchronize.

9. Synchronization completed successfully.

10. Press Close button, goto Model pane and look stored procedures list. It's still empty but model was changed!!!

Suggested fix:
Just close model and open it again - stored procedure list looks correctly after that.
[22 Oct 2011 13:45] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.2.35.
[23 Oct 2011 18:02] Анатолий Кирсанов
The same on version 5.2.35
[2 Nov 2011 4:08] Dragon Chuang
The same on version 5.2.35
not just stored procedure only, 'table' also does not refresh.
I have to save model, close model, re-open it again.
[11 Nov 2011 17:21] Valeriy Kravchuk
Verified just as described with 5.2.35 on Mac OS X.
[27 Jul 2012 8:26] Philip Olson
Fixed as of Workbench 5.2.41, and here's the changelog entry:

After synchronizing a database, refreshing a model would not
refresh the stored procedure information.