2025-03-05 13:40:18.852 UTC [33098][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:18.852 UTC [33098][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:18.853 UTC [33098][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:18.877 UTC [33109][startup] LOG: database system was shut down at 2025-03-05 13:38:14 UTC 2025-03-05 13:40:18.887 UTC [33098][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:18.954 UTC [33124][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:18.955 UTC [33124][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:18.955 UTC [33124][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:18.979 UTC [33124][client backend] [001_auth.pl][0/2:0] LOG: statement: CREATE USER test1; 2025-03-05 13:40:18.985 UTC [33124][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.035 UTC [33138][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.036 UTC [33138][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.036 UTC [33138][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.049 UTC [33138][client backend] [001_auth.pl][1/2:0] LOG: statement: CREATE USER test2 WITH ENCRYPTED PASSWORD 'abc123'; 2025-03-05 13:40:19.096 UTC [33138][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.064 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.131 UTC [33157][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.136 UTC [33157][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.136 UTC [33157][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.139 UTC [33157][client backend] [001_auth.pl][2/2:0] LOG: statement: CREATE EXTENSION postgres_fdw; 2025-03-05 13:40:19.177 UTC [33157][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.046 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.202 UTC [33170][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.203 UTC [33170][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.203 UTC [33170][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.205 UTC [33170][client backend] [001_auth.pl][3/2:0] LOG: statement: CREATE EXTENSION dblink; 2025-03-05 13:40:19.235 UTC [33170][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.279 UTC [33186][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.282 UTC [33186][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.282 UTC [33186][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.286 UTC [33186][client backend] [001_auth.pl][4/2:0] LOG: statement: CREATE SERVER s1 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host 'auth-test-localhost.postgresql.example.com', hostaddr '127.0.0.1', port '12172', dbname 'postgres'); 2025-03-05 13:40:19.303 UTC [33186][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.361 UTC [33198][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.362 UTC [33198][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.362 UTC [33198][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.384 UTC [33198][client backend] [001_auth.pl][5/2:0] LOG: statement: CREATE SERVER s2 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '12172', dbname 'postgres', passfile '/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/.pgpass'); 2025-03-05 13:40:19.393 UTC [33198][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.422 UTC [33209][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.428 UTC [33209][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.428 UTC [33209][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.430 UTC [33209][client backend] [001_auth.pl][6/2:0] LOG: statement: GRANT USAGE ON FOREIGN SERVER s1 TO test1; 2025-03-05 13:40:19.437 UTC [33209][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.516 UTC [33226][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.517 UTC [33226][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.517 UTC [33226][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.519 UTC [33226][client backend] [001_auth.pl][7/2:0] LOG: statement: CREATE USER MAPPING FOR test1 SERVER s1 OPTIONS (user 'test1'); 2025-03-05 13:40:19.531 UTC [33226][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.564 UTC [33235][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.565 UTC [33235][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.565 UTC [33235][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.567 UTC [33235][client backend] [001_auth.pl][8/2:0] LOG: statement: CREATE USER MAPPING FOR test1 SERVER s2 OPTIONS (user 'test2'); 2025-03-05 13:40:19.577 UTC [33235][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.607 UTC [33240][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.609 UTC [33240][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.609 UTC [33240][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.611 UTC [33240][client backend] [001_auth.pl][9/2:0] LOG: statement: CREATE TABLE t1 (c1 int); 2025-03-05 13:40:19.621 UTC [33240][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.676 UTC [33247][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.685 UTC [33247][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.685 UTC [33247][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.688 UTC [33247][client backend] [001_auth.pl][10/2:0] LOG: statement: INSERT INTO t1 VALUES (1); 2025-03-05 13:40:19.689 UTC [33247][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.745 UTC [33257][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.746 UTC [33257][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.746 UTC [33257][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.754 UTC [33257][client backend] [001_auth.pl][11/2:0] LOG: statement: CREATE FOREIGN TABLE tf1 (c1 int) SERVER s1 OPTIONS (schema_name 'public', table_name 't1'); 2025-03-05 13:40:19.770 UTC [33257][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.828 UTC [33268][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.834 UTC [33268][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.834 UTC [33268][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.836 UTC [33268][client backend] [001_auth.pl][12/2:0] LOG: statement: GRANT SELECT ON t1 TO test1; 2025-03-05 13:40:19.845 UTC [33268][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.898 UTC [33276][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.899 UTC [33276][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.899 UTC [33276][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.909 UTC [33276][client backend] [001_auth.pl][13/2:0] LOG: statement: GRANT SELECT ON tf1 TO test1; 2025-03-05 13:40:19.911 UTC [33276][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=postgres host=[local] 2025-03-05 13:40:19.962 UTC [33286][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:19.963 UTC [33286][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:19.963 UTC [33286][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:19.965 UTC [33286][client backend] [001_auth.pl][14/2:0] LOG: statement: CREATE FOREIGN TABLE tf2 (c1 int) SERVER s2 OPTIONS (schema_name 'public', table_name 't1'); 2025-03-05 13:40:19.976 UTC [33286][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2025-03-05 13:40:20.017 UTC [33297][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:20.018 UTC [33297][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:20.018 UTC [33297][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:20.027 UTC [33297][client backend] [001_auth.pl][15/2:0] LOG: statement: GRANT SELECT ON tf2 TO test1; 2025-03-05 13:40:20.034 UTC [33297][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=postgres database=postgres host=[local] 2025-03-05 13:40:20.072 UTC [33303][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:20.074 UTC [33303][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:20.074 UTC [33303][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:20.085 UTC [33303][client backend] [001_auth.pl][16/2:0] LOG: statement: CREATE TABLE ids (id) AS SELECT 'gss:test1@EXAMPLE.COM' FROM generate_series(1, 10); 2025-03-05 13:40:20.105 UTC [33303][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2025-03-05 13:40:20.155 UTC [33311][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:20.156 UTC [33311][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2025-03-05 13:40:20.156 UTC [33311][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2025-03-05 13:40:20.163 UTC [33311][client backend] [001_auth.pl][17/2:0] LOG: statement: GRANT SELECT ON ids TO public; 2025-03-05 13:40:20.180 UTC [33311][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=postgres database=postgres host=[local] 2025-03-05 13:40:20.197 UTC [33098][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:20.197 UTC [33098][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:20.219 UTC [33098][postmaster] LOG: background worker "logical replication launcher" (PID 33116) exited with exit code 1 2025-03-05 13:40:20.220 UTC [33106][checkpointer] LOG: shutting down 2025-03-05 13:40:20.220 UTC [33106][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:20.223 UTC [33106][checkpointer] LOG: checkpoint complete: wrote 121 buffers (0.7%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=543 kB, estimate=543 kB; lsn=0/1812230, redo lsn=0/1812230 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 33106 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fb736851f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x556864f85ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x556864ca4c2c] postgres: node: checkpointer (+0xe96ed6)[0x556864ca4ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x556864bf2a89] postgres: node: checkpointer (+0xde4d27)[0x556864bf2d27] postgres: node: checkpointer (proc_exit+0x3d)[0x556864bf2e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x556864ab6196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x556864ab6a53] postgres: node: checkpointer (+0xcaed1d)[0x556864abcd1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x556864ac187f] postgres: node: checkpointer (main+0x2a2)[0x55686485d0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fb73577824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fb735778305] postgres: node: checkpointer (_start+0x21)[0x5568642323a1] 2025-03-05 13:40:23.680 UTC [33098][postmaster] LOG: checkpointer process (PID 33106) was terminated by signal 6: Aborted 2025-03-05 13:40:23.680 UTC [33098][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:23.680 UTC [33098][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:23.708 UTC [33098][postmaster] LOG: database system is shut down 2025-03-05 13:40:23.759 UTC [33863][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:23.759 UTC [33863][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:23.759 UTC [33863][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:23.837 UTC [33888][startup] LOG: database system was shut down at 2025-03-05 13:40:20 UTC 2025-03-05 13:40:23.847 UTC [33863][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:23.976 UTC [33906][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42576 2025-03-05 13:40:24.017 UTC [33906][client backend] [[unknown]][0/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:24.017 UTC [33906][client backend] [[unknown]][0/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: "host all all 127.0.0.1/32 gss map=mymap" 2025-03-05 13:40:24.081 UTC [33925][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42586 2025-03-05 13:40:24.095 UTC [33925][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:24.095 UTC [33925][client backend] [[unknown]][1/1:0] LOG: no match in usermap "mymap" for user "test1" authenticated as "test1@EXAMPLE.COM" 2025-03-05 13:40:24.095 UTC [33925][client backend] [[unknown]][1/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:24.095 UTC [33925][client backend] [[unknown]][1/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: "host all all 127.0.0.1/32 gss map=mymap" 2025-03-05 13:40:24.106 UTC [33929][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42598 2025-03-05 13:40:24.114 UTC [33929][client backend] [[unknown]][2/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:24.114 UTC [33929][client backend] [[unknown]][2/1:0] LOG: no match in usermap "mymap" for user "test1" authenticated as "test1@EXAMPLE.COM" 2025-03-05 13:40:24.114 UTC [33929][client backend] [[unknown]][2/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:24.114 UTC [33929][client backend] [[unknown]][2/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: "host all all 127.0.0.1/32 gss map=mymap" 2025-03-05 13:40:24.137 UTC [33863][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:24.137 UTC [33863][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:24.159 UTC [33863][postmaster] LOG: background worker "logical replication launcher" (PID 33892) exited with exit code 1 2025-03-05 13:40:24.159 UTC [33885][checkpointer] LOG: shutting down 2025-03-05 13:40:24.159 UTC [33885][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:24.170 UTC [33885][checkpointer] LOG: checkpoint complete: wrote 1 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s; distance=2 kB, estimate=2 kB; lsn=0/1812C20, redo lsn=0/1812C20 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 33885 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fe66c251f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x5617b38dbac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x5617b35fac2c] postgres: node: checkpointer (+0xe96ed6)[0x5617b35faed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x5617b3548a89] postgres: node: checkpointer (+0xde4d27)[0x5617b3548d27] postgres: node: checkpointer (proc_exit+0x3d)[0x5617b3548e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x5617b340c196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x5617b340ca53] postgres: node: checkpointer (+0xcaed1d)[0x5617b3412d1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x5617b341787f] postgres: node: checkpointer (main+0x2a2)[0x5617b31b30be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fe66b04824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fe66b048305] postgres: node: checkpointer (_start+0x21)[0x5617b2b883a1] 2025-03-05 13:40:26.811 UTC [33863][postmaster] LOG: checkpointer process (PID 33885) was terminated by signal 6: Aborted 2025-03-05 13:40:26.811 UTC [33863][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:26.811 UTC [33863][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:26.917 UTC [33863][postmaster] LOG: database system is shut down 2025-03-05 13:40:27.020 UTC [34358][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:27.020 UTC [34358][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:27.020 UTC [34358][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:27.039 UTC [34371][startup] LOG: database system was shut down at 2025-03-05 13:40:24 UTC 2025-03-05 13:40:27.066 UTC [34358][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:27.157 UTC [34391][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42608 2025-03-05 13:40:27.169 UTC [34391][client backend] [[unknown]][0/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.169 UTC [34391][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.210 UTC [34391][client backend] [001_auth.pl][0/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:27.227 UTC [34391][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.070 user=test1 database=postgres host=127.0.0.1 port=42608 2025-03-05 13:40:27.289 UTC [34404][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42618 2025-03-05 13:40:27.301 UTC [34404][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.301 UTC [34404][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.306 UTC [34404][client backend] [001_auth.pl][1/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:27.309 UTC [34404][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=test1 database=postgres host=127.0.0.1 port=42618 2025-03-05 13:40:27.357 UTC [34418][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42632 2025-03-05 13:40:27.369 UTC [34418][client backend] [[unknown]][2/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.369 UTC [34418][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.372 UTC [34418][client backend] [001_auth.pl][2/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:27.385 UTC [34418][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=test1 database=postgres host=127.0.0.1 port=42632 2025-03-05 13:40:27.433 UTC [34430][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42640 2025-03-05 13:40:27.447 UTC [34430][client backend] [[unknown]][3/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.447 UTC [34430][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.450 UTC [34430][client backend] [001_auth.pl][3/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:27.461 UTC [34430][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=test1 database=postgres host=127.0.0.1 port=42640 2025-03-05 13:40:27.509 UTC [34441][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42652 2025-03-05 13:40:27.522 UTC [34441][client backend] [[unknown]][4/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.523 UTC [34441][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.525 UTC [34441][client backend] [001_auth.pl][4/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:27.531 UTC [34441][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=test1 database=postgres host=127.0.0.1 port=42652 2025-03-05 13:40:27.596 UTC [34462][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42668 2025-03-05 13:40:27.610 UTC [34462][client backend] [[unknown]][5/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.610 UTC [34462][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.612 UTC [34462][client backend] [001_auth.pl][5/2:0] LOG: statement: SELECT * FROM generate_series(1, 100000); 2025-03-05 13:40:27.809 UTC [34462][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.216 user=test1 database=postgres host=127.0.0.1 port=42668 2025-03-05 13:40:27.910 UTC [34509][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42684 2025-03-05 13:40:27.923 UTC [34509][client backend] [[unknown]][6/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:27.923 UTC [34509][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:27.930 UTC [34509][client backend] [001_auth.pl][6/2:0] LOG: statement: CREATE TEMP TABLE mytab (f1 int primary key); 2025-03-05 13:40:27.939 UTC [34509][client backend] [001_auth.pl][6/3:0] LOG: statement: COPY mytab FROM STDIN; 2025-03-05 13:40:28.501 UTC [34509][client backend] [001_auth.pl][6/4:0] LOG: statement: SELECT COUNT(*) FROM mytab; 2025-03-05 13:40:28.542 UTC [34509][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.632 user=test1 database=postgres host=127.0.0.1 port=42684 2025-03-05 13:40:28.578 UTC [34580][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42700 2025-03-05 13:40:28.589 UTC [34580][client backend] [[unknown]][7/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:28.589 UTC [34580][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:28.593 UTC [34580][client backend] [001_auth.pl][7/2:0] LOG: statement: SELECT $$connected with port=12172 host=/tmp/oVchEAiOqU dbname='postgres' user=test1 host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 gssencmode=disable require_auth=gss$$ 2025-03-05 13:40:28.598 UTC [34580][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.020 user=test1 database=postgres host=127.0.0.1 port=42700 2025-03-05 13:40:28.643 UTC [34587][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42704 2025-03-05 13:40:28.657 UTC [34587][client backend] [[unknown]][8/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:28.657 UTC [34587][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:28.659 UTC [34587][client backend] [001_auth.pl][8/2:0] LOG: statement: SELECT $$connected with port=12172 host=/tmp/oVchEAiOqU dbname='postgres' user=test1 host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 gssencmode=require require_auth=gss$$ 2025-03-05 13:40:28.665 UTC [34587][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=test1 database=postgres host=127.0.0.1 port=42704 2025-03-05 13:40:28.698 UTC [34597][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42710 2025-03-05 13:40:28.705 UTC [34597][client backend] [[unknown]][9/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:28.705 UTC [34597][client backend] [[unknown]][9/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: "host all all 127.0.0.1/32 gss map=mymap" 2025-03-05 13:40:28.752 UTC [34605][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42724 2025-03-05 13:40:28.770 UTC [34605][client backend] [[unknown]][10/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:28.770 UTC [34605][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:28.779 UTC [34605][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=test1 database=postgres host=127.0.0.1 port=42724 2025-03-05 13:40:28.817 UTC [34614][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42736 2025-03-05 13:40:28.834 UTC [34614][client backend] [[unknown]][11/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:28.834 UTC [34614][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:28.837 UTC [34614][client backend] [001_auth.pl][11/2:0] LOG: statement: SELECT SYSTEM_USER; 2025-03-05 13:40:28.838 UTC [34614][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=test1 database=postgres host=127.0.0.1 port=42736 2025-03-05 13:40:28.880 UTC [34624][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42752 2025-03-05 13:40:28.893 UTC [34624][client backend] [[unknown]][12/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:28.893 UTC [34624][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:28.895 UTC [34624][client backend] [001_auth.pl][12/2:0] LOG: statement: SET min_parallel_table_scan_size TO 0; 2025-03-05 13:40:28.896 UTC [34624][client backend] [001_auth.pl][12/3:0] LOG: statement: SET parallel_setup_cost TO 0; 2025-03-05 13:40:28.896 UTC [34624][client backend] [001_auth.pl][12/4:0] LOG: statement: SET parallel_tuple_cost TO 0; 2025-03-05 13:40:28.896 UTC [34624][client backend] [001_auth.pl][12/5:0] LOG: statement: SET max_parallel_workers_per_gather TO 2; 2025-03-05 13:40:28.896 UTC [34624][client backend] [001_auth.pl][12/6:0] LOG: statement: SELECT bool_and(SYSTEM_USER = id) FROM ids; 2025-03-05 13:40:28.939 UTC [34624][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.059 user=test1 database=postgres host=127.0.0.1 port=42752 2025-03-05 13:40:28.998 UTC [34640][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42768 2025-03-05 13:40:29.025 UTC [34640][client backend] [[unknown]][13/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:29.025 UTC [34640][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:29.034 UTC [34640][client backend] [001_auth.pl][13/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:29.039 UTC [34640][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.041 user=test1 database=postgres host=127.0.0.1 port=42768 2025-03-05 13:40:29.069 UTC [34648][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=42772 2025-03-05 13:40:29.095 UTC [34648][client backend] [[unknown]][14/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:29.095 UTC [34648][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:29.097 UTC [34648][client backend] [001_auth.pl][14/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:29.116 UTC [34648][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.047 user=test1 database=postgres host=127.0.0.1 port=42772 2025-03-05 13:40:29.135 UTC [34358][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:29.135 UTC [34358][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:29.157 UTC [34358][postmaster] LOG: background worker "logical replication launcher" (PID 34380) exited with exit code 1 2025-03-05 13:40:29.158 UTC [34369][checkpointer] LOG: shutting down 2025-03-05 13:40:29.158 UTC [34369][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:29.228 UTC [34369][checkpointer] LOG: checkpoint complete: wrote 40 buffers (0.2%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.071 s; sync files=0, longest=0.000 s, average=0.000 s; distance=153 kB, estimate=153 kB; lsn=0/1839238, redo lsn=0/1839238 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 34369 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7fe5f2e51f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x5640d0188ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x5640cfea7c2c] postgres: node: checkpointer (+0xe96ed6)[0x5640cfea7ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x5640cfdf5a89] postgres: node: checkpointer (+0xde4d27)[0x5640cfdf5d27] postgres: node: checkpointer (proc_exit+0x3d)[0x5640cfdf5e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x5640cfcb9196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x5640cfcb9a53] postgres: node: checkpointer (+0xcaed1d)[0x5640cfcbfd1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x5640cfcc487f] postgres: node: checkpointer (main+0x2a2)[0x5640cfa600be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7fe5f1e4824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7fe5f1e48305] postgres: node: checkpointer (_start+0x21)[0x5640cf4353a1] 2025-03-05 13:40:33.951 UTC [34358][postmaster] LOG: checkpointer process (PID 34369) was terminated by signal 6: Aborted 2025-03-05 13:40:33.951 UTC [34358][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:33.951 UTC [34358][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:33.979 UTC [34358][postmaster] LOG: database system is shut down 2025-03-05 13:40:34.089 UTC [35065][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:34.089 UTC [35065][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:34.089 UTC [35065][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:34.249 UTC [35075][startup] LOG: database system was shut down at 2025-03-05 13:40:29 UTC 2025-03-05 13:40:34.263 UTC [35065][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:34.372 UTC [35087][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41482 2025-03-05 13:40:34.425 UTC [35087][client backend] [[unknown]][0/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:34.425 UTC [35087][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:34.458 UTC [35087][client backend] [001_auth.pl][0/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:34.470 UTC [35087][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.098 user=test1 database=postgres host=127.0.0.1 port=41482 2025-03-05 13:40:34.491 UTC [35097][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41486 2025-03-05 13:40:34.507 UTC [35097][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:34.507 UTC [35097][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:34.510 UTC [35097][client backend] [001_auth.pl][1/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:34.513 UTC [35097][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=test1 database=postgres host=127.0.0.1 port=41486 2025-03-05 13:40:34.527 UTC [35065][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:34.527 UTC [35065][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:34.541 UTC [35065][postmaster] LOG: background worker "logical replication launcher" (PID 35079) exited with exit code 1 2025-03-05 13:40:34.541 UTC [35073][checkpointer] LOG: shutting down 2025-03-05 13:40:34.541 UTC [35073][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:34.615 UTC [35073][checkpointer] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.075 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/18392B0, redo lsn=0/18392B0 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 35073 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f6f94e51f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x55c687684ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x55c6873a3c2c] postgres: node: checkpointer (+0xe96ed6)[0x55c6873a3ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x55c6872f1a89] postgres: node: checkpointer (+0xde4d27)[0x55c6872f1d27] postgres: node: checkpointer (proc_exit+0x3d)[0x55c6872f1e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x55c6871b5196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x55c6871b5a53] postgres: node: checkpointer (+0xcaed1d)[0x55c6871bbd1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x55c6871c087f] postgres: node: checkpointer (main+0x2a2)[0x55c686f5c0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f6f93e4824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f6f93e48305] postgres: node: checkpointer (_start+0x21)[0x55c6869313a1] 2025-03-05 13:40:36.694 UTC [35065][postmaster] LOG: checkpointer process (PID 35073) was terminated by signal 6: Aborted 2025-03-05 13:40:36.694 UTC [35065][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:36.694 UTC [35065][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:36.728 UTC [35065][postmaster] LOG: database system is shut down 2025-03-05 13:40:36.778 UTC [35360][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:36.778 UTC [35360][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:36.778 UTC [35360][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:36.813 UTC [35370][startup] LOG: database system was shut down at 2025-03-05 13:40:34 UTC 2025-03-05 13:40:36.825 UTC [35360][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:36.889 UTC [35381][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41492 2025-03-05 13:40:36.904 UTC [35381][client backend] [[unknown]][0/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:36.904 UTC [35381][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:36.945 UTC [35381][client backend] [001_auth.pl][0/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:36.962 UTC [35381][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.074 user=test1 database=postgres host=127.0.0.1 port=41492 2025-03-05 13:40:36.994 UTC [35395][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41496 2025-03-05 13:40:37.008 UTC [35395][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.008 UTC [35395][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.010 UTC [35395][client backend] [001_auth.pl][1/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND credentials_delegated from pg_stat_gssapi where pid = pg_backend_pid(); 2025-03-05 13:40:37.022 UTC [35395][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=test1 database=postgres host=127.0.0.1 port=41496 2025-03-05 13:40:37.079 UTC [35405][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41498 2025-03-05 13:40:37.092 UTC [35405][client backend] [[unknown]][2/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.092 UTC [35405][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.095 UTC [35405][client backend] [001_auth.pl][2/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:37.109 UTC [35405][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=test1 database=postgres host=127.0.0.1 port=41498 2025-03-05 13:40:37.148 UTC [35422][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41502 2025-03-05 13:40:37.164 UTC [35422][client backend] [[unknown]][3/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.164 UTC [35422][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.167 UTC [35422][client backend] [001_auth.pl][3/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND NOT credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:37.177 UTC [35422][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=test1 database=postgres host=127.0.0.1 port=41502 2025-03-05 13:40:37.204 UTC [35439][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41510 2025-03-05 13:40:37.216 UTC [35439][client backend] [[unknown]][4/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.216 UTC [35439][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.218 UTC [35439][client backend] [001_auth.pl][4/2:0] LOG: statement: SELECT * FROM dblink('user=test1 dbname=postgres host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 port=12172','select 1') as t1(c1 int); 2025-03-05 13:40:37.222 UTC [35439][client backend] [001_auth.pl][4/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:37.222 UTC [35439][client backend] [001_auth.pl][4/2:0] DETAIL: Non-superusers must provide a password in the connection string or send delegated GSSAPI credentials. 2025-03-05 13:40:37.222 UTC [35439][client backend] [001_auth.pl][4/2:0] STATEMENT: SELECT * FROM dblink('user=test1 dbname=postgres host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 port=12172','select 1') as t1(c1 int); 2025-03-05 13:40:37.229 UTC [35439][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=test1 database=postgres host=127.0.0.1 port=41510 2025-03-05 13:40:37.277 UTC [35452][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41518 2025-03-05 13:40:37.290 UTC [35452][client backend] [[unknown]][5/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.290 UTC [35452][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.293 UTC [35452][client backend] [001_auth.pl][5/2:0] LOG: statement: SELECT * FROM dblink('user=test2 dbname=postgres port=12172 passfile=/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/.pgpass','select 1') as t1(c1 int); 2025-03-05 13:40:37.297 UTC [35452][client backend] [001_auth.pl][5/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:37.297 UTC [35452][client backend] [001_auth.pl][5/2:0] DETAIL: Non-superusers must provide a password in the connection string or send delegated GSSAPI credentials. 2025-03-05 13:40:37.297 UTC [35452][client backend] [001_auth.pl][5/2:0] STATEMENT: SELECT * FROM dblink('user=test2 dbname=postgres port=12172 passfile=/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/.pgpass','select 1') as t1(c1 int); 2025-03-05 13:40:37.317 UTC [35452][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=test1 database=postgres host=127.0.0.1 port=41518 2025-03-05 13:40:37.366 UTC [35466][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41524 2025-03-05 13:40:37.380 UTC [35466][client backend] [[unknown]][6/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.380 UTC [35466][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.382 UTC [35466][client backend] [001_auth.pl][6/2:0] LOG: statement: TABLE tf1; 2025-03-05 13:40:37.387 UTC [35466][client backend] [001_auth.pl][6/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:37.387 UTC [35466][client backend] [001_auth.pl][6/2:0] DETAIL: Non-superusers must delegate GSSAPI credentials, provide a password, or enable SCRAM pass-through in user mapping. 2025-03-05 13:40:37.387 UTC [35466][client backend] [001_auth.pl][6/2:0] STATEMENT: TABLE tf1; 2025-03-05 13:40:37.397 UTC [35466][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.032 user=test1 database=postgres host=127.0.0.1 port=41524 2025-03-05 13:40:37.457 UTC [35480][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41530 2025-03-05 13:40:37.469 UTC [35480][client backend] [[unknown]][7/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.470 UTC [35480][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.472 UTC [35480][client backend] [001_auth.pl][7/2:0] LOG: statement: TABLE tf2; 2025-03-05 13:40:37.476 UTC [35480][client backend] [001_auth.pl][7/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:37.476 UTC [35480][client backend] [001_auth.pl][7/2:0] DETAIL: Non-superusers must delegate GSSAPI credentials, provide a password, or enable SCRAM pass-through in user mapping. 2025-03-05 13:40:37.476 UTC [35480][client backend] [001_auth.pl][7/2:0] STATEMENT: TABLE tf2; 2025-03-05 13:40:37.484 UTC [35480][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=test1 database=postgres host=127.0.0.1 port=41530 2025-03-05 13:40:37.545 UTC [35490][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41536 2025-03-05 13:40:37.546 UTC [35490][client backend] [[unknown]][8/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", no encryption 2025-03-05 13:40:37.606 UTC [35499][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41542 2025-03-05 13:40:37.620 UTC [35499][client backend] [[unknown]][9/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.620 UTC [35499][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.622 UTC [35499][client backend] [001_auth.pl][9/2:0] LOG: statement: SELECT $$connected with port=12172 host=/tmp/oVchEAiOqU dbname='postgres' user=test1 host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 gssencmode=require require_auth=gss$$ 2025-03-05 13:40:37.627 UTC [35499][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.028 user=test1 database=postgres host=127.0.0.1 port=41542 2025-03-05 13:40:37.659 UTC [35512][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41554 2025-03-05 13:40:37.673 UTC [35512][client backend] [[unknown]][10/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:37.673 UTC [35512][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:37.676 UTC [35512][client backend] [001_auth.pl][10/2:0] LOG: statement: SELECT $$connected with port=12172 host=/tmp/oVchEAiOqU dbname='postgres' user=test1 host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 gssencmode=require require_auth=gss,scram-sha-256$$ 2025-03-05 13:40:37.683 UTC [35512][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=test1 database=postgres host=127.0.0.1 port=41554 2025-03-05 13:40:37.703 UTC [35360][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:37.703 UTC [35360][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:37.719 UTC [35360][postmaster] LOG: background worker "logical replication launcher" (PID 35376) exited with exit code 1 2025-03-05 13:40:37.720 UTC [35368][checkpointer] LOG: shutting down 2025-03-05 13:40:37.720 UTC [35368][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:37.721 UTC [35368][checkpointer] LOG: checkpoint complete: wrote 6 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32 kB, estimate=32 kB; lsn=0/1841578, redo lsn=0/1841578 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 35368 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f7d7e451f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x558a14e15ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x558a14b34c2c] postgres: node: checkpointer (+0xe96ed6)[0x558a14b34ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x558a14a82a89] postgres: node: checkpointer (+0xde4d27)[0x558a14a82d27] postgres: node: checkpointer (proc_exit+0x3d)[0x558a14a82e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x558a14946196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x558a14946a53] postgres: node: checkpointer (+0xcaed1d)[0x558a1494cd1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x558a1495187f] postgres: node: checkpointer (main+0x2a2)[0x558a146ed0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f7d7d24824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f7d7d248305] postgres: node: checkpointer (_start+0x21)[0x558a140c23a1] 2025-03-05 13:40:39.506 UTC [35360][postmaster] LOG: checkpointer process (PID 35368) was terminated by signal 6: Aborted 2025-03-05 13:40:39.506 UTC [35360][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:39.506 UTC [35360][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:39.555 UTC [35360][postmaster] LOG: database system is shut down 2025-03-05 13:40:39.706 UTC [35694][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:39.706 UTC [35694][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:39.707 UTC [35694][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:39.716 UTC [35698][startup] LOG: database system was shut down at 2025-03-05 13:40:37 UTC 2025-03-05 13:40:39.726 UTC [35694][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:39.835 UTC [35717][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41556 2025-03-05 13:40:39.864 UTC [35717][client backend] [[unknown]][0/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:39.872 UTC [35726][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41566 2025-03-05 13:40:39.883 UTC [35726][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:39.883 UTC [35726][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:39.905 UTC [35726][client backend] [001_auth.pl][1/2:0] LOG: statement: SELECT gss_authenticated AND NOT encrypted AND credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:39.916 UTC [35726][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.044 user=test1 database=postgres host=127.0.0.1 port=41566 2025-03-05 13:40:39.943 UTC [35741][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41582 2025-03-05 13:40:39.954 UTC [35741][client backend] [[unknown]][2/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.009 UTC [35756][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41590 2025-03-05 13:40:40.020 UTC [35756][client backend] [[unknown]][3/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.020 UTC [35756][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.026 UTC [35756][client backend] [001_auth.pl][3/2:0] LOG: statement: SELECT gss_authenticated AND NOT encrypted AND credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:40.032 UTC [35756][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=test1 database=postgres host=127.0.0.1 port=41590 2025-03-05 13:40:40.075 UTC [35764][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41606 2025-03-05 13:40:40.089 UTC [35764][client backend] [[unknown]][4/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.094 UTC [35766][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41616 2025-03-05 13:40:40.107 UTC [35766][client backend] [[unknown]][5/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.107 UTC [35766][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.110 UTC [35766][client backend] [001_auth.pl][5/2:0] LOG: statement: SELECT * FROM dblink('user=test1 dbname=postgres host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 port=12172','select 1') as t1(c1 int); 2025-03-05 13:40:40.122 UTC [35770][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41622 2025-03-05 13:40:40.135 UTC [35770][client backend] [[unknown]][6/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.145 UTC [35772][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41630 2025-03-05 13:40:40.154 UTC [35772][client backend] [[unknown]][7/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.155 UTC [35772][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=test1 database=postgres GSS (authenticated=yes, encrypted=no, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.159 UTC [35772][client backend] [[unknown]][7/2:0] LOG: statement: select 1 2025-03-05 13:40:40.168 UTC [35766][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.074 user=test1 database=postgres host=127.0.0.1 port=41616 2025-03-05 13:40:40.177 UTC [35772][client backend] [[unknown]][:0] LOG: disconnection: session time: 0:00:00.032 user=test1 database=postgres host=127.0.0.1 port=41630 2025-03-05 13:40:40.202 UTC [35776][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41644 2025-03-05 13:40:40.219 UTC [35776][client backend] [[unknown]][8/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.238 UTC [35779][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41650 2025-03-05 13:40:40.251 UTC [35779][client backend] [[unknown]][9/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.251 UTC [35779][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.257 UTC [35779][client backend] [001_auth.pl][9/2:0] LOG: statement: TABLE tf1; 2025-03-05 13:40:40.274 UTC [35783][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41666 2025-03-05 13:40:40.288 UTC [35783][client backend] [[unknown]][10/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.298 UTC [35785][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41678 2025-03-05 13:40:40.308 UTC [35785][client backend] [[unknown]][11/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.308 UTC [35785][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=test1 database=postgres application_name=postgres_fdw GSS (authenticated=yes, encrypted=no, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.318 UTC [35785][client backend] [postgres_fdw][11/2:0] LOG: statement: SET search_path = pg_catalog 2025-03-05 13:40:40.318 UTC [35785][client backend] [postgres_fdw][11/3:0] LOG: statement: SET timezone = 'GMT' 2025-03-05 13:40:40.318 UTC [35785][client backend] [postgres_fdw][11/4:0] LOG: statement: SET datestyle = ISO 2025-03-05 13:40:40.319 UTC [35785][client backend] [postgres_fdw][11/5:0] LOG: statement: SET intervalstyle = postgres 2025-03-05 13:40:40.319 UTC [35785][client backend] [postgres_fdw][11/6:0] LOG: statement: SET extra_float_digits = 3 2025-03-05 13:40:40.319 UTC [35785][client backend] [postgres_fdw][11/7:0] LOG: statement: START TRANSACTION ISOLATION LEVEL REPEATABLE READ 2025-03-05 13:40:40.320 UTC [35785][client backend] [postgres_fdw][11/7:0] LOG: execute : DECLARE c1 CURSOR FOR SELECT c1 FROM public.t1 2025-03-05 13:40:40.320 UTC [35785][client backend] [postgres_fdw][11/7:0] LOG: statement: FETCH 100 FROM c1 2025-03-05 13:40:40.322 UTC [35785][client backend] [postgres_fdw][11/7:0] LOG: statement: CLOSE c1 2025-03-05 13:40:40.322 UTC [35785][client backend] [postgres_fdw][11/7:0] LOG: statement: COMMIT TRANSACTION 2025-03-05 13:40:40.327 UTC [35779][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.089 user=test1 database=postgres host=127.0.0.1 port=41650 2025-03-05 13:40:40.339 UTC [35785][client backend] [postgres_fdw][:0] LOG: disconnection: session time: 0:00:00.040 user=test1 database=postgres host=127.0.0.1 port=41678 2025-03-05 13:40:40.393 UTC [35795][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41688 2025-03-05 13:40:40.407 UTC [35795][client backend] [[unknown]][12/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.418 UTC [35802][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41692 2025-03-05 13:40:40.430 UTC [35802][client backend] [[unknown]][13/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.430 UTC [35802][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.437 UTC [35802][client backend] [001_auth.pl][13/2:0] LOG: statement: SELECT * FROM dblink('user=test2 dbname=postgres port=12172 passfile=/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/.pgpass','select 1') as t1(c1 int); 2025-03-05 13:40:40.452 UTC [35805][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:40.470 UTC [35805][client backend] [[unknown]][14/1:0] LOG: connection authenticated: identity="test2" method=scram-sha-256 (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:2) 2025-03-05 13:40:40.470 UTC [35805][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=test2 database=postgres 2025-03-05 13:40:40.474 UTC [35805][client backend] [[unknown]][:0] LOG: disconnection: session time: 0:00:00.025 user=test2 database=postgres host=[local] 2025-03-05 13:40:40.477 UTC [35802][client backend] [001_auth.pl][13/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:40.477 UTC [35802][client backend] [001_auth.pl][13/2:0] DETAIL: Non-superusers may only connect using credentials they provide, eg: password in connection string or delegated GSSAPI credentials 2025-03-05 13:40:40.477 UTC [35802][client backend] [001_auth.pl][13/2:0] HINT: Ensure provided credentials match target server's authentication method. 2025-03-05 13:40:40.477 UTC [35802][client backend] [001_auth.pl][13/2:0] STATEMENT: SELECT * FROM dblink('user=test2 dbname=postgres port=12172 passfile=/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/.pgpass','select 1') as t1(c1 int); 2025-03-05 13:40:40.481 UTC [35802][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.064 user=test1 database=postgres host=127.0.0.1 port=41692 2025-03-05 13:40:40.547 UTC [35827][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41702 2025-03-05 13:40:40.561 UTC [35827][client backend] [[unknown]][15/1:0] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "test1", database "postgres", GSS encryption 2025-03-05 13:40:40.570 UTC [35832][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=41712 2025-03-05 13:40:40.580 UTC [35832][client backend] [[unknown]][16/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:40.580 UTC [35832][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=no, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:40.584 UTC [35832][client backend] [001_auth.pl][16/2:0] LOG: statement: TABLE tf2; 2025-03-05 13:40:40.590 UTC [35836][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-03-05 13:40:40.610 UTC [35836][client backend] [[unknown]][17/1:0] LOG: connection authenticated: identity="test2" method=scram-sha-256 (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:2) 2025-03-05 13:40:40.610 UTC [35836][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=test2 database=postgres application_name=postgres_fdw 2025-03-05 13:40:40.612 UTC [35832][client backend] [001_auth.pl][16/2:0] ERROR: password or GSSAPI delegated credentials required 2025-03-05 13:40:40.612 UTC [35832][client backend] [001_auth.pl][16/2:0] DETAIL: Non-superuser cannot connect if the server does not request a password or use GSSAPI with delegated credentials. 2025-03-05 13:40:40.612 UTC [35832][client backend] [001_auth.pl][16/2:0] HINT: Target server's authentication method must be changed or password_required=false set in the user mapping attributes. 2025-03-05 13:40:40.612 UTC [35832][client backend] [001_auth.pl][16/2:0] STATEMENT: TABLE tf2; 2025-03-05 13:40:40.612 UTC [35836][client backend] [postgres_fdw][:0] LOG: disconnection: session time: 0:00:00.022 user=test2 database=postgres host=[local] 2025-03-05 13:40:40.630 UTC [35832][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.060 user=test1 database=postgres host=127.0.0.1 port=41712 2025-03-05 13:40:40.639 UTC [35694][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:40.639 UTC [35694][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:40.647 UTC [35694][postmaster] LOG: background worker "logical replication launcher" (PID 35702) exited with exit code 1 2025-03-05 13:40:40.660 UTC [35696][checkpointer] LOG: shutting down 2025-03-05 13:40:40.660 UTC [35696][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:40.661 UTC [35696][checkpointer] LOG: checkpoint complete: wrote 1 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/1841660, redo lsn=0/1841660 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 35696 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f1e8f251f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x55630bc37ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x55630b956c2c] postgres: node: checkpointer (+0xe96ed6)[0x55630b956ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x55630b8a4a89] postgres: node: checkpointer (+0xde4d27)[0x55630b8a4d27] postgres: node: checkpointer (proc_exit+0x3d)[0x55630b8a4e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x55630b768196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x55630b768a53] postgres: node: checkpointer (+0xcaed1d)[0x55630b76ed1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x55630b77387f] postgres: node: checkpointer (main+0x2a2)[0x55630b50f0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f1e8e04824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f1e8e048305] postgres: node: checkpointer (_start+0x21)[0x55630aee43a1] 2025-03-05 13:40:41.909 UTC [35694][postmaster] LOG: checkpointer process (PID 35696) was terminated by signal 6: Aborted 2025-03-05 13:40:41.909 UTC [35694][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:41.909 UTC [35694][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:41.967 UTC [35694][postmaster] LOG: database system is shut down 2025-03-05 13:40:42.149 UTC [36017][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:42.149 UTC [36017][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:42.149 UTC [36017][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:42.165 UTC [36033][startup] LOG: database system was shut down at 2025-03-05 13:40:40 UTC 2025-03-05 13:40:42.187 UTC [36017][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:42.309 UTC [36055][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38454 2025-03-05 13:40:42.333 UTC [36055][client backend] [[unknown]][0/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:42.333 UTC [36055][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:42.368 UTC [36055][client backend] [001_auth.pl][0/2:0] LOG: statement: SELECT gss_authenticated AND encrypted AND credentials_delegated FROM pg_stat_gssapi WHERE pid = pg_backend_pid(); 2025-03-05 13:40:42.379 UTC [36055][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.071 user=test1 database=postgres host=127.0.0.1 port=38454 2025-03-05 13:40:42.408 UTC [36066][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38460 2025-03-05 13:40:42.440 UTC [36066][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:42.440 UTC [36066][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:42.442 UTC [36066][client backend] [001_auth.pl][1/2:0] LOG: statement: SELECT * FROM dblink('user=test1 dbname=postgres host=auth-test-localhost.postgresql.example.com hostaddr=127.0.0.1 port=12172 password=1234','select 1') as t1(c1 int); 2025-03-05 13:40:42.461 UTC [36071][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38472 2025-03-05 13:40:42.474 UTC [36071][client backend] [[unknown]][2/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:42.474 UTC [36071][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=test1 database=postgres GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:42.476 UTC [36071][client backend] [[unknown]][2/2:0] LOG: statement: select 1 2025-03-05 13:40:42.477 UTC [36071][client backend] [[unknown]][:0] LOG: disconnection: session time: 0:00:00.023 user=test1 database=postgres host=127.0.0.1 port=38472 2025-03-05 13:40:42.477 UTC [36066][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.069 user=test1 database=postgres host=127.0.0.1 port=38460 2025-03-05 13:40:42.526 UTC [36081][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38474 2025-03-05 13:40:42.543 UTC [36081][client backend] [[unknown]][3/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:42.543 UTC [36081][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=test1 database=postgres application_name=001_auth.pl GSS (authenticated=yes, encrypted=yes, delegated_credentials=yes, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:42.545 UTC [36081][client backend] [001_auth.pl][3/2:0] LOG: statement: TABLE tf1; 2025-03-05 13:40:42.557 UTC [36087][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38480 2025-03-05 13:40:42.570 UTC [36087][client backend] [[unknown]][4/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:42.570 UTC [36087][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=test1 database=postgres application_name=postgres_fdw GSS (authenticated=yes, encrypted=yes, delegated_credentials=no, principal=test1@EXAMPLE.COM) 2025-03-05 13:40:42.572 UTC [36087][client backend] [postgres_fdw][4/2:0] LOG: statement: SET search_path = pg_catalog 2025-03-05 13:40:42.572 UTC [36087][client backend] [postgres_fdw][4/3:0] LOG: statement: SET timezone = 'GMT' 2025-03-05 13:40:42.572 UTC [36087][client backend] [postgres_fdw][4/4:0] LOG: statement: SET datestyle = ISO 2025-03-05 13:40:42.573 UTC [36087][client backend] [postgres_fdw][4/5:0] LOG: statement: SET intervalstyle = postgres 2025-03-05 13:40:42.573 UTC [36087][client backend] [postgres_fdw][4/6:0] LOG: statement: SET extra_float_digits = 3 2025-03-05 13:40:42.573 UTC [36087][client backend] [postgres_fdw][4/7:0] LOG: statement: START TRANSACTION ISOLATION LEVEL REPEATABLE READ 2025-03-05 13:40:42.574 UTC [36087][client backend] [postgres_fdw][4/7:0] LOG: execute : DECLARE c1 CURSOR FOR SELECT c1 FROM public.t1 2025-03-05 13:40:42.576 UTC [36087][client backend] [postgres_fdw][4/7:0] LOG: statement: FETCH 100 FROM c1 2025-03-05 13:40:42.576 UTC [36087][client backend] [postgres_fdw][4/7:0] LOG: statement: CLOSE c1 2025-03-05 13:40:42.576 UTC [36087][client backend] [postgres_fdw][4/7:0] LOG: statement: COMMIT TRANSACTION 2025-03-05 13:40:42.583 UTC [36081][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.058 user=test1 database=postgres host=127.0.0.1 port=38474 2025-03-05 13:40:42.592 UTC [36087][client backend] [postgres_fdw][:0] LOG: disconnection: session time: 0:00:00.035 user=test1 database=postgres host=127.0.0.1 port=38480 2025-03-05 13:40:42.611 UTC [36017][postmaster] LOG: received fast shutdown request 2025-03-05 13:40:42.611 UTC [36017][postmaster] LOG: aborting any active transactions 2025-03-05 13:40:42.627 UTC [36017][postmaster] LOG: background worker "logical replication launcher" (PID 36042) exited with exit code 1 2025-03-05 13:40:42.636 UTC [36031][checkpointer] LOG: shutting down 2025-03-05 13:40:42.636 UTC [36031][checkpointer] LOG: checkpoint starting: shutdown immediate 2025-03-05 13:40:42.661 UTC [36031][checkpointer] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.026 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/18416D8, redo lsn=0/18416D8 TRAP: failed Assert("!pgStatLocal.shmem->is_shutdown"), File: "pgstat.c", Line: 746, PID: 36031 /lib/x86_64-linux-gnu/libasan.so.8(+0x51f31)[0x7f0595251f31] postgres: node: checkpointer (ExceptionalCondition+0xe6)[0x55f26ecf5ac5] postgres: node: checkpointer (pgstat_report_stat+0x17e)[0x55f26ea14c2c] postgres: node: checkpointer (+0xe96ed6)[0x55f26ea14ed6] postgres: node: checkpointer (shmem_exit+0x6b)[0x55f26e962a89] postgres: node: checkpointer (+0xde4d27)[0x55f26e962d27] postgres: node: checkpointer (proc_exit+0x3d)[0x55f26e962e53] postgres: node: checkpointer (CheckpointWriteDelay+0x0)[0x55f26e826196] postgres: node: checkpointer (postmaster_child_launch+0x1f1)[0x55f26e826a53] postgres: node: checkpointer (+0xcaed1d)[0x55f26e82cd1d] postgres: node: checkpointer (PostmasterMain+0x1e36)[0x55f26e83187f] postgres: node: checkpointer (main+0x2a2)[0x55f26e5cd0be] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f059404824a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f0594048305] postgres: node: checkpointer (_start+0x21)[0x55f26dfa23a1] 2025-03-05 13:40:44.568 UTC [36017][postmaster] LOG: checkpointer process (PID 36031) was terminated by signal 6: Aborted 2025-03-05 13:40:44.568 UTC [36017][postmaster] LOG: terminating any other active server processes 2025-03-05 13:40:44.569 UTC [36017][postmaster] LOG: abnormal database system shutdown 2025-03-05 13:40:44.629 UTC [36017][postmaster] LOG: database system is shut down 2025-03-05 13:40:44.739 UTC [36374][postmaster] LOG: starting PostgreSQL 18devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-03-05 13:40:44.739 UTC [36374][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 12172 2025-03-05 13:40:44.739 UTC [36374][postmaster] LOG: listening on Unix socket "/tmp/oVchEAiOqU/.s.PGSQL.12172" 2025-03-05 13:40:44.829 UTC [36402][startup] LOG: database system was shut down at 2025-03-05 13:40:42 UTC 2025-03-05 13:40:44.858 UTC [36374][postmaster] LOG: database system is ready to accept connections 2025-03-05 13:40:44.994 UTC [36428][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38492 2025-03-05 13:40:45.032 UTC [36428][client backend] [[unknown]][0/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:45.032 UTC [36428][client backend] [[unknown]][0/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:45.032 UTC [36428][client backend] [[unknown]][0/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: " host all all 127.0.0.1/32 gss include_realm=0 krb_realm=EXAMPLE.ORG" 2025-03-05 13:40:45.045 UTC [36434][not initialized] [[unknown]][:0] LOG: connection received: host=127.0.0.1 port=38494 2025-03-05 13:40:45.056 UTC [36434][client backend] [[unknown]][1/1:0] LOG: connection authenticated: identity="test1@EXAMPLE.COM" method=gss (/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf:3) 2025-03-05 13:40:45.056 UTC [36434][client backend] [[unknown]][1/1:0] FATAL: GSSAPI authentication failed for user "test1" 2025-03-05 13:40:45.056 UTC [36434][client backend] [[unknown]][1/1:0] DETAIL: Connection matched file "/tmp/cirrus-ci-build/src/test/kerberos/tmp_check/t_001_auth_node_data/pgdata/pg_hba.conf" line 3: " host all all 127.0.0.1/32 gss include_realm=0 krb_realm=EXAMPLE.ORG" 2025-03-05 13:40:45.097 UTC [36374][postmaster] LOG: received immediate shutdown request 2025-03-05 13:40:45.116 UTC [36374][postmaster] LOG: database system is shut down