[03:50:48.710](0.036s) # setting up data directory # Checking port 53552 # Found port 53552 Name: primary Data directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/archives Connection string: port=53552 host=/tmp/MrCi2xXf8S Log file: /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log [03:50:48.719](0.009s) # 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/003_sslinfo/data/t_003_sslinfo_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/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 99352 ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/log/003_sslinfo_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-04-05 03:50:48.879 UTC [99352][postmaster] LOG: starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit 2024-04-05 03:50:48.880 UTC [99352][postmaster] LOG: listening on Unix socket "/tmp/MrCi2xXf8S/.s.PGSQL.53552" 2024-04-05 03:50:48.887 UTC [99363][startup] LOG: database system was shut down at 2024-04-05 03:48:16 UTC 2024-04-05 03:50:48.891 UTC [99352][postmaster] LOG: database system is ready to accept connections 2024-04-05 03:50:48.972 UTC [99411][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:48.973 UTC [99411][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:48.973 UTC [99411][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:48.983 UTC [99411][client backend] [003_sslinfo.pl][0/2:0] LOG: statement: CREATE USER ssltestuser 2024-04-05 03:50:48.984 UTC [99411][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.011 UTC [99431][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.011 UTC [99431][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.011 UTC [99431][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.012 UTC [99431][client backend] [003_sslinfo.pl][1/2:0] LOG: statement: CREATE USER md5testuser 2024-04-05 03:50:49.013 UTC [99431][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.054 UTC [99448][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.054 UTC [99448][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.054 UTC [99448][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.057 UTC [99448][client backend] [003_sslinfo.pl][2/2:0] LOG: statement: CREATE USER anotheruser 2024-04-05 03:50:49.058 UTC [99448][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.094 UTC [99470][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.095 UTC [99470][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.095 UTC [99470][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.096 UTC [99470][client backend] [003_sslinfo.pl][3/2:0] LOG: statement: CREATE USER yetanotheruser 2024-04-05 03:50:49.097 UTC [99470][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.141 UTC [99483][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.141 UTC [99483][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.142 UTC [99483][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.142 UTC [99483][client backend] [003_sslinfo.pl][4/2:0] LOG: statement: CREATE DATABASE trustdb 2024-04-05 03:50:49.186 UTC [99483][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.045 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.284 UTC [99518][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.285 UTC [99518][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.285 UTC [99518][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.286 UTC [99518][client backend] [003_sslinfo.pl][5/2:0] LOG: statement: CREATE DATABASE certdb 2024-04-05 03:50:49.327 UTC [99518][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.406 UTC [99544][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.407 UTC [99544][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.407 UTC [99544][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.408 UTC [99544][client backend] [003_sslinfo.pl][6/2:0] LOG: statement: CREATE DATABASE certdb_dn 2024-04-05 03:50:49.440 UTC [99544][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.455 UTC [99558][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.456 UTC [99558][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.456 UTC [99558][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.457 UTC [99558][client backend] [003_sslinfo.pl][7/2:0] LOG: statement: CREATE DATABASE certdb_dn_re 2024-04-05 03:50:49.498 UTC [99558][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.571 UTC [99600][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.572 UTC [99600][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.572 UTC [99600][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.573 UTC [99600][client backend] [003_sslinfo.pl][8/2:0] LOG: statement: CREATE DATABASE certdb_cn 2024-04-05 03:50:49.603 UTC [99600][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.613 UTC [99607][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.614 UTC [99607][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.614 UTC [99607][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-04-05 03:50:49.615 UTC [99607][client backend] [003_sslinfo.pl][9/2:0] LOG: statement: CREATE DATABASE verifydb 2024-04-05 03:50:49.641 UTC [99607][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2024-04-05 03:50:49.661 UTC [99619][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.662 UTC [99619][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.662 UTC [99619][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=trustdb application_name=003_sslinfo.pl 2024-04-05 03:50:49.667 UTC [99619][client backend] [003_sslinfo.pl][10/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.695 UTC [99619][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=trustdb host=[local] 2024-04-05 03:50:49.712 UTC [99635][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.712 UTC [99635][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.712 UTC [99635][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=certdb application_name=003_sslinfo.pl 2024-04-05 03:50:49.718 UTC [99635][client backend] [003_sslinfo.pl][11/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.722 UTC [99635][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=certdb host=[local] 2024-04-05 03:50:49.749 UTC [99646][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.749 UTC [99646][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.749 UTC [99646][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=certdb_dn application_name=003_sslinfo.pl 2024-04-05 03:50:49.754 UTC [99646][client backend] [003_sslinfo.pl][12/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.757 UTC [99646][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=certdb_dn host=[local] 2024-04-05 03:50:49.802 UTC [99665][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.803 UTC [99665][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.803 UTC [99665][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=certdb_dn_re application_name=003_sslinfo.pl 2024-04-05 03:50:49.815 UTC [99665][client backend] [003_sslinfo.pl][13/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.827 UTC [99665][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=certdb_dn_re host=[local] 2024-04-05 03:50:49.844 UTC [99682][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.845 UTC [99682][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.845 UTC [99682][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=certdb_cn application_name=003_sslinfo.pl 2024-04-05 03:50:49.850 UTC [99682][client backend] [003_sslinfo.pl][14/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.853 UTC [99682][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=certdb_cn host=[local] 2024-04-05 03:50:49.886 UTC [99687][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-05 03:50:49.887 UTC [99687][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-04-05 03:50:49.887 UTC [99687][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=verifydb application_name=003_sslinfo.pl 2024-04-05 03:50:49.892 UTC [99687][client backend] [003_sslinfo.pl][15/2:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-04-05 03:50:49.894 UTC [99687][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=verifydb host=[local] 2024-04-05 03:50:49.927 UTC [99352][postmaster] LOG: received fast shutdown request 2024-04-05 03:50:49.927 UTC [99352][postmaster] LOG: aborting any active transactions 2024-04-05 03:50:49.928 UTC [99352][postmaster] LOG: background worker "logical replication launcher" (PID 99371) exited with exit code 1 2024-04-05 03:50:49.930 UTC [99361][checkpointer] LOG: shutting down 2024-04-05 03:50:49.930 UTC [99361][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-04-05 03:50:49.964 UTC [99361][checkpointer] LOG: checkpoint complete: wrote 5476 buffers (33.4%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.035 s, sync=0.001 s, total=0.035 s; sync files=0, longest=0.000 s, average=0.000 s; distance=44101 kB, estimate=44101 kB; lsn=0/400BA34, redo lsn=0/400BA34 2024-04-05 03:50:49.973 UTC [99352][postmaster] LOG: database system is shut down 2024-04-05 03:50:50.046 UTC [99712][postmaster] LOG: starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit 2024-04-05 03:50:50.046 UTC [99712][postmaster] LOG: could not bind IPv4 address "127.0.0.1": Address already in use 2024-04-05 03:50:50.046 UTC [99712][postmaster] HINT: Is another postmaster already running on port 53552? If not, wait a few seconds and retry. 2024-04-05 03:50:50.046 UTC [99712][postmaster] WARNING: could not create listen socket for "127.0.0.1" 2024-04-05 03:50:50.046 UTC [99712][postmaster] FATAL: could not create any TCP/IP sockets 2024-04-05 03:50:50.047 UTC [99712][postmaster] LOG: database system is shut down # No postmaster PID for node "primary" [03:50:50.128](1.409s) Bail out! pg_ctl restart failed # No postmaster PID for node "primary"