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_120136298.pp.ABLNLp 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 193.76 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_120452830.pp.tW1OKP 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.94 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 ==)