Skip navigation links

MySQL Forums :: Stored Procedures :: MySQL doesn't close connection at the end of SP on linux


Advanced Search

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 1089 Alex Koloshich 04/15/2013 12:10AM
Re: MySQL doesn't close connection at the end of SP on linux 421 Peter Brawley 04/15/2013 03:33PM
Re: MySQL doesn't close connection at the end of SP on linux 414 Rick James 04/16/2013 10:46PM
Re: MySQL doesn't close connection at the end of SP on linux 408 Alex Koloshich 04/17/2013 07:02AM


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.