Buildfarm support for older versions

Andrew Dunstan <andrew@dunslane.net> writes:

I have set up a test buildfarm client (which will eventually report
under the name 'godwit') alongside crake (Fedora 34). So far testing has
run smoothly, there are only two glitches:

* 9.3 and 9.2 don't have a show_dl_suffix make target. This would
require backpatching b40cb99b85 and d9cdb1ba9e. That's a tiny
change, and I propose to do it shortly unless there's an objection.

Not really user-visible, so I can't see a problem with it.

regards, tom lane

On 12/15/2021 11:15 am, Andrew Dunstan wrote:

OK, old_branches_of_interest.txt now exists on the buildfarm server,
and
the code has been modified to take notice of it (i.e. to accept builds
for branches listed there). The contents are the non-live versions from
9.2 on.

I have set up a test buildfarm client (which will eventually report
under the name 'godwit') alongside crake (Fedora 34). So far testing
has
run smoothly, there are only two glitches:

* 9.3 and 9.2 don't have a show_dl_suffix make target. This would
require backpatching b40cb99b85 and d9cdb1ba9e. That's a tiny
change, and I propose to do it shortly unless there's an objection.
* I need to undo the removal of client logic that supported 9.2's
unix_socket_directory setting as opposed to the later
unix_socket_directories.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Would a FreeBSD head (peripatus or a new animal) help?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/15/21 21:36, Larry Rosenman wrote:

On 12/15/2021 11:15 am, Andrew Dunstan wrote:

OK, old_branches_of_interest.txt now exists on the buildfarm server, and
the code has been modified to take notice of it (i.e. to accept builds
for branches listed there). The contents are the non-live versions from
9.2 on.

I have set up a test buildfarm client (which will eventually report
under the name 'godwit') alongside crake (Fedora 34). So far testing has
run smoothly, there are only two glitches:

  * 9.3 and 9.2 don't have a show_dl_suffix make target. This would
    require backpatching b40cb99b85 and d9cdb1ba9e. That's a tiny
    change, and I propose to do it shortly unless there's an objection.
  * I need to undo the removal of client logic that supported 9.2's
    unix_socket_directory setting as opposed to the later
    unix_socket_directories.

Would a FreeBSD head (peripatus or a new animal) help?

A new animal, because we're not supporting every build option. On the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal (godwit and crake do this). The client is smart enough to manage locks of several animals appropriately.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

On 12/16/2021 10:02 am, Andrew Dunstan wrote:

On 12/15/21 21:36, Larry Rosenman wrote:

On 12/15/2021 11:15 am, Andrew Dunstan wrote:

OK, old_branches_of_interest.txt now exists on the buildfarm server,
and
the code has been modified to take notice of it (i.e. to accept
builds
for branches listed there). The contents are the non-live versions
from
9.2 on.

I have set up a test buildfarm client (which will eventually report
under the name 'godwit') alongside crake (Fedora 34). So far testing
has
run smoothly, there are only two glitches:

  * 9.3 and 9.2 don't have a show_dl_suffix make target. This would
    require backpatching b40cb99b85 and d9cdb1ba9e. That's a tiny
    change, and I propose to do it shortly unless there's an
objection.
  * I need to undo the removal of client logic that supported 9.2's
    unix_socket_directory setting as opposed to the later
    unix_socket_directories.

Would a FreeBSD head (peripatus or a new animal) help?

A new animal, because we're not supporting every build option. On the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal (godwit
and crake do this). The client is smart enough to manage locks of
several animals appropriately.

cheers

andrew

--

So just create a new animal / config file, and set those options?
and FreeBSD head / main would be useful?
(Currently FreeBSD 14 and clang 13).

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/16/21 11:11, Larry Rosenman wrote:

A new animal, because we're not supporting every build option. On the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal (godwit
and crake do this). The client is smart enough to manage locks of
several animals appropriately.

So just create a new animal / config file, and set those options?
and FreeBSD head / main would be useful?
(Currently FreeBSD 14 and clang 13).

Sure. I think if we get coverage for modern Linux, FreeBSD and Windows
we should be in good shape.

I doubt we need a heck of a lot of animals - there's not going to be
much going on here.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

On 12/16/2021 11:17 am, Andrew Dunstan wrote:

On 12/16/21 11:11, Larry Rosenman wrote:

A new animal, because we're not supporting every build option. On the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal
(godwit
and crake do this). The client is smart enough to manage locks of
several animals appropriately.

So just create a new animal / config file, and set those options?
and FreeBSD head / main would be useful?
(Currently FreeBSD 14 and clang 13).

Sure. I think if we get coverage for modern Linux, FreeBSD and Windows
we should be in good shape.

I doubt we need a heck of a lot of animals - there's not going to be
much going on here.

cheers

andrew

Would you mind terribly giving me the exact steps?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/16/21 12:26, Larry Rosenman wrote:

On 12/16/2021 11:17 am, Andrew Dunstan wrote:

On 12/16/21 11:11, Larry Rosenman wrote:

A new animal, because we're not supporting every build option. On the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal (godwit
and crake do this). The client is smart enough to manage locks of
several animals appropriately.

So just create a new animal / config file, and set those options?
and FreeBSD head / main would be useful?
(Currently FreeBSD 14 and clang 13).

Sure. I think if we get coverage for modern Linux, FreeBSD and Windows
we should be in good shape.

I doubt we need a heck of a lot of animals - there's not going to be
much going on here.

Would you mind terribly giving me the exact steps?

* register a new animal with the same details
* copy your existing config file to $new_animal.conf
* edit the file and change the animal name and secret, the config_opts
as above, and remove TestUpgrade form the modules setting
* change branches_to_build to [qw(
            REL9_2_STABLE REL9_3_STABLE REL9_4_STABLE
            REL9_5_STABLE REL9_6_STABLE)]
* you should probably unset CCACHEDIR in both config files
* test with ./run_branches --test --config $newanimal.conf --run-all

cheers

andew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

On 12/16/2021 2:47 pm, Andrew Dunstan wrote:

On 12/16/21 12:26, Larry Rosenman wrote:

On 12/16/2021 11:17 am, Andrew Dunstan wrote:

On 12/16/21 11:11, Larry Rosenman wrote:

A new animal, because we're not supporting every build option. On
the
non-live branches you really only want:

    --enable-debug --enable-cassert --enable-nls

    --enable-tap-tests --with-perl

You can make it share the same storage as your existing animal
(godwit
and crake do this). The client is smart enough to manage locks of
several animals appropriately.

So just create a new animal / config file, and set those options?
and FreeBSD head / main would be useful?
(Currently FreeBSD 14 and clang 13).

Sure. I think if we get coverage for modern Linux, FreeBSD and
Windows
we should be in good shape.

I doubt we need a heck of a lot of animals - there's not going to be
much going on here.

Would you mind terribly giving me the exact steps?

* register a new animal with the same details
* copy your existing config file to $new_animal.conf
* edit the file and change the animal name and secret, the
config_opts
as above, and remove TestUpgrade form the modules setting
* change branches_to_build to [qw(
            REL9_2_STABLE REL9_3_STABLE REL9_4_STABLE
            REL9_5_STABLE REL9_6_STABLE)]
* you should probably unset CCACHEDIR in both config files
* test with ./run_branches --test --config $newanimal.conf --run-all

I get:
ERROR for site owner:
Invalid domain for site key

on https://pgbuildfarm.org/cgi-bin/register-form.pl
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/16/21 15:53, Larry Rosenman wrote:

I get:
ERROR for site owner:
Invalid domain for site key

on https://pgbuildfarm.org/cgi-bin/register-form.pl

try https://buildfarm.postgresql.org/cgi-bin/register-form.pl

cheers

andrew

On 12/16/2021 3:23 pm, Andrew Dunstan wrote:

On 12/16/21 15:53, Larry Rosenman wrote:

I get:
ERROR for site owner:
Invalid domain for site key

on https://pgbuildfarm.org/cgi-bin/register-form.pl

try https://buildfarm.postgresql.org/cgi-bin/register-form.pl

cheers

andrew

I filled out that form on the 16th, and haven't gotten a new animal
assignment. Is there
a problem with my data?
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/21/21 15:06, Larry Rosenman wrote:

I filled out that form on the 16th, and haven't gotten a new animal
assignment.  Is there
a problem with my data?

It's a manual process, done when your friendly admins have time. I have
approved it now.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

On 12/22/2021 7:20 am, Andrew Dunstan wrote:

On 12/21/21 15:06, Larry Rosenman wrote:

I filled out that form on the 16th, and haven't gotten a new animal
assignment.  Is there
a problem with my data?

It's a manual process, done when your friendly admins have time. I have
approved it now.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

REL9_2_STABLE make dies on:
gmake[4]: Entering directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend/utils'
'/usr/bin/perl' ./generate-errcodes.pl
../../../src/backend/utils/errcodes.txt > errcodes.h
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -I../../src/port -DFRONTEND
-I../../src/include -I/usr/local/include -c -o path.o path.c
gmake[4]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend/utils'
prereqdir=`cd 'utils/' >/dev/null && pwd` && \
cd '../../src/include/utils/' && rm -f errcodes.h && \
ln -s "$prereqdir/errcodes.h" .
gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend'
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing
$ tail -30 make.log
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:109
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:126
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

cc: error: linker command failed with exit code 1 (use -v to see
invocation)
gmake[3]: *** [../../src/Makefile.port:20: timetravel.so] Error 1
gmake[3]: *** Waiting for unfinished jobs....
rm moddatetime.o autoinc.o refint.o timetravel.o insert_username.o
gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/contrib/spi'
gmake[2]: *** [GNUmakefile:126: submake-contrib-spi] Error 2
gmake[2]: *** Waiting for unfinished jobs....
gmake[2]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/test/regress'
gmake[1]: *** [Makefile:33: all-test/regress-recurse] Error 2
gmake[1]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src'
gmake: *** [GNUmakefile:11: all-src-recurse] Error 2
$

The other branches are still running.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

On 12/22/2021 7:16 pm, Larry Rosenman wrote:

On 12/22/2021 7:20 am, Andrew Dunstan wrote:

On 12/21/21 15:06, Larry Rosenman wrote:

I filled out that form on the 16th, and haven't gotten a new animal
assignment.  Is there
a problem with my data?

It's a manual process, done when your friendly admins have time. I
have
approved it now.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

REL9_2_STABLE make dies on:
gmake[4]: Entering directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend/utils'
'/usr/bin/perl' ./generate-errcodes.pl
../../../src/backend/utils/errcodes.txt > errcodes.h
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -Wno-unused-command-line-argument
-Wno-compound-token-split-by-macro -Wno-sometimes-uninitialized -g
-I../../src/port -DFRONTEND -I../../src/include -I/usr/local/include
-c -o path.o path.c
gmake[4]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend/utils'
prereqdir=`cd 'utils/' >/dev/null && pwd` && \
cd '../../src/include/utils/' && rm -f errcodes.h && \
ln -s "$prereqdir/errcodes.h" .
gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/backend'
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
$ tail -30 make.log
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:109
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:126
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

cc: error: linker command failed with exit code 1 (use -v to see
invocation)
gmake[3]: *** [../../src/Makefile.port:20: timetravel.so] Error 1
gmake[3]: *** Waiting for unfinished jobs....
rm moddatetime.o autoinc.o refint.o timetravel.o insert_username.o
gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/contrib/spi'
gmake[2]: *** [GNUmakefile:126: submake-contrib-spi] Error 2
gmake[2]: *** Waiting for unfinished jobs....
gmake[2]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/test/regress'
gmake[1]: *** [Makefile:33: all-test/regress-recurse] Error 2
gmake[1]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src'
gmake: *** [GNUmakefile:11: all-src-recurse] Error 2
$

The other branches are still running.

Here's the full run:
$ bin/latest/run_branches.pl --test --config $(pwd)/conf/gerenuk.conf
--run-all
Wed Dec 22 19:05:53 2021: buildfarm run for gerenuk:REL9_2_STABLE
starting
gerenuk:REL9_2_STABLE [19:05:54] checking out source ...
gerenuk:REL9_2_STABLE [19:06:06] checking if build run needed ...
gerenuk:REL9_2_STABLE [19:06:06] copying source to pgsql.build ...
gerenuk:REL9_2_STABLE [19:06:08] running configure ...
gerenuk:REL9_2_STABLE [19:06:36] running make ...
Branch: REL9_2_STABLE
Stage Make failed with status 2
Wed Dec 22 19:08:21 2021: buildfarm run for gerenuk:REL9_3_STABLE
starting
gerenuk:REL9_3_STABLE [19:08:21] checking out source ...
gerenuk:REL9_3_STABLE [19:08:27] checking if build run needed ...
gerenuk:REL9_3_STABLE [19:08:28] copying source to pgsql.build ...
gerenuk:REL9_3_STABLE [19:08:29] running configure ...
gerenuk:REL9_3_STABLE [19:08:52] running make ...
gerenuk:REL9_3_STABLE [19:10:38] running make check ...
gerenuk:REL9_3_STABLE [19:11:05] running make contrib ...
gerenuk:REL9_3_STABLE [19:11:15] running make install ...
gerenuk:REL9_3_STABLE [19:11:19] running make contrib install ...
gerenuk:REL9_3_STABLE [19:11:21] checking pg_upgrade
gerenuk:REL9_3_STABLE [19:12:29] running make check miscellaneous
modules ...
gerenuk:REL9_3_STABLE [19:12:29] setting up db cluster (C)...
gerenuk:REL9_3_STABLE [19:12:32] starting db (C)...
gerenuk:REL9_3_STABLE [19:12:33] running make installcheck (C)...
gerenuk:REL9_3_STABLE [19:13:00] restarting db (C)...
gerenuk:REL9_3_STABLE [19:13:03] running make isolation check ...
gerenuk:REL9_3_STABLE [19:14:00] restarting db (C)...
gerenuk:REL9_3_STABLE [19:14:03] running make PL installcheck (C)...
gerenuk:REL9_3_STABLE [19:14:04] restarting db (C)...
gerenuk:REL9_3_STABLE [19:14:07] running make contrib installcheck
(C)...
gerenuk:REL9_3_STABLE [19:14:24] stopping db (C)...
gerenuk:REL9_3_STABLE [19:14:26] running make ecpg check ...
gerenuk:REL9_3_STABLE [19:14:47] OK
Branch: REL9_3_STABLE
All stages succeeded
Wed Dec 22 19:14:48 2021: buildfarm run for gerenuk:REL9_4_STABLE
starting
gerenuk:REL9_4_STABLE [19:14:48] checking out source ...
gerenuk:REL9_4_STABLE [19:14:52] checking if build run needed ...
gerenuk:REL9_4_STABLE [19:14:52] copying source to pgsql.build ...
gerenuk:REL9_4_STABLE [19:15:14] running configure ...
gerenuk:REL9_4_STABLE [19:15:32] running make ...
gerenuk:REL9_4_STABLE [19:17:22] running make check ...
gerenuk:REL9_4_STABLE [19:17:49] running make contrib ...
gerenuk:REL9_4_STABLE [19:18:00] running make install ...
gerenuk:REL9_4_STABLE [19:18:03] running make contrib install ...
gerenuk:REL9_4_STABLE [19:18:06] checking pg_upgrade
gerenuk:REL9_4_STABLE [19:19:11] checking test-decoding
gerenuk:REL9_4_STABLE [19:20:13] running make check miscellaneous
modules ...
gerenuk:REL9_4_STABLE [19:20:13] running bin test initdb ...
Branch: REL9_4_STABLE
Stage initdbCheck failed with status 2
Wed Dec 22 19:20:20 2021: buildfarm run for gerenuk:REL9_5_STABLE
starting
gerenuk:REL9_5_STABLE [19:20:20] checking out source ...
gerenuk:REL9_5_STABLE [19:20:26] checking if build run needed ...
gerenuk:REL9_5_STABLE [19:20:26] copying source to pgsql.build ...
gerenuk:REL9_5_STABLE [19:20:56] running configure ...
gerenuk:REL9_5_STABLE [19:21:17] running make ...
gerenuk:REL9_5_STABLE [19:23:16] running make check ...
gerenuk:REL9_5_STABLE [19:23:43] running make contrib ...
gerenuk:REL9_5_STABLE [19:23:53] running make testmodules ...
gerenuk:REL9_5_STABLE [19:23:53] running make install ...
gerenuk:REL9_5_STABLE [19:23:57] running make contrib install ...
gerenuk:REL9_5_STABLE [19:23:59] running make testmodules install ...
gerenuk:REL9_5_STABLE [19:23:59] checking pg_upgrade
gerenuk:REL9_5_STABLE [19:25:09] checking test-decoding
gerenuk:REL9_5_STABLE [19:26:02] running make check miscellaneous
modules ...
gerenuk:REL9_5_STABLE [19:26:02] running bin test initdb ...
Can't stat pgsql.build/src/bin/initdb/tmp_check: No such file or
directory
at /home/pgbuildfarm/bin/build-farm-13.1/PGBuild/Utils.pm line 222.
Branch: REL9_5_STABLE
Stage initdbCheck failed with status 2
Wed Dec 22 19:26:04 2021: buildfarm run for gerenuk:REL9_6_STABLE
starting
gerenuk:REL9_6_STABLE [19:26:04] checking out source ...
gerenuk:REL9_6_STABLE [19:26:12] checking if build run needed ...
gerenuk:REL9_6_STABLE [19:26:12] copying source to pgsql.build ...
gerenuk:REL9_6_STABLE [19:26:47] running configure ...
gerenuk:REL9_6_STABLE [19:27:06] running make ...
gerenuk:REL9_6_STABLE [19:29:13] running make check ...
gerenuk:REL9_6_STABLE [19:29:41] running make contrib ...
gerenuk:REL9_6_STABLE [19:29:51] running make testmodules ...
gerenuk:REL9_6_STABLE [19:29:51] running make install ...
gerenuk:REL9_6_STABLE [19:29:55] running make contrib install ...
gerenuk:REL9_6_STABLE [19:29:57] running make testmodules install ...
gerenuk:REL9_6_STABLE [19:29:58] checking pg_upgrade
gerenuk:REL9_6_STABLE [19:31:09] checking test-decoding
gerenuk:REL9_6_STABLE [19:32:02] running make check miscellaneous
modules ...
gerenuk:REL9_6_STABLE [19:32:02] running bin test initdb ...
Can't stat pgsql.build/src/bin/initdb/tmp_check: No such file or
directory
at /home/pgbuildfarm/bin/build-farm-13.1/PGBuild/Utils.pm line 222.
Branch: REL9_6_STABLE
Stage initdbCheck failed with status 2
$

Looks like there are "issues".

Should I set it up on cron? Or does someone want to look first?

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

Larry Rosenman <ler@lerctr.org> writes:

REL9_2_STABLE make dies on:
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC
[etc]

What configure options did you use?

regards, tom lane

On 12/22/2021 9:34 pm, Tom Lane wrote:

Larry Rosenman <ler@lerctr.org> writes:

REL9_2_STABLE make dies on:
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC
[etc]

What configure options did you use?

regards, tom lane

config_opts =>[
qw(
--enable-cassert
--enable-debug
--enable-nls
--enable-tap-tests
--with-perl
)
],

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

Larry Rosenman <ler@lerctr.org> writes:

On 12/22/2021 9:34 pm, Tom Lane wrote:

What configure options did you use?

config_opts =>[
qw(
--enable-cassert
--enable-debug
--enable-nls
--enable-tap-tests
--with-perl
)
],

Does it work if you drop --enable-nls? (It'd likely be worth fixing
if so, but I'm trying to narrow the possible causes.)

regards, tom lane

On 12/22/2021 9:59 pm, Tom Lane wrote:

Larry Rosenman <ler@lerctr.org> writes:

On 12/22/2021 9:34 pm, Tom Lane wrote:

What configure options did you use?

config_opts =>[
qw(
--enable-cassert
--enable-debug
--enable-nls
--enable-tap-tests
--with-perl
)
],

Does it work if you drop --enable-nls? (It'd likely be worth fixing
if so, but I'm trying to narrow the possible causes.)

regards, tom lane

Nope...

gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/contrib/dummy_seclabel'
cp ../../../contrib/dummy_seclabel/dummy_seclabel.so dummy_seclabel.so
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -fPIC -DPIC -L../../src/port
-L/usr/local/lib -Wl,--as-needed
-Wl,-R'/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/lib'
-L../../src/port -lpgport -shared -o moddatetime.so moddatetime.o
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -fPIC -DPIC -L../../src/port
-L/usr/local/lib -Wl,--as-needed
-Wl,-R'/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/lib'
-L../../src/port -lpgport -shared -o insert_username.so
insert_username.o
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -fPIC -DPIC -L../../src/port
-L/usr/local/lib -Wl,--as-needed
-Wl,-R'/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/lib'
-L../../src/port -lpgport -shared -o autoinc.so autoinc.o
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -fPIC -DPIC -L../../src/port
-L/usr/local/lib -Wl,--as-needed
-Wl,-R'/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/lib'
-L../../src/port -lpgport -shared -o timetravel.so timetravel.o
cc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-Wno-unused-command-line-argument -Wno-compound-token-split-by-macro
-Wno-sometimes-uninitialized -g -fPIC -DPIC -L../../src/port
-L/usr/local/lib -Wl,--as-needed
-Wl,-R'/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/lib'
-L../../src/port -lpgport -shared -o refint.so refint.o
ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:37
pgstrcasecmp.o:(pg_strcasecmp) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:37
pgstrcasecmp.o:(pg_strcasecmp) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:70
pgstrcasecmp.o:(pg_strncasecmp) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:70
pgstrcasecmp.o:(pg_strncasecmp) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:109
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_toupper) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
__mb_sb_limit; recompile with -fPIC

defined in /lib/libc.so.7
referenced by pgstrcasecmp.c:126
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

ld: error: relocation R_X86_64_PC32 cannot be used against symbol
_CurrentRuneLocale; recompile with -fPIC

defined in /lib/libc.so.7
referenced by runetype.h:0 (/usr/include/runetype.h:0)
pgstrcasecmp.o:(pg_tolower) in archive
../../src/port/libpgport.a

cc: error: linker command failed with exit code 1 (use -v to see
invocation)
gmake[3]: *** [../../src/Makefile.port:20: timetravel.so] Error 1
gmake[3]: *** Waiting for unfinished jobs....
rm moddatetime.o autoinc.o refint.o timetravel.o insert_username.o
gmake[3]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/contrib/spi'
gmake[2]: *** [GNUmakefile:126: submake-contrib-spi] Error 2
gmake[2]: *** Waiting for unfinished jobs....
gmake[2]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src/test/regress'
gmake[1]: *** [Makefile:33: all-test/regress-recurse] Error 2
gmake[1]: Leaving directory
'/home/pgbuildfarm/buildroot/REL9_2_STABLE/pgsql.build/src'
gmake: *** [GNUmakefile:11: all-src-recurse] Error 2
$

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106

Larry Rosenman <ler@lerctr.org> writes:

On 12/22/2021 9:59 pm, Tom Lane wrote:

Does it work if you drop --enable-nls? (It'd likely be worth fixing
if so, but I'm trying to narrow the possible causes.)

Nope...

OK. Since 9.3 succeeds, it seems like it's a link problem
we fixed at some point. Can you bisect to find where we
fixed it?

regards, tom lane

On 12/22/2021 10:15 pm, Tom Lane wrote:

Larry Rosenman <ler@lerctr.org> writes:

On 12/22/2021 9:59 pm, Tom Lane wrote:

Does it work if you drop --enable-nls? (It'd likely be worth fixing
if so, but I'm trying to narrow the possible causes.)

Nope...

OK. Since 9.3 succeeds, it seems like it's a link problem
we fixed at some point. Can you bisect to find where we
fixed it?

regards, tom lane

I can try -- I haven't been very good at that.

I can give you access to the machine and the id the Buildfarm runs
under.

(or give me a good process starting from a buildfarm layout).

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106