I reproduced this bug in both MOS 7.0 and MOS 8.0 deployment (Ubuntu).
The following is MOS 8.0 log. ======================= 2016-03-06 01:50:40 ERR (/Stage[main]/Keystone::Db::Mysql/Openstacklib::Db::Mysql[keystone]/Openstacklib::Db::Mysql::Host_access[keystone_CTRNODE03]/Database_user[keystone@CTRNODE03]/ensure) change from absent to present failed: Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf mysql -e create user 'keystone'@'CTRNODE03' identified by PASSWORD '*XXXXXXXXXXXXXXXXXXXXXXXXX'' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'keystone'@'CTRNODE03' 2016-03-06 01:50:40 ERR /usr/bin/puppet:8:in `<main>' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util/command_line.rb:92:in `execute' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util/command_line.rb:146:in `run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:496:in `exit_on_fail' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `block in run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:507:in `plugin_hook' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application.rb:381:in `block (2 levels) in run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:159:in `run_command' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:198:in `main' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet.rb:244:in `override' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/context.rb:64:in `override' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:236:in `block in main' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/application/apply.rb:302:in `apply_catalog' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/configurer.rb:133:in `run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet.rb:244:in `override' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/context.rb:64:in `override' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/configurer.rb:134:in `block in run' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/configurer.rb:227:in `run_internal' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/configurer.rb:119:in `apply_catalog' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:160:in `benchmark' 2016-03-06 01:50:40 ERR /usr/lib/ruby/1.9.1/benchmark.rb:295:in `realtime' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:161:in `block in benchmark' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/configurer.rb:120:in `block in apply_catalog' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:168:in `apply' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction/report.rb:112:in `as_logging_destination' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util/log.rb:149:in `with_destination' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/resource/catalog.rb:169:in `block in apply' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:138:in `evaluate' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/graph/relationship_graph.rb:118:in `traverse' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:147:in `block in evaluate' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:334:in `thinmark' 2016-03-06 01:50:40 ERR /usr/lib/ruby/1.9.1/benchmark.rb:295:in `realtime' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util.rb:335:in `block in thinmark' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:147:in `block (2 levels) in evaluate' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:147:in `call' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:217:in `eval_resource' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction.rb:204:in `apply' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction/resource_harness.rb:20:in `evaluate' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction/resource_harness.rb:81:in `perform_changes' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction/resource_harness.rb:128:in `sync_if_needed' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/transaction/resource_harness.rb:204:in `sync' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/property.rb:581:in `sync' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/property.rb:498:in `set' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/property.rb:197:in `call_valuemethod' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/property/ensure.rb:16:in `block in defaultvalues' 2016-03-06 01:50:40 ERR /etc/puppet/modules/mysql/lib/puppet/provider/database_user/mysql.rb:31:in `create' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/provider.rb:463:in `block in create_class_and_instance_method' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/provider.rb:237:in `block in has_command' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/provider/command.rb:23:in `execute' 2016-03-06 01:50:40 ERR /usr/lib/ruby/vendor_ruby/puppet/util/execution.rb:219:in `execute' 2016-03-06 01:50:40 ERR Execution of '/usr/bin/mysql --defaults-extra-file=/root/.my.cnf mysql -e create user 'keystone'@'CTRNODE03' identified by PASSWORD '*XXXXXXXXXXXXXXXXXXXXXXXXX'' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'keystone'@'CTRNODE03' =======================
I reproduced this bug in both MOS 7.0 and MOS 8.0 deployment (Ubuntu).
The following is MOS 8.0 log. ======= ======= == main]/Keystone: :Db::Mysql/ Openstacklib: :Db::Mysql[ keystone] /Openstacklib: :Db::Mysql: :Host_access[ keystone_ CTRNODE03] /Database_ user[keystone@ CTRNODE03] /ensure) change from absent to present failed: Execution of '/usr/bin/mysql --defaults- extra-file= /root/. my.cnf mysql -e create user 'keystone' @'CTRNODE03' identified by PASSWORD '*XXXXXXXXXXXXX XXXXXXXXXXXX' ' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'keystone' @'CTRNODE03' puppet: 8:in `<main>' ruby/vendor_ ruby/puppet/ util/command_ line.rb: 92:in `execute' ruby/vendor_ ruby/puppet/ util/command_ line.rb: 146:in `run' ruby/vendor_ ruby/puppet/ application. rb:381: in `run' ruby/vendor_ ruby/puppet/ util.rb: 496:in `exit_on_fail' ruby/vendor_ ruby/puppet/ application. rb:381: in `block in run' ruby/vendor_ ruby/puppet/ application. rb:507: in `plugin_hook' ruby/vendor_ ruby/puppet/ application. rb:381: in `block (2 levels) in run' ruby/vendor_ ruby/puppet/ application/ apply.rb: 159:in `run_command' ruby/vendor_ ruby/puppet/ application/ apply.rb: 198:in `main' ruby/vendor_ ruby/puppet. rb:244: in `override' ruby/vendor_ ruby/puppet/ context. rb:64:in `override' ruby/vendor_ ruby/puppet/ application/ apply.rb: 236:in `block in main' ruby/vendor_ ruby/puppet/ application/ apply.rb: 302:in `apply_catalog' ruby/vendor_ ruby/puppet/ configurer. rb:133: in `run' ruby/vendor_ ruby/puppet. rb:244: in `override' ruby/vendor_ ruby/puppet/ context. rb:64:in `override' ruby/vendor_ ruby/puppet/ configurer. rb:134: in `block in run' ruby/vendor_ ruby/puppet/ configurer. rb:227: in `run_internal' ruby/vendor_ ruby/puppet/ configurer. rb:119: in `apply_catalog' ruby/vendor_ ruby/puppet/ util.rb: 160:in `benchmark' ruby/1. 9.1/benchmark. rb:295: in `realtime' ruby/vendor_ ruby/puppet/ util.rb: 161:in `block in benchmark' ruby/vendor_ ruby/puppet/ configurer. rb:120: in `block in apply_catalog' ruby/vendor_ ruby/puppet/ resource/ catalog. rb:168: in `apply' ruby/vendor_ ruby/puppet/ transaction/ report. rb:112: in `as_logging_ destination' ruby/vendor_ ruby/puppet/ util/log. rb:149: in `with_destination' ruby/vendor_ ruby/puppet/ resource/ catalog. rb:169: in `block in apply' ruby/vendor_ ruby/puppet/ transaction. rb:138: in `evaluate' ruby/vendor_ ruby/puppet/ graph/relations hip_graph. rb:118: in `traverse' ruby/vendor_ ruby/puppet/ transaction. rb:147: in `block in evaluate' ruby/vendor_ ruby/puppet/ util.rb: 334:in `thinmark' ruby/1. 9.1/benchmark. rb:295: in `realtime' ruby/vendor_ ruby/puppet/ util.rb: 335:in `block in thinmark' ruby/vendor_ ruby/puppet/ transaction. rb:147: in `block (2 levels) in evaluate' ruby/vendor_ ruby/puppet/ transaction. rb:147: in `call' ruby/vendor_ ruby/puppet/ transaction. rb:217: in `eval_resource' ruby/vendor_ ruby/puppet/ transaction. rb:204: in `apply' ruby/vendor_ ruby/puppet/ transaction/ resource_ harness. rb:20:in `evaluate' ruby/vendor_ ruby/puppet/ transaction/ resource_ harness. rb:81:in `perform_changes' ruby/vendor_ ruby/puppet/ transaction/ resource_ harness. rb:128: in `sync_if_needed' ruby/vendor_ ruby/puppet/ transaction/ resource_ harness. rb:204: in `sync' ruby/vendor_ ruby/puppet/ property. rb:581: in `sync' ruby/vendor_ ruby/puppet/ property. rb:498: in `set' ruby/vendor_ ruby/puppet/ property. rb:197: in `call_valuemethod' ruby/vendor_ ruby/puppet/ property/ ensure. rb:16:in `block in defaultvalues' modules/ mysql/lib/ puppet/ provider/ database_ user/mysql. rb:31:in `create' ruby/vendor_ ruby/puppet/ provider. rb:463: in `block in create_ class_and_ instance_ method' ruby/vendor_ ruby/puppet/ provider. rb:237: in `block in has_command' ruby/vendor_ ruby/puppet/ provider/ command. rb:23:in `execute' ruby/vendor_ ruby/puppet/ util/execution. rb:219: in `execute' extra-file= /root/. my.cnf mysql -e create user 'keystone' @'CTRNODE03' identified by PASSWORD '*XXXXXXXXXXXXX XXXXXXXXXXXX' ' returned 1: ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'keystone' @'CTRNODE03' ======= ======= ==
=======
2016-03-06 01:50:40 ERR (/Stage[
2016-03-06 01:50:40 ERR /usr/bin/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /etc/puppet/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR /usr/lib/
2016-03-06 01:50:40 ERR Execution of '/usr/bin/mysql --defaults-
=======