Starting a Vagrant VM for Percona-toolkit testing

init_puppet.pp

Exec {
  path => "/usr/bin:/usr/sbin/:/bin:/sbin"
}

host { "localhost":
  ensure  => present,
  ip      => '127.0.0.1',
}

host { $host_name:
  ensure => present,
  ip     => $ip_addr,
}

service{ 'iptables':
  ensure => stopped,
  enable => false
}

package{
  [
    'bzr',
  ]:
    ensure => present,
}

package{
  [
    'perl-ExtUtils-MakeMaker',
    'perl-CPAN',
  ]:
  ensure => present,
}

# Satisfy check in util/check-dev-env
package{
  [
    'perl-DBD-MySQL',
    'perl-File-Slurp',
    'perl-Test-Simple',
    'perl-Time-HiRes',
    'perl-JSON'
  ]:
  ensure => present,
}

# packages needed for running tests
package{
  [
    'strace',
    'perl-IPC-Cmd',

  ]:
  ensure => present,
}

# tar -zxf /downloads/mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
exec { 'tar -zxf /downloads/mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz':
  cwd     => '/home/vagrant',
  creates => '/home/vagrant/mysql-5.6.13-linux-glibc2.5-x86_64',
}

# mkdir ~/mysql-bin
file { '/home/vagrant/mysql-bin':
  ensure => directory,
}

# ln -s ~/mysql-5.6.13-linux-glibc2.5-x86_64 ~/mysql-bin/mysql-5.6
file { '/home/vagrant/mysql-bin/mysql-5.6':
  ensure => link,
  target => '/home/vagrant/mysql-5.6.13-linux-glibc2.5-x86_64',
}

file{'/etc/profile.d/pt-sandbox.sh':
  ensure  => present,
  content => " export PERCONA_TOOLKIT_SANDBOX=/home/vagrant/mysql-bin/mysql-5.6 \n export PERCONA_TOOLKIT_BRANCH=/pt \n export PATH=\$PERCONA_TOOLKIT_SANDBOX/bin:\$PATH ",
}

shell

percona-toolkit-001 zipkid$ vagrant ssh
Welcome to your Vagrant-built virtual machine.

[vagrant@pt01 ~]$ /pt/sandbox/test-env start
Starting MySQL test server on port 12345... OK (1s)
Starting MySQL test server on port 12346... OK (1s)
Starting MySQL test server on port 12347... OK (1s)
Loading sakila database... OK
LOAD DATA LOCAL INFILE is enabled
Waiting for replication to finish.... OK
Percona Toolkit test environment started with MySQL v5.6.

[vagrant@pt01 ~]$ prove -rs /pt/t/
/pt/t/lib/OobNibbleIterator.t ......................... ok
/pt/t/lib/Advisor.t ................................... ok
/pt/t/lib/Percona/WebAPI/Representation.t ............. 1/?
#   Failed test 'as_json'
#   at /pt/t/lib/Percona/WebAPI/Representation.t line 28.
#          got: '{"versions":{"Perl":"5.10.1"},"hostname":"pt","id":"123"}'
#     expected: '{"versions":{"Perl":"5.10.1"},"id":"123","hostname":"pt"}'
# Looks like you failed 1 test of 2.
/pt/t/lib/Percona/WebAPI/Representation.t ............. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/2 subtests
/pt/t/pt-config-diff/basics.t ......................... ok
/pt/t/pt-visual-explain/pt-visual-explain.t ........... ok
/pt/t/lib/RawLogParser.t .............................. ok
/pt/t/pt-online-schema-change/rename_columns.t ........ ok
/pt/t/lib/Schema.t .................................... ok
/pt/t/lib/TableUsage.t ................................ ok

tests

[vagrant@pt01 ~]$ time SLOW_TESTS=1 PT_PERL_LIB=/pt/lib prove -rs /pt/t/
/pt/t/pt-table-checksum/issue_388.t ................... ok
/pt/t/pt-mysql-summary/pt-mysql-summary.t ............. ok
/pt/t/pt-query-digest/issue_360.t ..................... ok
/pt/t/pt-config-diff/basics.t ......................... ok
/pt/t/pt-table-sync/master_master.t ................... # Starting master-master servers...
/pt/t/pt-table-sync/master_master.t ................... 1/4 # Stopping master-master servers...
/pt/t/pt-table-sync/master_master.t ................... ok
/pt/t/lib/DuplicateKeyFinder.t ........................ ok
/pt/t/pt-online-schema-change/charset.t ............... ok
/pt/t/pt-duplicate-key-checker/issue_298.t ............ ok
/pt/t/lib/Lmo/unimport.t .............................. ok
/pt/t/lib/bash/report_formatting.t .................... ok
/pt/t/pt-table-checksum/run_time.t .................... ok
/pt/t/pt-agent/send_data.t ............................ ok
/pt/t/pt-visual-explain/explain-output.t .............. ok
/pt/t/pt-query-digest/sample.t ........................ ok
/pt/t/pt-archiver/issue_131.t ......................... ok
/pt/t/lib/CleanupTask.t ............................... ok
/pt/t/lib/TextResultSetParser.t ....................... ok
/pt/t/pt-archiver/basics.t ............................ ok
/pt/t/pt-table-usage/create_table_definitions.t ....... ok
/pt/t/pt-heartbeat/basics.t ........................... 23/? # KILL 656 /* db: test */
# KILL 657 /* db: test */
/pt/t/pt-heartbeat/basics.t ........................... ok
/pt/t/lib/MockSyncStream.t ............................ ok
/pt/t/pt-agent/schedule_services.t .................... ok
/pt/t/pt-table-sync/compare_conflict_col.t ............ ok
/pt/t/pt-slave-delay/standard_options.t ............... ok
/pt/t/pt-table-sync/replicate.t ....................... ok
/pt/t/lib/MasterSlave.t ............................... 1/? # Starting MySQL test server on port 2900... OK (1s)
# Starting MySQL test server on port 2903... OK (1s)
# Starting MySQL test server on port 2901... OK (3s)
# Starting MySQL test server on port 2902... OK (1s)
/pt/t/lib/MasterSlave.t ............................... 48/? # Stopping MySQL test server on port 2903... OK (4s)
# Stopping MySQL test server on port 2902... OK (4s)
# Stopping MySQL test server on port 2901... OK (4s)
# Stopping MySQL test server on port 2900... OK (4s)
/pt/t/lib/MasterSlave.t ............................... ok
/pt/t/lib/CompareQueryTimes.t ......................... ok
/pt/t/pt-table-sync/issue_218.t ....................... ok
/pt/t/lib/Lmo/init_arg.t .............................. ok
/pt/t/pt-table-checksum/skip_innodb.t ................. skipped: Cannot disable InnoDB in MySQL 5.6
/pt/t/lib/TableSyncStream.t ........................... ok
/pt/t/lib/Lmo/coerce.t ................................ ok
/pt/t/lib/Processlist.t ............................... ok
/pt/t/lib/Percona/WebAPI/Representation.t ............. 1/?
#   Failed test 'as_json'
#   at /pt/t/lib/Percona/WebAPI/Representation.t line 28.
#          got: '{"versions":{"Perl":"5.10.1"},"hostname":"pt","id":"123"}'
#     expected: '{"versions":{"Perl":"5.10.1"},"id":"123","hostname":"pt"}'
# Looks like you failed 1 test of 2.
/pt/t/lib/Percona/WebAPI/Representation.t ............. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/2 subtests
/pt/t/pt-archiver/bulk_insert.t ....................... 10/?
#   Failed test '--bulk-insert inserted the data'
#   at /pt/t/pt-archiver/bulk_insert.t line 115.

#   Failed test '--bulk-insert can handle ß'
#   at /pt/t/pt-archiver/bulk_insert.t line 122.
#          got: ''
#     expected: 'ß'
/pt/t/pt-archiver/bulk_insert.t ....................... 18/? # Looks like you failed 2 tests of 18.
/pt/t/pt-archiver/bulk_insert.t ....................... Dubious, test returned 2 (wstat 512, 0x200)
Failed 2/18 subtests
/pt/t/lib/CompareResults.t ............................ ok
/pt/t/lib/RowDiff.t ................................... ok
/pt/t/lib/Schema.t .................................... ok
/pt/t/lib/bash/collect.t .............................. ok
/pt/t/pt-visual-explain/explain-to-tree.t ............. ok
/pt/t/pt-archiver/issue_655.t ......................... ok
/pt/t/pt-archiver/version_check.t ..................... ok
/pt/t/pt-table-sync/traces.t .......................... # Master position: mysql-bin.000005 / 50746
/pt/t/pt-table-sync/traces.t .......................... ok
/pt/t/lib/OptionParser.t .............................. ok
/pt/t/pt-table-checksum/bugs.t ........................ 12/? # Starting MySQL test server on port 12348... OK (1s)
# Starting MySQL test server on port 12349... OK (1s)
/pt/t/pt-table-checksum/bugs.t ........................ 14/? # Stopping MySQL test server on port 12349... OK (2s)
# Stopping MySQL test server on port 12348... OK (5s)
/pt/t/pt-table-checksum/bugs.t ........................ ok
/pt/t/pt-query-digest/prepared_statements_analyses.t .. ok
/pt/t/lib/QueryReview.t ............................... ok
/pt/t/pt-show-grants/basics.t ......................... ok
/pt/t/pt-table-checksum/throttle.t .................... ok
/pt/t/pt-agent/replace_special_vars.t ................. ok
/pt/t/pt-pmp/pt-pmp.t ................................. ok
/pt/t/pt-table-checksum/replication_filters.t ......... # Stopping 12346 and 12347 to reconfigure them with replication filters
/pt/t/pt-table-checksum/replication_filters.t ......... 4/12 # Restarting the slaves again to remove the replication filters
# Restarting 12345 to add binlog_ignore_db filter
/pt/t/pt-table-checksum/replication_filters.t ......... 6/12 # Restarting master to reconfigure with binlog-do-db filter only
/pt/t/pt-table-checksum/replication_filters.t ......... 7/12 # Restoring original sandbox server configuration
/pt/t/pt-table-checksum/replication_filters.t ......... ok
/pt/t/pt-fk-error-logger/basics.t ..................... ok
/pt/t/pt-online-schema-change/bugs.t .................. ok
/pt/t/pt-table-sync/replicate_do_db.t ................. # Restarting slave 12346 with replicate-do-db=test1
/pt/t/pt-table-sync/replicate_do_db.t ................. 2/9 # MySQL processes on master: 185, 189, 191
# MySQL processes on master: 185, 189, 191
# Reconfiguring instance 12346 without replication filters
/pt/t/pt-table-sync/replicate_do_db.t ................. ok
/pt/t/pt-online-schema-change/rename_columns.t ........ ok
/pt/t/pt-archiver/indexes.t ........................... ok
/pt/t/lib/bash/daemon.t ............................... ok
/pt/t/pt-online-schema-change/option_sanity.t ......... ok
/pt/t/lib/TableParser.t ............................... ok
/pt/t/lib/MySQLStatusWaiter.t ......................... ok
/pt/t/pt-show-grants/issue_445.t ...................... ok
/pt/t/lib/PodParser.t ................................. ok
/pt/t/lib/bash/report_mysql_info.t .................... ok
/pt/t/pt-online-schema-change/ansi_quotes.t ........... ok
/pt/t/lib/NibbleIterator.t ............................ ok
/pt/t/pt-show-grants/all_grants.t ..................... ok
/pt/t/lib/Daemon.t .................................... ok
/pt/t/lib/TableNibbler.t .............................. ok
/pt/t/pt-query-digest/review.t ........................ ok
/pt/t/pt-table-sync/specify_column_or_index.t ......... ok
/pt/t/lib/MySQLConfigComparer.t ....................... ok
/pt/t/lib/RawLogParser.t .............................. ok
/pt/t/pt-table-checksum/settings.t .................... ok
/pt/t/pt-online-schema-change/metadata_locks.t ........ ok
/pt/t/lib/Runtime.t ................................... ok
/pt/t/lib/Lmo/role.t .................................. skipped: Can't load Role::Tiny, not testing Roles
/pt/t/pt-archiver/issue_1229.t ........................ ok
/pt/t/pt-archiver/plugin.t ............................ ok
/pt/t/pt-table-checksum/filters.t ..................... ok
/pt/t/pt-upgrade/query_time_diffs.t ................... ok
/pt/t/pt-table-sync/force_index.t ..................... ok
/pt/t/pt-online-schema-change/find_renamed_cols.t ..... ok
/pt/t/pt-query-digest/issue_565.t ..................... ok
/pt/t/lib/Percona/XtraDB/Cluster.t .................... skipped: PXC-only test
/pt/t/lib/TableUsage.t ................................ ok
/pt/t/pt-variable-advisor/show_variables_online.t ..... ok
/pt/t/pt-table-sync/columns.t ......................... ok
/pt/t/lib/IndexUsage.t ................................ ok
/pt/t/pt-ioprofile/pt-ioprofile.t ..................... ok
/pt/t/pt-archiver/safe_auto_increment.t ............... ok
/pt/t/pt-query-digest/group_by_order_by.t ............. ok
/pt/t/lib/VersionCheck.t .............................. ok
/pt/t/pt-archiver/res_fk.t ............................ ok
/pt/t/lib/RowDiff-custom.t ............................ I need a left_sth argument at /pt/lib/RowDiff.pm line 58.
# Looks like your test exited with 255 before it could output anything.
/pt/t/lib/RowDiff-custom.t ............................ Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 5/5 subtests
/pt/t/pt-query-digest/explain.t ....................... ok
/pt/t/pt-query-digest/explain_partitions.t ............ ok
/pt/t/pt-slave-restart/pt-slave-restart.t ............. ok
/pt/t/pt-table-sync/hex_blob.t ........................ ok
/pt/t/lib/Progress.t .................................. ok
/pt/t/lib/TableSyncNibble.t ........................... ok
/pt/t/pt-table-sync/wait.t ............................ ok
/pt/t/pt-agent/make_new_crontab.t ..................... ok
/pt/t/pt-online-schema-change/plugin.t ................ ok
/pt/t/lib/Lmo/meta.t .................................. ok
/pt/t/pt-table-usage/explain_extended.t ............... ok
/pt/t/lib/RowChecksum.t ............................... ok
/pt/t/pt-archiver/dest.t .............................. ok
/pt/t/pt-variable-advisor/option_sanity.t ............. ok
/pt/t/pt-visual-explain/pt-visual-explain.t ........... ok
/pt/t/pt-table-sync/sync_to_differnt_db.t ............. ok
/pt/t/pt-table-sync/issue_560.t ....................... ok
/pt/t/pt-deadlock-logger/create_dest_table.t .......... ok
/pt/t/pt-table-checksum/create_replicate_table.t ...... ok
/pt/t/lib/MySQLConfig.t ............................... ok
/pt/t/pt-upgrade/diff_query_times.t ................... ok
/pt/t/pt-table-sync/issue_616.t ....................... ok
/pt/t/pt-fk-error-logger/get_fk_error.t ............... ok
/pt/t/pt-slave-delay/issue_1169.t ..................... ok
/pt/t/pt-query-digest/genlog_analyses.t ............... ok
/pt/t/pt-align/pt-align.t ............................. ok
/pt/t/lib/Percona/XtraDB/Cluster-no-PXC.t ............. # Starting master1
/pt/t/lib/Percona/XtraDB/Cluster-no-PXC.t ............. 1/? # Stopping MySQL test server on port 12348... OK (4s)
/pt/t/lib/Percona/XtraDB/Cluster-no-PXC.t ............. ok
/pt/t/lib/ExecutionThrottler.t ........................ ok
/pt/t/pt-online-schema-change/check_alter.t ........... ok
/pt/t/pt-query-digest/resume.t ........................ ok
/pt/t/lib/bash/tmpdir.t ............................... ok
/pt/t/pt-archiver/pxc.t ............................... skipped: PXC tests
/pt/t/lib/QueryIterator.t ............................. ok
/pt/t/pt-table-sync/issue_631.t ....................... ok
/pt/t/pt-index-usage/save_results.t ................... ok
/pt/t/pt-archiver/issue_1152.t ........................ skipped: issue 1152
/pt/t/pt-online-schema-change/alter_active_table.t .... ok
/pt/t/pt-deadlock-logger/clear_deadlocks.t ............ ok
/pt/t/pt-table-checksum/resume.t ...................... ok
/pt/t/pt-kill/kill.t .................................. ok
/pt/t/lib/ReplicaLagWaiter.t .......................... ok
/pt/t/pt-table-checksum/fnv_64.t ...................... skipped: No FNV_64 UDF lib
/pt/t/pt-kill/standard_options.t ...................... ok
/pt/t/lib/Advisor.t ................................... ok
/pt/t/lib/CopyRowsInsertSelect.t ...................... ok
/pt/t/pt-table-sync/option_sanity.t ................... ok
/pt/t/pt-stalk/option_sanity.t ........................ ok
/pt/t/pt-query-digest/issue_1186.t .................... ok
/pt/t/pt-query-digest/attrib_inheritance.t ............ ok
/pt/t/pt-archiver/file.t .............................. ok
/pt/t/lib/Percona/WebAPI/Client.t ..................... ok
/pt/t/pt-online-schema-change/pxc.t ................... skipped: PXC tests
/pt/t/pt-duplicate-key-checker/basics.t ............... ok
/pt/t/lib/bash/mysql_options.t ........................ ok
/pt/t/pt-query-digest/issue_232.t ..................... ok
/pt/t/pt-upgrade/compare_hosts.t ...................... ok
/pt/t/lib/SimpleTCPDumpParser.t ....................... ok
/pt/t/pt-deadlock-logger/basics.t ..................... ok
/pt/t/pt-query-digest/read_timeout.t .................. ok
/pt/t/lib/Lmo/handles.t ............................... ok
/pt/t/pt-kill/group_queries.t ......................... ok
/pt/t/lib/SQLParser.t ................................. ok
/pt/t/lib/TableSyncGroupBy.t .......................... ok
/pt/t/pt-online-schema-change/privs.t ................. ok
/pt/t/pt-archiver/delete_more.t ....................... ok
/pt/t/lib/QueryHistory.t .............................. ok
/pt/t/pt-table-checksum/chunk_index.t ................. ok
/pt/t/pt-kill/execute_command.t ....................... ok
/pt/t/pt-archiver/gt_n.t .............................. ok
/pt/t/pt-config-diff/reports.t ........................ ok
/pt/t/pt-table-sync/instrumentaiton.t ................. ok
/pt/t/pt-query-digest/rawlog_analyses.t ............... ok
/pt/t/lib/BinaryLogParser.t ........................... ok
/pt/t/pt-query-digest/version_check.t ................. ok
/pt/t/lib/GeneralLogParser.t .......................... ok
/pt/t/pt-table-sync/issue_262.t ....................... ok
/pt/t/lib/Quoter.t .................................... ok
/pt/t/lib/ChangeHandler.t ............................. ok
/pt/t/pt-archiver/purge.t ............................. ok
/pt/t/lib/Lmo/test.t .................................. ok
/pt/t/lib/Percona/Toolkit.t ........................... ok
/pt/t/pt-config-diff/customize.t ...................... ok
/pt/t/pt-online-schema-change/sanity_checks.t ......... ok
/pt/t/pt-upgrade/save_results.t ....................... ok
/pt/t/lib/QueryReportFormatter.t ...................... ok
/pt/t/pt-slave-delay/basics.t ......................... ok
/pt/t/lib/bash/log_warn_die.t ......................... ok
/pt/t/pt-kill/match.t ................................. ok
/pt/t/lib/Retry.t ..................................... ok
/pt/t/pt-table-checksum/issue_602.t ................... ok
/pt/t/pt-table-sync/issue_627.t ....................... ok
/pt/t/lib/Lmo/isa.t ................................... ok
/pt/t/lib/bash/collect_system_info.t .................. ok
/pt/t/pt-agent/run_agent.t ............................ skipped: Need to make start-service testable
/pt/t/pt-duplicate-key-checker/issue_331.t ............ ok
/pt/t/pt-archiver/issue_1166.t ........................ ok
/pt/t/pt-query-digest/collect_and_report_cycles.t ..... ok
/pt/t/lib/bash/safeguards.t ........................... ok
/pt/t/lib/bash/summary_common.t ....................... ok
/pt/t/pt-online-schema-change/cleanup.t ............... ok
/pt/t/lib/SlowLogWriter.t ............................. ok
/pt/t/pt-query-digest/processlist.t ................... ok
/pt/t/pt-table-sync/triggers.t ........................ 6/11 # Loading file and waiting for replication
/pt/t/pt-table-sync/triggers.t ........................ ok
/pt/t/pt-heartbeat/utc.t .............................. ok
/pt/t/pt-upgrade/run_time.t ........................... ok
/pt/t/pt-query-digest/verify_run_time.t ............... ok
/pt/t/pt-table-sync/issue_408.t ....................... ok
/pt/t/pt-query-digest/outliers.t ...................... ok
/pt/t/pt-find/pt-find.t ............................... ok
/pt/t/lib/ExplainAnalyzer.t ........................... ok
/pt/t/pt-table-checksum/issue_47.t .................... ok
/pt/t/lib/DSNParser.t ................................. 27/? # Setting SQL mode globally on 12345
# Old SQL mode: NO_ENGINE_SUBSTITUTION
# New SQL mode: NO_ZERO_DATE
/pt/t/lib/DSNParser.t ................................. ok
/pt/t/pt-table-sync/lock_level.t ...................... ok
/pt/t/pt-archiver/compact_col_vals.t .................. 1/4
#   Failed test 'Reset AUTO_INCREMENT'
#   at /pt/t/pt-archiver/compact_col_vals.t line 74.
#          got: '306'
#     expected: '16'
/pt/t/pt-archiver/compact_col_vals.t .................. 4/4 # Looks like you failed 1 test of 4.
/pt/t/pt-archiver/compact_col_vals.t .................. Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/4 subtests
/pt/t/pt-table-sync/char_chunking.t ................... ok
/pt/t/pt-table-sync/issue_996.t ....................... ok
/pt/t/pt-deadlock-logger/standard_options.t ........... ok
/pt/t/pt-table-sync/bugs.t ............................ ok
/pt/t/lib/Outfile.t ................................... ok
/pt/t/lib/QueryParser.t ............................... ok
/pt/t/lib/TCPRequestAggregator.t ...................... ok
/pt/t/pt-online-schema-change/skip_innodb.t ........... skipped: Cannot disable InnoDB in MySQL 5.6
/pt/t/lib/TableSyncer.t ............................... 54/? # KILL 4688 /* db: bidi */
/pt/t/lib/TableSyncer.t ............................... ok
/pt/t/lib/ProtocolParser.t ............................ ok
/pt/t/lib/Lmo/strict.t ................................ ok
/pt/t/pt-variable-advisor/advice.t .................... ok
/pt/t/pt-archiver/standard_options.t .................. ok
/pt/t/lib/UpgradeResults.t ............................ ok
/pt/t/pt-visual-explain/explain-parser.t .............. ok
/pt/t/pt-table-sync/issue_96.t ........................ ok
/pt/t/lib/TableChunker.t .............................. ok
/pt/t/pt-variable-advisor/show_variables_static.t ..... ok
/pt/t/pt-table-sync/bidirectional.t ................... ok
/pt/t/pt-table-sync/binlog_format.t ................... ok
/pt/t/pt-table-sync/issue_804.t ....................... ok
/pt/t/lib/SchemaIterator.t ............................ 1/?
#   Failed test 'Iterate all schema objects with dbh'
#   at /pt/t/lib/SchemaIterator.t line 101.
/pt/t/lib/SchemaIterator.t ............................ 2/?
#   Failed test 'Resume'
#   at /pt/t/lib/SchemaIterator.t line 101.

#   Failed test 'Resume from ignored table'
#   at /pt/t/lib/SchemaIterator.t line 101.
/pt/t/lib/SchemaIterator.t ............................ 37/? # Looks like you failed 3 tests of 37.
/pt/t/lib/SchemaIterator.t ............................ Dubious, test returned 3 (wstat 768, 0x300)
Failed 3/37 subtests
/pt/t/pt-table-checksum/error_handling.t .............. 7/? # Warning: Using a password on the command line interface can be insecure.
# Warning: Using a password on the command line interface can be insecure.
# Warning: Using a password on the command line interface can be insecure.
/pt/t/pt-table-checksum/error_handling.t .............. ok
/pt/t/pt-ioprofile/saved_samples.t .................... ok
/pt/t/lib/MockSth.t ................................... ok
/pt/t/pt-kill/basics.t ................................ 4/6
#   Failed test 'pt-kill still checked the processlist 4 times'
#   at /pt/t/pt-kill/basics.t line 103.
#          got: '3'
#     expected: '4'
# # 2013-09-09T21:45:47 /pt/t/pt-kill/basics.t starting
# # 2013-09-09T21:45:47 Connected to host h=localhost
# # 2013-09-09T21:45:47 Find spec: $VAR1 = {
#   all => undef,
#   busy_time => undef,
#   idle_time => undef,
#   ignore => {
#     Command => undef,
#     Host => undef,
#     Id => 5325,
#     Info => undef,
#     State => 'Locked',
#     User => undef,
#     db => undef
#   },
#   match => {
#     Command => undef,
#     Host => undef,
#     Info => undef,
#     State => undef,
#     User => undef,
#     db => undef
#   },
#   replication_threads => undef
# };
#
# # 2013-09-09T21:45:47 Run-time: 4 seconds at 1 second intervals
# # 2013-09-09T21:45:47 Checking processlist
# # 2013-09-09T21:45:47 Matched 0 queries
# # 2013-09-09T21:45:47 Sleeping 1 seconds after normal interval
# # 2013-09-09T21:45:48 Checking processlist
# # 2013-09-09T21:45:48 Matched 0 queries
# # 2013-09-09T21:45:48 Sleeping 1 seconds after normal interval
# # 2013-09-09T21:45:49 Checking processlist
# # 2013-09-09T21:45:49 Reconnected to h=localhost
# # 2013-09-09T21:45:52 Matched 0 queries
# # 2013-09-09T21:45:52 Sleeping 1 seconds after normal interval
# # 2013-09-09T21:45:53 /pt/t/pt-kill/basics.t ending
/pt/t/pt-kill/basics.t ................................ 6/6 # Looks like you failed 1 test of 6.
/pt/t/pt-kill/basics.t ................................ Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/6 subtests
/pt/t/pt-table-sync/basics.t .......................... ok
/pt/t/lib/MySQLProtocolParser.t ....................... 1/?
#   Failed test 'Saves errors by default'
#   at /pt/t/lib/MySQLProtocolParser.t line 1764.
#                   'Cannot open tcpdump032.txt: No such file or directory at /pt/t/lib/MySQLProtocolParser.t line 1753.
# '
#     doesn't match '(?-xism:had errors, will save them in )'
Use of uninitialized value in ref-to-glob cast at /pt/t/lib/MySQLProtocolParser.t line 1770.
# Tests were run but no plan was declared and done_testing() was not seen.
/pt/t/lib/MySQLProtocolParser.t ....................... Dubious, test returned 2 (wstat 512, 0x200)
Failed 1/79 subtests
/pt/t/lib/Safeguards.t ................................ ok
/pt/t/pt-table-checksum/standard_options.t ............ ok
/pt/t/pt-table-checksum/progress.t .................... ok
/pt/t/pt-index-usage/basics.t ......................... ok
/pt/t/pt-slave-delay/auto_restart.t ................... 1/? # Killing connection on slave1: 7 (Sleep)
/pt/t/pt-slave-delay/auto_restart.t ................... ok
/pt/t/pt-table-sync/issue_22.t ........................ ok
/pt/t/lib/bash/report_system_info.t ................... ok
/pt/t/pt-slave-find/pt-slave-find.t ................... ok
/pt/t/lib/WeightedAvgRate.t ........................... ok
/pt/t/pt-heartbeat/standard_options.t ................. ok
/pt/t/pt-table-checksum/pxc.t ......................... skipped: PXC tests
/pt/t/pt-table-sync/lock_and_rename.t ................. ok
/pt/t/pt-table-sync/issue_1052.t ...................... ok
/pt/t/pt-upgrade/diff_rows.t .......................... ok
/pt/t/pt-table-checksum/privs.t ....................... ok
/pt/t/pt-table-sync/check_privs.t ..................... ok
/pt/t/lib/Lmo/is.t .................................... ok
/pt/t/lib/Lmo/extends.t ............................... ok
/pt/t/pt-query-digest/continue_on_error.t ............. ok
/pt/t/lib/bash/parse_options.t ........................ ok
/pt/t/lib/TableChecksum.t ............................. ok
/pt/t/pt-fingerprint/basics.t ......................... ok
/pt/t/lib/bash/alt_cmds.t ............................. ok
/pt/t/lib/Lmo/buildargs.t ............................. ok
/pt/t/pt-table-sync/issue_920.t ....................... skipped: Pending solution
/pt/t/pt-archiver/issue_1225.t ........................ ok
/pt/t/pt-deadlock-logger/option_sanity.t .............. ok
/pt/t/pt-agent/basics.t ............................... Dubious, test returned 168 (wstat 43008, 0xa800)
No subtests run
/pt/t/pt-query-digest/variations.t .................... ok
/pt/t/pt-agent/get_services.t ......................... ok
/pt/t/pt-archiver/issue_524.t ......................... ok
/pt/t/pt-upgrade/compare_results.t .................... ok
/pt/t/lib/QueryRewriter.t ............................. ok
/pt/t/pt-diskstats/pt-diskstats.t ..................... ok
/pt/t/lib/TableSyncChunk.t ............................ ok
/pt/t/pt-index-usage/option_sanity.t .................. ok
/pt/t/lib/Pipeline.t .................................. ok
/pt/t/pt-table-checksum/ignore_columns.t .............. ok
/pt/t/pt-agent/write_services.t ....................... ok
/pt/t/pt-heartbeat/pxc.t .............................. skipped: PXC tests
/pt/t/pt-query-digest/history.t ....................... 5/? # KILL 600 /* db: test */
# KILL 601 /* db: percona_schema */
# KILL 602 /* db: test */
# KILL 603 /* db: test */
/pt/t/pt-query-digest/history.t ....................... ok
/pt/t/pt-table-checksum/basics.t ...................... ok
/pt/t/pt-query-digest/option_sanity.t ................. ok
/pt/t/lib/Lmo/object.t ................................ ok
/pt/t/lib/EventTimeline.t ............................. ok
/pt/t/pt-duplicate-key-checker/standard_options.t ..... ok
/pt/t/pt-show-grants/standard_options.t ............... ok
/pt/t/pt-archiver/bulk_delete.t ....................... ok
/pt/t/pt-query-digest/daemon.t ........................ ok
/pt/t/lib/OobNibbleIterator.t ......................... ok
/pt/t/pt-table-checksum/float_precision.t ............. ok
/pt/t/pt-kill/group_by.t .............................. ok
/pt/t/lib/Diskstats.t ................................. ok
/pt/t/lib/HTTP/Micro.t ................................ skipped: HTTP::Tiny is not installed
/pt/t/pt-duplicate-key-checker/clustered_keys.t ....... ok
/pt/t/lib/Lmo/required.t .............................. ok
/pt/t/pt-table-sync/diff_where.t ...................... ok
/pt/t/pt-heartbeat/multi_update_mode.t ................ ok
/pt/t/pt-table-sync/filters.t ......................... ok
/pt/t/pt-query-digest/issue_736.t ..................... ok
/pt/t/pt-query-digest/report_histogram.t .............. ok
/pt/t/pt-table-sync/issue_644.t ....................... ok
/pt/t/pt-config-diff/pxc.t ............................ skipped: PXC tests
/pt/t/pt-agent/init_agent.t ........................... ok
/pt/t/pt-duplicate-key-checker/issue_663.t ............ ok
/pt/t/pt-archiver/bugs.t .............................. ok
/pt/t/pt-table-sync/issue_634.t ....................... ok
/pt/t/pt-query-digest/slowlog_analyses.t .............. ok
/pt/t/lib/SlowLogParser.t ............................. ok
/pt/t/lib/CompareWarnings.t ........................... ok
/pt/t/pt-online-schema-change/basics.t ................ 86/? # Restoring sakila...
/pt/t/pt-online-schema-change/basics.t ................ ok
/pt/t/lib/Cxn.t ....................................... ok
/pt/t/pt-agent/run_service.t .......................... ok
/pt/t/pt-archiver/bulk_regular_insert.t ............... ok
/pt/t/pt-duplicate-key-checker/issue_1192.t ........... ok
/pt/t/pt-summary/pt-summary.t ......................... ok
/pt/t/pt-query-digest/standard_options.t .............. ok
/pt/t/pt-query-digest/run_time.t ...................... ok
/pt/t/lib/KeySize.t ................................... ok
/pt/t/pt-query-digest/mysql_analyses.t ................ ok
/pt/t/pt-stalk/plugin.t ............................... ok
/pt/t/pt-query-digest/issue_687.t ..................... ok
/pt/t/lib/EventAggregator.t ........................... ok
/pt/t/pt-stalk/pt-stalk.t ............................. ok
/pt/t/pt-query-digest/json.t .......................... ok
/pt/t/pt-table-checksum/option_sanity.t ............... ok
/pt/t/pt-table-checksum/chunk_size.t .................. ok
/pt/t/pt-table-sync/float_precision.t ................. ok
/pt/t/lib/Transformers.t .............................. ok
/pt/t/pt-query-digest/bugs.t .......................... ok
/pt/t/lib/FileIterator.t .............................. ok
/pt/t/pt-fifo-split/pt-fifo-split.t ................... ok
/pt/t/pt-upgrade/log_types.t .......................... ok
/pt/t/lib/Lmo/build.t ................................. ok
/pt/t/pt-query-digest/since_until.t ................... ok
/pt/t/pt-table-sync/standard_options.t ................ ok
/pt/t/pt-mext/pt-mext.t ............................... ok
/pt/t/pt-table-usage/basics.t ......................... ok
/pt/t/pt-table-sync/zero_chunk.t ...................... ok
/pt/t/pt-query-digest/issue_514.t ..................... ok
/pt/t/pt-archiver/check_slave_lag.t ................... skipped: Slave trick does not work on MySQL 5.6+
/pt/t/lib/VariableAdvisorRules.t ...................... ok
/pt/t/pt-deadlock-logger/bugs.t ....................... ok
/pt/t/pt-table-sync/issue_965.t ....................... ok
/pt/t/pt-upgrade/diff_warnings.t ...................... ok
/pt/t/lib/bash/collect_mysql_info.t ................... ok
/pt/t/lib/ReportFormatter.t ........................... ok
/pt/t/lib/TcpdumpParser.t ............................. ok
/pt/t/pt-table-sync/issue_1065.t ...................... ok
/pt/t/pt-query-digest/binlog_analyses.t ............... ok
/pt/t/pt-sift/pt-sift.t ............................... ok
/pt/t/pt-table-checksum/char_chunking.t ............... ok
/pt/t/lib/VersionParser.t ............................. ok

Test Summary Report
-------------------
/pt/t/lib/Percona/WebAPI/Representation.t           (Wstat: 256 Tests: 2 Failed: 1)
  Failed test:  1
  Non-zero exit status: 1
/pt/t/pt-archiver/bulk_insert.t                     (Wstat: 512 Tests: 18 Failed: 2)
  Failed tests:  14-15
  Non-zero exit status: 2
/pt/t/lib/RowDiff-custom.t                          (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 5 tests but ran 0.
/pt/t/pt-archiver/compact_col_vals.t                (Wstat: 256 Tests: 4 Failed: 1)
  Failed test:  3
  Non-zero exit status: 1
/pt/t/lib/SchemaIterator.t                          (Wstat: 768 Tests: 37 Failed: 3)
  Failed tests:  1, 28-29
  Non-zero exit status: 3
/pt/t/pt-kill/basics.t                              (Wstat: 256 Tests: 6 Failed: 1)
  Failed test:  5
  Non-zero exit status: 1
/pt/t/lib/MySQLProtocolParser.t                     (Wstat: 512 Tests: 79 Failed: 1)
  Failed test:  79
  Non-zero exit status: 2
  Parse errors: No plan found in TAP output
/pt/t/pt-agent/basics.t                             (Wstat: 43008 Tests: 0 Failed: 0)
  Non-zero exit status: 168
  Parse errors: No plan found in TAP output
Files=350, Tests=5189, 1387 wallclock secs ( 1.67 usr  2.33 sys + 117.40 cusr 148.36 csys = 269.76 CPU)
Result: FAIL

real  23m8.450s
user	1m59.304s
sys	2m31.297s

Vagrantfile

# -*- mode: ruby -*-
# vi: set ft=ruby :

hostname = 'pt01'
fqdn = 'pt01.vm.some.where'
ip_addr = '10.10.10.101'


Vagrant.configure("2") do |config|
  # All Vagrant configuration is done here. The most common configuration
  # options are documented and commented below. For a complete reference,
  # please see the online documentation at vagrantup.com.

  # Every Vagrant virtual environment requires a box to build off of.
  config.vm.box = "CentOS-6.4-x86_64-minimal"
  #config.vm.box = "CentOS-6.4-i386-minimal"

  # The url from where the 'config.vm.box' box will be fetched if it
  # doesn't already exist on the user's system.
  # config.vm.box_url = "http://domain.com/path/to/above.box"

  config.vm.define :pt01 do |pt01_config|
    pt01_config.vm.hostname = "#{fqdn}"
    pt01_config.vm.network :private_network, ip: "#{ip_addr}"

    pt01_config.vm.synced_folder "~/Downloads", "/downloads"

    pt01_config.vm.synced_folder "../../../Other/percona-toolkit", "/pt"
    pt01_config.vm.synced_folder "../../../github-puppet-modules", "/etc/puppet/modules"

    pt01_config.vm.provider :virtualbox do |vb|
      # vb.gui = true
      vb.customize ["modifyvm", :id, "--memory", "2048"]
      vb.customize ["modifyvm", :id, "--cpus", "2"]
    end

    pt01_config.vm.provision :puppet do |puppet|
      puppet.manifests_path = "manifests"
      puppet.manifest_file  = "init_puppet.pp"
      puppet.options = "--verbose --debug"
      puppet.facter = {
        'ip_addr' => "#{ip_addr}",
        'host_name' => "#{fqdn}"
      }
    end

  end
end