Very cool, glad to hear. Yes you can go ahead and clean out those reservations that are in maintenance(stateid=10) and the ones that are scheduled for tomaintenance(stateid=18), this will remove the clutter from the db.
to delete the maintenance reservations. mysql> DELETE request where stateid=10; to delete the ones on tomaintenance state mysql> DELETE request where stateid=18; Cheers, Aaron On Fri, Jun 28, 2013 at 12:48 PM, James A.s. Trimbee <[email protected]> wrote: > Thank you. I have made quite a bit of progress, through the magic of > restarting things... > > I restarted the management node and the database server (I'm using a layout > that is close to the documented suggestion with everything on separate > boxes) and now it is behaving perfectly...I have been able to capture a > Centos image from KVM. it reloaded automatically, and I was able to update it. > > I ran the query and pasted the output as a csv here: > http://apaste.info/oX1X > > I do still have 6 entries that appear to relate to maintenance showing up in > the log, from when I was wrestling with reservations. They don't seem to be > harming anything at the moment: > > http://apaste.info/eCYt > > > James > > > -----Original Message----- > From: Aaron Peeler [mailto:[email protected]] > Sent: Friday, June 28, 2013 11:21 AM > To: [email protected] > Subject: Re: Stuck after creating Linux Base Image (KVM) > > If you would please run the below statement at the mysql cmdline and send me > the output. Just want to make sure there is nothing else in the database > request and reservation tables. > > select request.id,request.stateid,reservation.requestid,reservation.computerid > from request,reservation; > > Details on how to run this sql statement database server, I'm assuming your > using one server for web,db and vcld code. > > as root: > run mysql to get the mysql cmdline you will see the prompt change to mysql> > > Change to the vcl database. > mysql> use vcl; > > query the request and reservation table > > mysql> select > mysql> request.id,request.stateid,reservation.requestid,reservation.comp > mysql> uterid > from request,reservation; > > Btw, I definitely recommend phpMyAdmin if you don't already have it. > It makes managing the database a lot easier. > > > Aaron > > > > On Fri, Jun 28, 2013 at 10:43 AM, James A.s. Trimbee <[email protected]> wrote: >> Hi Aaron, >> >> Thanks for your help. That makes sense - I'd appreciate the SQL statement if >> you have it, I'm not sure where in the db to start! >> >> James >> >> -----Original Message----- >> From: Aaron Peeler [mailto:[email protected]] >> Sent: Friday, June 28, 2013 10:34 AM >> To: [email protected] >> Subject: Re: Stuck after creating Linux Base Image (KVM) >> >> James, >> >> Correction, with Andy's assistance we noticed that you have some older stale >> reservations in the database that will prevent a reload. These are left over >> from previous attempts of running vcld --setup. If any new reservation or >> reload request detects a conflict it will stop the processing. >> >> Simply delete those reservation entries from the database request table >> either using phpmyadmin, at the mysql cmd line or another tool. >> If needed I can provide a cmdline mysql statement to delete those for you, >> just let me know. >> >> >> Aaron >> >> >> On Fri, Jun 28, 2013 at 9:30 AM, Aaron Peeler <[email protected]> wrote: >>> Hi James, >>> >>> I was able to see the full log output in the file you attached, no >>> need to use pastebin now. Also good to know they have a line >>> limit...... >>> >>> One thing I noticed in the log file, after a image capture the node >>> should get reloaded automatically. It didn't happen in this case, for >>> some reason the state of the computer did not get changed. >>> >>> I recommend to. Go to: >>> manage computers >>> select Select All computers >>> make sure computer utilities is selected hit submit >>> >>> Make sure computenode1 is set to available. >>> >>>>> The wiki states "You must add the image to an image group using the VCL >>>>> website after the image capture process is complete. Reservations for >>>>> the image cannot be made until this is done. To add the image to an >>>>> image group, browse to the VCL website and select Manage Images > Edit >>>>> Image Grouping." What's meant to happen after this step? >>>>> >>> >>> On your new image, yes it will need to be mapped correctly. The >>> reason for this mapping is that VCL supports the ability to run >>> different types of images under the same VCL instance, kvm, vmware, >>> virtual box, bare metal and standalone lab machines, and hopefully in >>> the future openstack, cloudstack on so on. This image to computer >>> mapping is the method to correctly have images land on the correct >>> subset of computer resources in your VCL infrastructure. By default, >>> we have made a couple of initial mappings for you, allVMimages is >>> mapped to All VM computers. >>> allimages is mapped to allComputers >>> >>> Once you add you new image to the allVMimages then you should be >>> able to test it out either through the computer reload or through >>> making a new reservation. >>> >>> Aaron >>> >>> >>> -- >>> Aaron Peeler >>> Program Manager >>> Virtual Computing Lab >>> NC State University >>> >>> 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. >> >> >> >> -- >> Aaron Peeler >> Program Manager >> Virtual Computing Lab >> NC State University >> >> 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. > > > > -- > Aaron Peeler > Program Manager > Virtual Computing Lab > NC State University > > 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. -- Aaron Peeler Program Manager Virtual Computing Lab NC State University 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.
