From: Date: September 21 2005 11:35pm
Subject: Re: "Lost connection to MySQL server during query" when calling stored
 procedure
List-Archive: http://lists.mysql.com/mysql/189402
Message-Id: <4331D23D.1040705@bryant-greene.name>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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

PHP MySQLi


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

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