2017-11-08 09:10:52,066 [salt.cli.daemons ][WARNING ][906] IMPORTANT: Do not use md5 hashing algorithm! Please set "hash_type" to sha256 in Salt Minion config!
2017-11-08 09:11:35,591 [salt.state       ][ERROR   ][1086] No contents found in top file
2017-11-08 09:11:42,760 [py.warnings      ][WARNING ][1214] /usr/lib/python2.7/dist-packages/salt/utils/templates.py:73: DeprecationWarning: Starting in 2015.5, cmd.run uses python_shell=False by default, which doesn't support shellisms (pipes, env variables, etc). cmd.run is currently aliased to cmd.shell to prevent breakage. Please switch to cmd.shell or set python_shell=True to avoid breakage in the future, when this aliasing is removed.

2017-11-08 09:13:59,362 [salt.loaded.int.module.cmdmod][ERROR   ][1214] Command 'while true; do salt-call saltutil.running|grep fun: && continue; salt-call --local service.restart salt-minion; break; done' failed with return code: None
2017-11-08 09:16:21,261 [salt.loaded.int.module.cmdmod][INFO    ][17235] Executing command ['systemctl', 'status', 'salt-minion.service', '-n', '0'] in directory '/root'
2017-11-08 09:16:21,268 [salt.loaded.int.module.cmdmod][INFO    ][17235] Executing command ['systemctl', 'is-enabled', 'salt-minion.service'] in directory '/root'
2017-11-08 09:16:21,276 [salt.loaded.int.module.cmdmod][INFO    ][17235] Executing command ['systemd-run', '--scope', 'systemctl', 'restart', 'salt-minion.service'] in directory '/root'
2017-11-08 09:16:21,296 [salt.utils.parsers][WARNING ][906] Minion received a SIGTERM. Exiting.
2017-11-08 09:16:21,546 [salt.cli.daemons ][INFO    ][17304] Setting up the Salt Minion "dbs01.baremetal-mcp-ocata-odl-ha.local"
2017-11-08 09:16:21,834 [salt.minion      ][INFO    ][17304] Creating minion process manager
2017-11-08 09:16:21,835 [salt.cli.daemons ][WARNING ][17304] IMPORTANT: Do not use md5 hashing algorithm! Please set "hash_type" to sha256 in Salt Minion config!
2017-11-08 09:16:21,835 [salt.cli.daemons ][INFO    ][17304] The Salt Minion is starting up
2017-11-08 09:16:21,835 [salt.minion      ][INFO    ][17304] Minion is starting as user 'root'
2017-11-08 09:16:21,836 [salt.utils.event ][INFO    ][17304] Starting pull socket on /var/run/salt/minion/minion_event_ccd5d6347c_pull.ipc
2017-11-08 09:16:22,551 [salt.loaded.int.module.cmdmod][INFO    ][17304] Executing command ['date', '+%z'] in directory '/root'
2017-11-08 09:16:22,559 [salt.utils.schedule][INFO    ][17304] Updating job settings for scheduled job: __mine_interval
2017-11-08 09:16:22,561 [salt.minion      ][INFO    ][17304] Added mine.update to scheduler
2017-11-08 09:16:22,618 [salt.minion      ][INFO    ][17304] Minion is ready to receive requests!
2017-11-08 09:16:23,620 [salt.utils.schedule][INFO    ][17304] Running scheduled job: __mine_interval
2017-11-08 09:16:47,692 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command ssh.set_auth_key with jid 20171108091647670948
2017-11-08 09:16:47,713 [salt.minion      ][INFO    ][17421] Starting a new job with PID 17421
2017-11-08 09:16:47,725 [salt.minion      ][INFO    ][17421] Returning information for job: 20171108091647670948
2017-11-08 09:35:15,512 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command test.ping with jid 20171108093515505067
2017-11-08 09:35:15,540 [salt.minion      ][INFO    ][18241] Starting a new job with PID 18241
2017-11-08 09:35:15,565 [salt.minion      ][INFO    ][18241] Returning information for job: 20171108093515505067
2017-11-08 09:35:43,974 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command state.sls with jid 20171108093543968650
2017-11-08 09:35:43,987 [salt.minion      ][INFO    ][18251] Starting a new job with PID 18251
2017-11-08 09:35:45,646 [salt.state       ][INFO    ][18251] Loading fresh modules for state activity
2017-11-08 09:35:45,673 [salt.fileclient  ][INFO    ][18251] Fetching file from saltenv 'base', ** done ** 'keepalived/init.sls'
2017-11-08 09:35:45,691 [salt.fileclient  ][INFO    ][18251] Fetching file from saltenv 'base', ** done ** 'keepalived/cluster.sls'
2017-11-08 09:35:45,716 [salt.fileclient  ][INFO    ][18251] Fetching file from saltenv 'base', ** done ** 'keepalived/map.jinja'
2017-11-08 09:35:45,989 [salt.state       ][INFO    ][18251] Running state [lsof] at time 09:35:45.988745
2017-11-08 09:35:45,989 [salt.state       ][INFO    ][18251] Executing state pkg.installed for lsof
2017-11-08 09:35:45,990 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:35:46,393 [salt.state       ][INFO    ][18251] Package lsof is already installed
2017-11-08 09:35:46,393 [salt.state       ][INFO    ][18251] Completed state [lsof] at time 09:35:46.393159 duration_in_ms=404.414
2017-11-08 09:35:46,394 [salt.state       ][INFO    ][18251] Running state [keepalived] at time 09:35:46.393523
2017-11-08 09:35:46,394 [salt.state       ][INFO    ][18251] Executing state pkg.installed for keepalived
2017-11-08 09:35:46,407 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:35:48,796 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'keepalived'] in directory '/root'
2017-11-08 09:35:54,021 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108093554013989
2017-11-08 09:35:54,035 [salt.minion      ][INFO    ][18924] Starting a new job with PID 18924
2017-11-08 09:35:54,043 [salt.minion      ][INFO    ][18924] Returning information for job: 20171108093554013989
2017-11-08 09:35:59,262 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:35:59,279 [salt.state       ][INFO    ][18251] Made the following changes:
'libsnmp30' changed from 'absent' to '5.7.3+dfsg-1ubuntu4'
'libsnmp-base' changed from 'absent' to '5.7.3+dfsg-1ubuntu4'
'keepalived' changed from 'absent' to '1:1.2.19-1ubuntu0.2'
'ipvsadm' changed from 'absent' to '1:1.28-3'
'libsensors4' changed from 'absent' to '1:3.4.0-2'

2017-11-08 09:35:59,287 [salt.state       ][INFO    ][18251] Loading fresh modules for state activity
2017-11-08 09:35:59,306 [salt.state       ][INFO    ][18251] Completed state [keepalived] at time 09:35:59.305598 duration_in_ms=12912.074
2017-11-08 09:35:59,308 [salt.state       ][INFO    ][18251] Running state [/etc/keepalived/keepalived.conf] at time 09:35:59.307849
2017-11-08 09:35:59,308 [salt.state       ][INFO    ][18251] Executing state file.managed for /etc/keepalived/keepalived.conf
2017-11-08 09:35:59,368 [salt.fileclient  ][INFO    ][18251] Fetching file from saltenv 'base', ** done ** 'keepalived/files/keepalived.conf'
2017-11-08 09:35:59,402 [salt.fileclient  ][INFO    ][18251] Fetching file from saltenv 'base', ** done ** 'keepalived/map.jinja'
2017-11-08 09:35:59,409 [salt.state       ][INFO    ][18251] File changed:
New file
2017-11-08 09:35:59,410 [salt.state       ][INFO    ][18251] Completed state [/etc/keepalived/keepalived.conf] at time 09:35:59.409762 duration_in_ms=101.912
2017-11-08 09:35:59,478 [salt.state       ][INFO    ][18251] Running state [keepalived] at time 09:35:59.477809
2017-11-08 09:35:59,478 [salt.state       ][INFO    ][18251] Executing state service.running for keepalived
2017-11-08 09:35:59,480 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'status', 'keepalived.service', '-n', '0'] in directory '/root'
2017-11-08 09:35:59,489 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-active', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,497 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-enabled', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,506 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-enabled', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,515 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemd-run', '--scope', 'systemctl', 'start', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,556 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-active', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,563 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-enabled', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,571 [salt.loaded.int.module.cmdmod][INFO    ][18251] Executing command ['systemctl', 'is-enabled', 'keepalived.service'] in directory '/root'
2017-11-08 09:35:59,580 [salt.state       ][INFO    ][18251] {'keepalived': True}
2017-11-08 09:35:59,580 [salt.state       ][INFO    ][18251] Completed state [keepalived] at time 09:35:59.580168 duration_in_ms=102.36
2017-11-08 09:35:59,581 [salt.minion      ][INFO    ][18251] Returning information for job: 20171108093543968650
2017-11-08 09:39:14,252 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command pillar.get with jid 20171108093914219760
2017-11-08 09:39:14,283 [salt.minion      ][INFO    ][19374] Starting a new job with PID 19374
2017-11-08 09:39:14,288 [salt.minion      ][INFO    ][19374] Returning information for job: 20171108093914219760
2017-11-08 09:46:03,403 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command state.sls with jid 20171108094603403966
2017-11-08 09:46:03,416 [salt.minion      ][INFO    ][19605] Starting a new job with PID 19605
2017-11-08 09:46:03,936 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:04,001 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/init.sls'
2017-11-08 09:46:04,019 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/ssl.sls'
2017-11-08 09:46:04,038 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/map.jinja'
2017-11-08 09:46:04,063 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/master.sls'
2017-11-08 09:46:04,087 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/map.jinja'
2017-11-08 09:46:04,102 [py.warnings      ][WARNING ][19605] /usr/lib/python2.7/dist-packages/salt/utils/templates.py:73: DeprecationWarning: Starting in 2015.5, cmd.run uses python_shell=False by default, which doesn't support shellisms (pipes, env variables, etc). cmd.run is currently aliased to cmd.shell to prevent breakage. Please switch to cmd.shell or set python_shell=True to avoid breakage in the future, when this aliasing is removed.

2017-11-08 09:46:04,103 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command 'test -e /var/lib/mysql/.galera_bootstrap; echo $?' in directory '/root'
2017-11-08 09:46:04,147 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/server.sls'
2017-11-08 09:46:04,189 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'mysql/map.jinja'
2017-11-08 09:46:04,496 [salt.state       ][INFO    ][19605] Running state [/etc/mysql/my.cnf] at time 09:46:04.495703
2017-11-08 09:46:04,496 [salt.state       ][INFO    ][19605] Executing state file.managed for /etc/mysql/my.cnf
2017-11-08 09:46:04,516 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/my.cnf.pre'
2017-11-08 09:46:04,520 [salt.state       ][INFO    ][19605] File changed:
New file
2017-11-08 09:46:04,520 [salt.state       ][INFO    ][19605] Completed state [/etc/mysql/my.cnf] at time 09:46:04.519828 duration_in_ms=24.125
2017-11-08 09:46:04,520 [salt.state       ][INFO    ][19605] Running state [rsync] at time 09:46:04.520342
2017-11-08 09:46:04,521 [salt.state       ][INFO    ][19605] Executing state pkg.installed for rsync
2017-11-08 09:46:04,521 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:04,943 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:07,434 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'rsync'] in directory '/root'
2017-11-08 09:46:11,558 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:11,577 [salt.state       ][INFO    ][19605] Made the following changes:
'rsync' changed from 'absent' to '3.1.1-3ubuntu1'

2017-11-08 09:46:11,584 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:11,597 [salt.state       ][INFO    ][19605] Completed state [rsync] at time 09:46:11.596635 duration_in_ms=7076.293
2017-11-08 09:46:11,602 [salt.state       ][INFO    ][19605] Running state [galera-3] at time 09:46:11.601915
2017-11-08 09:46:11,602 [salt.state       ][INFO    ][19605] Executing state pkg.installed for galera-3
2017-11-08 09:46:11,804 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:13,495 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094613490564
2017-11-08 09:46:13,508 [salt.minion      ][INFO    ][20950] Starting a new job with PID 20950
2017-11-08 09:46:13,518 [salt.minion      ][INFO    ][20950] Returning information for job: 20171108094613490564
2017-11-08 09:46:14,028 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'galera-3'] in directory '/root'
2017-11-08 09:46:16,721 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:16,743 [salt.state       ][INFO    ][19605] Made the following changes:
'galera' changed from 'absent' to '1'
'percona-xtradb-cluster-galera-25' changed from 'absent' to '1'
'galera3' changed from 'absent' to '1'
'galera-3' changed from 'absent' to '25.3.14-1'
'wsrep' changed from 'absent' to '1'

2017-11-08 09:46:16,751 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:16,763 [salt.state       ][INFO    ][19605] Completed state [galera-3] at time 09:46:16.763371 duration_in_ms=5161.455
2017-11-08 09:46:16,769 [salt.state       ][INFO    ][19605] Running state [python-mysqldb] at time 09:46:16.769026
2017-11-08 09:46:16,769 [salt.state       ][INFO    ][19605] Executing state pkg.installed for python-mysqldb
2017-11-08 09:46:16,953 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:19,288 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'python-mysqldb'] in directory '/root'
2017-11-08 09:46:23,681 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094623675662
2017-11-08 09:46:23,697 [salt.minion      ][INFO    ][21669] Starting a new job with PID 21669
2017-11-08 09:46:23,741 [salt.minion      ][INFO    ][21669] Returning information for job: 20171108094623675662
2017-11-08 09:46:25,131 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:25,153 [salt.state       ][INFO    ][19605] Made the following changes:
'python2.7-mysqldb' changed from 'absent' to '1'
'mysql-common' changed from 'absent' to '5.7.20-0ubuntu0.16.04.1'
'mysql-common-5.6' changed from 'absent' to '1'
'libmysqlclient20' changed from 'absent' to '5.7.20-0ubuntu0.16.04.1'
'python-mysqldb' changed from 'absent' to '1.3.7-1build2'

2017-11-08 09:46:25,161 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:25,174 [salt.state       ][INFO    ][19605] Completed state [python-mysqldb] at time 09:46:25.173844 duration_in_ms=8404.818
2017-11-08 09:46:25,182 [salt.state       ][INFO    ][19605] Running state [percona-xtrabackup] at time 09:46:25.181927
2017-11-08 09:46:25,182 [salt.state       ][INFO    ][19605] Executing state pkg.installed for percona-xtrabackup
2017-11-08 09:46:25,375 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:27,702 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'percona-xtrabackup'] in directory '/root'
2017-11-08 09:46:33,904 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094633901248
2017-11-08 09:46:33,969 [salt.minion      ][INFO    ][22377] Starting a new job with PID 22377
2017-11-08 09:46:34,056 [salt.minion      ][INFO    ][22377] Returning information for job: 20171108094633901248
2017-11-08 09:46:36,913 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:36,936 [salt.state       ][INFO    ][19605] Made the following changes:
'libaio1' changed from 'absent' to '0.3.110-2'
'libev4' changed from 'absent' to '1:4.22-1'
'percona-xtrabackup' changed from 'absent' to '2.3.4-1~u16.04+mcp1'
'libdbi-perl' changed from 'absent' to '1.634-1build1'
'xtrabackup' changed from 'absent' to '1'
'libcurl3' changed from 'absent' to '7.47.0-1ubuntu2.4'
'perl-dbdabi-94' changed from 'absent' to '1'
'libdbd-mysql-perl' changed from 'absent' to '4.033-1ubuntu0.1'

2017-11-08 09:46:36,945 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:36,959 [salt.state       ][INFO    ][19605] Completed state [percona-xtrabackup] at time 09:46:36.958750 duration_in_ms=11776.822
2017-11-08 09:46:36,965 [salt.state       ][INFO    ][19605] Running state [psmisc] at time 09:46:36.964952
2017-11-08 09:46:36,965 [salt.state       ][INFO    ][19605] Executing state pkg.installed for psmisc
2017-11-08 09:46:37,171 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:39,325 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'psmisc'] in directory '/root'
2017-11-08 09:46:42,255 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:42,275 [salt.state       ][INFO    ][19605] Made the following changes:
'psmisc' changed from 'absent' to '22.21-2.1build1'

2017-11-08 09:46:42,282 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:42,295 [salt.state       ][INFO    ][19605] Completed state [psmisc] at time 09:46:42.294978 duration_in_ms=5330.025
2017-11-08 09:46:42,306 [salt.state       ][INFO    ][19605] Running state [python-pymysql] at time 09:46:42.306196
2017-11-08 09:46:42,307 [salt.state       ][INFO    ][19605] Executing state pkg.installed for python-pymysql
2017-11-08 09:46:42,486 [salt.state       ][INFO    ][19605] Package python-pymysql is already installed
2017-11-08 09:46:42,486 [salt.state       ][INFO    ][19605] Completed state [python-pymysql] at time 09:46:42.486126 duration_in_ms=179.93
2017-11-08 09:46:42,487 [salt.state       ][INFO    ][19605] Running state [socat] at time 09:46:42.486588
2017-11-08 09:46:42,487 [salt.state       ][INFO    ][19605] Executing state pkg.installed for socat
2017-11-08 09:46:42,494 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:44,010 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094644006553
2017-11-08 09:46:44,023 [salt.minion      ][INFO    ][23816] Starting a new job with PID 23816
2017-11-08 09:46:44,033 [salt.minion      ][INFO    ][23816] Returning information for job: 20171108094644006553
2017-11-08 09:46:44,766 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'socat'] in directory '/root'
2017-11-08 09:46:48,198 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:48,218 [salt.state       ][INFO    ][19605] Made the following changes:
'socat' changed from 'absent' to '1.7.3.1-1'

2017-11-08 09:46:48,226 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:48,238 [salt.state       ][INFO    ][19605] Completed state [socat] at time 09:46:48.237527 duration_in_ms=5750.938
2017-11-08 09:46:48,243 [salt.state       ][INFO    ][19605] Running state [libdbd-mysql] at time 09:46:48.242684
2017-11-08 09:46:48,243 [salt.state       ][INFO    ][19605] Executing state pkg.installed for libdbd-mysql
2017-11-08 09:46:48,431 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:50,675 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'libdbd-mysql'] in directory '/root'
2017-11-08 09:46:54,206 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094654198100
2017-11-08 09:46:54,221 [salt.minion      ][INFO    ][24509] Starting a new job with PID 24509
2017-11-08 09:46:54,231 [salt.minion      ][INFO    ][24509] Returning information for job: 20171108094654198100
2017-11-08 09:46:54,929 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:46:54,954 [salt.state       ][INFO    ][19605] Made the following changes:
'libdbd-mysql' changed from 'absent' to '0.9.0-3ubuntu2'
'libdbi1' changed from 'absent' to '0.9.0-4'

2017-11-08 09:46:54,962 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:46:54,974 [salt.state       ][INFO    ][19605] Completed state [libdbd-mysql] at time 09:46:54.974390 duration_in_ms=6731.706
2017-11-08 09:46:54,982 [salt.state       ][INFO    ][19605] Running state [netcat] at time 09:46:54.982021
2017-11-08 09:46:54,982 [salt.state       ][INFO    ][19605] Executing state pkg.installed for netcat
2017-11-08 09:46:55,181 [salt.state       ][INFO    ][19605] Package netcat is already installed
2017-11-08 09:46:55,181 [salt.state       ][INFO    ][19605] Completed state [netcat] at time 09:46:55.180986 duration_in_ms=198.965
2017-11-08 09:46:55,182 [salt.state       ][INFO    ][19605] Running state [mysql-wsrep-5.6] at time 09:46:55.181744
2017-11-08 09:46:55,182 [salt.state       ][INFO    ][19605] Executing state pkg.installed for mysql-wsrep-5.6
2017-11-08 09:46:55,190 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 09:46:57,510 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '--force-yes', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'mysql-wsrep-5.6'] in directory '/root'
2017-11-08 09:47:04,395 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094704387278
2017-11-08 09:47:04,408 [salt.minion      ][INFO    ][25186] Starting a new job with PID 25186
2017-11-08 09:47:04,417 [salt.minion      ][INFO    ][25186] Returning information for job: 20171108094704387278
2017-11-08 09:47:14,586 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094714577084
2017-11-08 09:47:14,602 [salt.minion      ][INFO    ][25310] Starting a new job with PID 25310
2017-11-08 09:47:14,613 [salt.minion      ][INFO    ][25310] Returning information for job: 20171108094714577084
2017-11-08 09:47:24,618 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094724609318
2017-11-08 09:47:24,634 [salt.minion      ][INFO    ][25484] Starting a new job with PID 25484
2017-11-08 09:47:24,644 [salt.minion      ][INFO    ][25484] Returning information for job: 20171108094724609318
2017-11-08 09:47:34,818 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094734808287
2017-11-08 09:47:34,831 [salt.minion      ][INFO    ][25543] Starting a new job with PID 25543
2017-11-08 09:47:34,840 [salt.minion      ][INFO    ][25543] Returning information for job: 20171108094734808287
2017-11-08 09:47:43,243 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 09:47:43,269 [salt.state       ][INFO    ][19605] Made the following changes:
'mysql-wsrep-common-5.6' changed from 'absent' to '5.6.35-0~u16.04+mcp3'
'libmysqlclient18' changed from 'absent' to '1'
'virtual-mysql-client' changed from 'absent' to '1'
'libencode-locale-perl' changed from 'absent' to '1.05-1'
'libhttp-message-perl' changed from 'absent' to '6.11-1'
'mysql-wsrep-client-5.6' changed from 'absent' to '5.6.35-0~u16.04+mcp3'
'timedate' changed from 'absent' to '1'
'mysql-server-5.6' changed from 'absent' to '1'
'libfcgi-perl' changed from 'absent' to '0.77-1build1'
'libhtml-parser-perl' changed from 'absent' to '3.72-1'
'liburi-perl' changed from 'absent' to '1.71-1'
'mysql-wsrep-server-5.6' changed from 'absent' to '5.6.35-0~u16.04+mcp3'
'libcgi-fast-perl' changed from 'absent' to '1:2.10-1'
'libcgi-pm-perl' changed from 'absent' to '4.26-1'
'liblwp-mediatypes-perl' changed from 'absent' to '6.02-1'
'libhtml-template-perl' changed from 'absent' to '2.95-2'
'virtual-mysql-server' changed from 'absent' to '1'
'mysql-wsrep-libmysqlclient18' changed from 'absent' to '5.6.35-0~u16.04+mcp3'
'libhttp-date-perl' changed from 'absent' to '6.02-1'
'libtimedate-perl' changed from 'absent' to '2.3000-2'
'libterm-readkey-perl' changed from 'absent' to '2.33-1build1'
'libhtml-tagset-perl' changed from 'absent' to '3.20-2'
'libio-html-perl' changed from 'absent' to '1.001-1'
'mysql-wsrep-5.6' changed from 'absent' to '5.6.35-0~u16.04+mcp3'

2017-11-08 09:47:43,278 [salt.state       ][INFO    ][19605] Loading fresh modules for state activity
2017-11-08 09:47:43,290 [salt.state       ][INFO    ][19605] Completed state [mysql-wsrep-5.6] at time 09:47:43.289531 duration_in_ms=48107.79
2017-11-08 09:47:43,292 [salt.state       ][INFO    ][19605] Running state [/var/log/mysql] at time 09:47:43.291669
2017-11-08 09:47:43,292 [salt.state       ][INFO    ][19605] Executing state file.directory for /var/log/mysql
2017-11-08 09:47:43,294 [salt.state       ][INFO    ][19605] {'mode': '0755'}
2017-11-08 09:47:43,294 [salt.state       ][INFO    ][19605] Completed state [/var/log/mysql] at time 09:47:43.294150 duration_in_ms=2.481
2017-11-08 09:47:43,295 [salt.state       ][INFO    ][19605] Running state [/var/run/mysqld] at time 09:47:43.294725
2017-11-08 09:47:43,295 [salt.state       ][INFO    ][19605] Executing state file.directory for /var/run/mysqld
2017-11-08 09:47:43,296 [salt.state       ][INFO    ][19605] Directory /var/run/mysqld is in the correct state
2017-11-08 09:47:43,296 [salt.state       ][INFO    ][19605] Completed state [/var/run/mysqld] at time 09:47:43.295823 duration_in_ms=1.098
2017-11-08 09:47:43,296 [salt.state       ][INFO    ][19605] Running state [/etc/systemd/system/mysql.service.d] at time 09:47:43.296390
2017-11-08 09:47:43,297 [salt.state       ][INFO    ][19605] Executing state file.directory for /etc/systemd/system/mysql.service.d
2017-11-08 09:47:43,297 [salt.state       ][INFO    ][19605] {'/etc/systemd/system/mysql.service.d': 'New Dir'}
2017-11-08 09:47:43,298 [salt.state       ][INFO    ][19605] Completed state [/etc/systemd/system/mysql.service.d] at time 09:47:43.297652 duration_in_ms=1.262
2017-11-08 09:47:43,299 [salt.state       ][INFO    ][19605] Running state [/etc/systemd/system/mysql.service.d/override.conf] at time 09:47:43.298635
2017-11-08 09:47:43,299 [salt.state       ][INFO    ][19605] Executing state file.managed for /etc/systemd/system/mysql.service.d/override.conf
2017-11-08 09:47:43,309 [salt.state       ][INFO    ][19605] File changed:
New file
2017-11-08 09:47:43,309 [salt.state       ][INFO    ][19605] Completed state [/etc/systemd/system/mysql.service.d/override.conf] at time 09:47:43.309139 duration_in_ms=10.503
2017-11-08 09:47:43,310 [salt.state       ][INFO    ][19605] Running state [service.systemctl_reload] at time 09:47:43.310253
2017-11-08 09:47:43,311 [salt.state       ][INFO    ][19605] Executing state module.wait for service.systemctl_reload
2017-11-08 09:47:43,311 [salt.state       ][INFO    ][19605] No changes made for service.systemctl_reload
2017-11-08 09:47:43,311 [salt.state       ][INFO    ][19605] Completed state [service.systemctl_reload] at time 09:47:43.311140 duration_in_ms=0.886
2017-11-08 09:47:43,311 [salt.state       ][INFO    ][19605] Running state [service.systemctl_reload] at time 09:47:43.311399
2017-11-08 09:47:43,312 [salt.state       ][INFO    ][19605] Executing state module.mod_watch for service.systemctl_reload
2017-11-08 09:47:43,394 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', '--system', 'daemon-reload'] in directory '/root'
2017-11-08 09:47:43,441 [salt.state       ][INFO    ][19605] {'ret': True}
2017-11-08 09:47:43,441 [salt.state       ][INFO    ][19605] Completed state [service.systemctl_reload] at time 09:47:43.441372 duration_in_ms=129.972
2017-11-08 09:47:43,442 [salt.state       ][INFO    ][19605] Running state [/etc/mysql/debian.cnf] at time 09:47:43.442233
2017-11-08 09:47:43,443 [salt.state       ][INFO    ][19605] Executing state file.managed for /etc/mysql/debian.cnf
2017-11-08 09:47:43,460 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/debian.cnf'
2017-11-08 09:47:43,479 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/map.jinja'
2017-11-08 09:47:43,497 [salt.state       ][INFO    ][19605] File changed:
--- 
+++ 
@@ -1,12 +1,13 @@
-# Automatically generated for Debian scripts. DO NOT TOUCH!
+
 [client]
-host     = localhost
-user     = debian-sys-maint
-password = KnsNuGGIoyjW8sh9
-socket   = /var/run/mysqld/mysqld.sock
+host = localhost
+user = debian-sys-maint
+password = opnfv_secret
+socket = /var/run/mysqld/mysqld.sock
+
 [mysql_upgrade]
-host     = localhost
-user     = debian-sys-maint
-password = KnsNuGGIoyjW8sh9
-socket   = /var/run/mysqld/mysqld.sock
-basedir  = /usr
+host = localhost
+user = debian-sys-maint
+password = opnfv_secret
+socket = /var/run/mysqld/mysqld.sock
+basedir = /usr

2017-11-08 09:47:43,499 [salt.state       ][INFO    ][19605] Completed state [/etc/mysql/debian.cnf] at time 09:47:43.499352 duration_in_ms=57.119
2017-11-08 09:47:43,500 [salt.state       ][INFO    ][19605] Running state [/usr/local/sbin/galera_init.sh] at time 09:47:43.499746
2017-11-08 09:47:43,500 [salt.state       ][INFO    ][19605] Executing state file.managed for /usr/local/sbin/galera_init.sh
2017-11-08 09:47:43,519 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/init_bootstrap.sh'
2017-11-08 09:47:43,522 [salt.state       ][INFO    ][19605] File changed:
New file
2017-11-08 09:47:43,522 [salt.state       ][INFO    ][19605] Completed state [/usr/local/sbin/galera_init.sh] at time 09:47:43.522107 duration_in_ms=22.36
2017-11-08 09:47:43,522 [salt.state       ][INFO    ][19605] Running state [/usr/local/sbin/galera_bootstrap.sh] at time 09:47:43.522299
2017-11-08 09:47:43,523 [salt.state       ][INFO    ][19605] Executing state file.managed for /usr/local/sbin/galera_bootstrap.sh
2017-11-08 09:47:43,538 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/bootstrap.sh'
2017-11-08 09:47:43,541 [salt.state       ][INFO    ][19605] File changed:
New file
2017-11-08 09:47:43,541 [salt.state       ][INFO    ][19605] Completed state [/usr/local/sbin/galera_bootstrap.sh] at time 09:47:43.540803 duration_in_ms=18.504
2017-11-08 09:47:43,543 [salt.state       ][INFO    ][19605] Running state [/usr/local/sbin/galera_init.sh] at time 09:47:43.542541
2017-11-08 09:47:43,543 [salt.state       ][INFO    ][19605] Executing state cmd.run for /usr/local/sbin/galera_init.sh
2017-11-08 09:47:43,543 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command '/usr/local/sbin/galera_init.sh' in directory '/root'
2017-11-08 09:47:45,012 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094745004278
2017-11-08 09:47:45,028 [salt.minion      ][INFO    ][26105] Starting a new job with PID 26105
2017-11-08 09:47:45,038 [salt.minion      ][INFO    ][26105] Returning information for job: 20171108094745004278
2017-11-08 09:47:47,327 [salt.state       ][INFO    ][19605] {'pid': 25707, 'retcode': 0, 'stderr': '', 'stdout': 'Sucessfully connected to the MySQL service (0 retries).'}
2017-11-08 09:47:47,327 [salt.state       ][INFO    ][19605] Completed state [/usr/local/sbin/galera_init.sh] at time 09:47:47.327155 duration_in_ms=3784.611
2017-11-08 09:47:47,328 [salt.state       ][INFO    ][19605] Running state [mysqladmin password "opnfv_secret"] at time 09:47:47.328131
2017-11-08 09:47:47,328 [salt.state       ][INFO    ][19605] Executing state cmd.run for mysqladmin password "opnfv_secret"
2017-11-08 09:47:47,329 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command 'mysqladmin password "opnfv_secret"' in directory '/root'
2017-11-08 09:47:47,342 [salt.state       ][INFO    ][19605] {'pid': 26144, 'retcode': 0, 'stderr': 'Warning: Using a password on the command line interface can be insecure.', 'stdout': ''}
2017-11-08 09:47:47,342 [salt.state       ][INFO    ][19605] Completed state [mysqladmin password "opnfv_secret"] at time 09:47:47.342165 duration_in_ms=14.033
2017-11-08 09:47:47,343 [salt.state       ][INFO    ][19605] Running state [mysql -u root -popnfv_secret -e "GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'opnfv_secret';"] at time 09:47:47.343172
2017-11-08 09:47:47,344 [salt.state       ][INFO    ][19605] Executing state cmd.run for mysql -u root -popnfv_secret -e "GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'opnfv_secret';"
2017-11-08 09:47:47,344 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command 'mysql -u root -popnfv_secret -e "GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'opnfv_secret';"' in directory '/root'
2017-11-08 09:47:47,357 [salt.state       ][INFO    ][19605] {'pid': 26146, 'retcode': 0, 'stderr': 'Warning: Using a password on the command line interface can be insecure.', 'stdout': ''}
2017-11-08 09:47:47,357 [salt.state       ][INFO    ][19605] Completed state [mysql -u root -popnfv_secret -e "GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'opnfv_secret';"] at time 09:47:47.357452 duration_in_ms=14.278
2017-11-08 09:47:47,359 [salt.state       ][INFO    ][19605] Running state [mysql] at time 09:47:47.358844
2017-11-08 09:47:47,359 [salt.state       ][INFO    ][19605] Executing state service.dead for mysql
2017-11-08 09:47:47,360 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'status', 'mysql.service', '-n', '0'] in directory '/root'
2017-11-08 09:47:47,371 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-active', 'mysql.service'] in directory '/root'
2017-11-08 09:47:47,382 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:47:47,394 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'systemctl', 'stop', 'mysql.service'] in directory '/root'
2017-11-08 09:47:55,215 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094755206555
2017-11-08 09:47:55,227 [salt.minion      ][INFO    ][26237] Starting a new job with PID 26237
2017-11-08 09:47:55,237 [salt.minion      ][INFO    ][26237] Returning information for job: 20171108094755206555
2017-11-08 09:48:05,410 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094805406114
2017-11-08 09:48:05,426 [salt.minion      ][INFO    ][26247] Starting a new job with PID 26247
2017-11-08 09:48:05,435 [salt.minion      ][INFO    ][26247] Returning information for job: 20171108094805406114
2017-11-08 09:48:15,613 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094815605382
2017-11-08 09:48:15,627 [salt.minion      ][INFO    ][26257] Starting a new job with PID 26257
2017-11-08 09:48:15,636 [salt.minion      ][INFO    ][26257] Returning information for job: 20171108094815605382
2017-11-08 09:48:25,818 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094825810976
2017-11-08 09:48:25,833 [salt.minion      ][INFO    ][26262] Starting a new job with PID 26262
2017-11-08 09:48:25,845 [salt.minion      ][INFO    ][26262] Returning information for job: 20171108094825810976
2017-11-08 09:48:36,029 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094836023808
2017-11-08 09:48:36,043 [salt.minion      ][INFO    ][26267] Starting a new job with PID 26267
2017-11-08 09:48:36,052 [salt.minion      ][INFO    ][26267] Returning information for job: 20171108094836023808
2017-11-08 09:48:46,236 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094846229712
2017-11-08 09:48:46,250 [salt.minion      ][INFO    ][26277] Starting a new job with PID 26277
2017-11-08 09:48:46,260 [salt.minion      ][INFO    ][26277] Returning information for job: 20171108094846229712
2017-11-08 09:48:56,447 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094856439478
2017-11-08 09:48:56,461 [salt.minion      ][INFO    ][26282] Starting a new job with PID 26282
2017-11-08 09:48:56,470 [salt.minion      ][INFO    ][26282] Returning information for job: 20171108094856439478
2017-11-08 09:49:06,660 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094906654279
2017-11-08 09:49:06,674 [salt.minion      ][INFO    ][26292] Starting a new job with PID 26292
2017-11-08 09:49:06,684 [salt.minion      ][INFO    ][26292] Returning information for job: 20171108094906654279
2017-11-08 09:49:16,877 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094916871175
2017-11-08 09:49:16,891 [salt.minion      ][INFO    ][26297] Starting a new job with PID 26297
2017-11-08 09:49:16,900 [salt.minion      ][INFO    ][26297] Returning information for job: 20171108094916871175
2017-11-08 09:49:27,098 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094927092281
2017-11-08 09:49:27,112 [salt.minion      ][INFO    ][26302] Starting a new job with PID 26302
2017-11-08 09:49:27,122 [salt.minion      ][INFO    ][26302] Returning information for job: 20171108094927092281
2017-11-08 09:49:37,322 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094937317025
2017-11-08 09:49:37,338 [salt.minion      ][INFO    ][26312] Starting a new job with PID 26312
2017-11-08 09:49:37,346 [salt.minion      ][INFO    ][26312] Returning information for job: 20171108094937317025
2017-11-08 09:49:47,549 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094947543224
2017-11-08 09:49:47,565 [salt.minion      ][INFO    ][26317] Starting a new job with PID 26317
2017-11-08 09:49:47,576 [salt.minion      ][INFO    ][26317] Returning information for job: 20171108094947543224
2017-11-08 09:49:57,570 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108094957565609
2017-11-08 09:49:57,584 [salt.minion      ][INFO    ][26327] Starting a new job with PID 26327
2017-11-08 09:49:57,593 [salt.minion      ][INFO    ][26327] Returning information for job: 20171108094957565609
2017-11-08 09:50:07,591 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095007584759
2017-11-08 09:50:07,604 [salt.minion      ][INFO    ][26332] Starting a new job with PID 26332
2017-11-08 09:50:07,614 [salt.minion      ][INFO    ][26332] Returning information for job: 20171108095007584759
2017-11-08 09:50:17,611 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095017606248
2017-11-08 09:50:17,626 [salt.minion      ][INFO    ][26337] Starting a new job with PID 26337
2017-11-08 09:50:17,634 [salt.minion      ][INFO    ][26337] Returning information for job: 20171108095017606248
2017-11-08 09:50:27,639 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095027634791
2017-11-08 09:50:27,653 [salt.minion      ][INFO    ][26347] Starting a new job with PID 26347
2017-11-08 09:50:27,662 [salt.minion      ][INFO    ][26347] Returning information for job: 20171108095027634791
2017-11-08 09:50:37,671 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095037666844
2017-11-08 09:50:37,685 [salt.minion      ][INFO    ][26352] Starting a new job with PID 26352
2017-11-08 09:50:37,694 [salt.minion      ][INFO    ][26352] Returning information for job: 20171108095037666844
2017-11-08 09:50:47,711 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095047706465
2017-11-08 09:50:47,727 [salt.minion      ][INFO    ][26445] Starting a new job with PID 26445
2017-11-08 09:50:47,736 [salt.minion      ][INFO    ][26445] Returning information for job: 20171108095047706465
2017-11-08 09:50:57,756 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095057747585
2017-11-08 09:50:57,770 [salt.minion      ][INFO    ][26450] Starting a new job with PID 26450
2017-11-08 09:50:57,779 [salt.minion      ][INFO    ][26450] Returning information for job: 20171108095057747585
2017-11-08 09:51:07,803 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095107794034
2017-11-08 09:51:07,817 [salt.minion      ][INFO    ][26455] Starting a new job with PID 26455
2017-11-08 09:51:07,826 [salt.minion      ][INFO    ][26455] Returning information for job: 20171108095107794034
2017-11-08 09:51:17,849 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095117839545
2017-11-08 09:51:17,863 [salt.minion      ][INFO    ][26531] Starting a new job with PID 26531
2017-11-08 09:51:17,873 [salt.minion      ][INFO    ][26531] Returning information for job: 20171108095117839545
2017-11-08 09:51:27,904 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095127893254
2017-11-08 09:51:27,918 [salt.minion      ][INFO    ][26536] Starting a new job with PID 26536
2017-11-08 09:51:27,927 [salt.minion      ][INFO    ][26536] Returning information for job: 20171108095127893254
2017-11-08 09:51:37,960 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095137950029
2017-11-08 09:51:37,974 [salt.minion      ][INFO    ][26546] Starting a new job with PID 26546
2017-11-08 09:51:37,982 [salt.minion      ][INFO    ][26546] Returning information for job: 20171108095137950029
2017-11-08 09:51:48,023 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095148015005
2017-11-08 09:51:48,037 [salt.minion      ][INFO    ][26551] Starting a new job with PID 26551
2017-11-08 09:51:48,046 [salt.minion      ][INFO    ][26551] Returning information for job: 20171108095148015005
2017-11-08 09:51:58,089 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095158082602
2017-11-08 09:51:58,103 [salt.minion      ][INFO    ][26556] Starting a new job with PID 26556
2017-11-08 09:51:58,112 [salt.minion      ][INFO    ][26556] Returning information for job: 20171108095158082602
2017-11-08 09:52:08,161 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095208151767
2017-11-08 09:52:08,176 [salt.minion      ][INFO    ][26566] Starting a new job with PID 26566
2017-11-08 09:52:08,185 [salt.minion      ][INFO    ][26566] Returning information for job: 20171108095208151767
2017-11-08 09:52:18,237 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095218229480
2017-11-08 09:52:18,253 [salt.minion      ][INFO    ][26571] Starting a new job with PID 26571
2017-11-08 09:52:18,262 [salt.minion      ][INFO    ][26571] Returning information for job: 20171108095218229480
2017-11-08 09:52:28,321 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095228315226
2017-11-08 09:52:28,336 [salt.minion      ][INFO    ][26581] Starting a new job with PID 26581
2017-11-08 09:52:28,345 [salt.minion      ][INFO    ][26581] Returning information for job: 20171108095228315226
2017-11-08 09:52:38,407 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095238400076
2017-11-08 09:52:38,422 [salt.minion      ][INFO    ][26586] Starting a new job with PID 26586
2017-11-08 09:52:38,430 [salt.minion      ][INFO    ][26586] Returning information for job: 20171108095238400076
2017-11-08 09:52:48,497 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095248489301
2017-11-08 09:52:48,510 [salt.minion      ][INFO    ][26591] Starting a new job with PID 26591
2017-11-08 09:52:48,519 [salt.minion      ][INFO    ][26591] Returning information for job: 20171108095248489301
2017-11-08 09:52:58,592 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095258586112
2017-11-08 09:52:58,606 [salt.minion      ][INFO    ][26601] Starting a new job with PID 26601
2017-11-08 09:52:58,615 [salt.minion      ][INFO    ][26601] Returning information for job: 20171108095258586112
2017-11-08 09:53:08,692 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095308686510
2017-11-08 09:53:08,707 [salt.minion      ][INFO    ][26606] Starting a new job with PID 26606
2017-11-08 09:53:08,716 [salt.minion      ][INFO    ][26606] Returning information for job: 20171108095308686510
2017-11-08 09:53:18,800 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095318793695
2017-11-08 09:53:18,814 [salt.minion      ][INFO    ][26611] Starting a new job with PID 26611
2017-11-08 09:53:18,823 [salt.minion      ][INFO    ][26611] Returning information for job: 20171108095318793695
2017-11-08 09:53:28,914 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095328907070
2017-11-08 09:53:28,929 [salt.minion      ][INFO    ][26621] Starting a new job with PID 26621
2017-11-08 09:53:28,938 [salt.minion      ][INFO    ][26621] Returning information for job: 20171108095328907070
2017-11-08 09:53:39,037 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095339030262
2017-11-08 09:53:39,050 [salt.minion      ][INFO    ][26626] Starting a new job with PID 26626
2017-11-08 09:53:39,059 [salt.minion      ][INFO    ][26626] Returning information for job: 20171108095339030262
2017-11-08 09:53:49,161 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095349154945
2017-11-08 09:53:49,176 [salt.minion      ][INFO    ][26631] Starting a new job with PID 26631
2017-11-08 09:53:49,185 [salt.minion      ][INFO    ][26631] Returning information for job: 20171108095349154945
2017-11-08 09:53:59,294 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095359288337
2017-11-08 09:53:59,308 [salt.minion      ][INFO    ][26641] Starting a new job with PID 26641
2017-11-08 09:53:59,316 [salt.minion      ][INFO    ][26641] Returning information for job: 20171108095359288337
2017-11-08 09:54:09,429 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095409424796
2017-11-08 09:54:09,444 [salt.minion      ][INFO    ][26646] Starting a new job with PID 26646
2017-11-08 09:54:09,454 [salt.minion      ][INFO    ][26646] Returning information for job: 20171108095409424796
2017-11-08 09:54:19,576 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095419570644
2017-11-08 09:54:19,591 [salt.minion      ][INFO    ][26651] Starting a new job with PID 26651
2017-11-08 09:54:19,602 [salt.minion      ][INFO    ][26651] Returning information for job: 20171108095419570644
2017-11-08 09:54:29,730 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095429726136
2017-11-08 09:54:29,744 [salt.minion      ][INFO    ][26661] Starting a new job with PID 26661
2017-11-08 09:54:29,755 [salt.minion      ][INFO    ][26661] Returning information for job: 20171108095429726136
2017-11-08 09:54:39,887 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095439881176
2017-11-08 09:54:39,901 [salt.minion      ][INFO    ][26666] Starting a new job with PID 26666
2017-11-08 09:54:39,910 [salt.minion      ][INFO    ][26666] Returning information for job: 20171108095439881176
2017-11-08 09:54:50,049 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095450044598
2017-11-08 09:54:50,062 [salt.minion      ][INFO    ][26671] Starting a new job with PID 26671
2017-11-08 09:54:50,071 [salt.minion      ][INFO    ][26671] Returning information for job: 20171108095450044598
2017-11-08 09:55:00,228 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095500223824
2017-11-08 09:55:00,243 [salt.minion      ][INFO    ][26830] Starting a new job with PID 26830
2017-11-08 09:55:00,252 [salt.minion      ][INFO    ][26830] Returning information for job: 20171108095500223824
2017-11-08 09:55:10,407 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095510399858
2017-11-08 09:55:10,421 [salt.minion      ][INFO    ][26835] Starting a new job with PID 26835
2017-11-08 09:55:10,430 [salt.minion      ][INFO    ][26835] Returning information for job: 20171108095510399858
2017-11-08 09:55:20,595 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095520586085
2017-11-08 09:55:20,610 [salt.minion      ][INFO    ][26840] Starting a new job with PID 26840
2017-11-08 09:55:20,619 [salt.minion      ][INFO    ][26840] Returning information for job: 20171108095520586085
2017-11-08 09:55:30,791 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095530782380
2017-11-08 09:55:30,804 [salt.minion      ][INFO    ][26850] Starting a new job with PID 26850
2017-11-08 09:55:30,813 [salt.minion      ][INFO    ][26850] Returning information for job: 20171108095530782380
2017-11-08 09:55:40,992 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095540980777
2017-11-08 09:55:41,005 [salt.minion      ][INFO    ][26855] Starting a new job with PID 26855
2017-11-08 09:55:41,014 [salt.minion      ][INFO    ][26855] Returning information for job: 20171108095540980777
2017-11-08 09:55:51,197 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095551188918
2017-11-08 09:55:51,210 [salt.minion      ][INFO    ][26860] Starting a new job with PID 26860
2017-11-08 09:55:51,219 [salt.minion      ][INFO    ][26860] Returning information for job: 20171108095551188918
2017-11-08 09:56:01,407 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095601399793
2017-11-08 09:56:01,421 [salt.minion      ][INFO    ][26870] Starting a new job with PID 26870
2017-11-08 09:56:01,429 [salt.minion      ][INFO    ][26870] Returning information for job: 20171108095601399793
2017-11-08 09:56:11,627 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095611619342
2017-11-08 09:56:11,642 [salt.minion      ][INFO    ][26875] Starting a new job with PID 26875
2017-11-08 09:56:11,650 [salt.minion      ][INFO    ][26875] Returning information for job: 20171108095611619342
2017-11-08 09:56:21,859 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095621849934
2017-11-08 09:56:21,874 [salt.minion      ][INFO    ][26885] Starting a new job with PID 26885
2017-11-08 09:56:21,882 [salt.minion      ][INFO    ][26885] Returning information for job: 20171108095621849934
2017-11-08 09:56:31,880 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095631871497
2017-11-08 09:56:31,895 [salt.minion      ][INFO    ][26890] Starting a new job with PID 26890
2017-11-08 09:56:31,903 [salt.minion      ][INFO    ][26890] Returning information for job: 20171108095631871497
2017-11-08 09:56:41,907 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095641899438
2017-11-08 09:56:41,921 [salt.minion      ][INFO    ][26900] Starting a new job with PID 26900
2017-11-08 09:56:41,930 [salt.minion      ][INFO    ][26900] Returning information for job: 20171108095641899438
2017-11-08 09:56:51,942 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095651933620
2017-11-08 09:56:51,956 [salt.minion      ][INFO    ][26905] Starting a new job with PID 26905
2017-11-08 09:56:51,965 [salt.minion      ][INFO    ][26905] Returning information for job: 20171108095651933620
2017-11-08 09:57:01,985 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095701977404
2017-11-08 09:57:01,1000 [salt.minion      ][INFO    ][26915] Starting a new job with PID 26915
2017-11-08 09:57:02,011 [salt.minion      ][INFO    ][26915] Returning information for job: 20171108095701977404
2017-11-08 09:57:12,040 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095712032598
2017-11-08 09:57:12,053 [salt.minion      ][INFO    ][26920] Starting a new job with PID 26920
2017-11-08 09:57:12,064 [salt.minion      ][INFO    ][26920] Returning information for job: 20171108095712032598
2017-11-08 09:57:22,098 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095722092012
2017-11-08 09:57:22,113 [salt.minion      ][INFO    ][26925] Starting a new job with PID 26925
2017-11-08 09:57:22,125 [salt.minion      ][INFO    ][26925] Returning information for job: 20171108095722092012
2017-11-08 09:57:32,167 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095732161692
2017-11-08 09:57:32,181 [salt.minion      ][INFO    ][26935] Starting a new job with PID 26935
2017-11-08 09:57:32,191 [salt.minion      ][INFO    ][26935] Returning information for job: 20171108095732161692
2017-11-08 09:57:42,242 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095742235450
2017-11-08 09:57:42,257 [salt.minion      ][INFO    ][26940] Starting a new job with PID 26940
2017-11-08 09:57:42,269 [salt.minion      ][INFO    ][26940] Returning information for job: 20171108095742235450
2017-11-08 09:57:47,635 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-active', 'mysql.service'] in directory '/root'
2017-11-08 09:57:47,649 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:57:47,662 [salt.state       ][INFO    ][19605] {'mysql': False}
2017-11-08 09:57:47,663 [salt.state       ][INFO    ][19605] Completed state [mysql] at time 09:57:47.662872 duration_in_ms=600304.026
2017-11-08 09:57:47,664 [salt.state       ][INFO    ][19605] Running state [/etc/mysql/my.cnf] at time 09:57:47.663843
2017-11-08 09:57:47,664 [salt.state       ][INFO    ][19605] Executing state file.managed for /etc/mysql/my.cnf
2017-11-08 09:57:47,695 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/my.cnf.init'
2017-11-08 09:57:47,717 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/map.jinja'
2017-11-08 09:57:47,732 [salt.state       ][INFO    ][19605] File changed:
--- 
+++ 
@@ -1,36 +1,59 @@
-[client]
-port		= 3306
-socket		= /var/run/mysqld/mysqld.sock
+# All files in this package is subject to the GPL v2 license
+# More information is in the COPYING file in the top directory of this package.
+# Copyright (C) 2011 severalnines.com
 [mysqld_safe]
-socket		= /var/run/mysqld/mysqld.sock
-nice		= 0
 syslog
 [mysqld]
-user		= mysql
-pid-file	= /var/run/mysqld/mysqld.pid
-socket		= /var/run/mysqld/mysqld.sock
-port		= 3306
-basedir		= /usr
-datadir		= /var/lib/mysql
-tmpdir		= /tmp
-lc-messages-dir	= /usr/share/mysql
+datadir=/var/lib/mysql
+bind-address=10.167.4.51
+port=3306
+max_connections=3072
+default-storage-engine=innodb
+binlog_format=ROW
+collation-server=utf8_general_ci
+init-connect='SET NAMES utf8'
+character-set-server=utf8
+default-storage-engine=innodb
 skip-external-locking
-bind-address		= 127.0.0.1
-key_buffer		= 16M
-max_allowed_packet	= 16M
-thread_stack		= 192K
-thread_cache_size       = 8
-myisam-recover         = BACKUP
-query_cache_limit	= 1M
-query_cache_size        = 16M
-#log_error = /var/log/mysql/error.log
-expire_logs_days	= 10
-max_binlog_size         = 100M
-[mysqldump]
-quick
-quote-names
-max_allowed_packet	= 16M
-[mysql]
-[isamchk]
-key_buffer		= 16M
-!includedir /etc/mysql/conf.d/
+skip-name-resolve
+
+myisam_sort_buffer_size=64M
+wait_timeout=1800
+open_files_limit=102400
+table_open_cache=10000
+key_buffer_size=64M
+max_allowed_packet=256M
+query_cache_size=0
+query_cache_type=0
+
+innodb_file_format=Barracuda
+innodb_file_per_table=1
+innodb_buffer_pool_size=2048M
+innodb_log_file_size=627M
+innodb_read_io_threads=8
+innodb_write_io_threads=8
+innodb_io_capacity=500
+innodb_flush_log_at_trx_commit=2
+innodb_flush_method=O_DIRECT
+innodb_doublewrite=0
+innodb_autoinc_lock_mode=2
+innodb_locks_unsafe_for_binlog=1
+
+wsrep_cluster_address="gcomm://"
+wsrep_provider=/usr/lib/galera/libgalera_smm.so
+wsrep_cluster_name="openstack"
+
+wsrep_slave_threads=8
+wsrep_sst_method=xtrabackup-v2
+wsrep_sst_auth=root:opnfv_secret
+wsrep_node_address=10.167.4.51
+wsrep_provider_options="gcache.size = 256M"
+wsrep_provider_options="gmcast.listen_addr = tcp://10.167.4.51:4567"
+
+[xtrabackup]
+parallel=4
+
+[sst]
+streamfmt=xbstream
+transferfmt=socat
+sockopt=,nodelay,sndbuf=1048576,rcvbuf=1048576

2017-11-08 09:57:47,734 [salt.state       ][INFO    ][19605] Completed state [/etc/mysql/my.cnf] at time 09:57:47.733879 duration_in_ms=70.036
2017-11-08 09:57:47,735 [salt.state       ][INFO    ][19605] Running state [/usr/local/sbin/galera_bootstrap.sh] at time 09:57:47.734992
2017-11-08 09:57:47,735 [salt.state       ][INFO    ][19605] Executing state cmd.run for /usr/local/sbin/galera_bootstrap.sh
2017-11-08 09:57:47,736 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command '/usr/local/sbin/galera_bootstrap.sh' in directory '/root'
2017-11-08 09:57:52,330 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095752324459
2017-11-08 09:57:52,349 [salt.minion      ][INFO    ][27660] Starting a new job with PID 27660
2017-11-08 09:57:52,364 [salt.minion      ][INFO    ][27660] Returning information for job: 20171108095752324459
2017-11-08 09:57:58,343 [salt.state       ][INFO    ][19605] {'pid': 26954, 'retcode': 0, 'stderr': 'Warning: Using a password on the command line interface can be insecure.', 'stdout': 'Sucessfully connected to the MySQL service (0 retries).'}
2017-11-08 09:57:58,344 [salt.state       ][INFO    ][19605] Completed state [/usr/local/sbin/galera_bootstrap.sh] at time 09:57:58.343736 duration_in_ms=10608.742
2017-11-08 09:57:58,345 [salt.state       ][INFO    ][19605] Running state [/var/lib/mysql/.galera_bootstrap] at time 09:57:58.344729
2017-11-08 09:57:58,345 [salt.state       ][INFO    ][19605] Executing state file.touch for /var/lib/mysql/.galera_bootstrap
2017-11-08 09:57:58,346 [salt.state       ][INFO    ][19605] {'new': '/var/lib/mysql/.galera_bootstrap'}
2017-11-08 09:57:58,346 [salt.state       ][INFO    ][19605] Completed state [/var/lib/mysql/.galera_bootstrap] at time 09:57:58.346305 duration_in_ms=1.575
2017-11-08 09:57:58,809 [salt.state       ][INFO    ][19605] Running state [/etc/mysql/my.cnf] at time 09:57:58.809310
2017-11-08 09:57:58,810 [salt.state       ][INFO    ][19605] Executing state file.managed for /etc/mysql/my.cnf
2017-11-08 09:57:58,827 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/files/my.cnf'
2017-11-08 09:57:58,851 [salt.fileclient  ][INFO    ][19605] Fetching file from saltenv 'base', ** done ** 'galera/map.jinja'
2017-11-08 09:57:58,866 [salt.state       ][INFO    ][19605] File changed:
--- 
+++ 
@@ -1,8 +1,13 @@
 # All files in this package is subject to the GPL v2 license
 # More information is in the COPYING file in the top directory of this package.
 # Copyright (C) 2011 severalnines.com
+
+[mysql]
+
+
 [mysqld_safe]
 syslog
+
 [mysqld]
 datadir=/var/lib/mysql
 bind-address=10.167.4.51
@@ -14,8 +19,10 @@
 init-connect='SET NAMES utf8'
 character-set-server=utf8
 default-storage-engine=innodb
+#log_error=/var/log/mysql/error.log
 skip-external-locking
 skip-name-resolve
+socket = /var/run/mysqld/mysqld.sock
 
 myisam_sort_buffer_size=64M
 wait_timeout=1800
@@ -38,8 +45,7 @@
 innodb_doublewrite=0
 innodb_autoinc_lock_mode=2
 innodb_locks_unsafe_for_binlog=1
-
-wsrep_cluster_address="gcomm://"
+wsrep_cluster_address="gcomm://10.167.4.51:4567,10.167.4.52:4567,10.167.4.53:4567/?pc.wait_prim=no"
 wsrep_provider=/usr/lib/galera/libgalera_smm.so
 wsrep_cluster_name="openstack"
 
@@ -50,6 +56,8 @@
 wsrep_provider_options="gcache.size = 256M"
 wsrep_provider_options="gmcast.listen_addr = tcp://10.167.4.51:4567"
 
+
+
 [xtrabackup]
 parallel=4
 

2017-11-08 09:57:58,869 [salt.state       ][INFO    ][19605] Completed state [/etc/mysql/my.cnf] at time 09:57:58.869201 duration_in_ms=59.89
2017-11-08 09:57:58,871 [salt.state       ][INFO    ][19605] Running state [mysql] at time 09:57:58.870568
2017-11-08 09:57:58,871 [salt.state       ][INFO    ][19605] Executing state service.running for mysql
2017-11-08 09:57:58,871 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-active', 'mysql.service'] in directory '/root'
2017-11-08 09:57:58,886 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:57:58,901 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:57:58,914 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:57:58,929 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemd-run', '--scope', 'systemctl', 'enable', 'mysql.service'] in directory '/root'
2017-11-08 09:57:59,075 [salt.loaded.int.module.cmdmod][INFO    ][19605] Executing command ['systemctl', 'is-enabled', 'mysql.service'] in directory '/root'
2017-11-08 09:57:59,089 [salt.state       ][INFO    ][19605] {'mysql': True}
2017-11-08 09:57:59,089 [salt.state       ][INFO    ][19605] Completed state [mysql] at time 09:57:59.089459 duration_in_ms=218.89
2017-11-08 09:57:59,090 [salt.state       ][INFO    ][19605] Running state [ceilometer] at time 09:57:59.089817
2017-11-08 09:57:59,090 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for ceilometer
2017-11-08 09:57:59,207 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'ceilometer' created
2017-11-08 09:57:59,208 [salt.state       ][INFO    ][19605] {'ceilometer': 'Present'}
2017-11-08 09:57:59,208 [salt.state       ][INFO    ][19605] Completed state [ceilometer] at time 09:57:59.207985 duration_in_ms=118.168
2017-11-08 09:57:59,208 [salt.state       ][INFO    ][19605] Running state [ceilometer] at time 09:57:59.208293
2017-11-08 09:57:59,209 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for ceilometer
2017-11-08 09:57:59,286 [salt.loaded.int.module.mysql][INFO    ][19605] User 'ceilometer'@'%' has been created
2017-11-08 09:57:59,286 [salt.state       ][INFO    ][19605] {'ceilometer': 'Present'}
2017-11-08 09:57:59,286 [salt.state       ][INFO    ][19605] Completed state [ceilometer] at time 09:57:59.286410 duration_in_ms=78.117
2017-11-08 09:57:59,288 [salt.state       ][INFO    ][19605] Running state [mysql_grants_ceilometer_ceilometer_%] at time 09:57:59.287809
2017-11-08 09:57:59,288 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_ceilometer_ceilometer_%
2017-11-08 09:57:59,390 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'ceilometer.*' for user 'ceilometer' has been added
2017-11-08 09:57:59,390 [salt.state       ][INFO    ][19605] {'mysql_grants_ceilometer_ceilometer_%': 'Present'}
2017-11-08 09:57:59,390 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_ceilometer_ceilometer_%] at time 09:57:59.390341 duration_in_ms=102.532
2017-11-08 09:57:59,391 [salt.state       ][INFO    ][19605] Running state [ceilometer] at time 09:57:59.390733
2017-11-08 09:57:59,391 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for ceilometer
2017-11-08 09:57:59,430 [salt.loaded.int.module.mysql][INFO    ][19605] User 'ceilometer'@'10.167.4.51' has been created
2017-11-08 09:57:59,431 [salt.state       ][INFO    ][19605] {'ceilometer': 'Present'}
2017-11-08 09:57:59,431 [salt.state       ][INFO    ][19605] Completed state [ceilometer] at time 09:57:59.430909 duration_in_ms=40.176
2017-11-08 09:57:59,432 [salt.state       ][INFO    ][19605] Running state [mysql_grants_ceilometer_ceilometer_10.167.4.51] at time 09:57:59.432073
2017-11-08 09:57:59,466 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_ceilometer_ceilometer_10.167.4.51
2017-11-08 09:57:59,513 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'ceilometer.*' for user 'ceilometer' has been added
2017-11-08 09:57:59,513 [salt.state       ][INFO    ][19605] {'mysql_grants_ceilometer_ceilometer_10.167.4.51': 'Present'}
2017-11-08 09:57:59,514 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_ceilometer_ceilometer_10.167.4.51] at time 09:57:59.513482 duration_in_ms=81.409
2017-11-08 09:57:59,514 [salt.state       ][INFO    ][19605] Running state [aodh] at time 09:57:59.513871
2017-11-08 09:57:59,514 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for aodh
2017-11-08 09:57:59,615 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'aodh' created
2017-11-08 09:57:59,616 [salt.state       ][INFO    ][19605] {'aodh': 'Present'}
2017-11-08 09:57:59,616 [salt.state       ][INFO    ][19605] Completed state [aodh] at time 09:57:59.616003 duration_in_ms=102.132
2017-11-08 09:57:59,616 [salt.state       ][INFO    ][19605] Running state [aodh] at time 09:57:59.616421
2017-11-08 09:57:59,617 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for aodh
2017-11-08 09:57:59,695 [salt.loaded.int.module.mysql][INFO    ][19605] User 'aodh'@'%' has been created
2017-11-08 09:57:59,696 [salt.state       ][INFO    ][19605] {'aodh': 'Present'}
2017-11-08 09:57:59,696 [salt.state       ][INFO    ][19605] Completed state [aodh] at time 09:57:59.696159 duration_in_ms=79.739
2017-11-08 09:57:59,698 [salt.state       ][INFO    ][19605] Running state [mysql_grants_aodh_aodh_%] at time 09:57:59.697484
2017-11-08 09:57:59,698 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_aodh_aodh_%
2017-11-08 09:57:59,769 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'aodh.*' for user 'aodh' has been added
2017-11-08 09:57:59,769 [salt.state       ][INFO    ][19605] {'mysql_grants_aodh_aodh_%': 'Present'}
2017-11-08 09:57:59,770 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_aodh_aodh_%] at time 09:57:59.769768 duration_in_ms=72.284
2017-11-08 09:57:59,770 [salt.state       ][INFO    ][19605] Running state [aodh] at time 09:57:59.770131
2017-11-08 09:57:59,771 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for aodh
2017-11-08 09:57:59,790 [salt.loaded.int.module.mysql][INFO    ][19605] User 'aodh'@'10.167.4.50' has been created
2017-11-08 09:57:59,791 [salt.state       ][INFO    ][19605] {'aodh': 'Present'}
2017-11-08 09:57:59,791 [salt.state       ][INFO    ][19605] Completed state [aodh] at time 09:57:59.791013 duration_in_ms=20.882
2017-11-08 09:57:59,792 [salt.state       ][INFO    ][19605] Running state [mysql_grants_aodh_aodh_10.167.4.50] at time 09:57:59.792095
2017-11-08 09:57:59,792 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_aodh_aodh_10.167.4.50
2017-11-08 09:57:59,860 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'aodh.*' for user 'aodh' has been added
2017-11-08 09:57:59,860 [salt.state       ][INFO    ][19605] {'mysql_grants_aodh_aodh_10.167.4.50': 'Present'}
2017-11-08 09:57:59,861 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_aodh_aodh_10.167.4.50] at time 09:57:59.860656 duration_in_ms=68.561
2017-11-08 09:57:59,861 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:57:59.861046
2017-11-08 09:57:59,861 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for nova
2017-11-08 09:57:59,927 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'nova' created
2017-11-08 09:57:59,928 [salt.state       ][INFO    ][19605] {'nova': 'Present'}
2017-11-08 09:57:59,928 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:57:59.928117 duration_in_ms=67.071
2017-11-08 09:57:59,929 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:57:59.928477
2017-11-08 09:57:59,929 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:00,001 [salt.loaded.int.module.mysql][INFO    ][19605] User 'nova'@'%' has been created
2017-11-08 09:58:00,002 [salt.state       ][INFO    ][19605] {'nova': 'Present'}
2017-11-08 09:58:00,002 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:00.001993 duration_in_ms=73.516
2017-11-08 09:58:00,003 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_%] at time 09:58:00.003271
2017-11-08 09:58:00,004 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_%
2017-11-08 09:58:00,069 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova.*' for user 'nova' has been added
2017-11-08 09:58:00,070 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_%': 'Present'}
2017-11-08 09:58:00,070 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_%] at time 09:58:00.069950 duration_in_ms=66.679
2017-11-08 09:58:00,070 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:58:00.070321
2017-11-08 09:58:00,071 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:00,116 [salt.loaded.int.module.mysql][INFO    ][19605] User 'nova'@'10.167.4.51' has been created
2017-11-08 09:58:00,117 [salt.state       ][INFO    ][19605] {'nova': 'Present'}
2017-11-08 09:58:00,117 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:00.116921 duration_in_ms=46.6
2017-11-08 09:58:00,118 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_10.167.4.51] at time 09:58:00.118150
2017-11-08 09:58:00,119 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_10.167.4.51
2017-11-08 09:58:00,202 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova.*' for user 'nova' has been added
2017-11-08 09:58:00,202 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_10.167.4.51': 'Present'}
2017-11-08 09:58:00,203 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_10.167.4.51] at time 09:58:00.202675 duration_in_ms=84.524
2017-11-08 09:58:00,203 [salt.state       ][INFO    ][19605] Running state [grafana] at time 09:58:00.203042
2017-11-08 09:58:00,203 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for grafana
2017-11-08 09:58:00,264 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'grafana' created
2017-11-08 09:58:00,264 [salt.state       ][INFO    ][19605] {'grafana': 'Present'}
2017-11-08 09:58:00,264 [salt.state       ][INFO    ][19605] Completed state [grafana] at time 09:58:00.264425 duration_in_ms=61.383
2017-11-08 09:58:00,265 [salt.state       ][INFO    ][19605] Running state [grafana] at time 09:58:00.264779
2017-11-08 09:58:00,265 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for grafana
2017-11-08 09:58:00,337 [salt.loaded.int.module.mysql][INFO    ][19605] User 'grafana'@'%' has been created
2017-11-08 09:58:00,338 [salt.state       ][INFO    ][19605] {'grafana': 'Present'}
2017-11-08 09:58:00,338 [salt.state       ][INFO    ][19605] Completed state [grafana] at time 09:58:00.338160 duration_in_ms=73.38
2017-11-08 09:58:00,339 [salt.state       ][INFO    ][19605] Running state [mysql_grants_grafana_grafana_%] at time 09:58:00.339423
2017-11-08 09:58:00,340 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_grafana_grafana_%
2017-11-08 09:58:00,405 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'grafana.*' for user 'grafana' has been added
2017-11-08 09:58:00,406 [salt.state       ][INFO    ][19605] {'mysql_grants_grafana_grafana_%': 'Present'}
2017-11-08 09:58:00,406 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_grafana_grafana_%] at time 09:58:00.405874 duration_in_ms=66.45
2017-11-08 09:58:00,406 [salt.state       ][INFO    ][19605] Running state [grafana] at time 09:58:00.406296
2017-11-08 09:58:00,407 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for grafana
2017-11-08 09:58:00,433 [salt.loaded.int.module.mysql][INFO    ][19605] User 'grafana'@'10.167.4.51' has been created
2017-11-08 09:58:00,433 [salt.state       ][INFO    ][19605] {'grafana': 'Present'}
2017-11-08 09:58:00,433 [salt.state       ][INFO    ][19605] Completed state [grafana] at time 09:58:00.433280 duration_in_ms=26.984
2017-11-08 09:58:00,434 [salt.state       ][INFO    ][19605] Running state [mysql_grants_grafana_grafana_10.167.4.51] at time 09:58:00.434449
2017-11-08 09:58:00,435 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_grafana_grafana_10.167.4.51
2017-11-08 09:58:00,502 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'grafana.*' for user 'grafana' has been added
2017-11-08 09:58:00,503 [salt.state       ][INFO    ][19605] {'mysql_grants_grafana_grafana_10.167.4.51': 'Present'}
2017-11-08 09:58:00,503 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_grafana_grafana_10.167.4.51] at time 09:58:00.503087 duration_in_ms=68.638
2017-11-08 09:58:00,503 [salt.state       ][INFO    ][19605] Running state [designate_pool_manager] at time 09:58:00.503447
2017-11-08 09:58:00,504 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for designate_pool_manager
2017-11-08 09:58:00,564 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'designate_pool_manager' created
2017-11-08 09:58:00,565 [salt.state       ][INFO    ][19605] {'designate_pool_manager': 'Present'}
2017-11-08 09:58:00,565 [salt.state       ][INFO    ][19605] Completed state [designate_pool_manager] at time 09:58:00.564859 duration_in_ms=61.412
2017-11-08 09:58:00,565 [salt.state       ][INFO    ][19605] Running state [designate] at time 09:58:00.565224
2017-11-08 09:58:00,566 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for designate
2017-11-08 09:58:00,632 [salt.loaded.int.module.mysql][INFO    ][19605] User 'designate'@'%' has been created
2017-11-08 09:58:00,632 [salt.state       ][INFO    ][19605] {'designate': 'Present'}
2017-11-08 09:58:00,633 [salt.state       ][INFO    ][19605] Completed state [designate] at time 09:58:00.632482 duration_in_ms=67.257
2017-11-08 09:58:00,634 [salt.state       ][INFO    ][19605] Running state [mysql_grants_designate_designate_pool_manager_%] at time 09:58:00.633869
2017-11-08 09:58:00,634 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_designate_designate_pool_manager_%
2017-11-08 09:58:00,706 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'designate_pool_manager.*' for user 'designate' has been added
2017-11-08 09:58:00,706 [salt.state       ][INFO    ][19605] {'mysql_grants_designate_designate_pool_manager_%': 'Present'}
2017-11-08 09:58:00,707 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_designate_designate_pool_manager_%] at time 09:58:00.706577 duration_in_ms=72.708
2017-11-08 09:58:00,707 [salt.state       ][INFO    ][19605] Running state [designate] at time 09:58:00.706945
2017-11-08 09:58:00,707 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for designate
2017-11-08 09:58:00,776 [salt.loaded.int.module.mysql][INFO    ][19605] User 'designate'@'10.167.4.50' has been created
2017-11-08 09:58:00,776 [salt.state       ][INFO    ][19605] {'designate': 'Present'}
2017-11-08 09:58:00,777 [salt.state       ][INFO    ][19605] Completed state [designate] at time 09:58:00.776642 duration_in_ms=69.697
2017-11-08 09:58:00,778 [salt.state       ][INFO    ][19605] Running state [mysql_grants_designate_designate_pool_manager_10.167.4.50] at time 09:58:00.777833
2017-11-08 09:58:00,778 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_designate_designate_pool_manager_10.167.4.50
2017-11-08 09:58:00,876 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'designate_pool_manager.*' for user 'designate' has been added
2017-11-08 09:58:00,876 [salt.state       ][INFO    ][19605] {'mysql_grants_designate_designate_pool_manager_10.167.4.50': 'Present'}
2017-11-08 09:58:00,876 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_designate_designate_pool_manager_10.167.4.50] at time 09:58:00.876390 duration_in_ms=98.557
2017-11-08 09:58:00,877 [salt.state       ][INFO    ][19605] Running state [heat] at time 09:58:00.876759
2017-11-08 09:58:00,877 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for heat
2017-11-08 09:58:00,949 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'heat' created
2017-11-08 09:58:00,950 [salt.state       ][INFO    ][19605] {'heat': 'Present'}
2017-11-08 09:58:00,950 [salt.state       ][INFO    ][19605] Completed state [heat] at time 09:58:00.949857 duration_in_ms=73.098
2017-11-08 09:58:00,950 [salt.state       ][INFO    ][19605] Running state [heat] at time 09:58:00.950200
2017-11-08 09:58:00,951 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for heat
2017-11-08 09:58:01,027 [salt.loaded.int.module.mysql][INFO    ][19605] User 'heat'@'%' has been created
2017-11-08 09:58:01,028 [salt.state       ][INFO    ][19605] {'heat': 'Present'}
2017-11-08 09:58:01,028 [salt.state       ][INFO    ][19605] Completed state [heat] at time 09:58:01.027964 duration_in_ms=77.764
2017-11-08 09:58:01,029 [salt.state       ][INFO    ][19605] Running state [mysql_grants_heat_heat_%] at time 09:58:01.029175
2017-11-08 09:58:01,030 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_heat_heat_%
2017-11-08 09:58:01,097 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'heat.*' for user 'heat' has been added
2017-11-08 09:58:01,097 [salt.state       ][INFO    ][19605] {'mysql_grants_heat_heat_%': 'Present'}
2017-11-08 09:58:01,097 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_heat_heat_%] at time 09:58:01.097328 duration_in_ms=68.152
2017-11-08 09:58:01,129 [salt.state       ][INFO    ][19605] Running state [heat] at time 09:58:01.129435
2017-11-08 09:58:01,130 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for heat
2017-11-08 09:58:01,220 [salt.loaded.int.module.mysql][INFO    ][19605] User 'heat'@'10.167.4.51' has been created
2017-11-08 09:58:01,221 [salt.state       ][INFO    ][19605] {'heat': 'Present'}
2017-11-08 09:58:01,221 [salt.state       ][INFO    ][19605] Completed state [heat] at time 09:58:01.220803 duration_in_ms=91.368
2017-11-08 09:58:01,222 [salt.state       ][INFO    ][19605] Running state [mysql_grants_heat_heat_10.167.4.51] at time 09:58:01.221984
2017-11-08 09:58:01,222 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_heat_heat_10.167.4.51
2017-11-08 09:58:01,295 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'heat.*' for user 'heat' has been added
2017-11-08 09:58:01,295 [salt.state       ][INFO    ][19605] {'mysql_grants_heat_heat_10.167.4.51': 'Present'}
2017-11-08 09:58:01,295 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_heat_heat_10.167.4.51] at time 09:58:01.295288 duration_in_ms=73.303
2017-11-08 09:58:01,296 [salt.state       ][INFO    ][19605] Running state [nova_api] at time 09:58:01.295662
2017-11-08 09:58:01,296 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for nova_api
2017-11-08 09:58:01,364 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'nova_api' created
2017-11-08 09:58:01,364 [salt.state       ][INFO    ][19605] {'nova_api': 'Present'}
2017-11-08 09:58:01,364 [salt.state       ][INFO    ][19605] Completed state [nova_api] at time 09:58:01.364275 duration_in_ms=68.612
2017-11-08 09:58:01,365 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:58:01.364618
2017-11-08 09:58:01,365 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:01,368 [salt.state       ][INFO    ][19605] User nova@% is already present with the desired password
2017-11-08 09:58:01,393 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:01.393083 duration_in_ms=28.465
2017-11-08 09:58:01,394 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_api_%] at time 09:58:01.394406
2017-11-08 09:58:01,395 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_api_%
2017-11-08 09:58:01,450 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova_api.*' for user 'nova' has been added
2017-11-08 09:58:01,450 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_api_%': 'Present'}
2017-11-08 09:58:01,451 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_api_%] at time 09:58:01.450630 duration_in_ms=56.224
2017-11-08 09:58:01,451 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:58:01.450942
2017-11-08 09:58:01,451 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:01,458 [salt.state       ][INFO    ][19605] User nova@10.167.4.51 is already present with the desired password
2017-11-08 09:58:01,458 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:01.458050 duration_in_ms=7.108
2017-11-08 09:58:01,459 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_api_10.167.4.51] at time 09:58:01.459152
2017-11-08 09:58:01,460 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_api_10.167.4.51
2017-11-08 09:58:01,504 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova_api.*' for user 'nova' has been added
2017-11-08 09:58:01,504 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_api_10.167.4.51': 'Present'}
2017-11-08 09:58:01,504 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_api_10.167.4.51] at time 09:58:01.504422 duration_in_ms=45.27
2017-11-08 09:58:01,505 [salt.state       ][INFO    ][19605] Running state [keystone] at time 09:58:01.504778
2017-11-08 09:58:01,505 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for keystone
2017-11-08 09:58:01,586 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'keystone' created
2017-11-08 09:58:01,586 [salt.state       ][INFO    ][19605] {'keystone': 'Present'}
2017-11-08 09:58:01,587 [salt.state       ][INFO    ][19605] Completed state [keystone] at time 09:58:01.586476 duration_in_ms=81.698
2017-11-08 09:58:01,587 [salt.state       ][INFO    ][19605] Running state [keystone] at time 09:58:01.586838
2017-11-08 09:58:01,587 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for keystone
2017-11-08 09:58:01,652 [salt.loaded.int.module.mysql][INFO    ][19605] User 'keystone'@'%' has been created
2017-11-08 09:58:01,652 [salt.state       ][INFO    ][19605] {'keystone': 'Present'}
2017-11-08 09:58:01,653 [salt.state       ][INFO    ][19605] Completed state [keystone] at time 09:58:01.652528 duration_in_ms=65.689
2017-11-08 09:58:01,654 [salt.state       ][INFO    ][19605] Running state [mysql_grants_keystone_keystone_%] at time 09:58:01.653846
2017-11-08 09:58:01,654 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_keystone_keystone_%
2017-11-08 09:58:01,725 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'keystone.*' for user 'keystone' has been added
2017-11-08 09:58:01,726 [salt.state       ][INFO    ][19605] {'mysql_grants_keystone_keystone_%': 'Present'}
2017-11-08 09:58:01,726 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_keystone_keystone_%] at time 09:58:01.726163 duration_in_ms=72.316
2017-11-08 09:58:01,727 [salt.state       ][INFO    ][19605] Running state [keystone] at time 09:58:01.726539
2017-11-08 09:58:01,727 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for keystone
2017-11-08 09:58:01,749 [salt.loaded.int.module.mysql][INFO    ][19605] User 'keystone'@'10.167.4.51' has been created
2017-11-08 09:58:01,749 [salt.state       ][INFO    ][19605] {'keystone': 'Present'}
2017-11-08 09:58:01,750 [salt.state       ][INFO    ][19605] Completed state [keystone] at time 09:58:01.749572 duration_in_ms=23.032
2017-11-08 09:58:01,751 [salt.state       ][INFO    ][19605] Running state [mysql_grants_keystone_keystone_10.167.4.51] at time 09:58:01.750719
2017-11-08 09:58:01,751 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_keystone_keystone_10.167.4.51
2017-11-08 09:58:01,823 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'keystone.*' for user 'keystone' has been added
2017-11-08 09:58:01,824 [salt.state       ][INFO    ][19605] {'mysql_grants_keystone_keystone_10.167.4.51': 'Present'}
2017-11-08 09:58:01,824 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_keystone_keystone_10.167.4.51] at time 09:58:01.823802 duration_in_ms=73.082
2017-11-08 09:58:01,824 [salt.state       ][INFO    ][19605] Running state [nova_cell0] at time 09:58:01.824144
2017-11-08 09:58:01,825 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for nova_cell0
2017-11-08 09:58:01,886 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'nova_cell0' created
2017-11-08 09:58:01,887 [salt.state       ][INFO    ][19605] {'nova_cell0': 'Present'}
2017-11-08 09:58:01,887 [salt.state       ][INFO    ][19605] Completed state [nova_cell0] at time 09:58:01.886928 duration_in_ms=62.784
2017-11-08 09:58:01,887 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:58:01.887264
2017-11-08 09:58:01,888 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:01,890 [salt.state       ][INFO    ][19605] User nova@% is already present with the desired password
2017-11-08 09:58:01,891 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:01.890613 duration_in_ms=3.349
2017-11-08 09:58:01,892 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_cell0_%] at time 09:58:01.891933
2017-11-08 09:58:01,892 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_cell0_%
2017-11-08 09:58:01,967 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova_cell0.*' for user 'nova' has been added
2017-11-08 09:58:01,968 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_cell0_%': 'Present'}
2017-11-08 09:58:01,968 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_cell0_%] at time 09:58:01.967855 duration_in_ms=75.923
2017-11-08 09:58:01,968 [salt.state       ][INFO    ][19605] Running state [nova] at time 09:58:01.968196
2017-11-08 09:58:01,969 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for nova
2017-11-08 09:58:01,971 [salt.state       ][INFO    ][19605] User nova@10.167.4.51 is already present with the desired password
2017-11-08 09:58:01,971 [salt.state       ][INFO    ][19605] Completed state [nova] at time 09:58:01.971292 duration_in_ms=3.096
2017-11-08 09:58:01,972 [salt.state       ][INFO    ][19605] Running state [mysql_grants_nova_nova_cell0_10.167.4.51] at time 09:58:01.972391
2017-11-08 09:58:01,973 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_nova_nova_cell0_10.167.4.51
2017-11-08 09:58:02,040 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'nova_cell0.*' for user 'nova' has been added
2017-11-08 09:58:02,040 [salt.state       ][INFO    ][19605] {'mysql_grants_nova_nova_cell0_10.167.4.51': 'Present'}
2017-11-08 09:58:02,040 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_nova_nova_cell0_10.167.4.51] at time 09:58:02.040344 duration_in_ms=67.953
2017-11-08 09:58:02,041 [salt.state       ][INFO    ][19605] Running state [cinder] at time 09:58:02.040713
2017-11-08 09:58:02,041 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for cinder
2017-11-08 09:58:02,113 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'cinder' created
2017-11-08 09:58:02,114 [salt.state       ][INFO    ][19605] {'cinder': 'Present'}
2017-11-08 09:58:02,114 [salt.state       ][INFO    ][19605] Completed state [cinder] at time 09:58:02.114067 duration_in_ms=73.354
2017-11-08 09:58:02,114 [salt.state       ][INFO    ][19605] Running state [cinder] at time 09:58:02.114458
2017-11-08 09:58:02,115 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for cinder
2017-11-08 09:58:02,181 [salt.loaded.int.module.mysql][INFO    ][19605] User 'cinder'@'%' has been created
2017-11-08 09:58:02,181 [salt.state       ][INFO    ][19605] {'cinder': 'Present'}
2017-11-08 09:58:02,182 [salt.state       ][INFO    ][19605] Completed state [cinder] at time 09:58:02.181785 duration_in_ms=67.327
2017-11-08 09:58:02,183 [salt.state       ][INFO    ][19605] Running state [mysql_grants_cinder_cinder_%] at time 09:58:02.183107
2017-11-08 09:58:02,184 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_cinder_cinder_%
2017-11-08 09:58:02,248 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'cinder.*' for user 'cinder' has been added
2017-11-08 09:58:02,249 [salt.state       ][INFO    ][19605] {'mysql_grants_cinder_cinder_%': 'Present'}
2017-11-08 09:58:02,249 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_cinder_cinder_%] at time 09:58:02.249143 duration_in_ms=66.035
2017-11-08 09:58:02,250 [salt.state       ][INFO    ][19605] Running state [cinder] at time 09:58:02.249513
2017-11-08 09:58:02,250 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for cinder
2017-11-08 09:58:02,270 [salt.loaded.int.module.mysql][INFO    ][19605] User 'cinder'@'10.167.4.51' has been created
2017-11-08 09:58:02,271 [salt.state       ][INFO    ][19605] {'cinder': 'Present'}
2017-11-08 09:58:02,271 [salt.state       ][INFO    ][19605] Completed state [cinder] at time 09:58:02.271040 duration_in_ms=21.526
2017-11-08 09:58:02,272 [salt.state       ][INFO    ][19605] Running state [mysql_grants_cinder_cinder_10.167.4.51] at time 09:58:02.272143
2017-11-08 09:58:02,273 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_cinder_cinder_10.167.4.51
2017-11-08 09:58:02,340 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'cinder.*' for user 'cinder' has been added
2017-11-08 09:58:02,340 [salt.state       ][INFO    ][19605] {'mysql_grants_cinder_cinder_10.167.4.51': 'Present'}
2017-11-08 09:58:02,341 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_cinder_cinder_10.167.4.51] at time 09:58:02.340526 duration_in_ms=68.383
2017-11-08 09:58:02,341 [salt.state       ][INFO    ][19605] Running state [glance] at time 09:58:02.340859
2017-11-08 09:58:02,341 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for glance
2017-11-08 09:58:02,402 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'glance' created
2017-11-08 09:58:02,402 [salt.state       ][INFO    ][19605] {'glance': 'Present'}
2017-11-08 09:58:02,403 [salt.state       ][INFO    ][19605] Completed state [glance] at time 09:58:02.402482 duration_in_ms=61.623
2017-11-08 09:58:02,403 [salt.state       ][INFO    ][19605] Running state [glance] at time 09:58:02.402843
2017-11-08 09:58:02,403 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for glance
2017-11-08 09:58:02,436 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108095802429796
2017-11-08 09:58:02,457 [salt.minion      ][INFO    ][27794] Starting a new job with PID 27794
2017-11-08 09:58:02,470 [salt.loaded.int.module.mysql][INFO    ][19605] User 'glance'@'%' has been created
2017-11-08 09:58:02,470 [salt.state       ][INFO    ][19605] {'glance': 'Present'}
2017-11-08 09:58:02,470 [salt.state       ][INFO    ][19605] Completed state [glance] at time 09:58:02.470392 duration_in_ms=67.548
2017-11-08 09:58:02,472 [salt.state       ][INFO    ][19605] Running state [mysql_grants_glance_glance_%] at time 09:58:02.471834
2017-11-08 09:58:02,469 [salt.minion      ][INFO    ][27794] Returning information for job: 20171108095802429796
2017-11-08 09:58:02,472 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_glance_glance_%
2017-11-08 09:58:02,549 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'glance.*' for user 'glance' has been added
2017-11-08 09:58:02,549 [salt.state       ][INFO    ][19605] {'mysql_grants_glance_glance_%': 'Present'}
2017-11-08 09:58:02,550 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_glance_glance_%] at time 09:58:02.549543 duration_in_ms=77.709
2017-11-08 09:58:02,550 [salt.state       ][INFO    ][19605] Running state [glance] at time 09:58:02.549899
2017-11-08 09:58:02,550 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for glance
2017-11-08 09:58:02,685 [salt.loaded.int.module.mysql][INFO    ][19605] User 'glance'@'10.167.4.51' has been created
2017-11-08 09:58:02,685 [salt.state       ][INFO    ][19605] {'glance': 'Present'}
2017-11-08 09:58:02,685 [salt.state       ][INFO    ][19605] Completed state [glance] at time 09:58:02.685394 duration_in_ms=135.495
2017-11-08 09:58:02,687 [salt.state       ][INFO    ][19605] Running state [mysql_grants_glance_glance_10.167.4.51] at time 09:58:02.686634
2017-11-08 09:58:02,687 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_glance_glance_10.167.4.51
2017-11-08 09:58:02,772 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'glance.*' for user 'glance' has been added
2017-11-08 09:58:02,772 [salt.state       ][INFO    ][19605] {'mysql_grants_glance_glance_10.167.4.51': 'Present'}
2017-11-08 09:58:02,773 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_glance_glance_10.167.4.51] at time 09:58:02.772665 duration_in_ms=86.031
2017-11-08 09:58:02,773 [salt.state       ][INFO    ][19605] Running state [neutron] at time 09:58:02.773027
2017-11-08 09:58:02,773 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for neutron
2017-11-08 09:58:02,828 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'neutron' created
2017-11-08 09:58:02,829 [salt.state       ][INFO    ][19605] {'neutron': 'Present'}
2017-11-08 09:58:02,829 [salt.state       ][INFO    ][19605] Completed state [neutron] at time 09:58:02.829223 duration_in_ms=56.196
2017-11-08 09:58:02,830 [salt.state       ][INFO    ][19605] Running state [neutron] at time 09:58:02.829649
2017-11-08 09:58:02,830 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for neutron
2017-11-08 09:58:02,943 [salt.loaded.int.module.mysql][INFO    ][19605] User 'neutron'@'%' has been created
2017-11-08 09:58:02,943 [salt.state       ][INFO    ][19605] {'neutron': 'Present'}
2017-11-08 09:58:02,944 [salt.state       ][INFO    ][19605] Completed state [neutron] at time 09:58:02.943617 duration_in_ms=113.967
2017-11-08 09:58:02,945 [salt.state       ][INFO    ][19605] Running state [mysql_grants_neutron_neutron_%] at time 09:58:02.944893
2017-11-08 09:58:02,945 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_neutron_neutron_%
2017-11-08 09:58:03,030 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'neutron.*' for user 'neutron' has been added
2017-11-08 09:58:03,031 [salt.state       ][INFO    ][19605] {'mysql_grants_neutron_neutron_%': 'Present'}
2017-11-08 09:58:03,060 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_neutron_neutron_%] at time 09:58:03.059513 duration_in_ms=114.62
2017-11-08 09:58:03,060 [salt.state       ][INFO    ][19605] Running state [neutron] at time 09:58:03.059895
2017-11-08 09:58:03,060 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for neutron
2017-11-08 09:58:03,106 [salt.loaded.int.module.mysql][INFO    ][19605] User 'neutron'@'10.167.4.51' has been created
2017-11-08 09:58:03,106 [salt.state       ][INFO    ][19605] {'neutron': 'Present'}
2017-11-08 09:58:03,107 [salt.state       ][INFO    ][19605] Completed state [neutron] at time 09:58:03.106627 duration_in_ms=46.731
2017-11-08 09:58:03,108 [salt.state       ][INFO    ][19605] Running state [mysql_grants_neutron_neutron_10.167.4.51] at time 09:58:03.107848
2017-11-08 09:58:03,108 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_neutron_neutron_10.167.4.51
2017-11-08 09:58:03,176 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'neutron.*' for user 'neutron' has been added
2017-11-08 09:58:03,177 [salt.state       ][INFO    ][19605] {'mysql_grants_neutron_neutron_10.167.4.51': 'Present'}
2017-11-08 09:58:03,177 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_neutron_neutron_10.167.4.51] at time 09:58:03.176830 duration_in_ms=68.981
2017-11-08 09:58:03,177 [salt.state       ][INFO    ][19605] Running state [designate] at time 09:58:03.177247
2017-11-08 09:58:03,178 [salt.state       ][INFO    ][19605] Executing state mysql_database.present for designate
2017-11-08 09:58:03,297 [salt.loaded.int.module.mysql][INFO    ][19605] DB 'designate' created
2017-11-08 09:58:03,298 [salt.state       ][INFO    ][19605] {'designate': 'Present'}
2017-11-08 09:58:03,298 [salt.state       ][INFO    ][19605] Completed state [designate] at time 09:58:03.298361 duration_in_ms=121.114
2017-11-08 09:58:03,299 [salt.state       ][INFO    ][19605] Running state [designate] at time 09:58:03.298736
2017-11-08 09:58:03,299 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for designate
2017-11-08 09:58:03,303 [salt.state       ][INFO    ][19605] User designate@% is already present with the desired password
2017-11-08 09:58:03,303 [salt.state       ][INFO    ][19605] Completed state [designate] at time 09:58:03.303078 duration_in_ms=4.341
2017-11-08 09:58:03,305 [salt.state       ][INFO    ][19605] Running state [mysql_grants_designate_designate_%] at time 09:58:03.305304
2017-11-08 09:58:03,306 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_designate_designate_%
2017-11-08 09:58:03,378 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'designate.*' for user 'designate' has been added
2017-11-08 09:58:03,378 [salt.state       ][INFO    ][19605] {'mysql_grants_designate_designate_%': 'Present'}
2017-11-08 09:58:03,378 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_designate_designate_%] at time 09:58:03.378432 duration_in_ms=73.128
2017-11-08 09:58:03,379 [salt.state       ][INFO    ][19605] Running state [designate] at time 09:58:03.378732
2017-11-08 09:58:03,379 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for designate
2017-11-08 09:58:03,381 [salt.state       ][INFO    ][19605] User designate@10.167.4.50 is already present with the desired password
2017-11-08 09:58:03,381 [salt.state       ][INFO    ][19605] Completed state [designate] at time 09:58:03.381241 duration_in_ms=2.509
2017-11-08 09:58:03,382 [salt.state       ][INFO    ][19605] Running state [mysql_grants_designate_designate_10.167.4.50] at time 09:58:03.382279
2017-11-08 09:58:03,383 [salt.state       ][INFO    ][19605] Executing state mysql_grants.present for mysql_grants_designate_designate_10.167.4.50
2017-11-08 09:58:03,451 [salt.loaded.int.module.mysql][INFO    ][19605] Grant 'all' on 'designate.*' for user 'designate' has been added
2017-11-08 09:58:03,451 [salt.state       ][INFO    ][19605] {'mysql_grants_designate_designate_10.167.4.50': 'Present'}
2017-11-08 09:58:03,451 [salt.state       ][INFO    ][19605] Completed state [mysql_grants_designate_designate_10.167.4.50] at time 09:58:03.451188 duration_in_ms=68.908
2017-11-08 09:58:03,452 [salt.state       ][INFO    ][19605] Running state [haproxy] at time 09:58:03.451524
2017-11-08 09:58:03,452 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for haproxy
2017-11-08 09:58:03,472 [salt.loaded.int.module.mysql][INFO    ][19605] User 'haproxy'@'localhost' has been created with passwordless login
2017-11-08 09:58:03,473 [salt.state       ][INFO    ][19605] {'haproxy': 'Present'}
2017-11-08 09:58:03,473 [salt.state       ][INFO    ][19605] Completed state [haproxy] at time 09:58:03.472813 duration_in_ms=21.288
2017-11-08 09:58:03,473 [salt.state       ][INFO    ][19605] Running state [haproxy] at time 09:58:03.473141
2017-11-08 09:58:03,473 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for haproxy
2017-11-08 09:58:03,518 [salt.loaded.int.module.mysql][INFO    ][19605] User 'haproxy'@'%' has been created with passwordless login
2017-11-08 09:58:03,519 [salt.state       ][INFO    ][19605] {'haproxy': 'Present'}
2017-11-08 09:58:03,519 [salt.state       ][INFO    ][19605] Completed state [haproxy] at time 09:58:03.519091 duration_in_ms=45.95
2017-11-08 09:58:03,519 [salt.state       ][INFO    ][19605] Running state [haproxy] at time 09:58:03.519450
2017-11-08 09:58:03,520 [salt.state       ][INFO    ][19605] Executing state mysql_user.present for haproxy
2017-11-08 09:58:03,562 [salt.loaded.int.module.mysql][INFO    ][19605] User 'haproxy'@'10.167.4.51' has been created with passwordless login
2017-11-08 09:58:03,562 [salt.state       ][INFO    ][19605] {'haproxy': 'Present'}
2017-11-08 09:58:03,563 [salt.state       ][INFO    ][19605] Completed state [haproxy] at time 09:58:03.562576 duration_in_ms=43.126
2017-11-08 09:58:03,566 [salt.minion      ][INFO    ][19605] Returning information for job: 20171108094603403966
2017-11-08 10:11:05,372 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command mysql.status with jid 20171108101105362527
2017-11-08 10:11:05,385 [salt.minion      ][INFO    ][28979] Starting a new job with PID 28979
2017-11-08 10:11:05,396 [salt.minion      ][INFO    ][28979] Returning information for job: 20171108101105362527
2017-11-08 10:11:21,012 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command state.sls with jid 20171108101121004671
2017-11-08 10:11:21,030 [salt.minion      ][INFO    ][28989] Starting a new job with PID 28989
2017-11-08 10:11:21,904 [salt.state       ][INFO    ][28989] Loading fresh modules for state activity
2017-11-08 10:11:21,925 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/init.sls'
2017-11-08 10:11:21,942 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/proxy.sls'
2017-11-08 10:11:22,296 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/map.jinja'
2017-11-08 10:11:22,552 [salt.state       ][INFO    ][28989] Running state [haproxy] at time 10:11:22.551575
2017-11-08 10:11:22,552 [salt.state       ][INFO    ][28989] Executing state pkg.installed for haproxy
2017-11-08 10:11:22,553 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 10:11:23,017 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['apt-get', '-q', 'update'] in directory '/root'
2017-11-08 10:11:25,400 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemd-run', '--scope', 'apt-get', '-q', '-y', '-o', 'DPkg::Options::=--force-confold', '-o', 'DPkg::Options::=--force-confdef', 'install', 'haproxy'] in directory '/root'
2017-11-08 10:11:31,107 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command saltutil.find_job with jid 20171108101131096662
2017-11-08 10:11:31,129 [salt.minion      ][INFO    ][29635] Starting a new job with PID 29635
2017-11-08 10:11:31,140 [salt.minion      ][INFO    ][29635] Returning information for job: 20171108101131096662
2017-11-08 10:11:38,099 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['dpkg-query', '--showformat', '${Status} ${Package} ${Version} ${Architecture}\n', '-W'] in directory '/root'
2017-11-08 10:11:38,119 [salt.state       ][INFO    ][28989] Made the following changes:
'haproxy' changed from 'absent' to '1.6.3-1~u16.04+mcp1'
'liblua5.3-0' changed from 'absent' to '5.3.1-1ubuntu2'

2017-11-08 10:11:38,128 [salt.state       ][INFO    ][28989] Loading fresh modules for state activity
2017-11-08 10:11:38,141 [salt.state       ][INFO    ][28989] Completed state [haproxy] at time 10:11:38.140513 duration_in_ms=15588.937
2017-11-08 10:11:38,143 [salt.state       ][INFO    ][28989] Running state [/etc/default/haproxy] at time 10:11:38.142967
2017-11-08 10:11:38,143 [salt.state       ][INFO    ][28989] Executing state file.managed for /etc/default/haproxy
2017-11-08 10:11:38,168 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/files/haproxy.default'
2017-11-08 10:11:38,170 [salt.state       ][INFO    ][28989] File changed:
--- 
+++ 
@@ -1,10 +1,5 @@
-# Defaults file for HAProxy
-#
-# This is sourced by both, the initscript and the systemd unit file, so do not
-# treat it as a shell script fragment.
 
-# Change the config file location if needed
-#CONFIG="/etc/haproxy/haproxy.cfg"
-
-# Add extra flags here, see haproxy(1) for a few options
+# Set ENABLED to 1 if you want the init script to start haproxy.
+ENABLED=1
+# Add extra flags here.
 #EXTRAOPTS="-de -m 16"

2017-11-08 10:11:38,172 [salt.state       ][INFO    ][28989] Completed state [/etc/default/haproxy] at time 10:11:38.171543 duration_in_ms=28.575
2017-11-08 10:11:38,172 [salt.state       ][INFO    ][28989] Running state [/etc/haproxy/haproxy.cfg] at time 10:11:38.171904
2017-11-08 10:11:38,172 [salt.state       ][INFO    ][28989] Executing state file.managed for /etc/haproxy/haproxy.cfg
2017-11-08 10:11:38,191 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/files/haproxy.cfg'
2017-11-08 10:11:38,279 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/map.jinja'
2017-11-08 10:11:38,287 [salt.state       ][INFO    ][28989] File changed:
--- 
+++ 
@@ -1,35 +1,54 @@
 global
-	log /dev/log	local0
-	log /dev/log	local1 notice
-	chroot /var/lib/haproxy
-	stats socket /run/haproxy/admin.sock mode 660 level admin
-	stats timeout 30s
-	user haproxy
-	group haproxy
-	daemon
-
-	# Default SSL material locations
-	ca-base /etc/ssl/certs
-	crt-base /etc/ssl/private
-
-	# Default ciphers to use on SSL-enabled listening sockets.
-	# For more information, see ciphers(1SSL). This list is from:
-	#  https://hynek.me/articles/hardening-your-web-servers-ssl-ciphers/
-	ssl-default-bind-ciphers ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+3DES:!aNULL:!MD5:!DSS
-	ssl-default-bind-options no-sslv3
+  log /dev/log  local0
+  log /dev/log  local1 notice
+  chroot /var/lib/haproxy
+  stats  socket /run/haproxy/admin.sock mode 660 level admin
+  stats timeout 30s
+  user  haproxy
+  group haproxy
+  daemon
+  pidfile  /var/run/haproxy.pid
+  spread-checks 4
+  tune.maxrewrite 1024
+  tune.bufsize 32768
+  maxconn  16000
+  # SSL options
+  ca-base /etc/haproxy/ssl
+  crt-base /etc/haproxy/ssl
+  tune.ssl.default-dh-param 2048
+  ssl-default-bind-ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS
+  ssl-default-bind-options no-sslv3 no-tls-tickets
+  ssl-default-server-ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA256:DHE-RSA-AES256-SHA:ECDHE-ECDSA-DES-CBC3-SHA:ECDHE-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA:!DSS
+  ssl-default-server-options no-sslv3 no-tls-tickets
 
 defaults
-	log	global
-	mode	http
-	option	httplog
-	option	dontlognull
-        timeout connect 5000
-        timeout client  50000
-        timeout server  50000
-	errorfile 400 /etc/haproxy/errors/400.http
-	errorfile 403 /etc/haproxy/errors/403.http
-	errorfile 408 /etc/haproxy/errors/408.http
-	errorfile 500 /etc/haproxy/errors/500.http
-	errorfile 502 /etc/haproxy/errors/502.http
-	errorfile 503 /etc/haproxy/errors/503.http
-	errorfile 504 /etc/haproxy/errors/504.http
+  log  global
+  mode http
+
+  maxconn 8000
+  option  redispatch
+  retries  3
+  stats  enable
+
+  timeout http-request 10s
+  timeout queue 10s
+  timeout connect 10s
+  timeout client 10s
+  timeout server 10s
+  timeout check 10s
+
+listen mysql_cluster
+  bind 10.167.4.50:3306 
+  balance first
+  mode tcp
+  option httpchk
+  option tcplog
+  option clitcpka
+  option srvtcpka
+  timeout client  300s
+  timeout server  300s
+  # option conflict's with port check of clustercheck script, if enabled haproxy reports invalid reponse
+  option mysql-check user haproxy
+  server dbs01 10.167.4.51:3306 check inter 20s fastinter 2s downinter 2s rise 3 fall 3
+  server dbs02 10.167.4.52:3306 backup check inter 20s fastinter 2s downinter 2s rise 3 fall 3
+  server dbs03 10.167.4.53:3306 backup check inter 20s fastinter 2s downinter 2s rise 3 fall 3

2017-11-08 10:11:38,294 [salt.state       ][INFO    ][28989] Completed state [/etc/haproxy/haproxy.cfg] at time 10:11:38.294067 duration_in_ms=122.162
2017-11-08 10:11:38,294 [salt.state       ][INFO    ][28989] Running state [/etc/haproxy/ssl] at time 10:11:38.294430
2017-11-08 10:11:38,295 [salt.state       ][INFO    ][28989] Executing state file.directory for /etc/haproxy/ssl
2017-11-08 10:11:38,296 [salt.state       ][INFO    ][28989] {'/etc/haproxy/ssl': 'New Dir'}
2017-11-08 10:11:38,296 [salt.state       ][INFO    ][28989] Completed state [/etc/haproxy/ssl] at time 10:11:38.295818 duration_in_ms=1.387
2017-11-08 10:11:38,297 [salt.state       ][INFO    ][28989] Running state [haproxy_status_packages] at time 10:11:38.296487
2017-11-08 10:11:38,297 [salt.state       ][INFO    ][28989] Executing state pkg.installed for haproxy_status_packages
2017-11-08 10:11:38,516 [salt.state       ][INFO    ][28989] All specified packages are already installed
2017-11-08 10:11:38,516 [salt.state       ][INFO    ][28989] Completed state [haproxy_status_packages] at time 10:11:38.516449 duration_in_ms=219.961
2017-11-08 10:11:38,517 [salt.state       ][INFO    ][28989] Running state [/usr/bin/haproxy-status.sh] at time 10:11:38.516834
2017-11-08 10:11:38,517 [salt.state       ][INFO    ][28989] Executing state file.managed for /usr/bin/haproxy-status.sh
2017-11-08 10:11:38,544 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/files/haproxy-status.sh'
2017-11-08 10:11:38,560 [salt.fileclient  ][INFO    ][28989] Fetching file from saltenv 'base', ** done ** 'haproxy/map.jinja'
2017-11-08 10:11:38,564 [salt.state       ][INFO    ][28989] File changed:
New file
2017-11-08 10:11:38,564 [salt.state       ][INFO    ][28989] Completed state [/usr/bin/haproxy-status.sh] at time 10:11:38.563851 duration_in_ms=47.016
2017-11-08 10:11:38,564 [salt.state       ][INFO    ][28989] Running state [net.ipv4.ip_nonlocal_bind] at time 10:11:38.564151
2017-11-08 10:11:38,564 [salt.state       ][INFO    ][28989] Executing state sysctl.present for net.ipv4.ip_nonlocal_bind
2017-11-08 10:11:38,565 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command 'sysctl -a' in directory '/root'
2017-11-08 10:11:38,580 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command 'sysctl -w net.ipv4.ip_nonlocal_bind="1"' in directory '/root'
2017-11-08 10:11:38,587 [salt.state       ][INFO    ][28989] {'net.ipv4.ip_nonlocal_bind': 1}
2017-11-08 10:11:38,587 [salt.state       ][INFO    ][28989] Completed state [net.ipv4.ip_nonlocal_bind] at time 10:11:38.587252 duration_in_ms=23.099
2017-11-08 10:11:38,588 [salt.state       ][INFO    ][28989] Running state [haproxy] at time 10:11:38.588176
2017-11-08 10:11:38,588 [salt.state       ][INFO    ][28989] Executing state service.running for haproxy
2017-11-08 10:11:38,589 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemctl', 'status', 'haproxy.service', '-n', '0'] in directory '/root'
2017-11-08 10:11:38,597 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemctl', 'is-active', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:38,603 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemctl', 'is-enabled', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:38,610 [salt.state       ][INFO    ][28989] The service haproxy is already running
2017-11-08 10:11:38,610 [salt.state       ][INFO    ][28989] Completed state [haproxy] at time 10:11:38.610401 duration_in_ms=22.224
2017-11-08 10:11:38,611 [salt.state       ][INFO    ][28989] Running state [haproxy] at time 10:11:38.610694
2017-11-08 10:11:38,611 [salt.state       ][INFO    ][28989] Executing state service.mod_watch for haproxy
2017-11-08 10:11:38,612 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemctl', 'is-active', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:38,622 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemctl', 'is-enabled', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:38,630 [salt.loaded.int.module.cmdmod][INFO    ][28989] Executing command ['systemd-run', '--scope', 'systemctl', 'restart', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:38,666 [salt.state       ][INFO    ][28989] {'haproxy': True}
2017-11-08 10:11:38,666 [salt.state       ][INFO    ][28989] Completed state [haproxy] at time 10:11:38.666401 duration_in_ms=55.706
2017-11-08 10:11:38,667 [salt.minion      ][INFO    ][28989] Returning information for job: 20171108101121004671
2017-11-08 10:11:43,193 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command service.status with jid 20171108101143184991
2017-11-08 10:11:43,213 [salt.minion      ][INFO    ][29830] Starting a new job with PID 29830
2017-11-08 10:11:43,396 [salt.loaded.int.module.cmdmod][INFO    ][29830] Executing command ['systemctl', 'status', 'haproxy.service', '-n', '0'] in directory '/root'
2017-11-08 10:11:43,405 [salt.loaded.int.module.cmdmod][INFO    ][29830] Executing command ['systemctl', 'is-active', 'haproxy.service'] in directory '/root'
2017-11-08 10:11:43,413 [salt.minion      ][INFO    ][29830] Returning information for job: 20171108101143184991
2017-11-08 10:11:44,556 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command service.restart with jid 20171108101144552596
2017-11-08 10:11:44,577 [salt.minion      ][INFO    ][29838] Starting a new job with PID 29838
2017-11-08 10:11:44,670 [salt.loaded.int.module.cmdmod][INFO    ][29838] Executing command ['systemctl', 'status', 'rsyslog.service', '-n', '0'] in directory '/root'
2017-11-08 10:11:44,679 [salt.loaded.int.module.cmdmod][INFO    ][29838] Executing command ['systemctl', 'is-enabled', 'rsyslog.service'] in directory '/root'
2017-11-08 10:11:44,694 [salt.loaded.int.module.cmdmod][INFO    ][29838] Executing command ['systemd-run', '--scope', 'systemctl', 'restart', 'rsyslog.service'] in directory '/root'
2017-11-08 10:11:44,729 [salt.minion      ][INFO    ][29838] Returning information for job: 20171108101144552596
2017-11-08 10:16:23,619 [salt.utils.schedule][INFO    ][17304] Running scheduled job: __mine_interval
2017-11-08 11:07:47,131 [salt.minion      ][INFO    ][17304] User sudo_ubuntu Executing command cp.push_dir with jid 20171108110747127364
2017-11-08 11:07:47,164 [salt.minion      ][INFO    ][32605] Starting a new job with PID 32605
