Re: auto_explain log_verbose causes regression failure

On Wed, Aug 19, 2009 at 7:57 PM, Andrew
Dunstan<andrew(dot)dunstan(at)pgexperts(dot)com> wrot>
> I am getting a repeatable failure  on the HEAD regression tests when
> auto_explain's log_verbose is set. If auto_explain.log_verbose is turned off
> the failure disappears. Data below.
>
> cheers
>
> andrew
>
> config settings:
>
> custom_variable_classes = 'auto_explain'
> auto_explain.log_min_duration = 0
> auto_explain.log_format = 'xml'
> auto_explain.log_analyze = on
> auto_explain.log_verbose = on
> shared_preload_libraries = 'auto_explain'

I can't figure out how to make this config work. I dumped these
settings into a file called "t" and then did, from src/test/regress,
TEMP_CONFIG=t make check. This results in:

make -C ../../../src/port all
make[1]: Entering directory `/home/rhaas/pgsql-git/src/port'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/rhaas/pgsql-git/src/port'
rm -rf ./testtablespace
mkdir ./testtablespace
./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII
--load-language=plpgsql --temp-install=./tmp_check
--top-builddir=../../.. --schedule=./parallel_schedule
--temp-config=t
============== removing existing temp installation ==============
============== creating temporary installation ==============
============== initializing database system ==============
============== starting postmaster ==============

pg_regress: postmaster did not respond within 60 seconds
Examine /home/rhaas/pgsql-git/src/test/regress/log/postmaster.log for the reason
make: *** [check] Error 2

That file contains:

FATAL: could not access file "auto_explain": No such file or directory

I tried copying auto_explain.so into $PWD, but that did not help.

Can you describe how you got this to run the tests at all?

...Robert