[check_postgres] make test check_postgres 2.20 problems

[blaise.jm at free.fr]

Hello,

I have currently 2 postgres versions installed on Redhat 5.8: 9.0.6 and 9.1.2.

-bash-3.2$ psql --version
psql (PostgreSQL) 9.1.2
contains support for command-line editing

When making the test for check_postgres (2.20), I've got several errors and I found that I had to export LANG=en_US.UTF-8 to eliminate most of them. 

But it seems to me that there are some critical issues remaining mostly due to the non recognition of the postgres version. Do you have any clue ?

Thanks for your help,

Jean-Marc


-bash-3.2$ make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_basic.................ok
t/00_signature.............skipped
        all skipped: Test skipped unless environment variable RELEASE_TESTING is set
t/00_test_tester...........skipped
        all skipped: Test skipped unless environment variable RELEASE_TESTING is set
t/01_validate_range........ok
t/02_autovac_freeze........# Creating database in directory "test_database_check_postgres"
t/02_autovac_freeze........ok
t/02_backends..............ok
t/02_bloat.................ok
t/02_checkpoint............ok 4/14# Looks like you planned 14 tests but only ran 13.
t/02_checkpoint............dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED test 14
        Failed 1/14 tests, 92.86% okay (less 6 skipped tests: 7 okay, 50.00%)
t/02_cluster_id............ok
t/02_commitratio...........ok 20/23
#   Failed test 'Action 'commitratio' with includeuser option returns nothing'
#   in t/02_commitratio.t at line 83.
#                   'POSTGRES_COMMITRATIO OK: DB "postgres" (host:/tmp/cptesting_socket) postgres: 94.92  | time=0.05s postgres=94.92;10
# '
#     doesn't match '(?-xism:No matching entries found due to user exclusion)'
# Looks like you failed 1 test of 23.
t/02_commitratio...........dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 23
        Failed 1/23 tests, 95.65% okay
t/02_connection............ok
t/02_custom_query..........ok
t/02_database_size.........ok 45/49
#   Failed test 'Action 'database_size' with includeuser option returns nothing'
#   in t/02_database_size.t at line 117.
#                   'POSTGRES_DATABASE_SIZE OK: DB "postgres" (host:/tmp/cptesting_socket) template0: 6169092 (6025 kB) template1: 6169092 (6025 kB) postgres: 5505848 (5377 kB)  | time=0.04s template0=6169092;10737418240 template1=6169092;10737418240; postgres=5505848;10737418240
# '
#     doesn't match '(?-xism:No matching entries found due to user exclusion)'
# Looks like you failed 1 test of 49.
t/02_database_size.........dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 49
        Failed 1/49 tests, 97.96% okay
t/02_dbstats...............ok
t/02_disabled_triggers.....ok
t/02_disk_space............ok
t/02_fsm_pages.............ok
        3/7 skipped: Cannot test fsm_pages completely on Postgres 8.4 or higher
t/02_fsm_relations.........ok
        3/7 skipped: Cannot test fsm_relations completely on Postgres 8.4 or higher
t/02_hitratio..............ok 21/23
#   Failed test 'Action 'hitratio' with includeuser option returns nothing'
#   in t/02_hitratio.t at line 83.
#                   'POSTGRES_HITRATIO OK: DB "postgres" (host:/tmp/cptesting_socket) postgres: 99.40  | time=0.05s postgres=99.40;10
# '
#     doesn't match '(?-xism:No matching entries found due to user exclusion)'
# Looks like you failed 1 test of 23.
t/02_hitratio..............dubious
        Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 23
        Failed 1/23 tests, 95.65% okay
t/02_last_analyze..........ok
t/02_last_vacuum...........ok
t/02_listener..............ok
        8/8 skipped: Cannot test listener on Postgres 9.0 or higher
t/02_locks.................ok
t/02_logfile...............WARNING:  invalid value for parameter "search_path": "cptest, public, pg_catalog"
DETAIL:  schema "cptest" does not exist
t/02_logfile...............ok
t/02_new_version_bc........ok
t/02_new_version_box.......ok
t/02_new_version_cp........ok 1/4
#   Failed test 'Action 'new_version_cp' returns warning for mismatched major version'
#   in t/02_new_version_cp.t at line 28.
#                   'POSTGRES_NEW_VERSION_CP UNKNOWN:  Could not download version information for check_postgres
# '
#     doesn't match '(?-xism:POSTGRES_NEW_VERSION_CP WARNING:  Please upgrade to version \d+\.\d+\.\d+ of check_postgres. You are running 1.2.3)'
Invalid version!?
# Looks like you planned 4 tests but only ran 2.
# Looks like you failed 1 test of 2 run.
# Looks like your test died just after 2.
t/02_new_version_cp........dubious
        Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-4
        Failed 3/4 tests, 25.00% okay
t/02_new_version_pg........ok 2/5
#   Failed test 'Action 'new_version_pg' returns critical for outdated Postgres revision'
#   in t/02_new_version_pg.t at line 31.
#                   'POSTGRES_NEW_VERSION_PG UNKNOWN:  Could not download version information for Postgres
# '
#     doesn't match '(?-xism:POSTGRES_NEW_VERSION_PG CRITICAL:.+Please upgrade to version 8.3.\d+ of Postgres)'
t/02_new_version_pg........NOK 3
#   Failed test 'Action 'new_version_pg' returns unknown for non-existent future version of Postgres'
#   in t/02_new_version_pg.t at line 35.
#                   'POSTGRES_NEW_VERSION_PG UNKNOWN:  Could not download version information for Postgres
# '
#     doesn't match '(?-xism:POSTGRES_NEW_VERSION_PG UNKNOWN:.+Your version of Postgres \(8.2.999\) appears to be ahead of the current release!)'
t/02_new_version_pg........NOK 4FAILED--Further testing stopped: Could not determine version!
make: *** [test_dynamic] Error 9