Bug #81334 MySQL Workbench Program Closes When Trying to View Stored Procedures
Submitted: 6 May 2016 3:28 Modified: 20 Apr 2018 16:08
Reporter: Michal Michalski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.6 OS:Windows (Microsoft Windows 7 Professional Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[6 May 2016 3:28] Michal Michalski
Description:
MySQL Workbench program closes when trying to view Stored Procedures on my hosting provider's server.

Same problem occurs whether I'm using the 32 bit or 64 bit installation of MySQL Workbench.

Connecting to my hosting provider's server using port 3306.

My hosting provider has upgraded to the latest version of phpMyAdmin and has disabled Stored Procedures on their SQL servers due to "security" concerns.

How to repeat:
Right click on a Stored Procedure and select "Alter Stored Procedure..." from pop-up menu or hover over a Stored Procedure and click the wrench icon.

"MySQL Workbench has stopped working" alert box pops up trying to find a Windows solution.  A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.
[6 May 2016 15:31] MySQL Verification Team
Thank you for the bug report. I couldn't repeat using the stored procedures created by the sakila script. Please provide the sql commands to create the stored procedure which presents the behavior you are reported.
[10 May 2016 13:12] MySQL Verification Team
[Managed to Native Transition]	
>	mforms.wr.dll!MformsTree.OnMouseDown(System.Windows.Forms.MouseEventArgs args)	Unknown
 	System.Windows.Forms.dll!System.Windows.Forms.Control.WmMouseDown(ref System.Windows.Forms.Message m, System.Windows.Forms.MouseButtons button, int clicks)	Unknown
 	System.Windows.Forms.dll!System.Windows.Forms.Control.WndProc(ref System.Windows.Forms.Message m)	Unknown
 	System.Windows.Forms.dll!System.Windows.Forms.NativeWindow.Callback(System.IntPtr hWnd, int msg, System.IntPtr wparam, System.IntPtr lparam)	Unknown
 	[Native to Managed Transition]	
 	[Managed to Native Transition]	
 	System.Windows.Forms.dll!System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(System.IntPtr dwComponentID, int reason, int pvLoopData)	Unknown
 	System.Windows.Forms.dll!System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(int reason, System.Windows.Forms.ApplicationContext context)	Unknown
 	System.Windows.Forms.dll!System.Windows.Forms.Application.ThreadContext.RunMessageLoop(int reason, System.Windows.Forms.ApplicationContext context)	Unknown
 	MySQLWorkbench.exe!MySQL.GUI.Workbench.Program.Main(string[] Args)	Unknown
[10 May 2016 16:11] Michal Michalski
What does all that mean?  Can you help me access my Stored Procedures?
[16 May 2016 0:43] Michal Michalski
CAN SOMEONE PLEASE RESPOND? I CURRENTLY HAVE NO WAY TO ACCESS MY STORED PROCEDURES ON THE DB SERVER.
[16 May 2016 10:15] MySQL Verification Team
If you have mysql client in your path then you can access/view stored procedure as(in the example below - creating a stored procedure named p1, and later to check procedure code):

[root@cluster-repo ~]# mysql -uroot -p test
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.12 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>  DELIMITER //
mysql>  CREATE PROCEDURE p1 ()
    ->      BEGIN
    ->        DECLARE fanta INT DEFAULT 55;
    ->        DROP TABLE t2;
    ->        LOOP
    ->          INSERT INTO t3 VALUES (fanta);
    ->          END LOOP;
    ->      END//
Query OK, 0 rows affected (0.01 sec)

mysql> DELIMITER ;
mysql> -- view stored prcedure
mysql> SHOW CREATE PROCEDURE p1\G
*************************** 1. row ***************************
           Procedure: p1
            sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
    Create Procedure: CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
BEGIN
       DECLARE fanta INT DEFAULT 55;
       DROP TABLE t2;
       LOOP
         INSERT INTO t3 VALUES (fanta);
         END LOOP;
     END
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: latin1_swedish_ci
1 row in set (0.00 sec)

mysql>

Also, see http://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html

Thanks,
Umesh
[20 Apr 2018 16:08] Miguel Tadeu Mota
Posted by developer:
 
Closed due to no response for more information. Please reopen this bug if needed.

Thanks
[22 May 2018 15:31] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

When Alter Stored Procedure was selected from the context menu, MySQL
Workbench stopped working.

Thank you for the bug report.