Dylan Volz resolved TC-497.
    Resolution: Fixed

> 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

Reply via email to