|
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: Martijn Tonies (m.tonies
upscene.com)
Date: Wed Sep 21 2005 - 03:47:14 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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.
And what is your question?
;-)
Most probably, a server crash...
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]