+++ This bug was initially created as a clone of Bug #1425432 +++ Description of problem: OSP10 -> OSP11 upgrade fails during neutron-db-manage upgrade heads: oslo_db.exception.DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'tenant_id'") [SQL: u'ALTER TABLE bsn_routerrules ADD COLUMN tenant_id VARCHAR(255)'] Version-Release number of selected component (if applicable): python-networking-bigswitch-10.0.0-0.20170211205641.584bf2d.el7ost.noarch openstack-neutron-bigswitch-agent-10.0.0-0.20170211205641.584bf2d.el7ost.noarch openstack-neutron-bigswitch-lldp-10.0.0-0.20170211205641.584bf2d.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. --- Additional comment from Assaf Muller on 2017-03-02 06:19:51 EST --- Looking at the u/s Launchpad it's unclear to me if the issue was resolved or not. Any ideas? --- Additional comment from Marius Cornea on 2017-03-02 08:59:31 EST --- (In reply to Assaf Muller from comment #1) > Looking at the u/s Launchpad it's unclear to me if the issue was resolved or > not. Any ideas? FWIW the issue is still present in the latest downstream build. --- Additional comment from Brent Eagles on 2017-03-03 09:37:48 EST --- @Marius can you spec the version of the packages in the lastest build? I'm trying to work out if we have the u/s patch that was supposed to fix this or not. --- Additional comment from Marius Cornea on 2017-03-03 09:48:49 EST --- (In reply to Brent Eagles from comment #3) > @Marius can you spec the version of the packages in the lastest build? I'm > trying to work out if we have the u/s patch that was supposed to fix this or > not. openstack-neutron-bigswitch-agent-10.0.0-0.20170224232203.1f1208d.el7ost.noarch.rpm openstack-neutron-bigswitch-lldp-10.0.0-0.20170224232203.1f1208d.el7ost.noarch.rpm python-networking-bigswitch-10.0.0-0.20170224232203.1f1208d.el7ost.noarch.rpm --- Additional comment from Brent Eagles on 2017-03-03 10:38:44 EST --- Unless I'm missing something, comparing with the u/s bug referenced here with the initial comment, these look like two (or more?) different issues. The one reported u/s is to do with an args mismatch on a decorator - this one is a duplicate field issue. Which is still occurring, the reported u/s issue, the one referenced later in comment 5 in the launchpad bug, or the original one for this bug report? --- Additional comment from Marius Cornea on 2017-03-03 10:43:30 EST --- (In reply to Brent Eagles from comment #5) > Unless I'm missing something, comparing with the u/s bug referenced here > with the initial comment, these look like two (or more?) different issues. > The one reported u/s is to do with an args mismatch on a decorator - this > one is a duplicate field issue. Which is still occurring, the reported u/s > issue, the one referenced later in comment 5 in the launchpad bug, or the > original one for this bug report? Sorry, I missed the details but it seems they are different issues. The issue that I see with the downstream testing is the one in the trace attached to this report. --- Additional comment from Brent Eagles on 2017-03-03 13:13:32 EST --- I've linked a more closely matched bug - same error actually. This should probably also be moved to the python-networking-bigswitch component.
This bugzilla has been removed from the release and needs to be reviewed and Triaged for another Target Release.
This is blocking OSP 11 CI.
This issue has been identified and prioritized at our end. We are working on posting a fix asap.
A tagged release for this and another couple of other bugs has been released. The latest version available (pypi uploaded) is: stable/newton: 9.40.4 stable/ocata: 10.0.3 Please give the triple-o CI another tug and let us know if this is still an issue.
*** This bug has been marked as a duplicate of bug 1434843 ***