proxysql supported operating systems on centos-9-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on redhat-7-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on oraclelinux-8-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on ubuntu-20.04-x86_64 proxysql class without any parameters is expected to contain Exec[wait_for_admin_socket_to_open] with command => "test -S /var/lib/proxysql/proxysql_admin.sock", unless => "test -S /var/lib/proxysql/proxysql_admin.sock", tries => 3, try_sleep => 10, require => "Service[proxysql]" and path => "/bin:/usr/bin" Failure/Error: is_expected.to contain_exec('wait_for_admin_socket_to_open').with( command: "test -S #{admin_socket}", unless: "test -S #{admin_socket}", tries: 3, try_sleep: 10, require: 'Service[proxysql]', path: '/bin:/usr/bin' ) expected that the catalogue would contain Exec[wait_for_admin_socket_to_open] with command set to "test -S /var/lib/proxysql/proxysql_admin.sock" but it is set to "test -S /tmp/proxysql_admin.sock", and parameter unless set to "test -S /var/lib/proxysql/proxysql_admin.sock" but it is set to "test -S /tmp/proxysql_admin.sock" Diff: @@ -1,4 +1,4 @@ -test -S /var/lib/proxysql/proxysql_admin.sock +test -S /tmp/proxysql_admin.sock -test -S /var/lib/proxysql/proxysql_admin.sock +test -S /tmp/proxysql_admin.sock

proxysql supported operating systems on oraclelinux-9-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on redhat-9-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on redhat-8-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on oraclelinux-7-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on scientific-7-x86_64 proxysql class without any parameters with restart = true and proxysql 2.7.1 is expected to contain Service[proxysql] with start => "/etc/init.d/proxysql reload" Failure/Error: it { is_expected.to contain_service('proxysql').with_start('/etc/init.d/proxysql reload') } expected that the catalogue would contain Service[proxysql] with start set to "/etc/init.d/proxysql reload" but it is set to nil

proxysql supported operating systems on amazon-2016-x86_64 proxysql class without any parameters is expected to contain Yumrepo[proxysql_2_7] with baseurl => "http://repo.proxysql.com/ProxySQL/proxysql-2.7.x/centos/2016" Failure/Error: it { is_expected.to contain_yumrepo('proxysql_2_7').with_baseurl("http://repo.proxysql.com/ProxySQL/proxysql-2.7.x/centos/#{facts[:operatingsystemmajrelease]}") } expected that the catalogue would contain Yumrepo[proxysql_2_7] with baseurl set to "http://repo.proxysql.com/ProxySQL/proxysql-2.7.x/centos/2016" but it is set to "http://repo.proxysql.com/ProxySQL/proxysql-2.7.x/centos/6"

proxysql class Upgrading to version 2.7 works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle7-64-puppet7.example.com' exited with 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_140623129.l5HsD2.pp Last 10 lines of output were: Warning: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Unscheduling all events on Exec[wait_for_admin_socket_to_open] Info: Class[Proxysql::Service]: Unscheduling all events on Class[Proxysql::Service] Warning: /Stage[main]/Proxysql::Admin_credentials/Exec[proxysql-admin-credentials]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Admin_credentials/File[root-mycnf-file]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Unscheduling all events on Exec[reload-config] Info: Class[Proxysql]: Unscheduling all events on Class[Proxysql] Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 102.08 seconds

proxysql class Upgrading to version 2.7 Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle7-64-puppet7.example.com' exited with 4 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_140809200.fQhiU1.pp Last 10 lines of output were: Warning: /Stage[main]/Main/Proxy_mysql_user[tester]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_user[tester1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_user[tester2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_server provider 'proxysql': Execution of '/usr/bin/mysql -NBe SELECT `hostname`, `port`, `hostgroup_id` FROM `mysql_servers`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_query_rule provider 'proxysql': Execution of '/usr/bin/mysql -NBe SELECT `rule_id` FROM `mysql_query_rules`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-2]: Skipping because of failed dependencies �[mNotice: Applied catalog in 90.47 seconds

proxysql class extended testing Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" stdout is expected to match "^localhost:3307-1$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-1$' } expected "" to match "^localhost:3307-1$"

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" stdout is expected to match "^localhost:3307-2$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-2$' } expected "" to match "^localhost:3307-2$"

proxysql class extended testing Command "mysql -NB -e 'SELECT comment FROM mysql_replication_hostgroups WHERE writer_hostgroup = 10 AND reader_hostgroup = 20;'" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e 'SELECT comment FROM mysql_replication_hostgroups WHERE writer_hostgroup = 10 AND reader_hostgroup = 20;'" stdout is expected to match "^Test MySQL Cluster 10-20$" Failure/Error: its(:stdout) { is_expected.to match '^Test MySQL Cluster 10-20$' } expected "" to match "^Test MySQL Cluster 10-20$"

proxysql class Upgrading to version 2.7 works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle8-64-puppet7.example.com' exited with 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_140645350.yaXkYi.pp Last 10 lines of output were: Warning: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Unscheduling all events on Exec[wait_for_admin_socket_to_open] Info: Class[Proxysql::Service]: Unscheduling all events on Class[Proxysql::Service] Warning: /Stage[main]/Proxysql::Admin_credentials/Exec[proxysql-admin-credentials]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Admin_credentials/File[root-mycnf-file]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Skipping because of failed dependencies Info: /Stage[main]/Proxysql::Reload_config/Exec[reload-config]: Unscheduling all events on Exec[reload-config] Info: Class[Proxysql]: Unscheduling all events on Class[Proxysql] Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 104.49 seconds

proxysql class Upgrading to version 2.7 Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'oracle8-64-puppet7.example.com' exited with 4 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_140832854.yAwhSR.pp Last 10 lines of output were: Warning: /Stage[main]/Main/Proxy_mysql_user[tester]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_user[tester1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_user[tester2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_server provider 'proxysql': Execution of '/usr/bin/mysql -NBe SELECT `hostname`, `port`, `hostgroup_id` FROM `mysql_servers`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_server[127.0.0.1:3307-2]: Skipping because of failed dependencies Error: Could not prefetch proxy_mysql_query_rule provider 'proxysql': Execution of '/usr/bin/mysql -NBe SELECT `rule_id` FROM `mysql_query_rules`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-1]: Skipping because of failed dependencies Warning: /Stage[main]/Main/Proxy_mysql_query_rule[mysql_query_rule-2]: Skipping because of failed dependencies �[mNotice: Applied catalog in 90.45 seconds

proxysql class extended testing Service "proxysql" is expected to be running Failure/Error: it { is_expected.to be_running } expected Service "proxysql" to be running

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 1;"" stdout is expected to match "^localhost:3307-1$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-1$' } expected "" to match "^localhost:3307-1$"

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)

proxysql class extended testing Command "mysql -NB -e "SELECT comment FROM mysql_servers WHERE hostname = '127.0.0.1' AND port = 3307 AND hostgroup_id = 2;"" stdout is expected to match "^localhost:3307-2$" Failure/Error: its(:stdout) { is_expected.to match '^localhost:3307-2$' } expected "" to match "^localhost:3307-2$"

proxysql class extended testing Command "mysql -NB -e 'SELECT comment FROM mysql_replication_hostgroups WHERE writer_hostgroup = 10 AND reader_hostgroup = 20;'" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 1 (compared using ==)