Bug 1434843 – OSP10 -> OSP11 upgrade fails neutron-db-manage upgrade heads: oslo_db.exception.DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'upstream.tenant_id' in 'field list'") [SQL: 'UPDATE bsn_routerrules bsn INNER JOIN routers upstream ON bsn.router

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1434843 - OSP10 -> OSP11 upgrade fails neutron-db-manage upgrade heads: oslo_db.exception.DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'upstream.tenant_id' in 'field list'") [SQL: 'UPDATE bsn_routerrules bsn INNER JOIN routers upstream ON bsn.router

Summary:	OSP10 -> OSP11 upgrade fails neutron-db-manage upgrade heads: oslo_db.excepti...

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat OpenStack
Classification:	Red Hat
Component:	python-networking-bigswitch (Show other bugs)
Sub Component:
Version:	11.0 (Ocata)
Hardware:	Unspecified Unspecified

Priority	unspecified Severity urgent
Target Milestone:	rc
Target Release:	11.0 (Ocata)
Assigned To:	mathieu bultel
QA Contact:	Marius Cornea
Docs Contact:

URL:
Whiteboard:
Keywords:

Duplicates:	1425432 1428976 (view as bug list)
Depends On:
Blocks:	1428976
	Show dependency tree / graph

Reported:	2017-03-22 09:12 EDT by Marius Cornea
Modified:	2017-05-17 16:11 EDT (History)
CC List:	10 users (show)

See Also:
Fixed In Version:	python-networking-bigswitch-10.0.1-2.el7ost
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2017-05-17 16:11:30 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
bigswitch trace (5.12 KB, text/plain) 2017-03-22 09:12 EDT, Marius Cornea	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
OpenStack gerrit	448262	None	None	None	2017-03-22 12:45 EDT
Red Hat Product Errata	RHEA-2017:1245	normal	SHIPPED_LIVE	Red Hat OpenStack Platform 11.0 Bug Fix and Enhancement Advisory	2017-05-17 19:01:50 EDT

Groups: None (edit)

Description Marius Cornea 2017-03-22 09:12:45 EDT

Created attachment 1265400 [details]
bigswitch trace

Description of problem:
OSP10 -> OSP11 upgrade fails neutron-db-manage upgrade heads: oslo_db.exception.DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'upstream.tenant_id' in 'field list'") [SQL: 'UPDATE bsn_routerrules bsn INNER JOIN routers upstream ON bsn.router

Version-Release number of selected component (if applicable):
openstack-neutron-bigswitch-lldp-10.0.1-0.20170310222150.2a3fa5d.el7ost.noarch
openstack-neutron-bigswitch-agent-10.0.1-0.20170310222150.2a3fa5d.el7ost.noarch
python-networking-bigswitch-10.0.1-0.20170310222150.2a3fa5d.el7ost.noarch

How reproducible:
100%

Steps to Reproduce:
1. Upgrade OSP10 to OSP11

Actual results:
Upgrade fails during neutron-db-manage  upgrade heads.

Expected results:

Additional info:
Attaching full trace.

Comment 1 Brent Eagles 2017-03-22 12:45:01 EDT

I believe this was fixed by u/s patch:

https://review.openstack.org/#/c/448262/

Comment 4 Nir Yechiel 2017-03-23 15:39:37 EDT

*** Bug 1425432 has been marked as a duplicate of this bug. ***

Comment 5 Assaf Muller 2017-03-28 14:40:54 EDT

*** Bug 1428976 has been marked as a duplicate of this bug. ***

Comment 7 errata-xmlrpc 2017-05-17 16:11:30 EDT

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHEA-2017:1245

Note You need to log in before you can comment on or make changes to this bug.