Re: [Sqlrelay-discussion] Patch to fix MySQL auto-reconnect (MYSQL_OPT_RECONNECT option)

[David M. <dav...@fi...>]

Cool.  I'll give it a try and should be able to include it in the next
release.

Thanks!

Dave Muse
dav...@fi...


On Mon, 2008-02-11 at 18:05 -0800, Renaud Amar wrote:
> I wrote a small patch which fixes an issue I’ve noticed with the SQL
> Relay connection daemons for MySQL:
> 
> the connection daemon doesn’t automatically reconnect to the MySQL
> database once it’s been disconnected (either when restarting mysqld or
> when the connection times out). I’ve also noticed that after being
> disconnected, the connection daemon usually gets stuck in a weird loop
> where it keeps trying to unsuccessfully send a query over and over.
> 
>  
> 
> After looking through the mysql connection daemon code, I noticed that
> the code that is supposed  to enable the  MYSQL_OPT_RECONNECT option
> (in mysqlconnection.h and mysqlconnection.C) was ifdef’ed using a
> different #define symbol as the one used in the config.h file.
> 
> Namely, it’s using “#ifdef MYSQL_OPT_RECONNECT” while config.h defines
> “HAVE_MYSQL_OPT_RECONNECT”.
> 
> This patch simply modifies mysqlconnection.h and mysqlconnection.C to
> use HAVE_MYSQL_OPT_RECONNECT.
> 
>  
> 
> This is probably the same issue Abraham Müller mentioned in a previous
> post (here:
> http://sourceforge.net/mailarchive/forum.php?thread_name=47739600.8090800%40gmx.de&forum_name=sqlrelay-discussion).
> 
> Hopefully, this patch will fix this issue as well.
> 
>  
> 
>  
> 
>  
> 
> Renaud.
> 
>  
> 
>  
> 
> PS: when applying the patch in your spec file, in the %prep section,
> make sure you call it with the –p1 option, in order to strip one level
> of directories from the paths in the patch file.
> 
>  
> 
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
> http://www.doteasy.com 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion



__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
             http://www.doteasy.com