You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@vcl.apache.org by "Andy Kurth (JIRA)" <ji...@apache.org> on 2015/08/20 16:29:47 UTC
[jira] [Updated] (VCL-898) Update utils.pm::insert_request to add
an entry to the log table
[ https://issues.apache.org/jira/browse/VCL-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andy Kurth updated VCL-898:
---------------------------
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:
{panel}
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)
{panel}
*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.
was:
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:
{noformat}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){noformat}
*insert_request* needs to be updated to first add a row to the log table. This subroutine should also probably be renamed to *insert_reservation* and reworked.
> Update utils.pm::insert_request to add an entry to the log table
> ----------------------------------------------------------------
>
> Key: VCL-898
> URL: https://issues.apache.org/jira/browse/VCL-898
> Project: VCL
> Issue Type: Sub-task
> Components: vcld (backend)
> Reporter: Andy Kurth
> Assignee: Andy Kurth
> Fix For: 2.5
>
>
> 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:
> {panel}
> 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)
> {panel}
> *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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)