2024-11-27 09:29:43.450 UTC [33537][postmaster] LOG: starting PostgreSQL 18devel on x86_64-linux, compiled by gcc-12.2.0, 64-bit 2024-11-27 09:29:43.450 UTC [33537][postmaster] LOG: listening on IPv4 address "127.0.0.1", port 19892 2024-11-27 09:29:43.450 UTC [33537][postmaster] LOG: listening on Unix socket "/tmp/5FSo1EL2At/.s.PGSQL.19892" 2024-11-27 09:29:43.453 UTC [33541][startup] LOG: database system was shut down at 2024-11-27 09:28:37 UTC 2024-11-27 09:29:43.457 UTC [33537][postmaster] LOG: database system is ready to accept connections 2024-11-27 09:29:43.545 UTC [33555][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.546 UTC [33555][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.546 UTC [33555][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.563 UTC [33555][client backend] [001_auth.pl][0/2:0] LOG: statement: CREATE USER test1; 2024-11-27 09:29:43.567 UTC [33555][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.592 UTC [33562][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.592 UTC [33562][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.592 UTC [33562][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.598 UTC [33562][client backend] [001_auth.pl][1/2:0] LOG: statement: CREATE USER test2 WITH ENCRYPTED PASSWORD 'abc123'; 2024-11-27 09:29:43.607 UTC [33562][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.633 UTC [33567][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.634 UTC [33567][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.634 UTC [33567][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.635 UTC [33567][client backend] [001_auth.pl][2/2:0] LOG: statement: CREATE EXTENSION postgres_fdw; 2024-11-27 09:29:43.643 UTC [33567][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.662 UTC [33571][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.663 UTC [33571][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.663 UTC [33571][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.667 UTC [33571][client backend] [001_auth.pl][3/2:0] LOG: statement: CREATE EXTENSION dblink; 2024-11-27 09:29:43.689 UTC [33571][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.711 UTC [33574][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.712 UTC [33574][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.712 UTC [33574][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.715 UTC [33574][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 '19892', dbname 'postgres'); 2024-11-27 09:29:43.720 UTC [33574][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.746 UTC [33576][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.756 UTC [33576][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.756 UTC [33576][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.757 UTC [33576][client backend] [001_auth.pl][5/2:0] LOG: statement: CREATE SERVER s2 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '19892', dbname 'postgres', passfile '/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/.pgpass'); 2024-11-27 09:29:43.761 UTC [33576][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.773 UTC [33579][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.774 UTC [33579][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.774 UTC [33579][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.776 UTC [33579][client backend] [001_auth.pl][6/2:0] LOG: statement: GRANT USAGE ON FOREIGN SERVER s1 TO test1; 2024-11-27 09:29:43.779 UTC [33579][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.804 UTC [33586][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.805 UTC [33586][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.805 UTC [33586][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.809 UTC [33586][client backend] [001_auth.pl][7/2:0] LOG: statement: CREATE USER MAPPING FOR test1 SERVER s1 OPTIONS (user 'test1'); 2024-11-27 09:29:43.814 UTC [33586][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.827 UTC [33590][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.829 UTC [33590][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.829 UTC [33590][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.831 UTC [33590][client backend] [001_auth.pl][8/2:0] LOG: statement: CREATE USER MAPPING FOR test1 SERVER s2 OPTIONS (user 'test2'); 2024-11-27 09:29:43.835 UTC [33590][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.853 UTC [33596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.853 UTC [33596][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.853 UTC [33596][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.854 UTC [33596][client backend] [001_auth.pl][9/2:0] LOG: statement: CREATE TABLE t1 (c1 int); 2024-11-27 09:29:43.858 UTC [33596][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.869 UTC [33598][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.870 UTC [33598][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.870 UTC [33598][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.871 UTC [33598][client backend] [001_auth.pl][10/2:0] LOG: statement: INSERT INTO t1 VALUES (1); 2024-11-27 09:29:43.872 UTC [33598][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.883 UTC [33600][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.884 UTC [33600][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.884 UTC [33600][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.885 UTC [33600][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'); 2024-11-27 09:29:43.887 UTC [33600][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.897 UTC [33602][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.898 UTC [33602][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.898 UTC [33602][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.899 UTC [33602][client backend] [001_auth.pl][12/2:0] LOG: statement: GRANT SELECT ON t1 TO test1; 2024-11-27 09:29:43.900 UTC [33602][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.912 UTC [33605][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.913 UTC [33605][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.913 UTC [33605][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.914 UTC [33605][client backend] [001_auth.pl][13/2:0] LOG: statement: GRANT SELECT ON tf1 TO test1; 2024-11-27 09:29:43.915 UTC [33605][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.927 UTC [33611][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.928 UTC [33611][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.928 UTC [33611][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.929 UTC [33611][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'); 2024-11-27 09:29:43.935 UTC [33611][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.943 UTC [33614][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.944 UTC [33614][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.944 UTC [33614][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.946 UTC [33614][client backend] [001_auth.pl][15/2:0] LOG: statement: GRANT SELECT ON tf2 TO test1; 2024-11-27 09:29:43.947 UTC [33614][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.959 UTC [33616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.960 UTC [33616][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.960 UTC [33616][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.961 UTC [33616][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); 2024-11-27 09:29:43.967 UTC [33616][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.986 UTC [33618][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-11-27 09:29:43.987 UTC [33618][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/kerberos/001_auth/data/t_001_auth_node_data/pgdata/pg_hba.conf:117) 2024-11-27 09:29:43.987 UTC [33618][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=postgres database=postgres application_name=001_auth.pl 2024-11-27 09:29:43.991 UTC [33618][client backend] [001_auth.pl][17/2:0] LOG: statement: GRANT SELECT ON ids TO public; 2024-11-27 09:29:43.992 UTC [33618][client backend] [001_auth.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-11-27 09:29:43.999 UTC [33537][postmaster] LOG: received fast shutdown request 2024-11-27 09:29:43.999 UTC [33537][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 33537 /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(ExceptionalCondition+0x56)[0x55f447c67f54] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(+0xeb780c)[0x55f44788280c] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(+0xeb7d62)[0x55f447882d62] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(+0xeb8c24)[0x55f447883c24] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(PostmasterMain+0x13f2)[0x55f447885693] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(main+0x2c1)[0x55f4476baca1] /lib/x86_64-linux-gnu/libc.so.6(+0x2724a)[0x7f8865a4624a] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85)[0x7f8865a46305] /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres(_start+0x21)[0x55f44726a151]