yahoo-eng-team team mailing list archive

[Mehdi Abaakouk <mehdi.abaakouk@xxxxxxxxxxxx>]

Public bug reported:

Hi,

Gate fail with:

2014-12-02 08:57:06.298 28489 TRACE neutron.api.v2.resource
OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded;
try restarting transaction') 'INSERT INTO securitygroupportbindings
(port_id, security_group_id) VALUES (%s, %s)' ('503420ff-dab1-430a-a5dc-
d568f3b90d2a', 'b9f16f0e-e32d-4094-a90a-e07bd6dbc02f')

For more detail see: http://logs.openstack.org/48/138048/4/check/gate-
tempest-dsvm-neutron-src-oslo.messaging-
icehouse/c18f928/logs/screen-q-svc.txt.gz?level=TRACE

Or:

http://logstash.openstack.org/#eyJzZWFyY2giOiJcIk9wZXJhdGlvbmFsRXJyb3I6IChPcGVyYXRpb25hbEVycm9yKSAoMTIwNSwgJ0xvY2sgd2FpdCB0aW1lb3V0IGV4Y2VlZGVkOyB0cnkgcmVzdGFydGluZyB0cmFuc2FjdGlvbicpICdJTlNFUlQgSU5UTyBzZWN1cml0eWdyb3VwcG9ydGJpbmRpbmdzIFwiIiwiZmllbGRzIjpbIm1vZHVsZSIsInByb2plY3QiXSwib2Zmc2V0IjowLCJ0aW1lZnJhbWUiOiI2MDQ4MDAiLCJncmFwaG1vZGUiOiJjb3VudCIsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxNDE3NTEyNzc0NDgzfQ==

Regards

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  Lock wait time out on 'INSERT INTO securitygroupportbindings'

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Hi,

  Gate fail with:

  2014-12-02 08:57:06.298 28489 TRACE neutron.api.v2.resource
  OperationalError: (OperationalError) (1205, 'Lock wait timeout
  exceeded; try restarting transaction') 'INSERT INTO
  securitygroupportbindings (port_id, security_group_id) VALUES (%s,
  %s)' ('503420ff-dab1-430a-a5dc-d568f3b90d2a', 'b9f16f0e-e32d-4094
  -a90a-e07bd6dbc02f')

  For more detail see: http://logs.openstack.org/48/138048/4/check/gate-
  tempest-dsvm-neutron-src-oslo.messaging-
  icehouse/c18f928/logs/screen-q-svc.txt.gz?level=TRACE

  Or:

  http://logstash.openstack.org/#eyJzZWFyY2giOiJcIk9wZXJhdGlvbmFsRXJyb3I6IChPcGVyYXRpb25hbEVycm9yKSAoMTIwNSwgJ0xvY2sgd2FpdCB0aW1lb3V0IGV4Y2VlZGVkOyB0cnkgcmVzdGFydGluZyB0cmFuc2FjdGlvbicpICdJTlNFUlQgSU5UTyBzZWN1cml0eWdyb3VwcG9ydGJpbmRpbmdzIFwiIiwiZmllbGRzIjpbIm1vZHVsZSIsInByb2plY3QiXSwib2Zmc2V0IjowLCJ0aW1lZnJhbWUiOiI2MDQ4MDAiLCJncmFwaG1vZGUiOiJjb3VudCIsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxNDE3NTEyNzc0NDgzfQ==

  Regards

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