List:General Discussion« Previous MessageNext Message »
From:Jasper Bryant-Greene Date:September 21 2005 8:54am
Subject:Re: "Lost connection to MySQL server during query" when calling stored
procedure
View as plain text  
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.

Thanks

-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
Thread
"Lost connection to MySQL server during query" when calling storedprocedureJasper Bryant-Greene21 Sep
  • Re: "Lost connection to MySQL server during query" when calling stored procedureMartijn Tonies21 Sep
    • Re: "Lost connection to MySQL server during query" when calling storedprocedureJasper Bryant-Greene21 Sep
      • Re: "Lost connection to MySQL server during query" when calling stored procedurePooly21 Sep
  • Re: "Lost connection to MySQL server during query" when calling storedprocedureDaniel21 Sep
    • Re: "Lost connection to MySQL server during query" when calling storedprocedureJasper Bryant-Greene21 Sep
  • Re: "Lost connection to MySQL server during query" when calling storedprocedureJasper Bryant-Greene22 Sep
    • Re: "Lost connection to MySQL server during query" when calling stored procedureGreg 'groggy' Lehey27 Sep
Re: "Lost connection to MySQL server during query" when calling storedprocedureJasper Bryant-Greene23 Sep
  • Re: "Lost connection to MySQL server during query" when callingstored procedureLenz Grimmer27 Sep