proxysql class Upgrading to version 2.0 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_203651147.pp.OK6xeL 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 189.29 seconds

proxysql class Upgrading to version 2.0 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 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_204002561.pp.kB2aTP Last 10 lines of output were: 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 --defaults-extra-file=/root/.my.cnf -NBe SELECT `hostname`, `port`, `hostgroup_id` FROM `mysql_servers`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/proxysql_admin.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 --defaults-extra-file=/root/.my.cnf -NBe SELECT `rule_id` FROM `mysql_query_rules`' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/proxysql_admin.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 Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 90.78 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.0 works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'ubuntu1804-64-puppet7.example.com' exited with 6 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_182750529.pp.S5efvu Last 10 lines of output were: Warning: /Stage[main]/Proxysql::Service/Systemd::Dropin_file[proxysql ExecStart override]/File[/etc/systemd/system/proxysql.service.d/puppet.conf]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Service/Systemd::Dropin_file[proxysql ExecStart override]/Systemd::Daemon_reload[proxysql.service]/Exec[systemd-proxysql.service-systemctl-daemon-reload]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Service/Service[proxysql]: Skipping because of failed dependencies Warning: /Stage[main]/Proxysql::Service/Exec[wait_for_admin_socket_to_open]: Skipping because of failed dependencies 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: Class[Proxysql]: Unscheduling all events on Class[Proxysql] Info: Stage[main]: Unscheduling all events on Stage[main] �[mNotice: Applied catalog in 5.47 seconds

proxysql class Upgrading to version 2.0 Package "proxysql" is expected to be installed Failure/Error: it { is_expected.to be_installed } expected Package "proxysql" to be installed

proxysql class Upgrading to version 2.0 Service "proxysql" is expected to be enabled Failure/Error: it { is_expected.to be_enabled } expected Service "proxysql" to be enabled

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

proxysql class Upgrading to version 2.0 Command "proxysql --version" exit_status is expected to eq 0 Failure/Error: its(:exit_status) { is_expected.to eq 0 } expected: 0 got: 127 (compared using ==)

proxysql class Upgrading to version 2.0 Command "proxysql --version" stdout is expected to match /^ProxySQL version 2\.0\./ Failure/Error: its(:stdout) { is_expected.to match %r{^ProxySQL version 2\.0\.} } expected "" to match /^ProxySQL version 2\.0\./ Diff: @@ -1 +1 @@ -/^ProxySQL version 2\.0\./ +""

proxysql class extended testing works idempotently with no errors Failure/Error: apply_manifest(pp, catch_failures: true) Beaker::Host::CommandFailure: Host 'ubuntu1804-64-puppet7.example.com' exited with 1 running: puppet apply --verbose --detailed-exitcodes /tmp/apply_manifest_182801663.pp.KzfsGt Last 10 lines of output were: Info: Loading facts Info: Loading facts Info: Loading facts Info: Loading facts Info: Loading facts Info: Loading facts Info: Loading facts Error: Evaluation Error: Left match operand must result in a String value. Got an Undef Value. (file: /tmp/apply_manifest_182801663.pp.KzfsGt, line: 48, column: 10) on node ubuntu1804-64-puppet7.example.com

proxysql class extended testing Package "proxysql" is expected to be installed Failure/Error: it { is_expected.to be_installed } expected Package "proxysql" to be installed

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