On Wed, Jan 21, 2015 at 5:35 AM, <[email protected]> wrote: > Dear all, > > I found a possible bug in VCL 2.4, base image creation is not working, > because image name cannot be set. > > Message: > ERROR: failed to insert into image table. Please choose another name. > > Relevant log part: > |20949|||vcld|utils.pm:database_execute|2928| ---- WARNING ---- > |20949|||vcld|utils.pm:database_execute|2928| 2015-01-21 > 09:04:18|20949|||vcld|utils.pm:database_execute|2928|could not execute > SQL statement: INSERT INTO image (name, prettyname, ownerid, platformid, > OSid, imagemetaid, deleted, lastupdate, size, architecture, > basedoffrevisionid) > |20949|||vcld|utils.pm:database_execute|2928| VALUES > ('xenserverlinux-centos-v0', 'centos', '1', '1', 56, 1, '1', NOW( ), > '1450', 'x86_64', '4') > |20949|||vcld|utils.pm:database_execute|2928| Cannot add or update a > child row: a foreign key constraint fails (`vcl`.`image`, CONSTRAINT > `image_ibfk_6` FOREIGN KEY (`basedoffrevisionid`) REFERENCES > `imagerevision` (`id`) ON UPDATE CASCADE) > |20949|||vcld|utils.pm:database_execute|2928| ( 0) utils.pm, > database_execute (line: 2928) > |20949|||vcld|utils.pm:database_execute|2928| (-1) image.pm, > setup_capture_base_image (line: 904) > |20949|||vcld|utils.pm:database_execute|2928| (-2) vcld, > setup_management_node (line: 929) >
Thank you for reporting this. It was a bug. The imagerevision.id value of 4 was hard coded. I updated trunk. > > VCL was installed with the script Josh provided. > > Frontend issue: > I add a new provisioning type(XenServer) to the VCL(database), but on the > frontend I cannot select it when I add new virtual machines to VCL. > I think this is the same issue encountered with OpenStack module. I traced down the cause in this message: http://markmail.org/message/2k7fiwwnq642gqr5 Josh, can this be improved for 2.4? Possibly merge getProvisioningTypes and getProvisioning in utils.pm? I would like to request your assitance. > > Br, > Aaron Toth > > VCL System Administrator > Fault Tolerant Systems Research Group > Department of Measurement and Information Systems > Budapest University of Technology and Economics
