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.
regress_log_001_password
Description: regress_log_001_password
025-07-10 12:49:00.836 CDT [14680534] LOG: starting PostgreSQL 16.9 on
powerpc-ibm-aix7.2.5.0, compiled by gcc-12 (GCC) 12.3.0, 64-bit
2025-07-10 12:49:00.837 CDT [14680534] LOG: listening on Unix socket
"/tmp/6JYaIWLWXo/.s.PGSQL.26272"
2025-07-10 12:49:00.843 CDT [19726748] LOG: database system was shut down at
2025-07-10 12:49:00 CDT
2025-07-10 12:49:00.855 CDT [14680534] LOG: database system is ready to accept
connections
2025-07-10 12:49:00.905 CDT [21758208] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:00.906 CDT [21758208] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:00.919 CDT [21758208] 001_password.pl LOG: statement: SET
password_encryption='scram-sha-256';
2025-07-10 12:49:00.919 CDT [21758208] 001_password.pl LOG: statement: CREATE
ROLE scram_role LOGIN PASSWORD 'pass';
2025-07-10 12:49:00.984 CDT [27853256] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:00.985 CDT [27853256] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:00.988 CDT [27853256] 001_password.pl LOG: statement: SET
password_encryption='md5';
2025-07-10 12:49:00.988 CDT [27853256] 001_password.pl LOG: statement: CREATE
ROLE md5_role LOGIN PASSWORD 'pass';
2025-07-10 12:49:01.009 CDT [27853258] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:01.010 CDT [27853258] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:01.013 CDT [27853258] 001_password.pl LOG: statement: CREATE
TABLE sysuser_data (n) AS SELECT NULL FROM generate_series(1, 10);
2025-07-10 12:49:01.020 CDT [27853258] 001_password.pl LOG: statement: GRANT
ALL ON sysuser_data TO md5_role;
2025-07-10 12:49:01.041 CDT [27853260] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:01.042 CDT [27853260] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:01.045 CDT [27853260] 001_password.pl LOG: statement: SET
password_encryption='md5';
2025-07-10 12:49:01.045 CDT [27853260] 001_password.pl LOG: statement: CREATE
ROLE "md5,role" LOGIN PASSWORD 'pass';
2025-07-10 12:49:01.066 CDT [21758210] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:01.068 CDT [21758210] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:01.070 CDT [21758210] 001_password.pl LOG: statement: SET
password_encryption='scram-sha-256';
2025-07-10 12:49:01.071 CDT [21758210] 001_password.pl LOG: statement: SET
scram_iterations=1024;
2025-07-10 12:49:01.071 CDT [21758210] 001_password.pl LOG: statement: CREATE
ROLE scram_role_iter LOGIN PASSWORD 'pass';
2025-07-10 12:49:01.083 CDT [21758210] 001_password.pl LOG: statement: RESET
scram_iterations;
2025-07-10 12:49:01.106 CDT [21758212] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:01.107 CDT [21758212] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:49:01.110 CDT [21758212] 001_password.pl LOG: statement: SELECT
substr(rolpassword,1,19)
FROM pg_authid
WHERE rolname = 'scram_role_iter'
2025-07-10 12:49:01.147 CDT [19923228] [unknown] LOG: connection received:
host=[local]
2025-07-10 12:49:01.148 CDT [19923228] [unknown] LOG: connection authorized:
user=pgsql database=postgres application_name=001_password.pl
2025-07-10 12:52:02.399 CDT [14680534] LOG: received immediate shutdown request
2025-07-10 12:52:02.419 CDT [14680534] LOG: database system is shut down
