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@borg.lerctr.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@0.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@lerctr.org\'
                                                   ],
                                       \'fail\' => [
                                                   \'ler@lerctr.org\'
                                                 ],
                                       \'green\' => [
                                                    \'ler@lerctr.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@0.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@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106