I had to remove all mysql directory and files and reinstall it and after that the problem was solve. Then I tried to relaunch again the ansible install and it goes running until:
root@mickael-HP-ProDesk-600-G1-TWR:~/elijah-openstack/ansible# ansible-playbook -i ./hosts openstack-kilo.yaml --limit @/root/elijah-openstack/ansible/openstack-kilo.retry
PLAY [controller, compute] *****************************************************
TASK [setup] *******************************************************************
ok: [localhost]
TASK [openstack-common : (OS-COMMON) modify grub config to show text on boot] **
changed: [localhost]
TASK [openstack-common : (OS-COMMON) install Ubuntu-Cloud-Keyring] *************
ok: [localhost]
TASK [openstack-common : (OS-COMMON) add Kilo repo] ****************************
ok: [localhost]
TASK [openstack-common : (OS-COMMON) update cache and perform upgrade] *********
ok: [localhost]
TASK [openstack-common : (OS-COMMON) install python openstack client] **********
ok: [localhost] => (item=[u'python-openstackclient'])
PLAY [controller] **************************************************************
TASK [setup] *******************************************************************
ok: [localhost]
TASK [openstack-controller : (CONTROLLER) install mariadb and python lib] ******
changed: [localhost] => (item=[u'mariadb-server', u'python-mysqldb', u'python-pip'])
TASK [openstack-controller : pip] **********************************************
ok: [localhost]
TASK [openstack-controller : (CONTROLLER) run mysql installation] **************
changed: [localhost]
TASK [openstack-controller : (CONTROLLER) create mysql conf] *******************
changed: [localhost]
RUNNING HANDLER [openstack-controller : restart mysql] *************************
changed: [localhost]
TASK [openstack-controller : (CONTROLLER) install RabbitMQ] ********************
ok: [localhost]
TASK [openstack-controller : (CONTROLLER) check if openstack user already exists] ***
changed: [localhost]
TASK [openstack-controller : (CONTROLLER) create openstack rabbitmq user] ******
changed: [localhost]
TASK [openstack-controller : (CONTROLLER) set user perms] **********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) transfer keystonedb SQL script] ********
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) check if keystone db already exists] ***
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create keystone db] ********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) disable automatic startup of keystone] *
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) install keystone...] *******************
changed: [localhost] => (item=[u'keystone'])
TASK [openstack-controller : (KEYSTONE) install apache/memcached] *************
changed: [localhost] => (item=[u'apache2', u'libapache2-mod-wsgi', u'memcached', u'python-memcache'])
TASK [openstack-controller : (KEYSTONE) replace keystone conf] *****************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) populate identity service database] ****
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) replace servername in apache conf] *****
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create wsgi-keystone.conf] *************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) enable identity service virtual hosts] *
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create wsgi dir] ***********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) copy keystone wsgi components] *********
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) copy keystone wsgi components] *********
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) stop keystone service if running (it will restart with apache2)] ***
ok: [localhost]
TASK [openstack-controller : (KEYSTONE) remove SQLite] *************************
ok: [localhost]
RUNNING HANDLER [openstack-controller : restart apache] ************************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) wait 5s for keystone to come back up] **
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create identity service] ***************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create identity endpoint] **************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create admin project] ******************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create service project] ****************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create admin user] *********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create admin role] *********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create user role] **********************
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) add admin role to admin user] **********
changed: [localhost]
TASK [openstack-controller : (KEYSTONE) create OpenStack client script] ********
changed: [localhost]
TASK [openstack-controller : (GLANCE) transfer glancedb SQL script] ************
changed: [localhost]
TASK [openstack-controller : (GLANCE) check if glance db already exists] *******
changed: [localhost]
TASK [openstack-controller : (GLANCE) create glance db] ************************
changed: [localhost]
TASK [openstack-controller : (GLANCE) check if glance user already exists] *****
changed: [localhost]
TASK [openstack-controller : (GLANCE) create glance user] **********************
changed: [localhost]
TASK [openstack-controller : (GLANCE) check if glance user is admin in service project] ***
changed: [localhost]
TASK [openstack-controller : (GLANCE) add glance user to service project] ******
changed: [localhost]
TASK [openstack-controller : (GLANCE) check if glance service exists] **********
changed: [localhost]
TASK [openstack-controller : (GLANCE) create glance service entity] ************
changed: [localhost]
TASK [openstack-controller : (GLANCE) check if glance endpoint exists] *********
changed: [localhost]
TASK [openstack-controller : (GLANCE) create api endpoint] *********************
changed: [localhost]
TASK [openstack-controller : (GLANCE) install glance and associated packages] **
changed: [localhost] => (item=[u'glance', u'python-glanceclient'])
TASK [openstack-controller : (GLANCE) replace glance-api.conf] *****************
changed: [localhost]
TASK [openstack-controller : (GLANCE) replace glance-registry.conf] ************
changed: [localhost]
TASK [openstack-controller : (GLANCE) populate image service database] *********
changed: [localhost]
RUNNING HANDLER [openstack-controller : restart glance] ************************
changed: [localhost] => (item=glance-registry)
changed: [localhost] => (item=glance-api)
TASK [openstack-controller : (GLANCE) remove SQLite] ***************************
ok: [localhost]
TASK [openstack-controller : (NOVA) transfer novadb SQL script] ****************
changed: [localhost]
TASK [openstack-controller : (NOVA) check if nova db already exists] ***********
changed: [localhost]
TASK [openstack-controller : (NOVA) create nova db] ****************************
changed: [localhost]
TASK [openstack-controller : (NOVA) check if nova user already exists] *********
changed: [localhost]
TASK [openstack-controller : (NOVA) create nova user] **************************
changed: [localhost]
TASK [openstack-controller : (NOVA) check if nova user is admin in service project] ***
changed: [localhost]
TASK [openstack-controller : (NOVA) add nova user to service project] **********
changed: [localhost]
TASK [openstack-controller : (NOVA) check if nova service exists] **************
changed: [localhost]
TASK [openstack-controller : (NOVA) create nova service entity] ****************
changed: [localhost]
TASK [openstack-controller : (NOVA) check if nova endpoint exists] *************
changed: [localhost]
TASK [openstack-controller : (NOVA) create nova api endpoint] ******************
changed: [localhost]
TASK [openstack-controller : (NOVA) install nova-api and associated packages] **
changed: [localhost] => (item=[u'nova-api', u'nova-cert', u'nova-conductor', u'nova-consoleauth', u'nova-novncproxy', u'nova-scheduler', u'python-novaclient'])
TASK [openstack-controller : (NOVA) install nova-network] **********************
changed: [localhost] => (item=[u'nova-network'])
TASK [openstack-controller : (NOVA) replace nova.conf] *************************
changed: [localhost]
TASK [openstack-controller : (NOVA) replace api-paste.ini] *********************
changed: [localhost]
TASK [openstack-controller : (NOVA) replace rootwrap.conf] *********************
changed: [localhost]
TASK [openstack-controller : (NOVA) replace policy.json] ***********************
changed: [localhost]
TASK [openstack-controller : (NOVA) populate nova service database] ************
fatal: [localhost]: FAILED! => {"changed": true, "cmd": "/bin/sh -c 'nova-manage db sync' nova", "delta": "0:00:43.436821", "end": "2017-03-07 23:01:57.914250", "failed": true, "rc": 1, "start": "2017-03-07 23:01:14.477429", "stderr": "No handlers could be found for logger \"oslo_config.cfg\"\n2017-03-07 23:01:56.725 19712 CRITICAL nova [-] DBDuplicateEntry: (IntegrityError) (1062, \"Duplicate entry 'mickael-HP-ProDesk-600-G1-TWR-conductor-0' for key 'uniq_services0host0topic0deleted'\") 'ALTER TABLE services ADD CONSTRAINT uniq_services0host0topic0deleted UNIQUE (host, topic, deleted)' ()\n2017-03-07 23:01:56.725 19712 TRACE nova Traceback (most recent call last):\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/bin/nova-manage\", line 10, in \n2017-03-07 23:01:56.725 19712 TRACE nova sys.exit(main())\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/opt/stack/nova/nova/cmd/manage.py\", line 1382, in main\n2017-03-07 23:01:56.725 19712 TRACE nova ret = fn(fn_args, **fn_kwargs)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/opt/stack/nova/nova/cmd/manage.py\", line 912, in sync\n2017-03-07 23:01:56.725 19712 TRACE nova return migration.db_sync(version)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/opt/stack/nova/nova/db/migration.py\", line 26, in db_sync\n2017-03-07 23:01:56.725 19712 TRACE nova return IMPL.db_sync(version=version, database=database)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/opt/stack/nova/nova/db/sqlalchemy/migration.py\", line 57, in db_sync\n2017-03-07 23:01:56.725 19712 TRACE nova version)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py\", line 186, in upgrade\n2017-03-07 23:01:56.725 19712 TRACE nova return migrate(url, repository, version, upgrade=True, err=err, **opts)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"\", line 2, in _migrate\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py\", line 160, in withengine\n2017-03-07 23:01:56.725 19712 TRACE nova return f(a, *kw)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py\", line 366, in migrate\n2017-03-07 23:01:56.725 19712 TRACE nova schema.runchange(ver, change, changeset.step)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py\", line 93, in runchange\n2017-03-07 23:01:56.725 19712 TRACE nova change.run(self.engine, step)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py\", line 148, in run\n2017-03-07 23:01:56.725 19712 TRACE nova scriptfunc(engine)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/opt/stack/nova/nova/db/sqlalchemy/migrate_repo/versions/216_havana.py\", line 1173, in upgrade\n2017-03-07 23:01:56.725 19712 TRACE nova name='uniq_services0host0topic0deleted').create()\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/constraint.py\", line 44, in create\n2017-03-07 23:01:56.725 19712 TRACE nova self._doimports('constraintgenerator', *a, **kw)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/constraint.py\", line 32, in _doimports\n2017-03-07 23:01:56.725 19712 TRACE nova run_single_visitor(engine, visitorcallable, self, *a, **kw)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/databases/visitor.py\", line 85, in run_single_visitor\n2017-03-07 23:01:56.725 19712 TRACE nova fn(element, **kwargs)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/ansisql.py\", line 294, in visit_migrate_unique_constraint\n2017-03-07 23:01:56.725 19712 TRACE nova self.visitconstraint(p, **k)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/ansisql.py\", line 300, in visitconstraint\n2017-03-07 23:01:56.725 19712 TRACE nova self.execute()\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/migrate/changeset/ansisql.py\", line 44, in execute\n2017-03-07 23:01:56.725 19712 TRACE nova return self.connection.execute(self.buffer.getvalue())\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 721, in execute\n2017-03-07 23:01:56.725 19712 TRACE nova return self.executetext(object, multiparams, params)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 870, in executetext\n2017-03-07 23:01:56.725 19712 TRACE nova statement, parameters\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 958, in executecontext\n2017-03-07 23:01:56.725 19712 TRACE nova context)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/compat/handle_error.py\", line 261, in handledbapi_exception\n2017-03-07 23:01:56.725 19712 TRACE nova e, statement, parameters, cursor, context)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1156, in handledbapi_exception\n2017-03-07 23:01:56.725 19712 TRACE nova util.raise_from_cause(newraise, exc_info)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py\", line 199, in raise_from_cause\n2017-03-07 23:01:56.725 19712 TRACE nova reraise(type(exception), exception, tb=exc_tb)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 951, in executecontext\n2017-03-07 23:01:56.725 19712 TRACE nova context)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 436, in do_execute\n2017-03-07 23:01:56.725 19712 TRACE nova cursor.execute(statement, parameters)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 174, in execute\n2017-03-07 23:01:56.725 19712 TRACE nova self.errorhandler(self, exc, value)\n2017-03-07 23:01:56.725 19712 TRACE nova File \"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py\", line 36, in defaulterrorhandler\n2017-03-07 23:01:56.725 19712 TRACE nova raise errorclass, errorvalue\n2017-03-07 23:01:56.725 19712 TRACE nova DBDuplicateEntry: (IntegrityError) (1062, \"Duplicate entry 'mickael-HP-ProDesk-600-G1-TWR-conductor-0' for key 'uniq_services0host0topic0deleted'\") 'ALTER TABLE services ADD CONSTRAINT uniq_services0host0topic0deleted UNIQUE (host, topic, deleted)' ()\n2017-03-07 23:01:56.725 19712 TRACE nova ", "stdout": "Command failed, please check log for more info", "stdout_lines": ["Command failed, please check log for more info"], "warnings": []}
to retry, use: --limit @/root/elijah-openstack/ansible/openstack-kilo.retry
PLAY RECAP *********************************************************************
localhost : ok=77 changed=66 unreachable=0 failed=1