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

[Jasper Bryant-Greene]

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/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]