[check_postgres] compile help on check_postgres

Matt Hodson matth at geospiza.com
Mon Feb 1 22:09:08 UTC 2010


thanks! FYI pg version 8.2.13. more inline...

-------
Matt Hodson
Scientific Customer Support, Geospiza
(206) 633-4403, Ext. 111
http://www.geospiza.com




On Feb 1, 2010, at 1:48 PM, Greg Sabino Mullane wrote:

> On Mon, Feb 01, 2010 at 01:40:34PM -0800, Matt Hodson wrote:
>>
>>   1) there is no conf file or place to set variables that i can  
>> see. i'm
>>   running PG form a unique path.  where do i set that?  i'm  
>> thinking that
>>   there is a variable or dep i'm missing that will solve all my woes.
>
> What error are you seeing? check_postgres only needs to know about  
> the location
> of a workng psql binary.

i hardcoded it like so:
$PSQL = '/usr/local/geospiza/bin/psql';
>
>>   2) running 'perl makefile' gives:
>>
>>     $ perl Makefile.PL
>>     Configuring check_postgres 2.13.0
>>     Warning: prerequisite Test::More 0.61 not found. We have 0.47.
>
> This is the cause of the 'make test' failures later on. Upgrade  
> Test::More
> to something recent (0.61 came out in 2005) and the tests should  
> start working.

i used cpan to install:
cpan> install Test::More
cpan> install Time::HiRes

then re-ran 'make test' and got Perl-DBD-Pg errors (again, mine is a  
non standard install path) so i did:

% sudo yum perl-DBD-Pg

then re-ran 'make test' to get:

$ 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..........Creating new symlink socket at /tmp/ 
cptesting_socket
please use DBI functions for transaction handling at /usr/lib/perl5/ 
vendor_perl/5.8.3/i386-linux-thread-multi/DBD/Pg.pm line 169.
# No matching test file found for action "new_version_bc" (expected t/ 
02_new_version_bc.t)

#   Failed test 'Did not find a test for every action'
#   at t/00_test_tester.t line 44.
# Looks like you failed 1 test of 1.
t/00_test_tester..........dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 1
	Failed 1/1 tests, 0.00% okay
t/02_autovac_freeze.......please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_autovac_freeze.t  
line 26.
t/02_autovac_freeze.......ok
         8/8 skipped: Cannot test autovac_freeze on old Postgres  
versions
t/02_backends.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric ge (>=) at t/02_backends.t line  
23.
t/02_backends.............ok 18/53
t/02_backends.............NOK 19#   Failed test 'Action 'backends'  
with the 'noidle' option returns expected result'
#   at t/02_backends.t line 85.
#                   'POSTGRES_BACKENDS OK: (host:/tmp/ 
cptesting_socket) 2 of 10 connections (20%) | time=0.01   
'postgres'=2;9;9;0;10
# '
#     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ 1 of 10  
connections)'

#   Failed test 'Action 'backends' with the 'noidle' option returns  
expected result'
#   at t/02_backends.t line 89.
#                   'POSTGRES_BACKENDS OK: (host:/tmp/ 
cptesting_socket) 3 of 10 connections (30%) | time=0.01   
'postgres'=3;9;9;0;10
# '
#     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ 1 of 10  
connections)'
t/02_backends.............NOK 20
#   Failed test 'Action 'backends' with the 'noidle' option returns  
expected result'
#   at t/02_backends.t line 92.
#                   'POSTGRES_BACKENDS OK: (host:/tmp/ 
cptesting_socket) 3 of 10 connections (30%) | time=0.01   
'postgres'=3;9;9;0;10
# '
#     doesn't match '(?-xism:^POSTGRES_BACKENDS OK:.+ (?:1|2) of 10  
connections)'
t/02_backends.............ok 53/53Issuing rollback() for database  
handle being DESTROY'd without explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
Issuing rollback() for database handle being DESTROY'd without  
explicit disconnect().
# Looks like you failed 3 tests of 53.
t/02_backends.............dubious
	Test returned status 3 (wstat 768, 0x300)
DIED. FAILED tests 19-21
	Failed 3/53 tests, 94.34% okay (less 9 skipped tests: 41 okay, 77.36%)
t/02_bloat................please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_bloat................ok
t/02_checkpoint...........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_checkpoint...........ok
t/02_connection...........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_connection...........ok 11/12DBD::Pg::db do failed: ERROR:   
syntax error at or near "SELECT" at character 175 at t/CP_Testing.pm  
line 673.
# Looks like you planned 12 tests but ran 11.
# Looks like your test exited with 9 just after 11.
t/02_connection...........dubious
	Test returned status 9 (wstat 2304, 0x900)
DIED. FAILED test 12
	Failed 1/12 tests, 91.67% okay
t/02_custom_query.........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_custom_query.........ok
t/02_database_size........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_database_size.t  
line 26.
t/02_database_size........ok 1/49
t/02_database_size........NOK 2#   Failed test 'Action 'database_size'  
gives an error when run against an old Postgres version'
#   at t/02_database_size.t line 29.
#                   'POSTGRES_DATABASE_SIZE WARNING: DB  
"postgres" (host:/tmp/cptesting_socket) postgres: 4630232 (4522 kB)  
ardala: 3743748 (3656 kB) beedeebeedee: 3743748 (3656 kB) template0:  
3743748 (3656 kB) template1: 3743748 (3656 kB)  | time=0.01   
postgres=4630232 ardala=3743748 beedeebeedee=3743748 template0=3743748  
template1=3743748
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_database_size........ok 36/49# Looks like you failed 1 test of 49.
t/02_database_size........dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 2
	Failed 1/49 tests, 97.96% okay (less 47 skipped tests: 1 okay, 2.04%)
t/02_dbstats..............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_dbstats..............ok
t/02_disabled_triggers....please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/ 
02_disabled_triggers.t line 28.

#   Failed test 'Action 'disabled_triggers' gives an error when run  
against an old Postgres version'
#   at t/02_disabled_triggers.t line 31.
#                   'POSTGRES_DISABLED_TRIGGERS OK: DB  
"postgres" (host:/tmp/cptesting_socket) Disabled triggers: 0 | time=0.01
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_disabled_triggers....ok 13/13# Looks like you failed 1 test of 13.
t/02_disabled_triggers....dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 1
	Failed 1/13 tests, 92.31% okay (less 12 skipped tests: 0 okay, 0.00%)
t/02_disk_space...........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.

#   Failed test 'Action 'disk_space' identifies self'
t/02_disk_space...........NOK 1#   at t/02_disk_space.t line 27.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:POSTGRES_DISK_SPACE)'

t/02_disk_space...........NOK 2#   Failed test 'Action 'disk_space'  
identifies host'
#   at t/02_disk_space.t line 30.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:host:/tmp/cptesting_socket)'

t/02_disk_space...........NOK 3#   Failed test 'Action 'disk_space'  
reports file system'
#   at t/02_disk_space.t line 33.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:FS /.*? mounted on /.*? is using )'

t/02_disk_space...........NOK 4#   Failed test 'Action 'disk_space'  
reports usage'
#   at t/02_disk_space.t line 36.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism: is using \d*\.\d+ [A-Z]B of \d*\.\d+ [A- 
Z]B)'

t/02_disk_space...........NOK 5#   Failed test 'Action 'disk_space'  
notes plenty of available space'
#   at t/02_disk_space.t line 39.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:POSTGRES_DISK_SPACE OK)'

t/02_disk_space...........NOK 6#   Failed test 'Action 'disk_space'  
flags insufficient space'
#   at t/02_disk_space.t line 42.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:POSTGRES_DISK_SPACE WARNING:)'

#   Failed test 'Action 'disk_space' reports MRTG output'
#   at t/02_disk_space.t line 45.
#                   'ERROR: Invalid result from command "/bin/df -kP  
"../../var/log" 2>&1": /bin/df: `../../var/log': No such file or  
directory
# '
#     doesn't match '(?-xism:\A\d+\n0\n\n/.*\n)'
# Looks like you failed 7 tests of 7.
t/02_disk_space...........dubious
	Test returned status 7 (wstat 1792, 0x700)
DIED. FAILED tests 1-7
	Failed 7/7 tests, 0.00% okay
t/02_fsm_pages............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_fsm_pages............ok 3/7Use of uninitialized value in numeric  
ge (>=) at t/02_fsm_pages.t line 60.
t/02_fsm_pages............ok
t/02_fsm_relations........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_fsm_relations........ok 3/7Use of uninitialized value in numeric  
ge (>=) at t/02_fsm_relations.t line 60.
t/02_fsm_relations........ok
t/02_last_analyze.........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_last_analyze.t  
line 27.
t/02_last_analyze.........ok
         14/14 skipped: Cannot test last_analyze on old Postgres  
versions
t/02_last_vacuum..........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_last_vacuum.t  
line 27.
t/02_last_vacuum..........ok
         14/14 skipped: Cannot test last_vacuum on old Postgres versions
t/02_listener.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_listener.............ok
t/02_locks................please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_locks................ok
t/02_logfile..............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_logfile..............ok
t/02_new_version_cp.......please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_new_version_cp.......ok
t/02_new_version_pg.......please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_new_version_pg.......ok 1/5DBD::Pg::db do failed: ERROR:  syntax  
error at or near "SELECT" at character 175 at t/CP_Testing.pm line 673.
# Looks like you planned 5 tests but ran 1.
# Looks like your test exited with 255 just after 1.
t/02_new_version_pg.......dubious
	Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-5
	Failed 4/5 tests, 20.00% okay
t/02_prepared_txns........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_prepared_txns.t  
line 26.
t/02_prepared_txns........ok 1/10
t/02_prepared_txns........NOK 2#   Failed test 'Action 'prepare_txns'  
gives an error when run against an old Postgres version'
#   at t/02_prepared_txns.t line 29.
#                   'POSTGRES_PREPARED_TXNS OK: (host:/tmp/ 
cptesting_socket) No prepared transactions found | time=0.01
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_prepared_txns........ok 9/10# Looks like you failed 1 test of 10.
t/02_prepared_txns........dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 2
	Failed 1/10 tests, 90.00% okay (less 8 skipped tests: 1 okay, 10.00%)
t/02_query_runtime........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_query_runtime........ok
t/02_query_time...........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_query_time...........ok 11/13Use of uninitialized value in  
numeric lt (<) at t/02_query_time.t line 52.
t/02_query_time...........ok
         1/13 skipped: Cannot test query_time on Postgres 8.1 or lower
t/02_relation_size........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_relation_size........ok 2/23Use of uninitialized value in numeric  
lt (<) at t/02_relation_size.t line 34.
t/02_relation_size........ok 3/23
t/02_relation_size........NOK 4#   Failed test 'Action 'relation_size'  
gives an error when run against an old Postgres version'
#   at t/02_relation_size.t line 37.
#                   'POSTGRES_RELATION_SIZE WARNING: DB  
"postgres" (host:/tmp/cptesting_socket) largest relation is table  
"public.cp_bloat_test": 712 kB | time=0.01   
information_schema.sql_sizing=8192 pg_toast_10767_index=8192  
information_schema.sql_sizing_profiles=0 pg_toast_10737_index=8192  
information_schema.sql_features=49152 pg_toast_10742_index=8192  
pg_toast_2604_index=8192 pg_toast_2606_index=8192  
pg_toast_2609_index=8192 pg_toast_1255_index=8192  
pg_toast_2618_index=16384 pg_toast_2619_index=8192  
pg_toast_1260_index=8192 pg_toast_1262_index=8192  
pg_toast_2396_index=8192 pg_aggregate_fnoid_index=16384  
pg_am_name_index=16384 pg_am_oid_index=16384  
pg_amop_opc_strat_index=32768 pg_amop_opr_opc_index=32768  
pg_amproc_opc_proc_index=16384 pg_attrdef_adrelid_adnum_index=8192  
pg_attrdef_oid_index=8192 pg_attribute_relid_attnam_index=188416  
pg_attribute_relid_attnum_index=57344 pg_authid_rolname_index=16384  
pg_authid_oid_index=16384 pg_auth_members_role_member_index=8192  
pg_auth_members_member_role_index=8192  
pg_autovacuum_vacrelid_index=8192 pg_cast_oid_index=16384  
pg_cast_source_target_index=16384 pg_class_oid_index=16384  
pg_class_relname_nsp_index=65536 pg_constraint_conname_nsp_index=16384  
pg_constraint_conrelid_index=16384 pg_constraint_contypid_index=16384  
pg_constraint_oid_index=16384 pg_conversion_default_index=16384  
pg_conversion_name_nsp_index=40960 pg_conversion_oid_index=16384  
pg_database_datname_index=16384 pg_database_oid_index=16384  
pg_depend_depender_index=172032 pg_depend_reference_index=188416  
pg_description_o_c_o_index=90112 pg_shdescription_o_c_index=16384  
pg_index_indrelid_index=16384 pg_index_indexrelid_index=16384  
pg_inherits_relid_seqno_index=8192 pg_language_name_index=16384  
pg_language_oid_index=16384 pg_largeobject_loid_pn_index=8192  
pg_namespace_nspname_index=16384 pg_namespace_oid_index=16384  
pg_opclass_am_name_nsp_index=32768 pg_opclass_oid_index=16384  
pg_operator_oid_index=32768 pg_operator_oprname_l_r_n_index=90112  
pg_pltemplate_name_index=16384 pg_proc_oid_index=57344  
pg_proc_proname_args_nsp_index=294912 pg_rewrite_oid_index=16384  
pg_rewrite_rel_rulename_index=16384 pg_shdepend_depender_index=16384  
pg_shdepend_reference_index=16384 pg_statistic_relid_att_index=40960  
pg_tablespace_oid_index=16384 pg_tablespace_spcname_index=16384  
pg_trigger_tgconstrname_index=16384  
pg_trigger_tgconstrrelid_index=16384  
pg_trigger_tgrelid_tgname_index=16384 pg_trigger_oid_index=16384  
pg_type_oid_index=16384 pg_type_typname_nsp_index=57344  
information_schema.sql_implementation_info=8192  
pg_toast_10747_index=8192 pg_catalog.pg_authid=8192  
information_schema.sql_languages=8192 pg_toast_10752_index=8192  
information_schema.sql_packages=8192 pg_toast_10757_index=8192  
information_schema.sql_parts=8192 pg_toast_10762_index=8192  
pg_catalog.pg_statistic=139264 pg_catalog.pg_type=49152  
pg_catalog.pg_attribute=237568 pg_catalog.pg_proc=376832  
pg_catalog.pg_class=49152 pg_catalog.pg_autovacuum=0  
pg_catalog.pg_attrdef=0 pg_catalog.pg_constraint=8192  
pg_catalog.pg_inherits=0 public.cp_bloat_test=729088  
pg_catalog.pg_index=16384 pg_catalog.pg_operator=114688  
pg_catalog.pg_opclass=16384 pg_catalog.pg_am=8192  
pg_catalog.pg_amop=24576 pg_catalog.pg_amproc=16384  
pg_catalog.pg_language=8192 pg_catalog.pg_largeobject=0  
pg_catalog.pg_aggregate=8192 pg_catalog.pg_rewrite=73728  
pg_catalog.pg_trigger=8192 pg_catalog.pg_listener=8192  
pg_catalog.pg_description=122880 pg_catalog.pg_cast=16384  
pg_catalog.pg_namespace=8192 pg_catalog.pg_conversion=16384  
pg_catalog.pg_depend=262144 pg_catalog.pg_tablespace=8192  
pg_catalog.pg_pltemplate=8192 pg_catalog.pg_shdepend=8192  
pg_catalog.pg_shdescription=8192 pg_catalog.pg_database=8192  
pg_catalog.pg_auth_members=0 public.test_query_runtime=188416
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_relation_size........ok 18/23# Looks like you failed 1 test of 23.
t/02_relation_size........dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
	Failed 1/23 tests, 95.65% okay (less 19 skipped tests: 3 okay, 13.04%)
t/02_replicate_row........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_replicate_row........ok
t/02_same_schema..........please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
# Creating database in directory "test_database_check_postgres2"
Creating new symlink socket at /tmp/cptesting_socket2
please use DBI functions for transaction handling at /usr/lib/perl5/ 
vendor_perl/5.8.3/i386-linux-thread-multi/DBD/Pg.pm line 169.
Use of uninitialized value in string eq at t/CP_Testing.pm line 358.
Use of uninitialized value in concatenation (.) or string at t/ 
CP_Testing.pm line 366.
Use of uninitialized value in concatenation (.) or string at t/ 
CP_Testing.pm line 366.
DBI connect('dbname=template1;port=;host=','',...) failed: could not  
connect to server: No such file or directory at t/CP_Testing.pm line 368
# Looks like you planned 47 tests but ran 1.
# Looks like your test exited with 2 just after 1.
t/02_same_schema..........dubious
	Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 2-47
	Failed 46/47 tests, 2.13% okay
t/02_sequence.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_sequence.............ok 2/11Use of uninitialized value in numeric  
lt (<) at t/02_sequence.t line 32.
t/02_sequence.............ok 3/11
t/02_sequence.............NOK 4#   Failed test 'Action 'sequence'  
gives an error when run against an old Postgres version'
#   at t/02_sequence.t line 35.
#                   'POSTGRES_SEQUENCE OK: DB "postgres" (host:/tmp/ 
cptesting_socket) No sequences found | time=0.02
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_sequence.............ok 11/11# Looks like you failed 1 test of 11.
t/02_sequence.............dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
	Failed 1/11 tests, 90.91% okay (less 7 skipped tests: 3 okay, 27.27%)
t/02_settings_checksum....please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_settings_checksum....ok
t/02_timesync.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_timesync.............ok
t/02_txn_idle.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_txn_idle.............ok 11/13please use DBI functions for  
transaction handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux- 
thread-multi/DBD/Pg.pm line 169.
t/02_txn_idle.............ok
t/02_txn_time.............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
Use of uninitialized value in numeric lt (<) at t/02_txn_time.t line 26.
t/02_txn_time.............ok
         14/14 skipped: Cannot test txn_time on Postgres 8.2 or older
t/02_txn_wraparound.......please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_txn_wraparound.......ok
t/02_version..............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_version..............ok 10/28DBD::Pg::db do failed: ERROR:   
syntax error at or near "SELECT" at character 175 at t/CP_Testing.pm  
line 673.
# Looks like you planned 28 tests but ran 10.
# Looks like your test exited with 2 just after 10.
t/02_version..............dubious
	Test returned status 2 (wstat 512, 0x200)
DIED. FAILED tests 11-28
	Failed 18/28 tests, 35.71% okay
t/02_wal_files............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/02_wal_files............ok 2/11Use of uninitialized value in numeric  
lt (<) at t/02_wal_files.t line 30.
t/02_wal_files............ok 3/11
t/02_wal_files............NOK 4#   Failed test 'Action 'wal_files'  
gives an error when run against an old Postgres version'
#   at t/02_wal_files.t line 33.
#                   'POSTGRES_WAL_FILES OK: (host:/tmp/ 
cptesting_socket) 1 | time=0.01  '/tmp/cptesting_socket'=1;99;
# '
#     doesn't match '(?-xism:ERROR.*server version must be >= 8.1)'
t/02_wal_files............ok 10/11# Looks like you failed 1 test of 11.
t/02_wal_files............dubious
	Test returned status 1 (wstat 256, 0x100)
DIED. FAILED test 4
	Failed 1/11 tests, 90.91% okay (less 7 skipped tests: 3 okay, 27.27%)
t/03_translations.........skipped
         all skipped: Test skipped unless environment variable  
RELEASE_TESTING is set
t/04_timeout..............please use DBI functions for transaction  
handling at /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/ 
DBD/Pg.pm line 169.
t/04_timeout..............ok
t/99_cleanup..............ok
Failed Test              Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/00_test_tester.t          1   256     1    1 100.00%  1
t/02_backends.t             3   768    53    3   5.66%  19-21
t/02_connection.t           9  2304    12    2  16.67%  12
t/02_database_size.t        1   256    49    1   2.04%  2
t/02_disabled_triggers.t    1   256    13    1   7.69%  1
t/02_disk_space.t           7  1792     7    7 100.00%  1-7
t/02_new_version_pg.t     255 65280     5    8 160.00%  2-5
t/02_prepared_txns.t        1   256    10    1  10.00%  2
t/02_relation_size.t        1   256    23    1   4.35%  4
t/02_same_schema.t          2   512    47   92 195.74%  2-47
t/02_sequence.t             1   256    11    1   9.09%  4
t/02_version.t              2   512    28   36 128.57%  11-28
t/02_wal_files.t            1   256    11    1   9.09%  4
2 tests and 160 subtests skipped.
Failed 13/39 test scripts, 66.67% okay. 86/575 subtests failed, 85.04%  
okay.
make: *** [test_dynamic] Error 255




>
> -- 
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/check_postgres/attachments/20100201/2d833971/attachment-0001.html 


More information about the Check_postgres mailing list