neutron

StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched.

Bug #1405379 reported by Ann Taraday
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Undecided
Ann Taraday
neutron 2015.1.0 "kilo"
Juno
Fix Released
Undecided
Unassigned
neutron 2014.2.2

Bug Description

For some reason sometimes at the same time for the same port delete_port and update_device_down commands have been executed. This arise StaleDataError in update_device_down. In other situations these commands are executed one after another and error does't appear.

neutron-server log with trace: http://paste.openstack.org/show/154358/

See original description
Ann Taraday (akamyshnikova)
Changed in neutron:
assignee: nobody → Ann Kamyshnikova (akamyshnikova)
Ann Taraday (akamyshnikova)
summary: - DBError: UPDATE statement on table 'ports' expected to update 1 row(s);
- 0 were matched
+ StaleDataError: UPDATE statement on table 'ports' expected to update 1
+ row(s); 0 were matched.
Ann Taraday (akamyshnikova)
description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (master)

Fix proposed to branch: master
Review: https://review.openstack.org/143826

Changed in neutron:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (master)

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

commit d9f3e46633b4a776d9c24a4e6e8ed61790ae790f
Author: Ann Kamyshnikova <email address hidden>
Date: Wed Dec 24 14:46:27 2014 +0300

    Catch StaleDataError in update_device_down

    For some reason sometimes at the same time for the same port
    delete_port and update_device_down commands have been executed.
    This arise StaleDataError in update_device_down. In other situations
    these commands are executed one after another and the error doesn't
    appear.

    This errors does not show anything broken, but to avoid confusion
    it will be skipped.

    Closes-bug: #1405379

    Change-Id: I4e5a3d1f1866b9cfba44d3cb7ccc5b2dee1d9633

Changed in neutron:
status: In Progress → Fix Committed
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron (stable/juno)

Fix proposed to branch: stable/juno
Review: https://review.openstack.org/148845

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/juno)

Reviewed: https://review.openstack.org/148845
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=88b73e63d07dfeb9609632d4cf5d50654e7a8570
Submitter: Jenkins
Branch: stable/juno

commit 88b73e63d07dfeb9609632d4cf5d50654e7a8570
Author: Ann Kamyshnikova <email address hidden>
Date: Wed Dec 24 14:46:27 2014 +0300

    Catch StaleDataError in update_device_down

    For some reason sometimes at the same time for the same port
    delete_port and update_device_down commands have been executed.
    This arise StaleDataError in update_device_down. In other situations
    these commands are executed one after another and the error doesn't
    appear.

    This errors does not show anything broken, but to avoid confusion
    it will be skipped.

    Closes-bug: #1405379

    Change-Id: I4e5a3d1f1866b9cfba44d3cb7ccc5b2dee1d9633
    (cherry picked from commit d9f3e46633b4a776d9c24a4e6e8ed61790ae790f)

tags: added: in-stable-juno
Thierry Carrez (ttx)
Changed in neutron:
milestone: none → kilo-2
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in neutron:
milestone: kilo-2 → 2015.1.0
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.