From: Date: September 21 2005 10:40am
Subject: "Lost connection to MySQL server during query" when calling stored
 procedure
List-Archive: http://lists.mysql.com/mysql/189351
Message-Id: <43311C7F.7090804@bryant-greene.name>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

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/