Hi,
2005/9/21, Jasper Bryant-Greene <[EMAIL PROTECTED]>: > Martijn Tonies 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. > > > > > > And what is your question? > > Fairly obviously, how do I fix it!? ;) > > > Most probably, a server crash... > > Can you be a little bit more specific please? The MySQL server is > working absolutely fine for everything else and also continues to > respond to connections and queries perfectly after getting that error. > I think he means, that you should try the official binaries, and this still happens, file a bug report because 5.0 is still in Beta stage. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]