> 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
