[From nobody Thu Dec  7 19:54:53 2006
Message-ID: <457870F0.6040703@rydia.net>
Date: Thu, 07 Dec 2006 11:52:16 -0800
From: dormando <dormando@rydia.net>
User-Agent: Thunderbird 1.5.0.8 (X11/20061025)
MIME-Version: 1.0
To: "Brett G. Durrett" <brett@imvu.com>
Subject: Re: Mixed environment with 1.x and svn tag 2.00_02 trackers failure
	adding files
References: <45786DCD.9070904@imvu.com>
In-Reply-To: <45786DCD.9070904@imvu.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Run mogdbsetup with --noschemabump to "upgrade" your schema, but not 
bump the version info.

Or if you're feeling more paranoid; Crack open mogdbsetup and 
hand-create those extra tables + any ALTER's that're needed. The 
schema's currently backwards compatible so that all works with the 1.x 
clients and the 2.x clients.

Then when you've migrated fully to 2.x and stable on it, you can run 
mogdbsetup again to bump the schema version (or do it by hand) and start 
up the trackers as normal.

-Dormando

Brett G. Durrett wrote:
> 
> I have been testing a deploy of a 2.x tracker in a 1.x environment and 
> keep getting failures adding files.  I start the 2.x tracker (pulled 
> from SVN tag 2.00_02) with the parameter "--no_schema_check" since I am 
> running the 1.x schema.  However, adding files fails in Query.pm in the 
> function cmd_create_close at these lines of code:
> 
>    # mark it as needing replicating:
>    $dbh->do("INSERT IGNORE INTO file_to_replicate ".
>             "SET fid=?, fromdevid=?, nexttry=0", undef, $fid, $devid);
>    return $self->err_line("db_error") if $dbh->err;
> 
> The reason for the failure is obvious... the table does not exist.  I 
> have heard running a mixed environment is possible by just skipping the 
> schema update... am I missing another step or is it not possible to run 
> un-modified 2.x in a 1.x environment?
> 
> B-
> 


]