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

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

Hello, 

When upgrading to emulab 5.x from 5.0, I got the similar problem when
going through "boss>sudo gmake boss boss-install"
I finished:
boss> cd /your/objdir/db
boss> sudo gmake install
boss> cd /your/srcdir/sql/updates
boss> /usr/testbed/sbin/dbupdate tbdb

Actually, after I deleted those temp tables in tbdb, I got another
issue:

boss# gmake boss-install
Checking DB schema...
cd ./db && perl schemacheck
Checking Site variables...
cd ./db && perl sitevarscheck
Use of uninitialized value in subroutine entry at
/usr/local/lib/perl5/site_perl/5.8.8/mach/Mysql.pm line 137.
Use of uninitialized value in subroutine entry at
/usr/local/lib/perl5/site_perl/5.8.8/mach/Mysql.pm line 137.
# sitevar 'general/maxpoolsize' was added.
INSERT INTO sitevariables VALUES ('general/maxpoolsize',NULL,'1','The
maximum size of the shared pool');
 
# sitevar 'protogeni/sa_uuid' was added.
INSERT INTO sitevariables VALUES ('protogeni/sa_uuid',NULL,'','The UUID
of the local Slice Authority.');
 
# sitevar 'general/default_longitude' was added.
INSERT INTO sitevariables VALUES
('general/default_longitude',NULL,'','The default longitude of your
site');
 
# sitevar 'general/open_showexplist' was changed.
UPDATE sitevariables SET description='Allow members of this project to
view all running experiments on the experiment list page' WHERE
name='general/open_showexplist';
 
# sitevar 'general/default_latitude' was added.
INSERT INTO sitevariables VALUES
('general/default_latitude',NULL,'','The default latitude of your
site');
 
# sitevar 'protogeni/max_externalnodes' was added.
INSERT INTO sitevariables VALUES
('protogeni/max_externalnodes',NULL,'1024','When set, maximum number of
nodes that external users may allocate.');
 
# sitevar 'protogeni/cm_uuid' was added.
INSERT INTO sitevariables VALUES ('protogeni/cm_uuid',NULL,'','The UUID
of the local Component Manager.');
 
# sitevar 'general/minpoolsize' was added.
INSERT INTO sitevariables VALUES ('general/minpoolsize',NULL,'1','The
Minimum size of the shared pool');
 
# sitevar 'general/poolnodetype' was added.
INSERT INTO sitevariables VALUES ('general/poolnodetype',NULL,'','The
preferred node type of the shared pool');
 
# sitevar 'general/default_country' was added.
INSERT INTO sitevariables VALUES ('general/default_country',NULL,'','The
default country of your site');
 
# sitevar 'protogeni/allow_externalusers' was added.
INSERT INTO sitevariables VALUES
('protogeni/allow_externalusers',NULL,'1','When set, external users may
allocate slivers on your testbed.');
 
 
The sitevariables from
/usr/testbed/src/emulab-stable/sql/sitevars-create.sql differs from
the running database. As a safety measure, you will not be able to
install
until this is resolved.
 
If you are a user of the emulab software outside of Utah, this is
probably
because your site variables have not been updated since the installation
of an older version of the emulab software.
Contact testbed-ops@emulab.net for help in updating your database.
 
If you're a developer at Utah, this is probably because you (or someone
else)
forgot to update sql/sitevars-create.sql .
 
gmake: *** [install-sitevarscheck] Error 1


Miguel, did you encounter the similar problem? 

Best Regards,

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


-----Original Message-----
From: testbed-admins-bounces@flux.utah.edu
[mailto:testbed-admins-bounces@flux.utah.edu] On Behalf Of Leigh Stoller
Sent: Tuesday, February 23, 2010 11:58 AM
To: Miguel A. Erazo
Cc: testbed-admins@flux.utah.edu
Subject: Re: [Testbed-admins] Problem updating the database

> # Table temp_os_info was removed
> DROP TABLE temp_os_info;
> # Table temp_o2i was removed
> DROP TABLE temp_o2i;
> # Table temp_images was removed
> DROP TABLE temp_images;

Ah, this is good. These are just some temp tables that are created
during the initial creation of your Emulab. Go ahead and start up
mysql on bsss and remove those tables.

boss> mysql tbdb
mysql> drop table temp_os_info;
mysql> ...
mysql> ...

And then try the install again.

Lbs

_______________________________________________
Testbed-admins mailing list
Testbed-admins@flux.utah.edu
http://www.flux.utah.edu/mailman/listinfo/testbed-admins