[check_postgres] install (test) problems
Rob Sargent
rsargent at xmission.com
Tue May 19 18:49:01 UTC 2009
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.
>
>
>
More information about the Check_postgres
mailing list