[check_postgres] failure of make test in

Wed Jul 5 20:36:58 UTC 2017

?  For 'make test', please report any failing tests to check_postgres at bucardo.org<mailto:check_postgres at bucardo.org>. The tests need to have some standard Postgres binaries available, such as 'initdb', 'psql', and 'pg_ctl'.

Hi,

I've just tried to install v2.22.0 on Centos5.11 and Centos6.7 with Pg 9.5.1 and Perl 5.18.4 and both failed. The output is very similar, 5.11 is on top and 6.7 is at the bottom. If you need more info let me know.

HTH,
Kevin

~/check_postgres-2.22.0 $ perl Makefile.PL
Configuring check_postgres 2.22.0
Checking if your kit is complete...
Looks good
Writing Makefile for check_postgres
Writing MYMETA.yml and MYMETA.json

~/check_postgres-2.22.0 $ make
make: Warning: File `Makefile' has modification time 60 s in the future
cp check_postgres.pl blib/script/check_postgres.pl
/opt/perl/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/check_postgres.pl
Manifying blib/man1/check_postgres.1p
make: warning:  Clock skew detected.  Your build may be incomplete.

~/check_postgres-2.22.0 $ make test
make: Warning: File `Makefile' has modification time 58 s in the future
PERL_DL_NONLAZY=1 /opt/perl/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_basic.t ............... ok
t/00_signature.t ........... skipped: Test skipped unless environment variable RELEASE_TESTING is set
t/00_test_tester.t ......... skipped: Test skipped unless environment variable RELEASE_TESTING is set
t/01_validate_range.t ...... 1/144
#   Failed test 'Should have warning == 1 exobytes'
#   at t/01_validate_range.t line 150.
#          got: '1152921504606846976'
#     expected: '1.15292150460685e+18'

#   Failed test 'Should have critical == 42 exobytes'
#   at t/01_validate_range.t line 151.
#          got: '4.8422703193487573e+19'
#     expected: '4.84227031934876e+19'

#   Failed test 'Should have warning == 1 zettabytes'
#   at t/01_validate_range.t line 158.
#          got: '1.1805916207174113e+21'
#     expected: '1.18059162071741e+21'

#   Failed test 'Should have critical == 42 zettaytes'
#   at t/01_validate_range.t line 159.
#          got: '4.95848480701312747e+22'
#     expected: '4.95848480701313e+22'
# Looks like you failed 4 tests of 144.
t/01_validate_range.t ...... Dubious, test returned 4 (wstat 1024, 0x400)
Failed 4/144 subtests
t/02_autovac_freeze.t ...... # Creating database in directory "test_database_check_postgres"
Creating new symlink socket at /tmp/cptesting_socket
t/02_autovac_freeze.t ...... ok
t/02_backends.t ............ ok
t/02_bloat.t ............... ok
t/02_checkpoint.t .......... 8/14 # Looks like you planned 14 tests but ran 13.
t/02_checkpoint.t .......... Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 1/14 subtests
        (less 6 skipped subtests: 7 okay)
t/02_cluster_id.t .......... ok
t/02_commitratio.t ......... ok
t/02_connection.t .......... ok
t/02_custom_query.t ........ ok
t/02_database_size.t ....... ok
t/02_dbstats.t ............. 3/42
#   Failed test 'Action 'dbstats' finds stats for database template0'
#   at t/02_dbstats.t line 39.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:dbname:template0)'

#   Failed test 'Action 'dbstats' finds stats for database template1'
#   at t/02_dbstats.t line 39.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:dbname:template1)'

#   Failed test 'Action 'dbstats' finds stats for database postgres'
#   at t/02_dbstats.t line 39.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:dbname:postgres)'

#   Failed test 'Action 'dbstats' finds stats for database ardala'
#   at t/02_dbstats.t line 39.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:dbname:ardala)'

#   Failed test 'Action 'dbstats' finds stats for database beedeebeedee'
#   at t/02_dbstats.t line 39.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:dbname:beedeebeedee)'

#   Failed test 'Action 'dbstats' retrieves stats for backends'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bbackends\b)'

#   Failed test 'Action 'dbstats' returns integer for backends'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bbackends:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for commits'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bcommits\b)'

#   Failed test 'Action 'dbstats' returns integer for commits'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bcommits:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for rollbacks'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\brollbacks\b)'

#   Failed test 'Action 'dbstats' returns integer for rollbacks'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\brollbacks:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for read'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bread\b)'

#   Failed test 'Action 'dbstats' returns integer for read'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bread:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for hit'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bhit\b)'

#   Failed test 'Action 'dbstats' returns integer for hit'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bhit:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for idxscan'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxscan\b)'

#   Failed test 'Action 'dbstats' returns integer for idxscan'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxscan:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for idxtupread'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxtupread\b)'

#   Failed test 'Action 'dbstats' returns integer for idxtupread'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxtupread:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for idxtupfetch'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxtupfetch\b)'

#   Failed test 'Action 'dbstats' returns integer for idxtupfetch'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxtupfetch:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for idxblksread'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxblksread\b)'

#   Failed test 'Action 'dbstats' returns integer for idxblksread'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxblksread:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for idxblkshit'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxblkshit\b)'

#   Failed test 'Action 'dbstats' returns integer for idxblkshit'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bidxblkshit:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for seqscan'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bseqscan\b)'

#   Failed test 'Action 'dbstats' returns integer for seqscan'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bseqscan:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for seqtupread'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bseqtupread\b)'

#   Failed test 'Action 'dbstats' returns integer for seqtupread'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bseqtupread:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for ret'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bret\b)'

#   Failed test 'Action 'dbstats' returns integer for ret'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bret:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for fetch'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bfetch\b)'

#   Failed test 'Action 'dbstats' returns integer for fetch'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bfetch:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for ins'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bins\b)'

#   Failed test 'Action 'dbstats' returns integer for ins'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bins:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for upd'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bupd\b)'

#   Failed test 'Action 'dbstats' returns integer for upd'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bupd:\d+\b)'

#   Failed test 'Action 'dbstats' retrieves stats for del'
#   at t/02_dbstats.t line 47.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bdel\b)'

#   Failed test 'Action 'dbstats' returns integer for del'
#   at t/02_dbstats.t line 48.
#                   'ERROR: FATAL:  database "nms" does not exist
# '
#     doesn't match '(?^:\bdel:\d+\b)'
# Looks like you failed 39 tests of 42.
t/02_dbstats.t ............. Dubious, test returned 39 (wstat 9984, 0x2700)
Failed 39/42 subtests
t/02_disabled_triggers.t ... ok
t/02_disk_space.t .......... skipped: Skipping disk_space tests because df does not work
t/02_fsm_pages.t ........... ok
t/02_fsm_relations.t ....... ok
t/02_hitratio.t ............ ok
t/02_last_analyze.t ........ ok
t/02_last_vacuum.t ......... ok
t/02_listener.t ............ ok
t/02_locks.t ............... ok
t/02_logfile.t ............. ok
t/02_new_version_bc.t ...... ok
t/02_new_version_box.t ..... ok
t/02_new_version_cp.t ...... ok
t/02_new_version_pg.t ...... ok
t/02_new_version_tnm.t ..... ok
t/02_pgagent_jobs.t ........ ok
t/02_pgbouncer_checksum.t .. ok
t/02_prepared_txns.t ....... ok
t/02_query_runtime.t ....... ok
t/02_query_time.t .......... ok
t/02_relation_size.t ....... ok
t/02_replicate_row.t ....... 18/19
#   Failed test 'Action 'replicate_row' works when rows match, with MRTG output'
#   at t/02_replicate_row.t line 144.
#          got: '2
# 0
#
#
# '
#     expected: '1
# 0
#
#
# '
t/02_replicate_row.t ....... 19/19 # Looks like you failed 1 test of 19.
t/02_replicate_row.t ....... Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/19 subtests
t/02_same_schema.t ......... # Creating database in directory "test_database_check_postgres2"
Creating new symlink socket at /tmp/cptesting_socket2
# Creating database in directory "test_database_check_postgres3"
Creating new symlink socket at /tmp/cptesting_socket3
t/02_same_schema.t ......... ok
t/02_sequence.t ............ ok
t/02_settings_checksum.t ... ok
t/02_slony_status.t ........ ok
t/02_timesync.t ............ ok
t/02_txn_idle.t ............ # Connected as 5432:/tmp/cptesting_socket:postgres
t/02_txn_idle.t ............ ok
t/02_txn_time.t ............ ok
t/02_txn_wraparound.t ...... ok
t/02_version.t ............. ok
t/02_wal_files.t ........... ok
t/03_translations.t ........ skipped: Test skipped unless environment variable RELEASE_TESTING is set
t/04_timeout.t ............. ok
t/05_docs.t ................ ok
t/99_cleanup.t ............. ok

Test Summary Report
-------------------
t/01_validate_range.t    (Wstat: 1024 Tests: 144 Failed: 4)
  Failed tests:  32-35
  Non-zero exit status: 4
t/02_checkpoint.t        (Wstat: 65280 Tests: 13 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 14 tests but ran 13.
t/02_dbstats.t           (Wstat: 9984 Tests: 42 Failed: 39)
  Failed tests:  4-42
  Non-zero exit status: 39
t/02_replicate_row.t     (Wstat: 256 Tests: 19 Failed: 1)
  Failed test:  18
  Non-zero exit status: 1
Files=50, Tests=887, 299 wallclock secs ( 0.28 usr  0.07 sys + 62.28 cusr 15.29 csys = 77.92 CPU)
Result: FAIL
Failed 4/50 test programs. 44/887 subtests failed.
make: *** [test_dynamic] Error 255

~/check_postgres-2.22.0 $ which perl
/opt/perl/bin/perl

~/check_postgres-2.22.0 $ perl -v

This is perl 5, version 18, subversion 4 (v5.18.4) built for x86_64-linux-thread-multi-ld

Copyright 1987-2013, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

~/check_postgres-2.22.0 $ cat /etc/redhat-release
CentOS release 5.11 (Final)
nmsdev-kevin:~/check_postgres-2.22.0

~/check_postgres-2.22.0 $ psql --version
psql (PostgreSQL) 9.5.1

~/check_postgres-2.22.0 $ which initdb pg_ctl psql
/opt/pgsql-9.5/bin/initdb
/opt/pgsql-9.5/bin/pg_ctl
/opt/pgsql-9.5/bin/psql

###################################

# same version of perl
# same version of postgresql

$ cat /etc/redhat-release
CentOS release 6.7 (Final)

# deleted dir
# tar -x

# perl Makefile.PL
# make
$ make test
...
Test Summary Report
-------------------
t/01_validate_range.t    (Wstat: 1024 Tests: 144 Failed: 4)
  Failed tests:  32-35
  Non-zero exit status: 4
t/02_checkpoint.t        (Wstat: 65280 Tests: 13 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 14 tests but ran 13.
t/02_dbstats.t           (Wstat: 9984 Tests: 42 Failed: 39)
  Failed tests:  4-42
  Non-zero exit status: 39
Files=50, Tests=887, 260 wallclock secs ( 0.38 usr  0.07 sys + 61.34 cusr 13.76 csys = 75.55 CPU)
Result: FAIL
Failed 3/50 test programs. 43/887 subtests failed.
make: *** [test_dynamic] Error 255

###################################
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20170705/028fbc3b/attachment-0001.html>