MySQL Bugs: #81334: MySQL Workbench Program Closes When Trying to View Stored Procedures

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

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.

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.

[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

What does all that mean?  Can you help me access my Stored Procedures?

CAN SOMEONE PLEASE RESPOND? I CURRENTLY HAVE NO WAY TO ACCESS MY STORED PROCEDURES ON THE DB SERVER.

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

Posted by developer:
 
Closed due to no response for more information. Please reopen this bug if needed.

Thanks

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.