[jira] [Created] (TC-497) delivery service updates taking >20 secs

["Dylan Volz (JIRA)" <ji...@apache.org>]

Dylan Volz created TC-497:
-----------------------------

             Summary: delivery service updates taking >20 secs
                 Key: TC-497
                 URL: https://issues.apache.org/jira/browse/TC-497
             Project: Traffic Control
          Issue Type: Bug
          Components: Traffic Ops
            Reporter: Dylan Volz
            Assignee: Dylan Volz


delivery service updates have begun taking about 25 seconds to finish. 
I have tracked this down to this call:
my $rs = $self->db->resultset('DeliveryserviceRegex')->search(undef, {prefetch => [
{regex => undef}
,
{deliveryservice => undef}
]} );
in the find_existing_host_regex helper defined in MojoPlugins/DeliveryService.pm
The worker is selected for graceful shutdown due to no heartbeat each time an update is made, but usually completes before the shutdown allowing the update to go through.
If you add a second host regex to the delivery service the update will always fail because it makes that db call twice and thus the worker is killed before the request finishes, and the request is sent to a new worker, continuing the process until the browser cancels the request.
Note: delivery service updates via the API do not have this problem because it appears that code path does not check for conflicting regexes.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)