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: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 5.7.19 | OS: | Windows |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
Tags: | MySQL |
[14 Nov 2019 6:27]
Thangaraj J
[14 Nov 2019 13:48]
MySQL Verification Team
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]
MySQL Verification Team
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".