[19:32:17.687](0.015s) # setting up data directory # Checking port 55321 # Found port 55321 Name: primary Data directory: /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/archives Connection string: port=55321 host=/tmp/jg3Ggk_V9K Log file: /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/log/003_sslinfo_primary.log [19:32:17.690](0.004s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build/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 46964 ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata -l /tmp/cirrus-ci-build/build/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-02-29 19:32:17.781 UTC [46964][postmaster] LOG: starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-10.2.1, 64-bit 2024-02-29 19:32:17.781 UTC [46964][postmaster] LOG: listening on Unix socket "/tmp/jg3Ggk_V9K/.s.PGSQL.55321" 2024-02-29 19:32:17.788 UTC [46975][startup] LOG: database system was shut down at 2024-02-29 19:30:00 UTC 2024-02-29 19:32:17.791 UTC [46964][postmaster] LOG: database system is ready to accept connections 2024-02-29 19:32:17.874 UTC [47016][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:17.875 UTC [47016][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:17.875 UTC [47016][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:17.884 UTC [47016][client backend] [003_sslinfo.pl][3/2:0] LOG: statement: CREATE USER ssltestuser 2024-02-29 19:32:17.885 UTC [47016][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2024-02-29 19:32:17.928 UTC [47031][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:17.929 UTC [47031][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:17.929 UTC [47031][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:17.930 UTC [47031][client backend] [003_sslinfo.pl][3/4:0] LOG: statement: CREATE USER md5testuser 2024-02-29 19:32:17.930 UTC [47031][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-02-29 19:32:17.972 UTC [47042][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:17.973 UTC [47042][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:17.973 UTC [47042][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:17.973 UTC [47042][client backend] [003_sslinfo.pl][3/6:0] LOG: statement: CREATE USER anotheruser 2024-02-29 19:32:17.974 UTC [47042][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.014 UTC [47048][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.015 UTC [47048][client backend] [[unknown]][3/7:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.015 UTC [47048][client backend] [[unknown]][3/7:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.016 UTC [47048][client backend] [003_sslinfo.pl][3/8:0] LOG: statement: CREATE USER yetanotheruser 2024-02-29 19:32:18.016 UTC [47048][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.001 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.057 UTC [47056][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.058 UTC [47056][client backend] [[unknown]][3/9:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.058 UTC [47056][client backend] [[unknown]][3/9:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.059 UTC [47056][client backend] [003_sslinfo.pl][3/10:0] LOG: statement: CREATE DATABASE trustdb 2024-02-29 19:32:18.092 UTC [47056][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.129 UTC [47073][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.129 UTC [47073][client backend] [[unknown]][3/11:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.129 UTC [47073][client backend] [[unknown]][3/11:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.135 UTC [47073][client backend] [003_sslinfo.pl][3/12:0] LOG: statement: CREATE DATABASE certdb 2024-02-29 19:32:18.231 UTC [47073][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.103 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.404 UTC [47119][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.405 UTC [47119][client backend] [[unknown]][3/13:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.405 UTC [47119][client backend] [[unknown]][3/13:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.406 UTC [47119][client backend] [003_sslinfo.pl][3/14:0] LOG: statement: CREATE DATABASE certdb_dn 2024-02-29 19:32:18.433 UTC [47119][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.527 UTC [47146][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.528 UTC [47146][client backend] [[unknown]][3/15:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.528 UTC [47146][client backend] [[unknown]][3/15:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.532 UTC [47146][client backend] [003_sslinfo.pl][3/16:0] LOG: statement: CREATE DATABASE certdb_dn_re 2024-02-29 19:32:18.574 UTC [47146][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.047 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.639 UTC [47180][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.640 UTC [47180][client backend] [[unknown]][3/17:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.640 UTC [47180][client backend] [[unknown]][3/17:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.641 UTC [47180][client backend] [003_sslinfo.pl][3/18:0] LOG: statement: CREATE DATABASE certdb_cn 2024-02-29 19:32:18.665 UTC [47180][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.684 UTC [47200][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.684 UTC [47200][client backend] [[unknown]][3/19:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.684 UTC [47200][client backend] [[unknown]][3/19:0] LOG: connection authorized: user=postgres database=postgres application_name=003_sslinfo.pl 2024-02-29 19:32:18.685 UTC [47200][client backend] [003_sslinfo.pl][3/20:0] LOG: statement: CREATE DATABASE verifydb 2024-02-29 19:32:18.726 UTC [47200][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=postgres database=postgres host=[local] 2024-02-29 19:32:18.805 UTC [47226][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.806 UTC [47226][client backend] [[unknown]][3/21:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.806 UTC [47226][client backend] [[unknown]][3/21:0] LOG: connection authorized: user=postgres database=trustdb application_name=003_sslinfo.pl 2024-02-29 19:32:18.811 UTC [47226][client backend] [003_sslinfo.pl][3/22:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:18.813 UTC [47226][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=trustdb host=[local] 2024-02-29 19:32:18.852 UTC [47255][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.852 UTC [47255][client backend] [[unknown]][3/23:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.852 UTC [47255][client backend] [[unknown]][3/23:0] LOG: connection authorized: user=postgres database=certdb application_name=003_sslinfo.pl 2024-02-29 19:32:18.856 UTC [47255][client backend] [003_sslinfo.pl][3/24:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:18.858 UTC [47255][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=certdb host=[local] 2024-02-29 19:32:18.894 UTC [47264][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.895 UTC [47264][client backend] [[unknown]][3/25:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.895 UTC [47264][client backend] [[unknown]][3/25:0] LOG: connection authorized: user=postgres database=certdb_dn application_name=003_sslinfo.pl 2024-02-29 19:32:18.899 UTC [47264][client backend] [003_sslinfo.pl][3/26:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:18.902 UTC [47264][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=certdb_dn host=[local] 2024-02-29 19:32:18.936 UTC [47278][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.937 UTC [47278][client backend] [[unknown]][3/27:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.937 UTC [47278][client backend] [[unknown]][3/27:0] LOG: connection authorized: user=postgres database=certdb_dn_re application_name=003_sslinfo.pl 2024-02-29 19:32:18.941 UTC [47278][client backend] [003_sslinfo.pl][3/28:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:18.943 UTC [47278][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=certdb_dn_re host=[local] 2024-02-29 19:32:18.979 UTC [47282][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:18.979 UTC [47282][client backend] [[unknown]][3/29:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:18.979 UTC [47282][client backend] [[unknown]][3/29:0] LOG: connection authorized: user=postgres database=certdb_cn application_name=003_sslinfo.pl 2024-02-29 19:32:18.984 UTC [47282][client backend] [003_sslinfo.pl][3/30:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:18.986 UTC [47282][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=certdb_cn host=[local] 2024-02-29 19:32:19.021 UTC [47291][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-29 19:32:19.022 UTC [47291][client backend] [[unknown]][3/31:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/ssl/003_sslinfo/data/t_003_sslinfo_primary_data/pgdata/pg_hba.conf:117) 2024-02-29 19:32:19.022 UTC [47291][client backend] [[unknown]][3/31:0] LOG: connection authorized: user=postgres database=verifydb application_name=003_sslinfo.pl 2024-02-29 19:32:19.026 UTC [47291][client backend] [003_sslinfo.pl][3/32:0] LOG: statement: CREATE EXTENSION sslinfo CASCADE; 2024-02-29 19:32:19.028 UTC [47291][client backend] [003_sslinfo.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=verifydb host=[local] 2024-02-29 19:32:19.063 UTC [46964][postmaster] LOG: received fast shutdown request 2024-02-29 19:32:19.063 UTC [46964][postmaster] LOG: aborting any active transactions 2024-02-29 19:32:19.064 UTC [46964][postmaster] LOG: background worker "logical replication launcher" (PID 46982) exited with exit code 1 2024-02-29 19:32:19.066 UTC [46973][checkpointer] LOG: shutting down 2024-02-29 19:32:19.066 UTC [46973][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-02-29 19:32:19.099 UTC [46973][checkpointer] LOG: checkpoint complete: wrote 5650 buffers (34.5%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.034 s, sync=0.001 s, total=0.034 s; sync files=0, longest=0.000 s, average=0.000 s; distance=45535 kB, estimate=45535 kB; lsn=0/41A2BB8, redo lsn=0/41A2BB8 2024-02-29 19:32:19.109 UTC [46964][postmaster] LOG: database system is shut down 2024-02-29 19:32:19.180 UTC [47328][postmaster] LOG: starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-10.2.1, 64-bit 2024-02-29 19:32:19.181 UTC [47328][postmaster] LOG: could not bind IPv4 address "127.0.0.1": Address already in use 2024-02-29 19:32:19.181 UTC [47328][postmaster] HINT: Is another postmaster already running on port 55321? If not, wait a few seconds and retry. 2024-02-29 19:32:19.181 UTC [47328][postmaster] WARNING: could not create listen socket for "127.0.0.1" 2024-02-29 19:32:19.181 UTC [47328][postmaster] FATAL: could not create any TCP/IP sockets 2024-02-29 19:32:19.182 UTC [47328][postmaster] LOG: database system is shut down # No postmaster PID for node "primary" [19:32:19.264](1.573s) Bail out! pg_ctl restart failed # No postmaster PID for node "primary"