Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              arkurth Andrew Kurth
              Reporter:
              arkurth Andrew Kurth
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: