[VCL-898] Update schema to allow NULL request.logid

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 2.5
• Component/s: database, vcld (backend), web gui (frontend)
• Assignee: Andrew Kurth
• Reporter: Andrew Kurth
• Created: 12/Aug/15 19:46
• Updated: 31/Mar/17 16:30
• Resolved: 31/Mar/17 16:30

Description

A constraint was (correctly) added to request.logid which causes utils.pm::insert_request to fail. insert_request is called from:

• image.pm::setup_capture_base_image
• utils.pm::insert_reload_request

insert_request does not currently attempt to insert an entry to the log table before inserting into the request table but it does accept a log.id argument. However, log.id is specified as 0 in both locations where it is called. Since there is no entry in the log table with id=0, the following error is generated when attempting to insert into the request table:

Cannot add or update a child row: a foreign key constraint fails (`vcl`.`request`, CONSTRAINT `request_ibfk_18` FOREIGN KEY (`logid`) REFERENCES `log` (`id`) ON UPDATE CASCADE)

insert_request either needs to be updated to first add a row to the log table or the request table needs to be modified to allow NULL logid values.