List:MySQL++« Previous MessageNext Message »
From:Martin Dubuc Date:July 20 2010 4:03pm
Subject:Re: Problem with ReconnectOption on CentOS 5.5
View as plain text  
What is the race condition that can occur if one sets the reconnect option
after the connection comes up?

Martin

On Tue, Jul 20, 2010 at 10:42 AM, Warren Young <mysqlpp@stripped> wrote:

> On 7/20/2010 8:17 AM, Martin Dubuc wrote:
>
>>
>> This code used to work on both CentOS 5.4 (mysql-5.0.77-3) and Fedora 13
>> when using the 3.0.9 version of mysql++, but since I upgraded to mysql++
>> 3.1.0 and CentOS 5.5, the connect call fails with error "Option can only
>> be
>> set while the connection is established" on CentOS 5.5, although it works
>> on
>> Fedora 13.
>>
>
> From the 3.1.0 section of the MySQL++ ChangeLog:
>
>    o ReconnectOption behavior now knows about a fix in MySQL 5.1.6 and
>      newer that lets you set it either before the connection is up,
>      or after.  If you try to set this option when MySQL++ is built
>      against earlier versions of the MySQL C API, it will refuse to
>      set the option because it knows the option will be reset when
>      the connection comes up.
>
> The truth about your observation that "it used to work" is that it didn't
> do what you thought it did.
>
> While you could just move the set_option() call to after the connect()
> call, it'd be better to upgrade to the current MySQL 5.1 release and leave
> your code the same, as that avoids a race condition.
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
> http://lists.mysql.com/plusplus?unsub=1
>
>

Thread
Problem with ReconnectOption on CentOS 5.5Martin Dubuc20 Jul
  • Re: Problem with ReconnectOption on CentOS 5.5Warren Young20 Jul
    • Re: Problem with ReconnectOption on CentOS 5.5Martin Dubuc20 Jul
      • Re: Problem with ReconnectOption on CentOS 5.5Warren Young20 Jul
        • Does 3.1.0 support MySQL 5.0?dancook)22 Jul
          • Re: Does 3.1.0 support MySQL 5.0?Warren Young22 Jul
            • RE: Does 3.1.0 support MySQL 5.0?dancook)23 Jul
              • Re: Does 3.1.0 support MySQL 5.0?Warren Young23 Jul