#35637 [Opn->Fbk]: Mysqli "Lost connection to MySQL server during query"

ID: 35637 Updated by: sniper@php.net Reported By: realbenzin at inbox dot lv -Status: Open +Status: Feedback Bug Type: MySQLi related Operating System: Win XP SP2 PHP Version: 5.1.1 New Comment: How about showing how you defined the procedure? Previous Comments: ------------------------------------------------------------------------ [2005-12-12 07:11:29] realbenzin at inbox dot lv It is not the same!!!!! Because I am calling the sp twice and sp contains only one select not two like in that other "bug". PS i red about that multi query, but that won`t help me... ------------------------------------------------------------------------ [2005-12-11 23:30:56] tony2001@php.net Duplicate of bug #32882. ------------------------------------------------------------------------ [2005-12-11 23:22:07] realbenzin at inbox dot lv 5.0.15 ------------------------------------------------------------------------ [2005-12-11 23:12:55] sniper@php.net What mysql version are you connecting to? ------------------------------------------------------------------------ [2005-12-11 22:49:42] realbenzin at inbox dot lv Description: ------------ When mysql stored procedures are called twice in a row I get mysqli error "Lost connection to MySQL server during query", it does not happen if I do it once or in row with simple sql statements... Mysql is ok, and no free_result is helping... Reproduce code: --------------- $db = new mysqli('localhost','root','qwerty','VT_SYS'); $u = $db->query("call spRazList(NULL);"); $u = $db->query("call spRazList(NULL);") or die('asdasdad'.$db->error); Expected result: ---------------- That stored procedure would execute twice with no errors. Actual result: -------------- Mysqli error "Lost connection to MySQL server during query" ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35637&edit=1