[16:42:37.543](0.024s) # setting up data directory
# Checking port 59805
# Found port 59805
Name: primary
Data directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/backup
Archive directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/archives
Connection string: port=59805 host=/tmp/3Job6A9_G6
Log file: /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/log/002_scram_primary.log
[16:42:37.547](0.004s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build-32/tmp_install/initdb-template /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
# Running: /tmp/cirrus-ci-build/build-32/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/log/002_scram_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 91296
d41d8cd98f00b204e9800998ecf8427e
### Restarting node "primary"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/log/002_scram_primary.log restart
waiting for server to shut down.... done
server stopped
waiting for server to start.... stopped waiting
pg_ctl: could not start server
Examine the log output.
# pg_ctl restart failed; logfile:
2024-03-08 16:42:37.663 UTC [91296][postmaster] LOG:  starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit
2024-03-08 16:42:37.663 UTC [91296][postmaster] LOG:  listening on Unix socket "/tmp/3Job6A9_G6/.s.PGSQL.59805"
2024-03-08 16:42:37.675 UTC [91304][startup] LOG:  database system was shut down at 2024-03-08 16:40:17 UTC
2024-03-08 16:42:37.686 UTC [91296][postmaster] LOG:  database system is ready to accept connections
2024-03-08 16:42:37.765 UTC [91339][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.766 UTC [91339][client backend] [[unknown]][0/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.766 UTC [91339][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.772 UTC [91339][client backend] [002_scram.pl][0/2:0] LOG:  statement: select md5('')
2024-03-08 16:42:37.774 UTC [91339][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local]
2024-03-08 16:42:37.802 UTC [91353][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.802 UTC [91353][client backend] [[unknown]][1/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.802 UTC [91353][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.804 UTC [91353][client backend] [002_scram.pl][1/2:0] LOG:  statement: CREATE USER ssltestuser
2024-03-08 16:42:37.805 UTC [91353][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
2024-03-08 16:42:37.845 UTC [91366][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.845 UTC [91366][client backend] [[unknown]][2/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.845 UTC [91366][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.846 UTC [91366][client backend] [002_scram.pl][2/2:0] LOG:  statement: CREATE USER md5testuser
2024-03-08 16:42:37.847 UTC [91366][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2024-03-08 16:42:37.889 UTC [91376][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.890 UTC [91376][client backend] [[unknown]][3/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.890 UTC [91376][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.891 UTC [91376][client backend] [002_scram.pl][3/2:0] LOG:  statement: CREATE USER anotheruser
2024-03-08 16:42:37.891 UTC [91376][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local]
2024-03-08 16:42:37.931 UTC [91385][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.931 UTC [91385][client backend] [[unknown]][4/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.931 UTC [91385][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.932 UTC [91385][client backend] [002_scram.pl][4/2:0] LOG:  statement: CREATE USER yetanotheruser
2024-03-08 16:42:37.933 UTC [91385][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local]
2024-03-08 16:42:37.977 UTC [91401][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:37.978 UTC [91401][client backend] [[unknown]][5/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:37.978 UTC [91401][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:37.979 UTC [91401][client backend] [002_scram.pl][5/2:0] LOG:  statement: CREATE DATABASE trustdb
2024-03-08 16:42:38.016 UTC [91401][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.039 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.103 UTC [91431][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.104 UTC [91431][client backend] [[unknown]][6/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.104 UTC [91431][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.104 UTC [91431][client backend] [002_scram.pl][6/2:0] LOG:  statement: CREATE DATABASE certdb
2024-03-08 16:42:38.174 UTC [91431][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.070 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.233 UTC [91458][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.234 UTC [91458][client backend] [[unknown]][7/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.234 UTC [91458][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.235 UTC [91458][client backend] [002_scram.pl][7/2:0] LOG:  statement: CREATE DATABASE certdb_dn
2024-03-08 16:42:38.266 UTC [91458][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.032 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.276 UTC [91472][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.276 UTC [91472][client backend] [[unknown]][8/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.276 UTC [91472][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.277 UTC [91472][client backend] [002_scram.pl][8/2:0] LOG:  statement: CREATE DATABASE certdb_dn_re
2024-03-08 16:42:38.364 UTC [91472][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.088 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.398 UTC [91506][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.398 UTC [91506][client backend] [[unknown]][9/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.398 UTC [91506][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.399 UTC [91506][client backend] [002_scram.pl][9/2:0] LOG:  statement: CREATE DATABASE certdb_cn
2024-03-08 16:42:38.424 UTC [91506][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.026 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.442 UTC [91512][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.442 UTC [91512][client backend] [[unknown]][10/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.442 UTC [91512][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.443 UTC [91512][client backend] [002_scram.pl][10/2:0] LOG:  statement: CREATE DATABASE verifydb
2024-03-08 16:42:38.583 UTC [91512][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.141 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.727 UTC [91556][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.727 UTC [91556][client backend] [[unknown]][11/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.727 UTC [91556][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.728 UTC [91556][client backend] [002_scram.pl][11/2:0] LOG:  statement: SET password_encryption='scram-sha-256';
2024-03-08 16:42:38.728 UTC [91556][client backend] [002_scram.pl][11/3:0] LOG:  statement: ALTER USER ssltestuser PASSWORD 'pass';
2024-03-08 16:42:38.732 UTC [91556][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.770 UTC [91564][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.770 UTC [91564][client backend] [[unknown]][12/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.770 UTC [91564][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.772 UTC [91564][client backend] [002_scram.pl][12/2:0] LOG:  statement: SET password_encryption='md5';
2024-03-08 16:42:38.772 UTC [91564][client backend] [002_scram.pl][12/3:0] LOG:  statement: ALTER USER md5testuser PASSWORD 'pass';
2024-03-08 16:42:38.773 UTC [91564][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.812 UTC [91574][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-03-08 16:42:38.813 UTC [91574][client backend] [[unknown]][13/1:0] LOG:  connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/002_scram/data/t_002_scram_primary_data/pgdata/pg_hba.conf:117)
2024-03-08 16:42:38.813 UTC [91574][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=postgres database=postgres application_name=002_scram.pl
2024-03-08 16:42:38.814 UTC [91574][client backend] [002_scram.pl][13/2:0] LOG:  statement: SET password_encryption='scram-sha-256';
2024-03-08 16:42:38.814 UTC [91574][client backend] [002_scram.pl][13/3:0] LOG:  statement: ALTER USER anotheruser PASSWORD 'pass';
2024-03-08 16:42:38.818 UTC [91574][client backend] [002_scram.pl][:0] LOG:  disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local]
2024-03-08 16:42:38.853 UTC [91296][postmaster] LOG:  received fast shutdown request
2024-03-08 16:42:38.853 UTC [91296][postmaster] LOG:  aborting any active transactions
2024-03-08 16:42:38.855 UTC [91296][postmaster] LOG:  background worker "logical replication launcher" (PID 91314) exited with exit code 1
2024-03-08 16:42:38.856 UTC [91302][checkpointer] LOG:  shutting down
2024-03-08 16:42:38.856 UTC [91302][checkpointer] LOG:  checkpoint starting: shutdown immediate
2024-03-08 16:42:38.916 UTC [91302][checkpointer] LOG:  checkpoint complete: wrote 5500 buffers (33.6%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.060 s, sync=0.001 s, total=0.061 s; sync files=0, longest=0.000 s, average=0.000 s; distance=44240 kB, estimate=44240 kB; lsn=0/40350C0, redo lsn=0/40350C0
2024-03-08 16:42:38.926 UTC [91296][postmaster] LOG:  database system is shut down
2024-03-08 16:42:38.970 UTC [91615][postmaster] LOG:  starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit
2024-03-08 16:42:38.970 UTC [91615][postmaster] LOG:  could not bind IPv4 address "127.0.0.1": Address already in use
2024-03-08 16:42:38.970 UTC [91615][postmaster] HINT:  Is another postmaster already running on port 59805? If not, wait a few seconds and retry.
2024-03-08 16:42:38.970 UTC [91615][postmaster] WARNING:  could not create listen socket for "127.0.0.1"
2024-03-08 16:42:38.970 UTC [91615][postmaster] FATAL:  could not create any TCP/IP sockets
2024-03-08 16:42:38.971 UTC [91615][postmaster] LOG:  database system is shut down
# No postmaster PID for node "primary"
[16:42:39.057](1.509s) Bail out!  pg_ctl restart failed
# No postmaster PID for node "primary"