|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: "Lost connection to MySQL server during query" when calling stored procedure
From: Jasper Bryant-Greene (jasper
bryant-greene.name)
Date: Thu Sep 22 2005 - 00:06:32 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]