[00:37:11.679](0.025s) # setting up data directory # Checking port 54474 # Found port 54474 Name: primary Data directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata Backup directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/backup Archive directory: /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/archives Connection string: port=54474 host=/tmp/mhyBmdBdrg Log file: /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/log/001_ssltests_primary.log [00:37:11.684](0.005s) # 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/001_ssltests/data/t_001_ssltests_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/001_ssltests/data/t_001_ssltests_primary_data/pgdata ### Starting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/log/001_ssltests_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 82149 [00:37:11.915](0.231s) ok 1 - ssl_library parameter ### Restarting node "primary" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata -l /tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/log/001_ssltests_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-19 00:37:11.809 UTC [82149][postmaster] LOG: starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit 2024-02-19 00:37:11.809 UTC [82149][postmaster] LOG: listening on Unix socket "/tmp/mhyBmdBdrg/.s.PGSQL.54474" 2024-02-19 00:37:11.837 UTC [82154][startup] LOG: database system was shut down at 2024-02-19 00:34:48 UTC 2024-02-19 00:37:11.841 UTC [82149][postmaster] LOG: database system is ready to accept connections 2024-02-19 00:37:11.905 UTC [82166][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:11.906 UTC [82166][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:11.906 UTC [82166][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:11.913 UTC [82166][client backend] [001_ssltests.pl][3/2:0] LOG: statement: SHOW ssl_library 2024-02-19 00:37:11.916 UTC [82166][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2024-02-19 00:37:11.925 UTC [82175][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:11.926 UTC [82175][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:11.926 UTC [82175][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:11.927 UTC [82175][client backend] [001_ssltests.pl][3/4:0] LOG: statement: CREATE USER ssltestuser 2024-02-19 00:37:11.928 UTC [82175][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-02-19 00:37:11.977 UTC [82192][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:11.978 UTC [82192][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:11.978 UTC [82192][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:11.979 UTC [82192][client backend] [001_ssltests.pl][3/6:0] LOG: statement: CREATE USER md5testuser 2024-02-19 00:37:11.980 UTC [82192][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.016 UTC [82222][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.017 UTC [82222][client backend] [[unknown]][3/7:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.017 UTC [82222][client backend] [[unknown]][3/7:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.021 UTC [82222][client backend] [001_ssltests.pl][3/8:0] LOG: statement: CREATE USER anotheruser 2024-02-19 00:37:12.022 UTC [82222][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.073 UTC [82250][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.073 UTC [82250][client backend] [[unknown]][3/9:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.073 UTC [82250][client backend] [[unknown]][3/9:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.074 UTC [82250][client backend] [001_ssltests.pl][3/10:0] LOG: statement: CREATE USER yetanotheruser 2024-02-19 00:37:12.075 UTC [82250][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.117 UTC [82269][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.118 UTC [82269][client backend] [[unknown]][3/11:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.118 UTC [82269][client backend] [[unknown]][3/11:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.119 UTC [82269][client backend] [001_ssltests.pl][3/12:0] LOG: statement: CREATE DATABASE trustdb 2024-02-19 00:37:12.156 UTC [82269][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.042 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.229 UTC [82310][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.230 UTC [82310][client backend] [[unknown]][3/13:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.230 UTC [82310][client backend] [[unknown]][3/13:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.231 UTC [82310][client backend] [001_ssltests.pl][3/14:0] LOG: statement: CREATE DATABASE certdb 2024-02-19 00:37:12.285 UTC [82310][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.055 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.352 UTC [82344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.353 UTC [82344][client backend] [[unknown]][3/15:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.353 UTC [82344][client backend] [[unknown]][3/15:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.354 UTC [82344][client backend] [001_ssltests.pl][3/16:0] LOG: statement: CREATE DATABASE certdb_dn 2024-02-19 00:37:12.380 UTC [82344][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.394 UTC [82358][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.394 UTC [82358][client backend] [[unknown]][3/17:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.394 UTC [82358][client backend] [[unknown]][3/17:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.395 UTC [82358][client backend] [001_ssltests.pl][3/18:0] LOG: statement: CREATE DATABASE certdb_dn_re 2024-02-19 00:37:12.447 UTC [82358][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.053 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.535 UTC [82407][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.536 UTC [82407][client backend] [[unknown]][3/19:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.536 UTC [82407][client backend] [[unknown]][3/19:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.537 UTC [82407][client backend] [001_ssltests.pl][3/20:0] LOG: statement: CREATE DATABASE certdb_cn 2024-02-19 00:37:12.563 UTC [82407][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.579 UTC [82417][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-02-19 00:37:12.580 UTC [82417][client backend] [[unknown]][3/21:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build-32/testrun/ssl/001_ssltests/data/t_001_ssltests_primary_data/pgdata/pg_hba.conf:117) 2024-02-19 00:37:12.580 UTC [82417][client backend] [[unknown]][3/21:0] LOG: connection authorized: user=postgres database=postgres application_name=001_ssltests.pl 2024-02-19 00:37:12.581 UTC [82417][client backend] [001_ssltests.pl][3/22:0] LOG: statement: CREATE DATABASE verifydb 2024-02-19 00:37:12.632 UTC [82417][client backend] [001_ssltests.pl][:0] LOG: disconnection: session time: 0:00:00.052 user=postgres database=postgres host=[local] 2024-02-19 00:37:12.702 UTC [82149][postmaster] LOG: received fast shutdown request 2024-02-19 00:37:12.702 UTC [82149][postmaster] LOG: aborting any active transactions 2024-02-19 00:37:12.707 UTC [82149][postmaster] LOG: background worker "logical replication launcher" (PID 82157) exited with exit code 1 2024-02-19 00:37:12.707 UTC [82152][checkpointer] LOG: shutting down 2024-02-19 00:37:12.707 UTC [82152][checkpointer] LOG: checkpoint starting: shutdown immediate 2024-02-19 00:37:12.747 UTC [82152][checkpointer] LOG: checkpoint complete: wrote 5506 buffers (33.6%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.040 s, sync=0.001 s, total=0.040 s; sync files=0, longest=0.000 s, average=0.000 s; distance=44288 kB, estimate=44288 kB; lsn=0/40400F8, redo lsn=0/40400F8 2024-02-19 00:37:12.764 UTC [82149][postmaster] LOG: database system is shut down 2024-02-19 00:37:12.844 UTC [82460][postmaster] LOG: starting PostgreSQL 17devel on x86-linux, compiled by gcc-10.2.1, 32-bit 2024-02-19 00:37:12.844 UTC [82460][postmaster] LOG: could not bind IPv4 address "127.0.0.1": Address already in use 2024-02-19 00:37:12.844 UTC [82460][postmaster] HINT: Is another postmaster already running on port 54474? If not, wait a few seconds and retry. 2024-02-19 00:37:12.844 UTC [82460][postmaster] WARNING: could not create listen socket for "127.0.0.1" 2024-02-19 00:37:12.844 UTC [82460][postmaster] FATAL: could not create any TCP/IP sockets 2024-02-19 00:37:12.845 UTC [82460][postmaster] LOG: database system is shut down # No postmaster PID for node "primary" [00:37:12.903](0.988s) Bail out! pg_ctl restart failed # No postmaster PID for node "primary"