From: Date: September 21 2005 4:22pm
Subject: Re: "Lost connection to MySQL server during query" when calling stored
 procedure
List-Archive: http://lists.mysql.com/mysql/189380
Message-Id: <43316C9D.8020804@codenode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, 
etc.?

-Daniel

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.
>