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

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

Yes, there is no output after the sitevars-create.sql update. But I
still get such error:

boss# cat /usr/testbed/src/CRON_branch/sql/sitevars-create.sql | mysql
tbdb
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 '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';
....

Do you want my local branch sitevars-create.sql as well? It just
contains several local variables which are different from Utah. Thanks.

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 12:59 PM
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

> DELETE FROM sitevariables WHERE name='node/ssh_pubkey';
> 
> 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.

All those delete statements seem to indicate that you have not
recreated the sitevars table correctly.

boss> cat sql/sitevars-create.sql | mysql tbdb

This should produce no output at all. If it does, something is wrong
and you should send us that output.

Lbs