Bug #97622 Mysql SP call is not returning the response to UI/Client
Submitted: 14 Nov 2019 6:27 Modified: 18 Dec 2019 14:14
Reporter: Thangaraj J Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.7.19 OS:Microsoft Windows
Assigned to: Bogdan Kecman CPU Architecture:Any
Tags: MySQL

[14 Nov 2019 6:27] Thangaraj J
Description:
Hi,
I have created a procedure for inserting 10 millions+ records into a table. Procedure execution is completed successfully with in 15+ minutes (Nothing is showing in processlist). But server is not returning the completed status to UI/Client. If I am running the procedure in SqlYog, the session still shows the procedure execution is going on and stuck. Whereas there is no process in processlist. The same problem is happening when I am using a .Net service for SP execution. We have not got any response from the server side.

How to repeat:
By executing a SP for more than 15 minutes.
[14 Nov 2019 13:48] Sinisa Milivojevic
Hi Mr. J,

Have you tried our mysql CLI. Does it show when the procedure is finished ....

Have you enabled multiple results on the client side ???

Check also whether you have an error in your stored routine. We can not help you with your stored routine, but we can inspect it and just inform you whether you have an error or not.
[15 Nov 2019 5:38] Thangaraj J
Hi Sinisa,
Thank you for your prompt response. 

Please find my comments below for your queries.

Have you tried our mysql CLI. Does it show when the procedure is finished....
--> Yes, I have tried calling the SP from mysql CLI and it showed when the procedure is completed. 

Have you enabled multiple results on the client side ???
--> I am not returning any result sets from SP. I am just performing an insert operation in the SP. 

Check also whether you have an error in your stored routine.
--> Whenever I am calling the SP from UI/Client, it is only not responding the completed status to the UI/Client. After SP execution, there is no process showing in the process list and also the records are available in the target table. SP is executing successfully without any error.

We are using the below .Net client : 
Mysql.Data (ADO.Net driver for MySQL for .Net Core 1.0) 
version 6.10.9.0
runtime version v4.0.30319

and it is also not returning the response to MySQLYog.

This problem is only occurring when SP execution is taking 10 minutes and we are getting the response for below 10 minutes executing statements.
[18 Nov 2019 14:14] Sinisa Milivojevic
Hi,

First of all, stored routines are ALWAYS returning a result. Hence, change your code.

Also , this is a wrong category. This is not a bug in the server.
[19 Dec 2019 1:00] Bugs System
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".