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

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

The complete output is attached as the problem.txt. Part of the top
output is like this:
%cd /usr/testbed/obj/testbed-stable-obj/
%sudo 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 'node/ssh_pubkey' was deleted.
DELETE FROM sitevariables WHERE name='node/ssh_pubkey';
 
# sitevar 'watchdog/hostkeys' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/hostkeys';


By the way, I have deleted the table "sitevariables" and checked the
statement between Utah and local site, re-synchronized the sql
statement, and re-inserted the whole data. Particularly, when there was
no data in the table "sitevariables", the check passed. But when the
data was there, the check didn't. 

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: Monday, March 29, 2010 9:47 AM
To: Cheng Cui
Cc: 'Robert P Ricci'; 'Mike Hibler'; testbed-admins@flux.utah.edu
Subject: Re: [Testbed-admins] Problem updating the database after git
clone from emulab-stable

> Will somebody add the debug mode in the sql update file
> "sitevarscheck"

Hmm, when you try to do a boss-install, what is the exact output
please?

Lbs

%cd /usr/testbed/obj/testbed-stable-obj/
%sudo 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 'node/ssh_pubkey' was deleted.
DELETE FROM sitevariables WHERE name='node/ssh_pubkey';
 
# sitevar 'watchdog/hostkeys' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/hostkeys';
 
# sitevar 'swap/swapout_command' was deleted.
DELETE FROM sitevariables WHERE name='swap/swapout_command';
 
# sitevar 'swap/idleswap_warn' was deleted.
DELETE FROM sitevariables WHERE name='swap/idleswap_warn';
 
# sitevar 'general/maxpoolsize' was deleted.
DELETE FROM sitevariables WHERE name='general/maxpoolsize';
 
# sitevar 'protogeni/sa_uuid' was deleted.
DELETE FROM sitevariables WHERE name='protogeni/sa_uuid';
 
# sitevar 'general/default_imagename' was deleted.
DELETE FROM sitevariables WHERE name='general/default_imagename';
 
# sitevar 'webcam/anyone_can_view' was deleted.
DELETE FROM sitevariables WHERE name='webcam/anyone_can_view';
 
# sitevar 'watchdog/interval' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/interval';
 
# sitevar 'batch/retry_wait' was deleted.
DELETE FROM sitevariables WHERE name='batch/retry_wait';
 
# sitevar 'general/testvar' was deleted.
DELETE FROM sitevariables WHERE name='general/testvar';
 
# sitevar 'web/message' was deleted.
DELETE FROM sitevariables WHERE name='web/message';
 
# sitevar 'plab/setup/vnode_wait_time' was deleted.
DELETE FROM sitevariables WHERE name='plab/setup/vnode_wait_time';
 
# sitevar 'robotlab/override' was deleted.
DELETE FROM sitevariables WHERE name='robotlab/override';
 
# sitevar 'idle/mailinterval' was deleted.
DELETE FROM sitevariables WHERE name='idle/mailinterval';
 
# sitevar 'swap/admission_control_debug' was deleted.
DELETE FROM sitevariables WHERE name='swap/admission_control_debug';
 
# sitevar 'watchdog/rusage' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/rusage';
 
# sitevar 'general/version/build' was deleted.
DELETE FROM sitevariables WHERE name='general/version/build';
 
# sitevar 'elabinelab/boss_pkg_dir' was deleted.
DELETE FROM sitevariables WHERE name='elabinelab/boss_pkg_dir';
 
# sitevar 'swap/use_admission_control' was deleted.
DELETE FROM sitevariables WHERE name='swap/use_admission_control';
 
# sitevar 'plab/message' was deleted.
DELETE FROM sitevariables WHERE name='plab/message';
 
# sitevar 'elabinelab/ops_pkg' was deleted.
DELETE FROM sitevariables WHERE name='elabinelab/ops_pkg';
 
# sitevar 'swap/autoswap_warn' was deleted.
DELETE FROM sitevariables WHERE name='swap/autoswap_warn';
 
# sitevar 'general/default_longitude' was deleted.
DELETE FROM sitevariables WHERE name='general/default_longitude';
 
# sitevar 'swap/swapout_command_failaction' was deleted.
DELETE FROM sitevariables WHERE name='swap/swapout_command_failaction';
 
# sitevar 'elabinelab/boss_pkg' was deleted.
DELETE FROM sitevariables WHERE name='elabinelab/boss_pkg';
 
# sitevar 'web/banner' was deleted.
DELETE FROM sitevariables WHERE name='web/banner';
 
# sitevar 'watchdog/isalive/local' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/isalive/local';
 
# sitevar 'robotlab/exclusive' was deleted.
DELETE FROM sitevariables WHERE name='robotlab/exclusive';
 
# sitevar 'general/open_showexplist' was deleted.
DELETE FROM sitevariables WHERE name='general/open_showexplist';
 
# sitevar 'general/version/major' was deleted.
DELETE FROM sitevariables WHERE name='general/version/major';
 
# sitevar 'watchdog/isalive/wa' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/isalive/wa';
 
# sitevar 'watchdog/ntpdrift' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/ntpdrift';
 
# sitevar 'watchdog/isalive/plab' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/isalive/plab';
 
# sitevar 'swap/swapout_command_timeout' was deleted.
DELETE FROM sitevariables WHERE name='swap/swapout_command_timeout';
 
# sitevar 'robotlab/closetime' was deleted.
DELETE FROM sitevariables WHERE name='robotlab/closetime';
 
# sitevar 'plab/setup/vnode_batch_size' was deleted.
DELETE FROM sitevariables WHERE name='plab/setup/vnode_batch_size';
 
# sitevar 'elabinelab/ops_pkg_dir' was deleted.
DELETE FROM sitevariables WHERE name='elabinelab/ops_pkg_dir';
 
# sitevar 'plab/max_load' was deleted.
DELETE FROM sitevariables WHERE name='plab/max_load';
 
# sitevar 'general/joinproject/admincheck' was deleted.
DELETE FROM sitevariables WHERE name='general/joinproject/admincheck';
 
# sitevar 'web/nologins' was deleted.
DELETE FROM sitevariables WHERE name='web/nologins';
 
# sitevar 'general/mailman/password' was deleted.
DELETE FROM sitevariables WHERE name='general/mailman/password';
 
# sitevar 'general/default_latitude' was deleted.
DELETE FROM sitevariables WHERE name='general/default_latitude';
 
# sitevar 'elabinelab/windows' was deleted.
DELETE FROM sitevariables WHERE name='elabinelab/windows';
 
# sitevar 'general/linux_endnodeshaping' was deleted.
DELETE FROM sitevariables WHERE name='general/linux_endnodeshaping';
 
# sitevar 'node/gw_mac' was deleted.
DELETE FROM sitevariables WHERE name='node/gw_mac';
 
# sitevar 'watchdog/cvsup' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/cvsup';
 
# sitevar 'robotlab/open' was deleted.
DELETE FROM sitevariables WHERE name='robotlab/open';
 
# sitevar 'plab/load_metric' was deleted.
DELETE FROM sitevariables WHERE name='plab/load_metric';
 
# sitevar 'idle/cc_grp_ldrs' was deleted.
DELETE FROM sitevariables WHERE name='idle/cc_grp_ldrs';
 
# sitevar 'watchdog/isalive/vnode' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/isalive/vnode';
 
# sitevar 'watchdog/isalive/dead_time' was deleted.
DELETE FROM sitevariables WHERE name='watchdog/isalive/dead_time';
 
# sitevar 'general/recently_active' was deleted.
DELETE FROM sitevariables WHERE name='general/recently_active';
 
# sitevar 'general/autoswap_threshold' was deleted.
DELETE FROM sitevariables WHERE name='general/autoswap_threshold';
 
# sitevar 'general/firstinit/state' was deleted.
DELETE FROM sitevariables WHERE name='general/firstinit/state';
 
# sitevar 'protogeni/max_externalnodes' was deleted.
DELETE FROM sitevariables WHERE name='protogeni/max_externalnodes';
 
# sitevar 'idle/batch_threshold' was deleted.
DELETE FROM sitevariables WHERE name='idle/batch_threshold';
 
# sitevar 'protogeni/cm_uuid' was deleted.
DELETE FROM sitevariables WHERE name='protogeni/cm_uuid';
 
# sitevar 'idle/threshold' was deleted.
DELETE FROM sitevariables WHERE name='idle/threshold';
 
# sitevar 'general/firstinit/pid' was deleted.
DELETE FROM sitevariables WHERE name='general/firstinit/pid';
 
# sitevar 'plab/stale_age' was deleted.
DELETE FROM sitevariables WHERE name='plab/stale_age';
 
# sitevar 'general/minpoolsize' was deleted.
DELETE FROM sitevariables WHERE name='general/minpoolsize';
 
# sitevar 'webcam/admins_can_view' was deleted.
DELETE FROM sitevariables WHERE name='webcam/admins_can_view';
 
# sitevar 'robotlab/opentime' was deleted.
DELETE FROM sitevariables WHERE name='robotlab/opentime';
 
# sitevar 'general/poolnodetype' was deleted.
DELETE FROM sitevariables WHERE name='general/poolnodetype';
 
# sitevar 'general/default_country' was deleted.
DELETE FROM sitevariables WHERE name='general/default_country';
 
# sitevar 'protogeni/allow_externalusers' was deleted.
DELETE FROM sitevariables WHERE name='protogeni/allow_externalusers';
 
# sitevar 'general/version/minor' was deleted.
DELETE FROM sitevariables WHERE name='general/version/minor';
 
# sitevar 'plab/min_disk' was deleted.
DELETE FROM sitevariables WHERE name='plab/min_disk';
 
# sitevar 'general/autoswap_mode' was deleted.
DELETE FROM sitevariables WHERE name='general/autoswap_mode';
 
 
The sitevariables from /usr/testbed/src/CRON_branch/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