MySQL doesn't close connection at the end of SP on linux
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?
Subject
Views
Written By
Posted
MySQL doesn't close connection at the end of SP on linux
2472
April 15, 2013 12:10AM
900
April 15, 2013 03:33PM
940
April 16, 2013 10:46PM
858
April 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.