yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1708463] [NEW] neutron-db-manage upgrade heads returned 1

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Matthias Runge <1708463@xxxxxxxxxxxxxxxxxx>
Date: Thu, 03 Aug 2017 14:14:03 -0000
Reply-to: Bug 1708463 <1708463@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

I'm doing a fresh deployment, and it currently fails with

2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     packet.check_error()ESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check
_errorESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     err.raise_mysql_exception(self._data)ESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_e
xceptionESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     raise errorclass(errno, errval)ESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: oslo_db.exception.DBError: (pymysql.err.InternalError) (1050, u"Table 'standardattributes' already exists") [SQL: u'\nCREATE TABLE standardattributes (\n\tid BIGINT NOT NULL AUTO_INCREMENT, \n\tresource_type VARCHAR(255) NOT NULL, \n\tPRIMARY KEY (id)\n)ENGINE=InnoDB\n\n']ESC[0m
2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 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

The deployment is done with TripleO, I'm using CentOS 7.3, neutron
packages are:

python-neutron-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
openstack-neutron-ml2-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
openstack-neutron-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
openstack-neutron-openvswitch-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
puppet-neutron-11.2.1-0.20170728192630.342cc06.el7.centos.noarch
python-neutron-lib-1.9.1-0.20170725142825.0ef54c3.el7.centos.noarch
python2-neutronclient-6.4.0-0.20170728181502.3c211f3.el7.centos.noarch
openstack-neutron-common-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch

(the numbers are timestamps and git hashes from upstream)

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1708463

Title:
  neutron-db-manage  upgrade heads returned 1

Status in neutron:
  New

Bug description:
  I'm doing a fresh deployment, and it currently fails with

  2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     packet.check_error()ESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check
  _errorESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,236 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     err.raise_mysql_exception(self._data)ESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_e
  xceptionESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns:     raise errorclass(errno, errval)ESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 INFO: ESC[mNotice: /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: oslo_db.exception.DBError: (pymysql.err.InternalError) (1050, u"Table 'standardattributes' already exists") [SQL: u'\nCREATE TABLE standardattributes (\n\tid BIGINT NOT NULL AUTO_INCREMENT, \n\tresource_type VARCHAR(255) NOT NULL, \n\tPRIMARY KEY (id)\n)ENGINE=InnoDB\n\n']ESC[0m
  2017-08-03 11:22:02 | 2017-08-03 11:22:02,237 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

  The deployment is done with TripleO, I'm using CentOS 7.3, neutron
  packages are:

  python-neutron-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
  openstack-neutron-ml2-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
  openstack-neutron-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
  openstack-neutron-openvswitch-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch
  puppet-neutron-11.2.1-0.20170728192630.342cc06.el7.centos.noarch
  python-neutron-lib-1.9.1-0.20170725142825.0ef54c3.el7.centos.noarch
  python2-neutronclient-6.4.0-0.20170728181502.3c211f3.el7.centos.noarch
  openstack-neutron-common-11.0.0-0.20170731021410.63f4d77.el7.centos.noarch

  (the numbers are timestamps and git hashes from upstream)

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1708463/+subscriptions
Follow ups

[Bug 1708463] Re: neutron-db-manage upgrade heads returned 1
From: Matthias Runge, 2017-08-08