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

2016-05-11 Thread Divya
Thanks Kevin. Will take a look at the example. Thanks, Divya On Tue, May 10, 2016 at 11:41 PM, Kevin Benton wrote: > Unfortunately we didn't switch to the new sql driver until liberty so that > probably wouldn't be a safe switch in Kilo. > > Adding a retry will help, but unfortunately that will

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

2016-05-10 Thread Kevin Benton
Unfortunately we didn't switch to the new sql driver until liberty so that probably wouldn't be a safe switch in Kilo. Adding a retry will help, but unfortunately that will still block your call for 60 seconds with that driver until the timeout exception is triggered. We worked around this in ML2

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

2016-05-10 Thread Divya
Thanks Mike for the response. I am part of Nuage openstack team. We are looking in to the issue. An extra delete_port call in NuagePlugin's add_router_interface triggers db lockout when insert into routerport ( this is in core neutron ). Are you suggesting NuagePlugin should retry in this case or s

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

2016-05-10 Thread Divya
Thanks Kevin for the response. Kevin, this is stable/kilo (customer is still on stable/kilo),is pymysql supported in stable/kilo?? Thanks & Regards, Divya On Tue, May 10, 2016 at 10:36 PM, Kevin Benton wrote: > In addition to what Mike said, "Lock wait timeout exceeded" sounds like an > error f

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

2016-05-10 Thread Kevin Benton
In addition to what Mike said, "Lock wait timeout exceeded" sounds like an error from the C-based mysql driver that eventlet couldn't recognize yielding calls on. We have moved away from that upstream for quite some time now. Ensure your DB connection string starts with 'mysql+pymysql://' to use th

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

2016-05-10 Thread Mike Bayer
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

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

2016-05-10 Thread Divya
Are there any general guidelines to avoid these db lock timeout issues in the third party neutron plugins?? Thanks, Divya On Tue, May 10, 2016 at 1: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/sce

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

2016-05-10 Thread Divya
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 route