[openstack-dev] [neutron] Seeing db lockout issues in neutron add_router_interface

Mike Bayer mbayer at redhat.com
Tue May 10 23:54:19 UTC 2016



On 05/10/2016 04:57 PM, Divya wrote:
> Hi,
>     I am trying to run this rally test on stable/kilo
> https://github.com/openstack/rally/blob/master/samples/tasks/scenarios/neutron/create_and_delete_routers.json
>
> with concurrency 50 and iterations 2000.
>
> This test basically cretaes routers and subnets
> and then calls
> router-interface-add
> router-interface-delete
>
>
> And i am running this against 3rd party Nuage plugin.
>
> In the NuagePlugin:
>
> add_router_interface is something like this:
> ----------------------------
> super().add_router_interface
> try:
>    some calls to external rest server
>    super().delete_port
> except:
>
> remove_router_interface:
> -----------------------------------
> super().remove_router_interface
> some calls to external rest server
> super().create_port()
> some calls to external rest server
>
>
> If i comment delete_port in the add_router_interface, i am not hitting
> the db lockout issue.
> delete_port or any other operations are not within any transaction.
> So not sure, why this is leading to db lock timeouts in insert to routerport
>
> error trace
> http://paste.openstack.org/show/496626/
>
>
>
> Really appreciate any help on this.


I'm not on the Neutron team, but in general, Openstack applications 
should be employing retry logic internally which anticipates database 
deadlocks like these and retries the operation.  I'd report this stack 
trace (especially if it is reproducible) as a bug to this plugin's 
launchpad project.



>
> Thanks,
> Divya
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list