Reviewed:  https://review.openstack.org/502850
Committed: 
https://git.openstack.org/cgit/openstack/neutron/commit/?id=1edd0c792499dbd6c59257a10c901360941dbcf6
Submitter: Jenkins
Branch:    master

commit 1edd0c792499dbd6c59257a10c901360941dbcf6
Author: Kevin Benton <ke...@benton.pub>
Date:   Mon Sep 11 15:20:45 2017 -0700

    Don't trigger DVR port update if status the same
    
    The DVR path was missing logic to avoid triggering DB updates
    even if the status was already correct. This was leading to a
    constant back-and-forth updating between the agent and the server
    effectively not changing anything but the updated_at timestamp
    and the revision_number.
    
    Closes-Bug: #1716522
    Change-Id: I88c678ac8a562db91c71edbc71dc43d1ada6c452


** Changed in: neutron
       Status: In Progress => Fix Released

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

Title:
  StaleDataError deleting router interface

Status in neutron:
  Fix Released

Bug description:
  Recently saw this error in the dvr-multinode grenade job:

  ERROR neutron.api.v2.resource [None req-efa49ab7-5bc4-49a4-9ede-e6f638f80004 
admin admin] remove_router_interface failed: No details.: StaleDataError: 
DELETE statement on table 'standardattributes' expected to delete 1 row(s); 0 
were matched.  Please set confirm_deleted_rows=False within the mapper 
configuration to prevent this warning.
  [...]
  INFO neutron.wsgi [None req-efa49ab7-5bc4-49a4-9ede-e6f638f80004 admin admin] 
10.210.34.251 "PUT 
/v2.0/routers/12dd139f-6d5f-437d-87bf-a75b6edf5125/remove_router_interface 
HTTP/1.1" status: 500  len: 363 time: 47.3295698

  http://logs.openstack.org/43/500143/4/check/gate-grenade-dsvm-neutron-
  dvr-multinode-ubuntu-xenial-
  nv/710e31d/logs/screen-q-svc.txt.gz#_Sep_11_19_16_23_495551

  I won't cut-paste the long backtrace.

  Kevin Benton looked and found the ML2 agent code on both agents was
  updating the port status once it received an update from the server,
  regardless if that status had changed, most likely triggering this
  error and filling both the q-agt and q-svc logs with lots of messages.

  https://review.openstack.org/#/c/502850/ test patch started.

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to