← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1332500] [NEW] Lock wait timeout inserting row into routers table

 

Public bug reported:

Another instance of the famous bug:

http://logs.openstack.org/87/99187/1/check/check-tempest-dsvm-neutron-
full/978727a/logs/screen-q-svc.txt.gz?level=TRACE#_2014-06-20_03_10_37_447

OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded;
try restarting transaction') 'INSERT INTO routers (tenant_id, id, name,
status, admin_state_up, gw_port_id, enable_snat) VALUES (%s, %s, %s, %s,
%s, %s, %s)' ('91f1077240284b0a85e9bb8a02712926', '04003809-f94c-42ef-
ad5a-d84dd0b0a086', 'AttachVolumeV3Test-488061603-router', 'ACTIVE', 1,
None, 1)

** Affects: neutron
     Importance: High
     Assignee: Eugene Nikanorov (enikanorov)
         Status: Confirmed


** Tags: db gate-failure

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1332500

Title:
  Lock wait timeout inserting row into routers table

Status in OpenStack Neutron (virtual network service):
  Confirmed

Bug description:
  Another instance of the famous bug:

  http://logs.openstack.org/87/99187/1/check/check-tempest-dsvm-neutron-
  full/978727a/logs/screen-q-svc.txt.gz?level=TRACE#_2014-06-20_03_10_37_447

  OperationalError: (OperationalError) (1205, 'Lock wait timeout
  exceeded; try restarting transaction') 'INSERT INTO routers
  (tenant_id, id, name, status, admin_state_up, gw_port_id, enable_snat)
  VALUES (%s, %s, %s, %s, %s, %s, %s)'
  ('91f1077240284b0a85e9bb8a02712926', '04003809-f94c-42ef-ad5a-
  d84dd0b0a086', 'AttachVolumeV3Test-488061603-router', 'ACTIVE', 1,
  None, 1)

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1332500/+subscriptions


Follow ups

References