Re: Buildfarm support for older versions

On 12/23/2021 11:23 am, Andrew Dunstan wrote:
> On 12/23/21 11:27, Larry Rosenman wrote:
>>
>>>>
>>>
>>> For the 9.2 error, try setting this in the config_env stanza:
>>>
>>>
>>>     CFLAGS => '-O2 -fPIC',
>>>
>>>
>>>
>>
>> That got us further, but it dies on startdb:
>> $ cat startdb-C-1.log
>> waiting for server to start.... stopped waiting
>> pg_ctl: could not start server
>> Examine the log output.
>> =========== db log file ==========
>> LOG:  unrecognized configuration parameter "unix_socket_directories"
>> in file
>> "/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/data-C/postgresql.conf"
>> line 576
>> FATAL:  configuration file
>> "/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/data-C/postgresql.conf"
>> contains errors
>> $
>>
>> And we have the errors on the other branches with a temp(?) directory.
>
>
> looks like it's picking up the wrong perl libraries. Please show us the
> output of
>
> grep -v secret
> /home/pgbuildfarm/buildroot/REL9_2_STABLE/$animal.lastrun-logs/web-txn.data
>
>
> cheers
>
> andrew
>
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com

$ grep -v secret web-txn.data
$changed_this_run = '';
$changed_since_success = '';
$branch = 'REL9_2_STABLE';
$status = 1;
$stage = 'StartDb-C:1';
$animal = 'gerenuk';
$ts = 1640276469;
$log_data = 'Last file mtime in snapshot: Wed Dec 15 23:00:28 2021 GMT
===================================================
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
=========== db log file ==========
LOG: unrecognized configuration parameter "unix_socket_directories" in
file
"/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/data-C/postgresql.conf"
line 576
FATAL: configuration file
"/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst/data-C/postgresql.conf"
contains errors
';
$confsum = 'This file was created by PostgreSQL configure 9.2.24, which
was
generated by GNU Autoconf 2.63. Invocation command line was

$ ./configure --enable-cassert --enable-debug --enable-nls
--enable-tap-tests \\
--with-perl
--prefix=/home/pgbuildfarm/buildroot/REL9_2_STABLE/inst \\
--with-pgport=5700
--cache-file=/home/pgbuildfarm/buildroot/accache-gerenuk/config-REL9_2_STABLE.cache

hostname = borg.lerctr.org
uname -m = amd64
uname -r = 14.0-CURRENT
uname -s = FreeBSD
uname -v = FreeBSD 14.0-CURRENT #26 main-n251898-acdc1de369a: Wed Dec 22
18:11:08 CST 2021
root(at)borg(dot)lerctr(dot)org:/usr/obj/usr/src/amd64.amd64/sys/LER-MINIMAL

/usr/bin/uname -p = amd64

PATH: /home/ler/.asdf/shims
PATH: /home/ler/.asdf/bin
PATH: /sbin
PATH: /bin
PATH: /usr/sbin
PATH: /usr/bin
PATH: /usr/local/sbin
PATH: /usr/local/bin
PATH: /home/ler/bin
PATH: /home/ler/go/bin
PATH: /usr/local/opt/terraform(at)0(dot)12/bin
PATH: /home/ler/bin

========================================================
$Script_Config = {
\'alerts\' => {},
\'animal\' => \'gerenuk\',
\'base_port\' => 5678,
\'bf_perl_version\' => \'5.32.1\',
\'build_env\' => {
\'INCLUDES\' =>
\'-I/usr/local/include\',
\'LDFLAGS\' => \'-L/usr/local/lib\'
},
\'build_root\' => \'/home/pgbuildfarm/buildroot\',
\'ccache_failure_remove\' => undef,
\'config\' => [],
\'config_env\' => {
\'CFLAGS\' => \'-O2 -fPIC\'
},
\'config_opts\' => [
\'--enable-cassert\',
\'--enable-debug\',
\'--enable-nls\',
\'--enable-tap-tests\',
\'--with-perl\'
],
\'core_file_glob\' => \'*.core*\',
\'extra_config\' => {
\'DEFAULT\' => [
\'log_line_prefix
= \\\'%m [%p:%l] %q%a \\\'\',
\'log_connections
= \\\'true\\\'\',

\'log_disconnections = \\\'true\\\'\',
\'log_statement =
\\\'all\\\'\',
\'fsync = off\'
]
},
\'force_every\' => {},
\'git_ignore_mirror_failure\' => 1,
\'git_keep_mirror\' => 1,
\'git_use_workdirs\' => 1,
\'invocation_args\' => [
\'--config\',

\'/home/pgbuildfarm/conf/gerenuk.conf\',
\'--test\',
\'REL9_2_STABLE\'
],
\'keep_error_builds\' => 0,
\'locales\' => [
\'C\'
],
\'mail_events\' => {
\'all\' => [],
\'change\' => [
\'ler(at)lerctr(dot)org\'
],
\'fail\' => [
\'ler(at)lerctr(dot)org\'
],
\'green\' => [
\'ler(at)lerctr(dot)org\'
]
},
\'make\' => \'gmake\',
\'make_jobs\' => 10,
\'module_versions\' => {
\'PGBuild::Log\' =>
\'REL_13.1\',

\'PGBuild::Modules::TestDecoding\' => \'REL_13.1\',

\'PGBuild::Modules::TestUpgrade\' => \'REL_13.1\',
\'PGBuild::Options\' =>
\'REL_13.1\',
\'PGBuild::SCM\' =>
\'REL_13.1\',
\'PGBuild::Utils\' =>
\'REL_13.1\',
\'PGBuild::WebTxn\' =>
\'REL_13.1\'
},
\'modules\' => [
\'TestUpgrade\',
\'TestDecoding\'
],
\'optional_steps\' => {},
\'orig_env\' => {
\'BF_CONF_BRANCHES\' =>
\'REL9_2_STABLE,REL9_3_STABLE,REL9_4_STABLE,REL9_5_STABLE,REL9_6_STABLE\',
\'EDITOR\' => \'xxxxxx\',
\'ENV\' => \'xxxxxx\',
\'HOME\' => \'/home/pgbuildfarm\',
\'LANG\' => \'xxxxxx\',
\'LOGNAME\' => \'pgbuildfarm\',
\'MAIL\' => \'xxxxxx\',
\'PAGER\' => \'xxxxxx\',
\'PATH\' =>
\'/home/ler/.asdf/shims:/home/ler/.asdf/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/home/ler/bin:/home/ler/go/bin:/usr/local/opt/terraform(at)0(dot)12/bin:/home/ler/bin\',
\'PWD\' => \'xxxxxx\',
\'SHELL\' => \'/bin/sh\',
\'SUDO_COMMAND\' => \'xxxxxx\',
\'SUDO_GID\' => \'xxxxxx\',
\'SUDO_UID\' => \'xxxxxx\',
\'SUDO_USER\' => \'xxxxxx\',
\'TERM\' => \'xxxxxx\',
\'USER\' => \'pgbuildfarm\'
},
\'scm\' => \'git\',
\'scm_url\' => undef,
\'scmrepo\' => undef,
\'script_version\' => \'REL_13.1\',
\'steps_completed\' => [
\'SCM-checkout\',
\'Configure\',
\'Make\',
\'Check\',
\'Contrib\',
\'Install\',
\'ContribInstall\',
\'pg_upgradeCheck\',
\'MiscCheck\',
\'Initdb-C\'
],
\'tar_log_cmd\' => undef,
\'target\' =>
\'https://buildfarm.postgresql.org/cgi-bin/pgstatus.pl\',
\'trigger_exclude\' => qr/^doc\\/|\\.po$/,
\'trigger_include\' => undef,
\'upgrade_target\' =>
\'https://buildfarm.postgresql.org/cgi-bin/upgrade.pl\',
\'use_default_ccache_dir\' => 0,
\'use_git_cvsserver\' => undef,
\'use_vpath\' => undef,
\'using_msvc\' => undef,
\'wait_timeout\' => undef
};
';
$target = 'https://buildfarm.postgresql.org/cgi-bin/pgstatus.pl';
$verbose = 1;
$ pwd
/home/pgbuildfarm/buildroot/REL9_2_STABLE/gerenuk.lastrun-logs
$
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler(at)lerctr(dot)org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106