Re: [Testbed-admins] Problem updating the database after git clone from emulab-stable

["Cheng Cui" <ccui1@tigers.lsu.edu>]

I checked about the sql statement "INSERT IGNORE INTO sitevariables
VALUES..." in "sitevars-create.sql". It looks even the sql use "IGNORE",
there are still interrupts when do not want to overwrite variables that
have been set locally. 

So how could I really "ignore" those updates, and make "boss-install" go
on? Do I need to alter your source code that I have cloned?

Best Regards,

Cheng Cui
. Frey Computing Services Center . Baton Rouge, LA 70803

-----Original Message-----
From: Leigh Stoller [mailto:lbstoller@gmail.com] On Behalf Of Leigh
Stoller
Sent: Friday, March 19, 2010 12:02 PM
To: Cheng Cui
Cc: testbed-admins@flux.utah.edu; 'Miguel A. Erazo'
Subject: Re: [Testbed-admins] Problem updating the database after git
clone from emulab-stable

> When upgrading to emulab 5.x from 5.0, I got the similar problem when
> going through "boss>sudo gmake boss boss-install"

> # sitevar 'general/maxpoolsize' was added.
> INSERT INTO sitevariables VALUES ('general/maxpoolsize',NULL,'1','The
> maximum size of the shared pool');

For each of these, go ahead and execute the sql statement. We are
still looking into how to push these updates out safely, since these
are intended to be "site" variables, and we do not want to overwrite
ones that have been set locally.

Lbs