Skip to content

Instantly share code, notes, and snippets.

@simonmcc

simonmcc/gist:41770d91e09b93e7258f

Created August 13, 2014 10:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save simonmcc/41770d91e09b93e7258f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save simonmcc/41770d91e09b93e7258f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[INFO ] Found minion id from getfqdn(): default-0162-ubuntu-1204.vagrantup.com
[INFO ] Executing command 'ps -efH' in directory '/home/vagrant'
[INFO ] Loading fresh modules for state activity
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/modules'
[INFO ] Syncing modules for environment 'base'
[INFO ] Loading cache from salt://_modules, for base)
[INFO ] Caching directory '_modules/' for environment 'base'
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/states'
[INFO ] Syncing states for environment 'base'
[INFO ] Loading cache from salt://_states, for base)
[INFO ] Caching directory '_states/' for environment 'base'
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/grains'
[INFO ] Syncing grains for environment 'base'
[INFO ] Loading cache from salt://_grains, for base)
[INFO ] Caching directory '_grains/' for environment 'base'
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/renderers'
[INFO ] Syncing renderers for environment 'base'
[INFO ] Loading cache from salt://_renderers, for base)
[INFO ] Caching directory '_renderers/' for environment 'base'
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/returners'
[INFO ] Syncing returners for environment 'base'
[INFO ] Loading cache from salt://_returners, for base)
[INFO ] Caching directory '_returners/' for environment 'base'
[INFO ] Creating module dir '/var/cache/salt/minion/extmods/outputters'
[INFO ] Syncing outputters for environment 'base'
[INFO ] Loading cache from salt://_outputters, for base)
[INFO ] Caching directory '_outputters/' for environment 'base'
[INFO ] Loading fresh modules for state activity
[INFO ] Executing state pkg.installed for debconf-utils
[INFO ] Executing command "dpkg-query --showformat='${Status} ${Package} ${Version} ${Architecture}\n' -W" in directory '/home/vagrant'
[INFO ] Executing command 'grep-available -F Provides -s Package,Provides -e "^.+$"' in directory '/home/vagrant'
[INFO ] No changes made for debconf-utils
[INFO ] Executing state debconf.set for percona-xtradb-cluster-server-5.6
[INFO ] Executing command 'debconf-get-selections' in directory '/home/vagrant'
[INFO ] Executing command 'debconf-set-selections /tmp/salt-rqctyc' in directory '/home/vagrant'
[INFO ] Executing command 'debconf-set-selections /tmp/salt-7HVLJr' in directory '/home/vagrant'
[INFO ] {'percona-xtradb-cluster-server/root_password': 'root-password', 'percona-xtradb-cluster-server/root_password_again': 'root-password'}
[INFO ] Executing state file.directory for /etc/mysql
[INFO ] {'/etc/mysql': 'New Dir'}
[INFO ] Executing state pkgrepo.managed for deb http://repo.percona.com/apt precise main
[INFO ] Executing command 'apt-key export 1C4CBDCDCD2EFD2A' in directory '/home/vagrant'
[INFO ] Executing command 'apt-key adv --keyserver keys.gnupg.net --logger-fd 1 --recv-keys 1C4CBDCDCD2EFD2A' in directory '/home/vagrant'
[INFO ] Executing command 'apt-get -q update' in directory '/home/vagrant'
[INFO ] {'repo': 'deb http://repo.percona.com/apt precise main'}
[INFO ] Executing state file.managed for /etc/mysql/my.cnf
[INFO ] File changed:
New file
[INFO ] Executing state pkg.latest for percona-xtradb-cluster-server-5.6
[INFO ] Executing command 'apt-get -q update' in directory '/home/vagrant'
[INFO ] Executing command 'apt-cache -q policy percona-xtradb-cluster-server-5.6 | grep Candidate' in directory '/home/vagrant'
[INFO ] Executing command 'apt-get -q -y -o DPkg::Options::=--force-confold -o DPkg::Options::=--force-confdef install percona-xtradb-cluster-server-5.6' in directory '/home/vagrant'
[INFO ] Executing command "dpkg-query --showformat='${Status} ${Package} ${Version} ${Architecture}\n' -W" in directory '/home/vagrant'
[INFO ] Executing command 'grep-available -F Provides -s Package,Provides -e "^.+$"' in directory '/home/vagrant'
[INFO ] Installed Packages:
libmysqlclient18 changed from absent to 1:5.5.35-rel33.0-611.precise
virtual-mysql-client changed from absent to 1
libplrpc-perl changed from absent to 0.2020-2
mysql-client changed from absent to 1
libreadline5 changed from absent to 5.2-11
libdbi-perl changed from absent to 1.616-1build2
xtrabackup changed from absent to 1
mysql-common changed from absent to 1
socat changed from absent to 1.7.1.3-1.2
percona-xtradb-cluster-server-5.6 changed from absent to 5.6.19-25.6-824.precise
percona-xtradb-cluster-client-5.6 changed from absent to 5.6.19-25.6-824.precise
galera3 changed from absent to 1
libnet-daemon-perl changed from absent to 0.48-1
mysql-server changed from absent to 1
virtual-mysql-client-core changed from absent to 1
percona-xtradb-cluster-common-5.6 changed from absent to 5.6.19-25.6-824.precise
libaio1 changed from absent to 0.3.109-2ubuntu1
percona-xtradb-cluster-galera-25 changed from absent to 1
percona-xtradb-cluster-galera-3.x changed from absent to 3.6.3190.precise
virtual-mysql-server-core changed from absent to 1
perl-dbdabi-94 changed from absent to 1
libdbd-mysql-perl changed from absent to 4.020-1build2
virtual-mysql-server changed from absent to 1
percona-xtrabackup changed from absent to 2.2.3-4982-1.precise
[INFO ] Loading fresh modules for state activity
[INFO ] Executing state file.managed for /etc/mysql/debian.cnf
[INFO ] File changed:
---
+++
@@ -1,12 +1,12 @@
-# Automatically generated for Debian scripts. DO NOT TOUCH!
+# Managed by Salt
[client]
host = localhost
user = debian-sys-maint
-password = yfvU6azxOlINrm1I
+password = debian-sys-maint-password
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
-password = yfvU6azxOlINrm1I
+password = debian-sys-maint-password
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
[INFO ] Executing state file.managed for /root/.my.cnf
[INFO ] File changed:
New file
[INFO ] Executing state pkg.installed for python-mysqldb
[INFO ] Executing command 'apt-get -q -y -o DPkg::Options::=--force-confold -o DPkg::Options::=--force-confdef install python-mysqldb' in directory '/home/vagrant'
[INFO ] Executing command "dpkg-query --showformat='${Status} ${Package} ${Version} ${Architecture}\n' -W" in directory '/home/vagrant'
[INFO ] Executing command 'grep-available -F Provides -s Package,Provides -e "^.+$"' in directory '/home/vagrant'
[INFO ] Installed Packages:
python2.7-mysqldb changed from absent to 1
python-mysqldb changed from absent to 1.2.3-1ubuntu0.1
[INFO ] Loading fresh modules for state activity
[INFO ] Executing state service.running for mysql
[INFO ] Executing command 'runlevel /run/utmp' in directory '/home/vagrant'
[INFO ] Executing command 'service mysql status' in directory '/home/vagrant'
[INFO ] No changes made for mysql
[INFO ] Executing state mysql_user.present for root
[INFO ] No changes made for root
[INFO ] Executing state mysql_grants.present for mysql_grants_root_localhost_*.*
[INFO ] Grant 'ALL' on '*.*' for user 'root' has NOT been added
[ERROR ] No changes made for mysql_grants_root_localhost_*.*
[INFO ] Executing state mysql_user.present for xtrabackup
[INFO ] User 'xtrabackup'@'localhost' has been created
[INFO ] {'xtrabackup': 'Present'}
[INFO ] Executing state mysql_grants.present for mysql_grants_xtrabackup_localhost_*.*
[INFO ] Grant 'RELOAD, LOCK TABLES, REPLICATION CLIENT' on '*.*' for user 'xtrabackup' has been added
[INFO ] {'mysql_grants_xtrabackup_localhost_*.*': 'Present'}
[INFO ] Executing state mysql_user.present for debian-sys-maint
[INFO ] Password for user 'debian-sys-maint'@'localhost' has been changed
[INFO ] {'debian-sys-maint': 'Updated'}
[INFO ] Executing state pkg.latest for percona-server-client-5.6
[INFO ] Executing command 'apt-cache -q policy percona-server-client-5.6 | grep Candidate' in directory '/home/vagrant'
[INFO ] Executing command 'apt-get -q -y -o DPkg::Options::=--force-confold -o DPkg::Options::=--force-confdef install percona-server-client-5.6' in directory '/home/vagrant'
[INFO ] Executing command "dpkg-query --showformat='${Status} ${Package} ${Version} ${Architecture}\n' -W" in directory '/home/vagrant'
[INFO ] Executing command 'grep-available -F Provides -s Package,Provides -e "^.+$"' in directory '/home/vagrant'
[INFO ] Installed Packages:
percona-xtradb-cluster-client-5.6 changed from 5.6.19-25.6-824.precise to absent
virtual-mysql-server changed from 1 to absent
mysql-server changed from 1 to absent
percona-server-common-5.6 changed from absent to 5.6.19-67.0-618.precise
libperconaserverclient18.1 changed from absent to 5.6.19-67.0-619.precise
percona-xtradb-cluster-server-5.6 changed from 5.6.19-25.6-824.precise to absent
virtual-mysql-server-core changed from 1 to absent
percona-server-client-5.6 changed from absent to 5.6.19-67.0-618.precise
[INFO ] Loading fresh modules for state activity
local:
----------
State: - pkg
Name: debconf-utils
Function: installed
Result: True
Comment: Package debconf-utils is already installed
Changes:
----------
State: - debconf
Name: percona-xtradb-cluster-server-5.6
Function: set
Result: True
Comment:
Changes: percona-xtradb-cluster-server/root_password: root-password
percona-xtradb-cluster-server/root_password_again: root-password
----------
State: - file
Name: /etc/mysql
Function: directory
Result: True
Comment: Directory /etc/mysql updated
Changes: /etc/mysql: New Dir
----------
State: - pkgrepo
Name: deb http://repo.percona.com/apt precise main
Function: managed
Result: True
Comment: Configured package repo deb http://repo.percona.com/apt precise main
Changes: repo: deb http://repo.percona.com/apt precise main
----------
State: - file
Name: /etc/mysql/my.cnf
Function: managed
Result: True
Comment: File /etc/mysql/my.cnf updated
Changes: diff: New file
----------
State: - pkg
Name: percona-xtradb-cluster-server-5.6
Function: latest
Result: True
Comment: The following packages were successfully installed/upgraded: percona-xtradb-cluster-server-5.6.
Changes: libmysqlclient18: { new : 1:5.5.35-rel33.0-611.precise
old :
}
virtual-mysql-client: { new : 1
old :
}
libplrpc-perl: { new : 0.2020-2
old :
}
mysql-client: { new : 1
old :
}
libreadline5: { new : 5.2-11
old :
}
libdbi-perl: { new : 1.616-1build2
old :
}
xtrabackup: { new : 1
old :
}
mysql-common: { new : 1
old :
}
socat: { new : 1.7.1.3-1.2
old :
}
percona-xtradb-cluster-server-5.6: { new : 5.6.19-25.6-824.precise
old :
}
percona-xtradb-cluster-client-5.6: { new : 5.6.19-25.6-824.precise
old :
}
galera3: { new : 1
old :
}
libnet-daemon-perl: { new : 0.48-1
old :
}
mysql-server: { new : 1
old :
}
virtual-mysql-client-core: { new : 1
old :
}
percona-xtradb-cluster-common-5.6: { new : 5.6.19-25.6-824.precise
old :
}
libaio1: { new : 0.3.109-2ubuntu1
old :
}
percona-xtradb-cluster-galera-25: { new : 1
old :
}
percona-xtradb-cluster-galera-3.x: { new : 3.6.3190.precise
old :
}
virtual-mysql-server-core: { new : 1
old :
}
perl-dbdabi-94: { new : 1
old :
}
libdbd-mysql-perl: { new : 4.020-1build2
old :
}
virtual-mysql-server: { new : 1
old :
}
percona-xtrabackup: { new : 2.2.3-4982-1.precise
old :
}
----------
State: - file
Name: /etc/mysql/debian.cnf
Function: managed
Result: True
Comment: File /etc/mysql/debian.cnf updated
Changes: diff: ---
+++
@@ -1,12 +1,12 @@
-# Automatically generated for Debian scripts. DO NOT TOUCH!
+# Managed by Salt
[client]
host = localhost
user = debian-sys-maint
-password = yfvU6azxOlINrm1I
+password = debian-sys-maint-password
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
-password = yfvU6azxOlINrm1I
+password = debian-sys-maint-password
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
mode: 600
----------
State: - file
Name: /root/.my.cnf
Function: managed
Result: True
Comment: File /root/.my.cnf updated
Changes: diff: New file
mode: 600
----------
State: - pkg
Name:
python-mysqldb
Function: installed
Result: True
Comment: The following packages were installed/updated: python-mysqldb.
Changes: python2.7-mysqldb: { new : 1
old :
}
python-mysqldb: { new : 1.2.3-1ubuntu0.1
old :
}
----------
State: - service
Name: mysql
Function: running
Result: True
Comment: The service mysql is already running
Changes:
----------
State: - mysql_user
Name: root
Function: present
Result: True
Comment: User root@localhost is already present with the desired password
Changes:
----------
State: - mysql_grants
Name: mysql_grants_root_localhost_*.*
Function: present
Result: False
Comment: Failed to execute: "GRANT ALL ON *.* TO root@localhost"
Changes:
----------
State: - mysql_user
Name: xtrabackup
Function: present
Result: True
Comment: The user xtrabackup@localhost has been added
Changes: xtrabackup: Present
----------
State: - mysql_grants
Name: mysql_grants_xtrabackup_localhost_*.*
Function: present
Result: True
Comment: Grant RELOAD, LOCK TABLES, REPLICATION CLIENT on *.* to xtrabackup@localhost has been added
Changes: mysql_grants_xtrabackup_localhost_*.*: Present
----------
State: - mysql_user
Name: debian-sys-maint
Function: present
Result: True
Comment: Password for user debian-sys-maint@localhost has been changed
Changes: debian-sys-maint: Updated
----------
State: - pkg
Name: percona-server-client-5.6
Function: latest
Result: True
Comment: The following packages were successfully installed/upgraded: percona-server-client-5.6.
Changes: percona-xtradb-cluster-client-5.6: { new :
old : 5.6.19-25.6-824.precise
}
virtual-mysql-server: { new :
old : 1
}
mysql-server: { new :
old : 1
}
percona-server-common-5.6: { new : 5.6.19-67.0-618.precise
old :
}
libperconaserverclient18.1: { new : 5.6.19-67.0-619.precise
old :
}
percona-xtradb-cluster-server-5.6: { new :
old : 5.6.19-25.6-824.precise
}
virtual-mysql-server-core: { new :
old : 1
}
percona-server-client-5.6: { new : 5.6.19-67.0-618.precise
old :
}
salt-call exit code: 0
Result: False
salt-call output grep exit code 0
>>>>>> Converge failed on instance <default-0162-ubuntu-1204>.
>>>>>> Please see .kitchen/logs/default-0162-ubuntu-1204.log for more details
>>>>>> ------Exception-------
>>>>>> Class: Kitchen::ActionFailed
>>>>>> Message: SSH exited (1) for command: [set -o pipefail ; sudo -E salt-call --config-dir=/tmp/kitchen/etc/salt --local state.highstate --log-level=info 2>&1 | tee /tmp/salt-call-output ; SC=$? ; echo salt-call exit code: $SC ; (sed '/grep -e Result.*False/d' /tmp/salt-call-output | grep -e Result.*False ; EC=$? ; echo salt-call output grep exit code ${EC} ; [ ${SC} -ne 0 ] && exit ${SC} ; [ ${EC} -eq 0 ] && exit 1 ; [ ${EC} -eq 1 ] && exit 0)]
>>>>>> ----------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment