← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1729363] Re: udercloud deployment fails due to database table exists

 

Looking again, I found an earlier issue:

2017-11-01 13:34:23,197 INFO: + puppet apply --detailed-exitcodes /etc/puppet/manifests/puppet-stack-config.pp
2017-11-01 13:34:26,677 INFO: ESC[1;33mWarning: Facter: Fact resolution fact='systemd_internal_services', resolution='<anonymous>' resolved to an invalid value: Expected disabled to be one of [Integer, Float, Tr
ueClass, FalseClass, NilClass, String, Array, Hash], but was SymbolESC[0m
2017-11-01 13:34:26,699 INFO: ovs-vsctl: unix:/var/run/openvswitch/db.sock: database connection failed (No such file or directory)
2017-11-01 13:34:26,862 INFO: ESC[mNotice: hiera(): Cannot load backend module_data: cannot load such file -- hiera/backend/module_data_backendESC[0m
2017-11-01 13:34:26,942 INFO: ESC[1;33mWarning: ModuleLoader: module 'openstacklib' has unresolved dependencies - it will only see those that are resolved. Use 'puppet module list --tree' to see information abou
t modules
2017-11-01 13:34:26,942 INFO:    (file & line not available)ESC[0m
2017-11-01 13:34:27,158 INFO: ESC[mNotice: hiera(): Cannot load backend module_data: cannot load such file -- hiera/backend/module_data_backendESC[0m
2017-11-01 13:34:27,360 INFO: ESC[1;33mWarning: This method is deprecated, please use match expressions with Stdlib::Compat::Ipv6 instead. They are described at https://docs.puppet.com/puppet/latest/reference/la
ng_data_type.html#match-expressions. at ["/etc/puppet/modules/rabbitmq/manifests/install/rabbitmqadmin.pp", 37]:["/etc/puppet/modules/rabbitmq/manifests/init.pp", 314]
2017-11-01 13:34:27,360 INFO:    (at /etc/puppet/modules/stdlib/lib/puppet/functions/deprecation.rb:25:in `deprecation')ESC[0m
2017-11-01 13:34:27,479 INFO: ESC[mNotice: Scope(Class[Tripleo::Firewall::Post]): At this stage, all network traffic is blocked.ESC[0m
2017-11-01 13:34:27,571 INFO: ESC[1;33mWarning: This method is deprecated, please use the stdlib validate_legacy function, with Stdlib::Compat::Hash. There is further documentation for validate_legacy function i
n the README. at ["/etc/puppet/modules/tripleo/manifests/profile/base/database/mysql.pp", 97]:["/etc/puppet/manifests/puppet-stack-config.pp", 73]
2017-11-01 13:34:27,571 INFO:    (at /etc/puppet/modules/stdlib/lib/puppet/functions/deprecation.rb:25:in `deprecation')ESC[0m
2017-11-01 13:34:27,635 INFO: ESC[1;33mWarning: ModuleLoader: module 'mysql' has unresolved dependencies - it will only see those that are resolved. Use 'puppet module list --tree' to see information about modul
es
2017-11-01 13:34:27,635 INFO:    (file & line not available)ESC[0m
2017-11-01 13:34:27,825 INFO: ESC[1;33mWarning: ModuleLoader: module 'keystone' has unresolved dependencies - it will only see those that are resolved. Use 'puppet module list --tree' to see information about mo
dules
2017-11-01 13:34:27,825 INFO:    (file & line not available)ESC[0m
2017-11-01 13:34:28,194 INFO: ESC[1;33mWarning: This method is deprecated, please use the stdlib validate_legacy function, with Stdlib::Compat::String. There is further documentation for validate_legacy function
 in the README. at ["/etc/puppet/modules/keystone/manifests/db/mysql.pp", 63]:
2017-11-01 13:34:28,194 INFO:    (at /etc/puppet/modules/stdlib/lib/puppet/functions/deprecation.rb:25:in `deprecation')ESC[0m
2017-11-01 13:34:28,213 INFO: ESC[1;33mWarning: ModuleLoader: module 'glance' has unresolved dependencies - it will only see those that are resolved. Use 'puppet module list --tree' to see information about modules


With that, I believe it doesn't affect neutron anymore, it looks like a puppet issue.

** Changed in: neutron
       Status: New => Invalid

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

Title:
  udercloud deployment fails due to database table exists

Status in neutron:
  Invalid
Status in tripleo:
  New

Bug description:

  
  openstack-neutron-common-12.0.0-0.20171031133005.c4ab792.el7.centos.noarch
  openstack-tripleo-heat-templates-8.0.0-0.20171101050604.d6a2160.el7.centos.noarch

  
  I ran 
  bash devmode.sh --no-gate --ovb -d -w /var/tmp/tripleo_local

  It fails with this error:
  Wednesday 01 November 2017  14:34:04 +0100 (0:00:08.612)       1:01:58.659 **** 
  fatal: [undercloud]: FAILED! => {"changed": true, "cmd": "set -o pipefail && /home/stack/undercloud-install.sh 2>&1 | awk '{ print strftime(\"%Y-%m-%d %H:%M:%S |\"), $0; fflush(); }' > /home/stack/undercloud_install.log", "delta": "0:54:11.019567", "end": "2017-11-01 14:28:15.963100", "failed": true, "rc": 1, "start": "2017-11-01 13:34:04.943533", "stderr": "", "stdout": "", "stdout_lines": [], "warnings": []}

  PLAY RECAP *********************************************************************
  localhost                  : ok=28   changed=19   unreachable=0    failed=0   
  undercloud                 : ok=57   changed=34   unreachable=0    failed=1   

  
  Logs were not really helpful, pointing me at logs pointing to the same for more info.

  Finally:
  oslo_db.exception.DBError: (pymysql.err.InternalError) (1050, u"Table 'qos_policies_default' already exists") [SQL: u'\nCREATE TABLE qos_policies_default (\n\tqos_policy_id VARCHAR(36) NOT NULL, \n\tproject_id VARCHAR(255) NOT NULL, \n\tPRIMARY KEY (project_id), \n\tFOREIGN KEY(qos_policy_id) REFERENCES qos_policies (id) ON DELETE CASCADE\n)ENGINE=InnoDB\n\n']

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


References