Thread

  1. Buildfarm setup for AIX

    Vamshikrishna T <tvk1271@gmail.com> — 2025-07-09T08:28:02Z

    Hi Team,
    
    Here are few updates on the buildfarm setup for AIX.
    We got a latest Power9 node in OSU lab dedicated for Postgres community
    development activity.
    
    In the last couple of weeks, we have setup the buildfarm on a node in OSU
    lab for all the supported versions of Postgres on AIX(13/14/15/16).
    
    https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_13_STABLE
    https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_14_STABLE
    https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_15_STABLE
    https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_16_STABLE
    
    For other latest releases(17/18/master) we are planning to run them locally
    on our node.
    
    Currently we are seeing some issues in the TAP test for REL_16.
    
    gmake -j1  checkprep
    >>'/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build'/tmp_install/log/install.log
    2>&1
    echo "# +++ tap check in src/test/authentication +++" && rm -rf
    '/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check
    && /opt/freeware/bin//mkdir -p
    '/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check
    && cd . &&
    TESTLOGDIR='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check/log'
    TESTDATADIR='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check'
    PATH="/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/tmp_install/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/inst/bin:/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication:$PATH"
    LIBPATH="/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/tmp_install/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/inst/lib"
     PGPORT='65768'
    top_builddir='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/../../..'
    PG_REGRESS='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/../../../src/test/regress/pg_regress'
    /opt/freeware/bin//prove -I ../../../src/test/perl/ -I .  t/001_password.pl
    # +++ tap check in src/test/authentication +++
    t/001_password.pl .. 1/? # Tests were run but no plan was declared and
    done_testing() was not seen.
    # Looks like your test exited with 2 just after 1.
    t/001_password.pl .. Dubious, test returned 2 (wstat 512, 0x200)
    All 1 subtests passed
    
    Test Summary Report
    -------------------
    t/001_password.pl (Wstat: 512 (exited 2) Tests: 1 Failed: 0)
      Non-zero exit status: 2
      Parse errors: No plan found in TAP output
    Files=1, Tests=1, 183 wallclock secs ( 0.02 usr  0.00 sys +  0.41 cusr
     0.14 csys =  0.57 CPU)
    Result: FAIL
    gmake: *** [Makefile:17: check] Error 1
    
    
    These tests were passing on other buildfarms (animals) , trying to debug if
    there are any environment specific issues.
    
    
    -- 
    Thanks
     Vamshi.
    
  2. Re: Buildfarm setup for AIX

    Andrew Dunstan <andrew@dunslane.net> — 2025-07-09T16:58:27Z

    On 2025-07-09 We 4:28 AM, Vamshikrishna T wrote:
    > Hi Team,
    >
    > Here are few updates on the buildfarm setup for AIX.
    > We got a latest Power9 node in OSU lab dedicated for Postgres 
    > community development activity.
    >
    > In the last couple of weeks, we have setup the buildfarm on a node in 
    > OSU lab for all the supported versions of Postgres on AIX(13/14/15/16).
    >
    > https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_13_STABLE 
    > <https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_13_STABLE>
    > https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_14_STABLE 
    > <https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_14_STABLE>
    > https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_15_STABLE 
    > <https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_15_STABLE>
    > https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_16_STABLE 
    > <https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=douc&br=REL_16_STABLE>
    >
    > For other latest releases(17/18/master) we are planning to run them 
    > locally on our node.
    >
    > Currently we are seeing some issues in the TAP test for REL_16.
    >
    > gmake -j1  checkprep 
    > >>'/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build'/tmp_install/log/install.log 
    > 2>&1
    > echo "# +++ tap check in src/test/authentication +++" && rm -rf 
    > '/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check 
    > && /opt/freeware/bin//mkdir -p 
    > '/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check 
    > && cd . && 
    > TESTLOGDIR='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check/log' 
    > TESTDATADIR='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check' 
    > PATH="/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/tmp_install/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/inst/bin:/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication:$PATH" 
    > LIBPATH="/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/tmp_install/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/inst/lib" 
    >  PGPORT='65768' 
    > top_builddir='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/../../..' 
    > PG_REGRESS='/home/pgsql/buildFarm/bfarm-19.1/buildroot/REL_16_STABLE/pgsql.build/src/test/authentication/../../../src/test/regress/pg_regress' 
    > /opt/freeware/bin//prove -I ../../../src/test/perl/ -I . 
    >  t/001_password.pl <http://001_password.pl>
    > # +++ tap check in src/test/authentication +++
    > t/001_password.pl <http://001_password.pl> .. 1/? # Tests were run but 
    > no plan was declared and done_testing() was not seen.
    > # Looks like your test exited with 2 just after 1.
    > t/001_password.pl <http://001_password.pl> .. Dubious, test returned 2 
    > (wstat 512, 0x200)
    > All 1 subtests passed
    >
    > Test Summary Report
    > -------------------
    > t/001_password.pl <http://001_password.pl> (Wstat: 512 (exited 2) 
    > Tests: 1 Failed: 0)
    >   Non-zero exit status: 2
    >   Parse errors: No plan found in TAP output
    > Files=1, Tests=1, 183 wallclock secs ( 0.02 usr  0.00 sys +  0.41 cusr 
    >  0.14 csys =  0.57 CPU)
    > Result: FAIL
    > gmake: *** [Makefile:17: check] Error 1
    >
    >
    > These tests were passing on other buildfarms (animals) , trying to 
    > debug if there are any environment specific issues.
    >
    >
    >
    
    I think we need more info. Let's have a look at the 
    regress_log_001_password file.
    
    
    cheers
    
    
    andrew
    
    
    --
    Andrew Dunstan
    EDB:https://www.enterprisedb.com
    
  3. RE: Buildfarm setup for AIX

    Srirama Kucherlapati <sriram.rk@in.ibm.com> — 2025-07-10T16:55:39Z

    Hi Andrew, Thanks for looking into this.
    
    
    
    Attached are the log files, regress_log_001_password and 001_password_primary.log
    
    
    
    This is the error I see in the regress_log_001_password file.
    
    
    
        server started
    
        # Postmaster PID for node "primary" is 15663422
    
        [22:28:33.832](1.867s) ok 1 - scram_iterations in server side ROLE
    
        IPC::Run: timeout on timer #1 at /opt/freeware/share/perl5/site_perl/IPC/Run.pm line 3007.
    
    
    
    
    
    One additional script seems to be running on other animal(hornet) while running this test.
    
    
    
        echo "# +++ tap check in src/test/authentication +++" && rm -rf
    
        '/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check
    
        && /bin/sh ../../../config/install-sh -c -d
    
        '/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication'/tmp_check
    
        && cd . &&
    
        TESTLOGDIR='/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check/log'
    
        TESTDATADIR='/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication/tmp_check'
    
        PATH="/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/tmp_install/home/nm/farm/xlc64/REL_16_STABLE/inst/bin:/home/nm/far
    
        LIBPATH="/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/tmp_install/home/nm/farm/xlc64/REL_16_STABLE/inst/lib"
    
        PGPORT='610768'
    
        top_builddir='/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication/../../..'
    
        PG_REGRESS='/home/nm/farm/xlc64/REL_16_STABLE/pgsql.build/src/test/authentication/../../../src/test/regress/pg_regress
    
        /usr/bin/prove -I ../../../src/test/perl/ -I . --timer t/*.pl
    
    
    
    
    
    — >> /bin/sh ../../../config/install-sh -c -d        << This is missing in our env
    
    
    
    Please let me know if there is anything missing in the build environment.
    
    
    
    
    
    
    
    Thanks,
    
    Sriram.