l3 db operations failed in multiple transactions

Bug #1070335 reported by yong sheng gong
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Fix Released
Undecided
yong sheng gong
Folsom
Fix Released
Medium
Gary Kotton
quantum (Ubuntu)
Fix Released
Undecided
Unassigned
Precise
Won't Fix
Undecided
Unassigned
Quantal
Fix Released
Undecided
Unassigned

Bug Description

gongysh@gongysh-laptop:~$ quantum router-gateway-set de58dce9-d8cd-4398-b00e-c3bdc058b77c pubnet2
Set gateway for router de58dce9-d8cd-4398-b00e-c3bdc058b77c
gongysh@gongysh-laptop:~$ quantum router-gateway-set de58dce9-d8cd-4398-b00e-c3bdc058b77c pubnet1
Request Failed: internal server error while processing your request.

SERVER traceBACK is:
Traceback (most recent call last):
  File "/home/gongysh/git/quantum/quantum/api/v2/resource.py", line 95, in resource
    result = method(request=request, **args)
  File "/home/gongysh/git/quantum/quantum/api/v2/base.py", line 397, in update
    obj = obj_updater(request.context, id, **kwargs)
  File "/home/gongysh/git/quantum/quantum/db/l3_db.py", line 168, in update_router
    self._update_router_gw_info(context, id, gw_info)
  File "/home/gongysh/git/quantum/quantum/db/l3_db.py", line 220, in _update_router_gw_info
    context.session.add(router)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1252, in add
    self._save_or_update_state(state)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1268, in _save_or_update_state
    self._save_or_update_impl(st_)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1493, in _save_or_update_impl
    self._update_impl(state)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1483, in _update_impl
    mapperutil.state_str(state)
InvalidRequestError: Instance '<Port at 0x2f072d0>' has been deleted. Use the make_transient() function to send this object back to the transient state.

Gary Kotton (garyk)
tags: added: folsom-backport-potential
Changed in quantum:
assignee: nobody → yong sheng gong (gongysh)
milestone: none → grizzly-1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to quantum (master)

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

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

Reviewed: https://review.openstack.org/14739
Committed: http://github.com/openstack/quantum/commit/90f60060ee3d8559a3ab3f50f49a9dcda7399d68
Submitter: Jenkins
Branch: master

commit 90f60060ee3d8559a3ab3f50f49a9dcda7399d68
Author: gongysh <email address hidden>
Date: Wed Oct 24 16:13:09 2012 +0800

    Delete the child object via setting the parent's attribute to None.

    Bug #1070335

    We should not operate the foreigh key attribute of parent attribute
    directly.

    Change-Id: I98dc8eae78fdf67f0e7189e73afba77c6affcc0e

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

Fix proposed to branch: stable/folsom
Review: https://review.openstack.org/15332

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

Reviewed: https://review.openstack.org/15332
Committed: http://github.com/openstack/quantum/commit/63b81f648ea207d2618e4b48533c59f6d58184f8
Submitter: Jenkins
Branch: stable/folsom

commit 63b81f648ea207d2618e4b48533c59f6d58184f8
Author: gongysh <email address hidden>
Date: Wed Oct 24 16:13:09 2012 +0800

    Delete the child object via setting the parent's attribute to None.

    Bug #1070335

    We should not operate the foreigh key attribute of parent attribute
    directly.

    Change-Id: I98dc8eae78fdf67f0e7189e73afba77c6affcc0e

tags: added: in-stable-folsom
Gary Kotton (garyk)
tags: removed: folsom-backport-potential
Chuck Short (zulcss)
Changed in quantum (Ubuntu):
status: New → Fix Released
Changed in quantum (Ubuntu Precise):
status: New → Confirmed
Thierry Carrez (ttx)
Changed in quantum:
status: Fix Committed → Fix Released
Changed in quantum (Ubuntu Quantal):
status: New → Confirmed
Revision history for this message
Clint Byrum (clint-fewbar) wrote : Please test proposed package

Hello yong, or anyone else affected,

Accepted quantum into quantal-proposed. The package will build now and be available at http://launchpad.net/ubuntu/+source/quantum/2012.2.1-0ubuntu1 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

Changed in quantum (Ubuntu Quantal):
status: Confirmed → Fix Committed
tags: added: verification-needed
Mark McLoughlin (markmc)
tags: removed: in-stable-folsom
Revision history for this message
Launchpad Janitor (janitor) wrote :
Download full text (3.8 KiB)

This bug was fixed in the package quantum - 2012.2.1-0ubuntu1

---------------
quantum (2012.2.1-0ubuntu1) quantal-proposed; urgency=low

  * Resynchronize with stable/folsom (1e774867) (LP: #1085255):
    - [aeabb42] There are routing problems when the dnsmasq port does not come
      first in the routing table (LP: #1083238)
    - [04aab72] Quantum linux bridge not optimized with libvirt (LP: #1078210)
    - [ca7fc10] getting quotas from database has severe performance implications
      (LP: #1075369)
    - [66605e8] failed to update an external network into non external network
      (LP: #1083387)
    - [c60051a] Quantum test suite leaks memory like a sieve (LP: #1065276)
    - [3179dfc] clear_db() does incomplete db teardown (LP: #1080988)
    - [c1e19d7] Unauthorized command: cat /proc/None/cmdline (LP: #1077651)
    - [af9e076] At times a instance will not receive an IP address from the DHCP
      agent (LP: #1081664)
    - [e0d1a7d] allow multiple floating-ip on single port if they use different
      fixed ips and/or external nets (LP: #1057844)
    - [8471d79] Delete port fails to gateway ip (LP: #1079980)
    - [aca8b4a] fixed_ip allocation which is not included within
      allocation_pools makes error when delete port or re-create port
      (LP: #1077292)
    - [eacc9d3] Mapping same bridge to different phyiscal networks succeed
      (LP: #1067669)
    - [51b4c82] python-quantum: not region aware (LP: #1080793)
    - [6f0a486] delete floatingip should be in one transaction to delete port
      (LP: #1080516)
    - [db6cda7] Remove qpid configuration variables no longer supported
    - [a112840] Allow NVP plugin to use per-tenant quota extension
    - [82b1a55] Quantum service does not restart after reboot (LP: #1073999)
    - [c01a839] There are some cases that L3 API with an invalid parameter
      returns 500. (LP: #1064765)
    - [26b383f] external network can be plugged also as internal network for one
      router (LP: #1053633)
    - [49f649c] There is a lot of cases that API with an invalid parameter
      returns 500. (LP: #1062046)
    - [4546a18] When create subnet, you con set up the value as cidr (the value
      isn't cidr form). (LP: #1067959)
    - [9ba453a] killfilter should handle updated/deleted executables
      (LP: #1073768)
    - [7c8a55c] a port which is not able to delete is made when floatingip
      create fails. (LP: #1064748)
    - [c9b84cf] Linux bridge port update causes exception (LP: #1072713)
    - [cb57932] I can't add interface to router, if there is another port in
      non-shared network of other tenant (LP: #1057558)
    - [574e278] Ryu plugin does not support Security Groups (LP: #1059393)
    - [607f486] tap device added to integration bridge without tag
      (LP: #1064070)
    - [21a0fdf] L3 agent external network flag (LP: #1056720)
    - [5cbaff4] router create with external_gateway_info fails with 500 always.
      (LP: #1064235)
    - [63b81f6] l3 db operations failed in multiple transactions (LP: #1070335)
    - [bff17fb] Ensure that the SqlSoup import is still supported.
    - [e091a29] l3_nat_agent was renamed to l3_agent
    - [9030969] remove default value of 'local_ip' of 10...

Read more...

Changed in quantum (Ubuntu Quantal):
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in quantum:
milestone: grizzly-1 → 2013.1
Revision history for this message
Steve Langasek (vorlon) wrote :

The Precise Pangolin has reached end of life, so this bug will not be fixed for that release

Changed in quantum (Ubuntu Precise):
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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