[check_postgres] install (test) problems

[Rob Sargent]

OK.  Exported PGBINDIR and ran make clean; perl Makefile.PL; make; make 
test;
Must better but still have errors:


    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: Set the environment variable TEST_SIGNATURE to
    enable this test
    t/00_test_tester..........# Creating database in directory
    "test_database_check_postgres"
    Creating new symlink socket at /tmp/cptesting_socket
    t/00_test_tester..........ok
    t/02_autovac_freeze.......ok
    t/02_backends.............ok 14/52
    #   Failed test 'Action 'backends' with the 'noidle' option returns
    expected result'
    #   in t/02_backends.t at line 86.
    #                   'POSTGRES_BACKENDS OK:
    (host:/tmp/cptesting_socket) 1 of 10 connections (10%) | time=0.03 
    postgres=1
    # '
    #     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ 2 of 10
    connections)'
    t/02_backends.............NOK 19
    #   Failed test 'Action 'backends' with the 'noidle' option returns
    expected result'
    #   in t/02_backends.t at line 90.
    #                   'POSTGRES_BACKENDS OK:
    (host:/tmp/cptesting_socket) 2 of 10 connections (20%) | time=0.03 
    postgres=2
    # '
    #     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ 3 of 10
    connections)'
    t/02_backends.............NOK 20
    #   Failed test 'Action 'backends' with the 'noidle' option returns
    expected result'
    #   in t/02_backends.t at line 93.
    #                   'POSTGRES_BACKENDS OK:
    (host:/tmp/cptesting_socket) 1 of 10 connections (10%) | time=0.03 
    postgres=1
    # '
    #     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ 2 of 10
    connections)'
    t/02_backends.............ok 52/52# Looks like you failed 3 tests of 52.
    t/02_backends.............dubious
        Test returned status 3 (wstat 768, 0x300)
    DIED. FAILED tests 19-21
        Failed 3/52 tests, 94.23% okay
    t/02_bloat................ok
    t/02_checkpoint...........ok
    t/02_connection...........ok
    t/02_custom_query.........ok
    t/02_database_size........ok
    t/02_dbstats..............ok
    t/02_disabled_triggers....ok
    t/02_disk_space...........ok
    t/02_fsm_pages............ok
    t/02_fsm_relations........ok
    t/02_last_analyze.........ok
    t/02_last_vacuum..........ok
    t/02_listener.............ok
    t/02_locks................ok
    t/02_logfile..............ok
    t/02_new_version_cp.......ok
    t/02_new_version_pg.......ok
    t/02_prepared_txns........ok
    t/02_query_runtime........ok
    t/02_query_time...........ok
    t/02_relation_size........ok
    t/02_replicate_row........ok
    t/02_sequence.............ok
    t/02_settings_checksum....ok
    t/02_timesync.............ok
    t/02_txn_idle.............ok 9/13
    #   Failed test 'Action 'txn_idle' identifies idle'
    #   in t/02_txn_idle.t at line 67.
    #                   'POSTGRES_TXN_IDLE OK:
    (host:/tmp/cptesting_socket) no idle in transaction | time=0.02
    # '
    #     doesn't match '(?-xism:longest idle in txn: \d+s)'
    t/02_txn_idle.............NOK 12# Looks like you failed 1 test of 13.
    t/02_txn_idle.............dubious
        Test returned status 1 (wstat 256, 0x100)
    DIED. FAILED test 12
        Failed 1/13 tests, 92.31% okay
    t/02_txn_time.............ok 8/14
    #   Failed test 'Action 'txn_time' identifies a one-second running txn'
    #   in t/02_txn_time.t at line 76.
    #                   'POSTGRES_TXN_TIME WARNING:
    (host:/tmp/cptesting_socket) longest txn: 0s | time=0.02  maxtime=0
    # '
    #     doesn't match '(?-xism:longest txn: 1s)'
    t/02_txn_time.............NOK 13# Looks like you failed 1 test of 14.
    t/02_txn_time.............dubious
        Test returned status 1 (wstat 256, 0x100)
    DIED. FAILED test 13
        Failed 1/14 tests, 92.86% okay
    t/02_txn_wraparound.......ok
    t/02_version..............ok
    t/02_wal_files............ok
    t/03_translations.........ok
    t/99_cleanup..............ok
    t/99_perlcritic...........skipped
            all skipped: Set the environment variable TEST_CRITIC to
    enable this test
    t/99_pod..................ok
            2/2 skipped: various reasons
    t/99_spellcheck...........skipped
            all skipped: Set the environment variable TEST_SPELL to
    enable this test
    Failed Test     Stat Wstat Total Fail  Failed  List of Failed
    ----------------------------------------------------------------------------------------------------
    t/02_backends.t    3   768    52    3   5.77%  19-21
    t/02_txn_idle.t    1   256    13    1   7.69%  12
    t/02_txn_time.t    1   256    14    1   7.14%  13
    3 tests and 2 subtests skipped.
    Failed 3/40 test scripts, 92.50% okay. 5/535 subtests failed, 99.07%
    okay.
    make: *** [test_dynamic] Error 255

Mostly pg.log has 'database xxx already exists' and a few (more surprising?)
"ERROR:  could not access file "$libdir/plperl": No such file or directory"

Greg Sabino Mullane wrote:
>> Correct initdb is not in my path.  But I'm not sure I want it to be.  I
>> have an instance postgres of postgres already and don't want another. 
>> Also the intended target of check_postgres is not on my machine. 
>> Perhaps I should just skip the 'make test' step and go to 'make install'?
>>     
>
> It's pretty safe, and won't interfere with any existing databases. The test sets
> up a private database, runs the tests, and then tears it down. Do a 'make clean'
>  at the end to remove all traces of it. You can tell it where initdb is by
> setting the PGBINDIR environment variable to the dir it lives in.
>
>
>