MySQL Forums
Forum List  »  Stored Procedures

MySQL doesn't close connection at the end of SP on linux
Posted by: Alex Koloshich
Date: April 15, 2013 12:10AM

I faced with strange issue in one stored procedure. On windows it's working fine, but on linux SP doexn't exit at the end of SP and after some time(timaeout) return an error.

Query: CALL <db name>.<SP name>()

Error Code: 2013
Lost connection to MySQL server during query

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 48 min 31 sec

Sp looks like:
1. CREATE DEFINER=`<user>`@`%` PROCEDURE `<sp name>`()
2. BEGIN
3. CALL <inner SP>();
4.
5. -- statements for processing big table in loop with batching
6.
7. CALL <inner SP 2>;
8.
9. END

On linux I see that <inner SP 2> completed, but in mysql workbench CALL <db name>.<SP name>() working. 48 min which above is time of execution SP.

MySQL version is 5.5.

Any idea how to fix this?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL doesn't close connection at the end of SP on linux
1936
April 15, 2013 12:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.