-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Joseph,
Yes, you can delete the reservations. However, you'll need to delete them from the request table, which will also cause the records in the reservation table to be deleted. Anything that would cause a vcld process to terminate in the middle of processing a reservation would leave entries like these. While a vcld process is handling a reservation, it sets request.stateid to pending so that the main vcld process knows it is being handled by another process. If the vcld process handling a reservation terminates, request.stateid is left as pending and the reservation is never picked up again. After deleting the request entries (you can safely delete any with request.state = 14 that don't have a corresponding vcld process), you'll probably want to go ahead and reload the VMs through the Edit Computer Profiles part of the site so that what the computer is actually loaded with is in sync with what is recorded in the database. Josh On Monday, October 16, 2017 10:16:11 AM EDT Joseph Fischetti wrote: > Hi, > I have a few (6) stale "pending|reload" reservations (from vclreload@Local) > listed in my dashboard, and the machines that are attached to these > reservations say "reload" for their status. > > I'm wondering if I can simply delete the reservations from the reservations > table, and mark the machines as available, without any adverse effects. > > Example from the dashboard: > Start ReqID User Computer States Image Install Type > Management Node > Thu > 10:51 1030 vclreload@Local PF1-VM04 pending|reload MSProjectWin764 vmware v > cl-pfmn > > > Example database row (lastcheck is the same for all 6 reservations, within a > few seconds) > id requestid computerid imageid imagerevisionid > managementnodeid remoteIP l > astcheck pw connectIP connectport 1030 1030 16 > 12 14 2 NULL 2017-09-21 > 11:53:09 NULL NULL NULL > > > Joseph Fischetti > Linux System Administrator > Marist College - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found at pgp.mit.edu All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties. -----BEGIN PGP SIGNATURE----- iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCWeT+ugAKCRBX8tBw1209 A8kmAJ0SzzFhhm8uRuuJYbKic5autAygWgCfaI/+y2FrALefWhV33V6NnfVWFGo= =JE7W -----END PGP SIGNATURE-----
