undercloud does not deploy due to "duplicate column" in database

Bug #1718611 reported by Matthias Runge
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Expired
Undecided
Unassigned
tripleo
Expired
Undecided
Unassigned

Bug Description

during undercloud install:

2017-09-21 08:30:36 | 2017-09-21 08:30:36,280 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: oslo_db.exception.DBError: (pymysql.err.InternalError) (1060, u"Duplicate column name 'ip_allocation'") [SQL: u'ALTER TABLE ports ADD COLUMN ip_allocation VARCHAR(16)']ESC[0m
2017-09-21 08:30:36 | 2017-09-21 08:30:36,280 INFO: ESC[1;31mError: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: Failed to call refresh: neutron-db-manage upgrade heads returned 1 instead of one of [0]ESC[0m

Neutron package is this one: openstack-neutron-11.0.0-0.20170909033636.d32d51d.el7.centos.noarch

Saravanan KR (skramaja)
Changed in tripleo:
importance: Undecided → High
milestone: none → queens-1
Changed in tripleo:
status: New → Triaged
Revision history for this message
Boden R (boden) wrote :

Can you please provide addition information from a neutron perspective?
For example how can we reproduce this?
What operating system?
What branch?

Changed in neutron:
status: New → Incomplete
Revision history for this message
Matthias Runge (mrunge) wrote :

iirc, this was triggered by neutron-db-manage

Operating system was CentOS 7, the package used was a build from Sep 9, 2017 based on a master snapshot (git hash d32d51d).

The environment is long gone now.

Changed in tripleo:
milestone: queens-1 → queens-2
Changed in tripleo:
milestone: queens-2 → queens-3
Changed in tripleo:
milestone: queens-3 → queens-rc1
Changed in tripleo:
milestone: queens-rc1 → rocky-1
Changed in tripleo:
milestone: rocky-1 → rocky-2
Changed in tripleo:
milestone: rocky-2 → rocky-3
Changed in tripleo:
milestone: rocky-3 → rocky-rc1
Changed in tripleo:
milestone: rocky-rc1 → stein-1
Matthias Runge (mrunge)
Changed in tripleo:
status: Triaged → Incomplete
importance: High → Undecided
milestone: stein-1 → none
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for tripleo because there has been no activity for 60 days.]

Changed in tripleo:
status: Incomplete → Expired
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for neutron because there has been no activity for 60 days.]

Changed in neutron:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.