Bug 1434843

Summary: 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
Product: Red Hat OpenStack Reporter: Marius Cornea <mcornea>
Component: python-networking-bigswitchAssignee: mathieu bultel <mbultel>
Status: CLOSED ERRATA QA Contact: Marius Cornea <mcornea>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 11.0 (Ocata)CC: amuller, beagles, dbecker, jcoufal, jschluet, lhh, mbultel, mburns, morazi, rhel-osp-director-maint
Target Milestone: rc   
Target Release: 11.0 (Ocata)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
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 20:11:30 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1428976    
Attachments:
Description Flags
bigswitch trace none

Description Marius Cornea 2017-03-22 13:12:45 UTC 
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 16:45:01 UTC 
I believe this was fixed by u/s patch:

https://review.openstack.org/#/c/448262/
Comment 4 Nir Yechiel 2017-03-23 19:39:37 UTC 
*** Bug 1425432 has been marked as a duplicate of this bug. ***
Comment 5 Assaf Muller 2017-03-28 18:40:54 UTC 
*** Bug 1428976 has been marked as a duplicate of this bug. ***
Comment 7 errata-xmlrpc 2017-05-17 20:11:30 UTC 
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