From: Warren Young
Date: July 20 2010 2:42pm
Subject: Re: Problem with ReconnectOption on CentOS 5.5
List-Archive: http://lists.mysql.com/plusplus/8993
Message-Id: <4C45B5BF.6000704@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.