+++ 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.
Comment 1Red Hat Bugzilla Rules Engine
2017-03-03 18:16:14 UTC
This bugzilla has been removed from the release and needs to be reviewed and Triaged for another Target Release.
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.