Re: pgsql: Rework option set of vacuumlo - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Rework option set of vacuumlo
Date
Msg-id 12438.1535488750@sss.pgh.pa.us
Whole thread Raw
In response to pgsql: Rework option set of vacuumlo  (Michael Paquier <michael@paquier.xyz>)
Responses Re: pgsql: Rework option set of vacuumlo  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Michael Paquier <michael@paquier.xyz> writes:
> Documentation and code is reordered to be more consistent. A basic set
> of TAP tests has been added while on it.

It'd be even better if these tests passed.  For me, not so much:

$ make check
...
t/001_basic.pl .. # Looks like your test exited with 2 before it could output anything.
t/001_basic.pl .. Dubious, test returned 2 (wstat 512, 0x200)
Failed 8/8 subtests

Test Summary Report
-------------------
t/001_basic.pl (Wstat: 512 Tests: 0 Failed: 0)
  Non-zero exit status: 2
  Parse errors: Bad plan.  You planned 8 tests but ran 0.
Files=1, Tests=0,  0 wallclock secs ( 0.02 usr  0.01 sys +  0.06 cusr  0.01 csys =  0.10 CPU)
Result: FAIL

and the log file says

# Running: oid2name --help
Command 'oid2name' not found in /home/postgres/testversion/bin, /home/postgres/t
estversion/bin, /usr/local/autoconf-2.69/bin, /home/postgres/bin, /usr/lib64/qt-
3.3/bin, /usr/lib64/ccache, /usr/local/bin, /bin, /usr/bin, /usr/local/sbin, /us
r/sbin, /sbin at /home/postgres/pgsql/contrib/oid2name/../../src/test/perl/TestL
ib.pm line 414
# Looks like your test exited with 2 before it could output anything.

Similarly for the new vacuumlo tests.

This is also why the cfbot is unhappy.  Oddly, the buildfarm is not.
I think the reason why not is that the buildfarm does "make installcheck"
in contrib, and it first does "make install" in contrib, so that there's a
copy of oid2name to be found in the PATH.  But "make check" ought to be
testing the executable in the temporary installation tree, and it's not.

Digging, this is because the "make check" processing isn't actually
installing oid2name (resp. vacuumlo) into the temp installation tree :-(.

I don't think this is the fault of your tests, exactly --- there's
something wrong in the existing make rules.  I'm not sure what though.
EXTRA_INSTALL should be getting set, according to pgxs.mk:

temp-install: EXTRA_INSTALL+=$(subdir)

but it evidently isn't.

            regards, tom lane


pgsql-committers by date:

Previous
From: Andrew Gierth
Date:
Subject: pgsql: postgres_fdw: don't push ORDER BY with no vars (bug #15352)
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Rework option set of vacuumlo