l3 db operations failed in multiple transactions

Bug #1070335 reported by yong sheng gong on 2012-10-23
This bug affects 1 person
Affects Status Importance Assigned to Milestone
yong sheng gong
Gary Kotton
quantum (Ubuntu)

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
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1252, in add
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1268, in _save_or_update_state
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1493, in _save_or_update_impl
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1483, in _update_impl
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) on 2012-10-23
tags: added: folsom-backport-potential
Changed in quantum:
assignee: nobody → yong sheng gong (gongysh)
milestone: none → grizzly-1

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

Changed in quantum:
status: New → In Progress

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

    Change-Id: I98dc8eae78fdf67f0e7189e73afba77c6affcc0e

Changed in quantum:
status: In Progress → Fix Committed

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

    Change-Id: I98dc8eae78fdf67f0e7189e73afba77c6affcc0e

tags: added: in-stable-folsom
Gary Kotton (garyk) on 2012-11-06
tags: removed: folsom-backport-potential
Chuck Short (zulcss) on 2012-11-06
Changed in quantum (Ubuntu):
status: New → Fix Released
Changed in quantum (Ubuntu Precise):
status: New → Confirmed
Thierry Carrez (ttx) on 2012-11-21
Changed in quantum:
status: Fix Committed → Fix Released
Changed in quantum (Ubuntu Quantal):
status: New → Confirmed

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) on 2013-01-22
tags: removed: in-stable-folsom
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...


Changed in quantum (Ubuntu Quantal):
status: Fix Committed → Fix Released
Thierry Carrez (ttx) on 2013-04-04
Changed in quantum:
milestone: grizzly-1 → 2013.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers