List:General Discussion« Previous MessageNext Message »
From:Pooly Date:September 21 2005 12:02pm
Subject:Re: "Lost connection to MySQL server during query" when calling stored procedure
View as plain text  
Hi,


2005/9/21, Jasper Bryant-Greene <jasper@stripped>:
> 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/
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