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