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

[Chris C. <cc...@gm...>]

Centos 4.4 (Generally)Mysql 5.0.22 or 5.0.41

Test Case
 - Set the wait_timeout on the mysql server to 10 seconds
 - open local sqlrsh instance to mysql server
 - run a few queries
 - let it sit for > 10s
 - run another query

Without auto_reconnect enabled, sqlrelay will hang indefinitely (or not,
I've never been that patient).  With reconnect enabled you can sit there and
every 15 seconds select session_id() and watch it increment.

It may be that the API treats a timeout or other non-server failure based
disconnect differently from the server bouncing (? vaguely recall something
like this from when I was digging through docs, but not sure).

Hope this helps,
 - Chris

On Feb 19, 2008 10:16 AM, David Muse <dav...@fi...> wrote:

> This patch appears to be more correct that the code I had before, so
> I'll apply it.  Though even without this patch, I can't replicate the
> problem that several folks have reported.
>
> If I run an instance of mysql, run sqlrelay against it, run some queries
> through sqlrsh, stop the mysql server, run a query through sqlrsh, then
> restart the mysql server, sqlrelay successfully reconnects and the query
> goes through.  I've tried several different versions of mysql and tried
> restart vs. stop/start, and other things, but I can't seem to reproduce
> the error.
>
> Could someone who's had trouble with this send me some more info.  What
> version of mysql are you using, what platform, and exactly what steps
> are you using to reproduce the error?
>
> Thanks,
>
> David Muse
> dav...@fi...
>
> On Fri, 2008-02-15 at 00:17 -0500, David Muse wrote:
> > 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
>
> -------------------------------------------------------------------------
> 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
>