RE: Regression test fails when 1) old PG is installed and 2) meson/ninja build is used

Dear Andres,

Sorry for late response. I have not been reproduced till now and now I do.
When happened, the problem still happens even when another build directory
is introduced.
There might be hidden conditions I have not found yet.

> I can't reproduce this. For me the psql started by pg_regress is the one in
> tmp_install and so is the libpq it links to.
>
> $ killall -STOP psql
> $ ps aux|grep psql
> andres 3375208 0.0 0.0 28696 9972 pts/5 T Apr10 0:00 psql
> tpch_10
> andres 3597915 1.0 0.0 36036 10120 ? T 09:42 0:00 psql -X
> -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
> andres 3597916 1.0 0.0 36036 10120 ? T 09:42 0:00 psql -X
> -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
> andres 3597918 0.6 0.0 36036 10144 ? T 09:42 0:00 psql -X
> -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
> andres 3597920 0.3 0.0 36036 10104 ? T 09:42 0:00 psql -X
> -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
> andres 3597922 0.6 0.0 36036 10120 ? T 09:42 0:00 psql -X
> -a -q -d regression -v HIDE_TABLEAM=on -v HIDE_TOAST_COMPRESSION=on
> andres 3597955 0.0 0.0 6608 2180 pts/0 S+ 09:42 0:00 grep
> psql
> $ ls -l /proc/3597918/exe
> lrwxrwxrwx 1 andres andres 0 Apr 11 09:42 /proc/3597918/exe ->
> /srv/dev/build/postgres/m-dev-assert/tmp_install/srv/dev/install/postgres/m-
> dev-assert/bin/psql
>
> $ less /proc/3597918/maps
> ...
> 000 103:06 4831894711
> /srv/dev/build/postgres/m-dev-assert/tmp_install/srv/dev/install/postgres/m-
> dev-assert/lib/x86_64-linux-gnu/libpq.so.5.18

Hmm. I could not do the check because the psql command could not be start or it
exit immediately with the symbol lookup error.

Not sure it is meaningful, but I attached the execution log of ldd command, with
the same PATH/LD_LIBRARY_PATH while doing a meson test.

> And meson-logs/testlog.txt shows that the command is executed with
> PATH=/srv/dev/build/postgres/m-dev-assert/tmp_install//srv/dev/install/post
> gres/m-dev-assert/bin:<other things>
> LD_LIBRARY_PATH=/srv/dev/build/postgres/m-dev-assert/tmp_install//srv/d
> ev/install/postgres/m-dev-assert/lib/x86_64-linux-gnu
> Can you check whether your meson-logs/testlog.txt shows the appropriate
> PATH/LD_LIBRARY_PATH and whether libpq is in the right place?

I also checked PATH/LD_LIBRARY_PATH and they looked correct.

PATH=/home/hayato/builddir/tmp_install//usr/local/pgsql/bin:/home/hayato/builddir/src/test/regress:/usr/local/pgsql/bin/:<others>...
LD_LIBRARY_PATH=/home/hayato/builddir/tmp_install//usr/local/pgsql/lib64:/usr/local/pgsql/lib:/usr/local/lib:/usr/lib64/...

Attached is a file which extract some lines from testlog.txt.

Best regards,
Hayato Kuroda
FUJITSU LIMITED