Re: "Lost connection to MySQL server during query" when calling stored procedure

[Jasper Bryant-Greene]

Jasper Bryant-Greene wrote:
> I have a stored procedure defined as follows:
> 
> CREATE PROCEDURE `album`.`getUser`( IN userID INT )
>     READS SQL DATA
>     DETERMINISTIC
>     SQL SECURITY INVOKER
> SELECT * FROM users WHERE id=userID LIMIT 1;
> 
> Sometimes when I execute this stored procedure with, for example:
> 
> CALL getUser(7);
> 
> I get the error "Lost connection to MySQL server during query".
> 
> This only ever happens with stored procedures, never with any normal 
> kind of query.
> 
> I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.
> 

This only seems to happen when accessing MySQL from PHP's MySQLi API, 
not when accessing it using the mysql command-line client.

Is this a bug I should report to MySQL or to PHP? I'm not able to test 
other APIs at the moment.

-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/