2024-03-20 13:38:55.336 UTC [32263][postmaster] LOG: starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-10.2.1, 64-bit 2024-03-20 13:38:55.337 UTC [32263][postmaster] LOG: listening on Unix socket "/tmp/7MNvflRhQD/.s.PGSQL.53315" 2024-03-20 13:38:55.346 UTC [32302][startup] LOG: database system was interrupted; last known up at 2024-03-20 13:38:54 UTC cp: cannot stat '/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives/00000002.history': No such file or directory 2024-03-20 13:38:55.363 UTC [32302][startup] LOG: starting backup recovery with redo LSN 0/2000028, checkpoint LSN 0/2000080, on timeline ID 1 2024-03-20 13:38:55.444 UTC [32302][startup] LOG: restored log file "000000010000000000000002" from archive 2024-03-20 13:38:55.446 UTC [32302][startup] LOG: entering standby mode 2024-03-20 13:38:55.447 UTC [32302][startup] LOG: redo starts at 0/2000028 cp: cannot stat '/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives/000000010000000000000003': No such file or directory 2024-03-20 13:38:55.474 UTC [32302][startup] LOG: completed backup recovery with redo LSN 0/2000028 and end LSN 0/2000120 2024-03-20 13:38:55.474 UTC [32302][startup] LOG: consistent recovery state reached at 0/2000120 2024-03-20 13:38:55.474 UTC [32263][postmaster] LOG: database system is ready to accept read-only connections cp: cannot stat '/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives/000000010000000000000003': No such file or directory 2024-03-20 13:38:55.566 UTC [32333][walreceiver] LOG: started streaming WAL from primary at 0/3000000 on timeline 1 2024-03-20 13:38:56.073 UTC [32391][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.074 UTC [32391][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.074 UTC [32391][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.089 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "behaves_ok_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.091 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.113 UTC [32394][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.114 UTC [32394][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.114 UTC [32394][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.129 UTC [32394][client backend] [035_standby_logical_decoding.pl][0/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'behaves_ok_inactiveslot' 2024-03-20 13:38:56.136 UTC [32394][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2024-03-20 13:38:56.281 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: logical decoding found consistent point at 0/3019E10 2024-03-20 13:38:56.281 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:56.281 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.282 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: released logical replication slot "behaves_ok_inactiveslot" 2024-03-20 13:38:56.282 UTC [32391][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.284 UTC [32391][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.212 user=postgres database=testdb host=[local] 2024-03-20 13:38:56.326 UTC [32425][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.327 UTC [32425][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.327 UTC [32425][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.329 UTC [32425][client backend] [035_standby_logical_decoding.pl][1/2:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'behaves_ok_inactiveslot' 2024-03-20 13:38:56.341 UTC [32425][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-03-20 13:38:56.367 UTC [32435][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.367 UTC [32435][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.367 UTC [32435][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.368 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "behaves_ok_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.369 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.376 UTC [32437][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.376 UTC [32437][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.376 UTC [32437][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.380 UTC [32437][client backend] [035_standby_logical_decoding.pl][2/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'behaves_ok_activeslot' 2024-03-20 13:38:56.389 UTC [32437][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=postgres database=postgres host=[local] 2024-03-20 13:38:56.482 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:56.482 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:56.482 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.482 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: released logical replication slot "behaves_ok_activeslot" 2024-03-20 13:38:56.482 UTC [32435][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "behaves_ok_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:56.484 UTC [32435][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.117 user=postgres database=testdb host=[local] 2024-03-20 13:38:56.511 UTC [32455][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.511 UTC [32455][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.511 UTC [32455][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.512 UTC [32455][client backend] [035_standby_logical_decoding.pl][3/2:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'behaves_ok_activeslot' 2024-03-20 13:38:56.515 UTC [32455][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2024-03-20 13:38:56.736 UTC [32495][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.736 UTC [32495][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.736 UTC [32495][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.745 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] LOG: statement: SELECT pg_logical_slot_get_changes('behaves_ok_activeslot', NULL, NULL); 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] LOG: starting logical decoding for slot "behaves_ok_activeslot" 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] DETAIL: Streaming transactions committing after 0/3019E80, reading WAL from 0/3019E48. 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] STATEMENT: SELECT pg_logical_slot_get_changes('behaves_ok_activeslot', NULL, NULL); 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] DETAIL: There are no running transactions. 2024-03-20 13:38:56.748 UTC [32495][client backend] [035_standby_logical_decoding.pl][4/2:0] STATEMENT: SELECT pg_logical_slot_get_changes('behaves_ok_activeslot', NULL, NULL); 2024-03-20 13:38:56.751 UTC [32495][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=postgres database=testdb host=[local] 2024-03-20 13:38:56.900 UTC [32533][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.900 UTC [32533][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.900 UTC [32533][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.905 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] LOG: statement: SELECT data FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] LOG: starting logical decoding for slot "behaves_ok_activeslot" 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] DETAIL: Streaming transactions committing after 0/3026718, reading WAL from 0/3019E48. 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] STATEMENT: SELECT data FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] DETAIL: There are no running transactions. 2024-03-20 13:38:56.908 UTC [32533][client backend] [035_standby_logical_decoding.pl][5/2:0] STATEMENT: SELECT data FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-03-20 13:38:56.911 UTC [32533][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=testdb host=[local] 2024-03-20 13:38:56.923 UTC [32544][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:56.923 UTC [32544][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:56.923 UTC [32544][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:56.924 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] LOG: statement: SELECT lsn FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL) ORDER BY lsn DESC LIMIT 1; 2024-03-20 13:38:56.929 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] LOG: starting logical decoding for slot "behaves_ok_activeslot" 2024-03-20 13:38:56.929 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] DETAIL: Streaming transactions committing after 0/3026718, reading WAL from 0/3019E48. 2024-03-20 13:38:56.929 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] STATEMENT: SELECT lsn FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL) ORDER BY lsn DESC LIMIT 1; 2024-03-20 13:38:56.930 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:56.930 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] DETAIL: There are no running transactions. 2024-03-20 13:38:56.930 UTC [32544][client backend] [035_standby_logical_decoding.pl][6/2:0] STATEMENT: SELECT lsn FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL) ORDER BY lsn DESC LIMIT 1; 2024-03-20 13:38:56.934 UTC [32544][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=testdb host=[local] 2024-03-20 13:38:57.086 UTC [32574][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.087 UTC [32574][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.087 UTC [32574][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.090 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: acquired logical replication slot "behaves_ok_activeslot" 2024-03-20 13:38:57.091 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.094 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: starting logical decoding for slot "behaves_ok_activeslot" 2024-03-20 13:38:57.094 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: Streaming transactions committing after 0/3026718, reading WAL from 0/3019E48. 2024-03-20 13:38:57.094 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.095 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:57.095 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:57.095 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.097 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: released logical replication slot "behaves_ok_activeslot" 2024-03-20 13:38:57.097 UTC [32574][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("skip-empty-xacts" '1', "include-xids" '0') 2024-03-20 13:38:57.100 UTC [32574][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=postgres database=testdb host=[local] 2024-03-20 13:38:57.111 UTC [32579][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.112 UTC [32579][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.112 UTC [32579][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.113 UTC [32579][client backend] [035_standby_logical_decoding.pl][7/2:0] LOG: statement: SELECT EXISTS (SELECT 1 FROM pg_replication_slots WHERE slot_name = 'behaves_ok_activeslot' AND active_pid IS NULL) 2024-03-20 13:38:57.117 UTC [32579][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=testdb host=[local] 2024-03-20 13:38:57.136 UTC [32585][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.137 UTC [32585][walsender] [[unknown]][25/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.137 UTC [32585][walsender] [[unknown]][25/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.137 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: acquired logical replication slot "behaves_ok_activeslot" 2024-03-20 13:38:57.138 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: starting logical decoding for slot "behaves_ok_activeslot" 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] DETAIL: Streaming transactions committing after 0/3026848, reading WAL from 0/3019E48. 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: logical decoding found consistent point at 0/3019E48 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:57.139 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.140 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: released logical replication slot "behaves_ok_activeslot" 2024-03-20 13:38:57.140 UTC [32585][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: START_REPLICATION SLOT "behaves_ok_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:57.140 UTC [32585][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=testdb host=[local] 2024-03-20 13:38:57.343 UTC [32620][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.344 UTC [32620][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.344 UTC [32620][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=otherdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.389 UTC [32620][client backend] [035_standby_logical_decoding.pl][8/2:0] LOG: statement: SELECT lsn FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL) ORDER BY lsn DESC LIMIT 1; 2024-03-20 13:38:57.390 UTC [32620][client backend] [035_standby_logical_decoding.pl][8/2:0] ERROR: replication slot "behaves_ok_activeslot" was not created in this database 2024-03-20 13:38:57.390 UTC [32620][client backend] [035_standby_logical_decoding.pl][8/2:0] STATEMENT: SELECT lsn FROM pg_logical_slot_peek_changes('behaves_ok_activeslot', NULL, NULL) ORDER BY lsn DESC LIMIT 1; 2024-03-20 13:38:57.393 UTC [32620][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.051 user=postgres database=otherdb host=[local] 2024-03-20 13:38:57.522 UTC [32647][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.523 UTC [32647][walsender] [[unknown]][22/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.523 UTC [32647][walsender] [[unknown]][22/5:0] LOG: replication connection authorized: user=postgres application_name=tap_sub 2024-03-20 13:38:57.528 UTC [32647][walsender] [tap_sub][22/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:57.529 UTC [32647][walsender] [tap_sub][22/7:0] LOG: statement: SELECT t.pubname FROM pg_catalog.pg_publication t WHERE t.pubname IN ('tap_pub') 2024-03-20 13:38:57.531 UTC [32647][walsender] [tap_sub][22/8:0] LOG: statement: SELECT DISTINCT n.nspname, c.relname, gpt.attrs FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace JOIN ( SELECT (pg_get_publication_tables(VARIADIC array_agg(pubname::text))).* FROM pg_publication WHERE pubname IN ( 'tap_pub' )) AS gpt ON gpt.relid = c.oid 2024-03-20 13:38:57.535 UTC [32647][walsender] [tap_sub][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-03-20 13:38:57.535 UTC [32647][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-03-20 13:38:57.540 UTC [32650][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.541 UTC [32650][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.541 UTC [32650][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.544 UTC [32650][client backend] [035_standby_logical_decoding.pl][9/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'tap_sub' 2024-03-20 13:38:57.551 UTC [32650][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2024-03-20 13:38:57.683 UTC [32647][walsender] [tap_sub][22/0:0] LOG: logical decoding found consistent point at 0/3498968 2024-03-20 13:38:57.683 UTC [32647][walsender] [tap_sub][22/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:57.683 UTC [32647][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-03-20 13:38:57.697 UTC [32647][walsender] [tap_sub][22/0:0] LOG: released logical replication slot "tap_sub" 2024-03-20 13:38:57.697 UTC [32647][walsender] [tap_sub][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "tap_sub" LOGICAL pgoutput (SNAPSHOT 'nothing') 2024-03-20 13:38:57.698 UTC [32647][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.176 user=postgres database=postgres host=[local] 2024-03-20 13:38:57.725 UTC [32673][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.726 UTC [32673][walsender] [[unknown]][23/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.726 UTC [32673][walsender] [[unknown]][23/5:0] LOG: replication connection authorized: user=postgres application_name=tap_sub 2024-03-20 13:38:57.733 UTC [32673][walsender] [tap_sub][23/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:57.734 UTC [32673][walsender] [tap_sub][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:57.734 UTC [32673][walsender] [tap_sub][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:57.736 UTC [32673][walsender] [tap_sub][23/0:0] LOG: received replication command: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"tap_pub"') 2024-03-20 13:38:57.736 UTC [32673][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"tap_pub"') 2024-03-20 13:38:57.736 UTC [32673][walsender] [tap_sub][23/0:0] LOG: acquired logical replication slot "tap_sub" 2024-03-20 13:38:57.736 UTC [32673][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"tap_pub"') 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] LOG: starting logical decoding for slot "tap_sub" 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] DETAIL: Streaming transactions committing after 0/34989A0, reading WAL from 0/3498968. 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"tap_pub"') 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] LOG: logical decoding found consistent point at 0/3498968 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:57.738 UTC [32673][walsender] [tap_sub][23/0:0] STATEMENT: START_REPLICATION SLOT "tap_sub" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"tap_pub"') 2024-03-20 13:38:57.780 UTC [32687][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.780 UTC [32687][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.780 UTC [32687][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.783 UTC [32687][client backend] [035_standby_logical_decoding.pl][0/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-03-20 13:38:57.785 UTC [32687][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-03-20 13:38:57.810 UTC [32693][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.811 UTC [32693][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.811 UTC [32693][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.812 UTC [32693][client backend] [035_standby_logical_decoding.pl][1/4:0] LOG: statement: SELECT pg_last_wal_replay_lsn() 2024-03-20 13:38:57.816 UTC [32693][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2024-03-20 13:38:57.841 UTC [32701][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:57.856 UTC [32701][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:57.857 UTC [32701][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:57.861 UTC [32701][client backend] [035_standby_logical_decoding.pl][2/4:0] LOG: statement: SELECT '0/34989A0' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-03-20 13:38:57.868 UTC [32701][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.121 UTC [32775][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.121 UTC [32775][client backend] [[unknown]][3/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.121 UTC [32775][client backend] [[unknown]][3/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.124 UTC [32775][client backend] [035_standby_logical_decoding.pl][3/4:0] LOG: statement: SELECT pg_is_in_recovery() 2024-03-20 13:38:58.125 UTC [32775][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.004 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.209 UTC [32778][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.210 UTC [32778][client backend] [[unknown]][4/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.210 UTC [32778][client backend] [[unknown]][4/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.215 UTC [32778][client backend] [035_standby_logical_decoding.pl][4/4:0] LOG: statement: SELECT pg_last_wal_replay_lsn() 2024-03-20 13:38:58.225 UTC [32778][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.295 UTC [32784][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.296 UTC [32784][client backend] [[unknown]][5/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.296 UTC [32784][client backend] [[unknown]][5/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.302 UTC [32784][client backend] [035_standby_logical_decoding.pl][5/4:0] LOG: statement: SELECT '0/3498F30' <= replay_lsn AND state = 'streaming' FROM pg_catalog.pg_stat_replication WHERE application_name IN ('tap_sub', 'walreceiver') 2024-03-20 13:38:58.327 UTC [32784][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.412 UTC [32673][walsender] [tap_sub][23/0:0] LOG: released logical replication slot "tap_sub" 2024-03-20 13:38:58.412 UTC [32673][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.687 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.554 UTC [32797][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.555 UTC [32797][walsender] [[unknown]][24/6:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.555 UTC [32797][walsender] [[unknown]][24/6:0] LOG: replication connection authorized: user=postgres application_name=tap_sub 2024-03-20 13:38:58.557 UTC [32797][walsender] [tap_sub][24/7:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:58.557 UTC [32797][walsender] [tap_sub][24/0:0] LOG: received replication command: DROP_REPLICATION_SLOT tap_sub WAIT 2024-03-20 13:38:58.557 UTC [32797][walsender] [tap_sub][24/0:0] STATEMENT: DROP_REPLICATION_SLOT tap_sub WAIT 2024-03-20 13:38:58.557 UTC [32797][walsender] [tap_sub][24/0:0] LOG: acquired logical replication slot "tap_sub" 2024-03-20 13:38:58.557 UTC [32797][walsender] [tap_sub][24/0:0] STATEMENT: DROP_REPLICATION_SLOT tap_sub WAIT 2024-03-20 13:38:58.560 UTC [32797][walsender] [tap_sub][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.706 UTC [32806][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.706 UTC [32806][client backend] [[unknown]][6/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.706 UTC [32806][client backend] [[unknown]][6/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.709 UTC [32806][client backend] [035_standby_logical_decoding.pl][6/4:0] LOG: statement: SELECT pg_drop_replication_slot('behaves_ok_inactiveslot') 2024-03-20 13:38:58.712 UTC [32806][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.768 UTC [32814][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.768 UTC [32814][client backend] [[unknown]][7/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.768 UTC [32814][client backend] [[unknown]][7/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.776 UTC [32814][client backend] [035_standby_logical_decoding.pl][7/4:0] LOG: statement: SELECT pg_drop_replication_slot('behaves_ok_activeslot') 2024-03-20 13:38:58.784 UTC [32814][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2024-03-20 13:38:58.896 UTC [32821][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.896 UTC [32821][walsender] [[unknown]][25/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.896 UTC [32821][walsender] [[unknown]][25/5:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.897 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/6:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "vacuum_full_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:58.898 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:58.901 UTC [32822][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:58.902 UTC [32822][client backend] [[unknown]][8/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:58.902 UTC [32822][client backend] [[unknown]][8/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:58.904 UTC [32822][client backend] [035_standby_logical_decoding.pl][8/4:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'vacuum_full_inactiveslot' 2024-03-20 13:38:58.917 UTC [32822][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2024-03-20 13:38:59.085 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: logical decoding found consistent point at 0/3498F30 2024-03-20 13:38:59.085 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:59.085 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.115 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] LOG: released logical replication slot "vacuum_full_inactiveslot" 2024-03-20 13:38:59.115 UTC [32821][walsender] [035_standby_logical_decoding.pl][25/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.117 UTC [32821][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.225 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.163 UTC [32841][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.164 UTC [32841][client backend] [[unknown]][9/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.164 UTC [32841][client backend] [[unknown]][9/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.170 UTC [32841][client backend] [035_standby_logical_decoding.pl][9/4:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'vacuum_full_inactiveslot' 2024-03-20 13:38:59.186 UTC [32841][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=postgres database=postgres host=[local] 2024-03-20 13:38:59.221 UTC [32844][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.222 UTC [32844][walsender] [[unknown]][22/9:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.222 UTC [32844][walsender] [[unknown]][22/9:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.224 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/10:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "vacuum_full_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.225 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.238 UTC [32846][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.238 UTC [32846][client backend] [[unknown]][0/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.238 UTC [32846][client backend] [[unknown]][0/5:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.247 UTC [32846][client backend] [035_standby_logical_decoding.pl][0/6:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'vacuum_full_activeslot' 2024-03-20 13:38:59.251 UTC [32846][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-03-20 13:38:59.485 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: logical decoding found consistent point at 0/3498F68 2024-03-20 13:38:59.485 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:59.485 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.498 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: released logical replication slot "vacuum_full_activeslot" 2024-03-20 13:38:59.498 UTC [32844][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "vacuum_full_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:38:59.501 UTC [32844][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.280 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.514 UTC [32874][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.576 UTC [32874][client backend] [[unknown]][1/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.576 UTC [32874][client backend] [[unknown]][1/5:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.577 UTC [32874][client backend] [035_standby_logical_decoding.pl][1/6:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'vacuum_full_activeslot' 2024-03-20 13:38:59.589 UTC [32874][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.074 user=postgres database=postgres host=[local] 2024-03-20 13:38:59.606 UTC [32263][postmaster] LOG: received SIGHUP, reloading configuration files 2024-03-20 13:38:59.686 UTC [32893][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.690 UTC [32893][walsender] [[unknown]][23/9:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.690 UTC [32893][walsender] [[unknown]][23/9:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.696 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/10:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: acquired logical replication slot "vacuum_full_activeslot" 2024-03-20 13:38:59.700 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: starting logical decoding for slot "vacuum_full_activeslot" 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] DETAIL: Streaming transactions committing after 0/3498FA0, reading WAL from 0/3498F68. 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: logical decoding found consistent point at 0/3498F68 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] DETAIL: There are no running transactions. 2024-03-20 13:38:59.703 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.705 UTC [32898][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.705 UTC [32898][client backend] [[unknown]][2/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.705 UTC [32898][client backend] [[unknown]][2/5:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.706 UTC [32898][client backend] [035_standby_logical_decoding.pl][2/6:0] LOG: statement: SELECT EXISTS (SELECT 1 FROM pg_replication_slots WHERE slot_name = 'vacuum_full_activeslot' AND active_pid IS NOT NULL) 2024-03-20 13:38:59.713 UTC [32898][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.735 UTC [32905][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.735 UTC [32905][client backend] [[unknown]][3/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.735 UTC [32905][client backend] [[unknown]][3/5:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.739 UTC [32905][client backend] [035_standby_logical_decoding.pl][3/6:0] LOG: statement: select pg_stat_reset(); 2024-03-20 13:38:59.740 UTC [32905][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.825 UTC [32919][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:38:59.826 UTC [32919][client backend] [[unknown]][4/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:38:59.826 UTC [32919][client backend] [[unknown]][4/5:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:38:59.828 UTC [32919][client backend] [035_standby_logical_decoding.pl][4/6:0] LOG: statement: SELECT total_txns > 0 FROM pg_stat_replication_slots WHERE slot_name = 'vacuum_full_activeslot' 2024-03-20 13:38:59.835 UTC [32919][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.992 UTC [32302][startup] LOG: invalidating obsolete replication slot "vacuum_full_inactiveslot" 2024-03-20 13:38:59.992 UTC [32302][startup] DETAIL: The slot conflicted with xid horizon 750. 2024-03-20 13:38:59.992 UTC [32302][startup] CONTEXT: WAL redo at 0/349DF28 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 750, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [43]; blkref #0: rel 1663/16384/2610, blk 0 2024-03-20 13:38:59.992 UTC [32302][startup] LOG: terminating process 32893 to release replication slot "vacuum_full_activeslot" 2024-03-20 13:38:59.992 UTC [32302][startup] DETAIL: The slot conflicted with xid horizon 750. 2024-03-20 13:38:59.992 UTC [32302][startup] CONTEXT: WAL redo at 0/349DF28 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 750, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [43]; blkref #0: rel 1663/16384/2610, blk 0 2024-03-20 13:38:59.992 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] ERROR: canceling statement due to conflict with recovery 2024-03-20 13:38:59.992 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] DETAIL: User was using a logical replication slot that must be invalidated. 2024-03-20 13:38:59.992 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:38:59.992 UTC [32893][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: released logical replication slot "vacuum_full_activeslot" 2024-03-20 13:38:59.993 UTC [32893][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.307 user=postgres database=testdb host=[local] 2024-03-20 13:38:59.994 UTC [32302][startup] LOG: invalidating obsolete replication slot "vacuum_full_activeslot" 2024-03-20 13:38:59.994 UTC [32302][startup] DETAIL: The slot conflicted with xid horizon 750. 2024-03-20 13:38:59.994 UTC [32302][startup] CONTEXT: WAL redo at 0/349DF28 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 750, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [43]; blkref #0: rel 1663/16384/2610, blk 0 2024-03-20 13:39:00.106 UTC [32974][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.108 UTC [32974][client backend] [[unknown]][5/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.108 UTC [32974][client backend] [[unknown]][5/5:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.112 UTC [32974][client backend] [035_standby_logical_decoding.pl][5/6:0] LOG: statement: select (confl_active_logicalslot = 1) from pg_stat_database_conflicts where datname = 'testdb' 2024-03-20 13:39:00.120 UTC [32974][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=postgres database=postgres host=[local] 2024-03-20 13:39:00.148 UTC [32978][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.148 UTC [32978][client backend] [[unknown]][6/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.148 UTC [32978][client backend] [[unknown]][6/5:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.152 UTC [32978][client backend] [035_standby_logical_decoding.pl][6/6:0] LOG: statement: select conflict_reason from pg_replication_slots where slot_name = 'vacuum_full_activeslot'; 2024-03-20 13:39:00.159 UTC [32978][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=postgres database=postgres host=[local] 2024-03-20 13:39:00.177 UTC [32986][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.178 UTC [32986][client backend] [[unknown]][7/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.178 UTC [32986][client backend] [[unknown]][7/5:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.178 UTC [32986][client backend] [035_standby_logical_decoding.pl][7/6:0] LOG: statement: select conflict_reason from pg_replication_slots where slot_name = 'vacuum_full_inactiveslot'; 2024-03-20 13:39:00.182 UTC [32986][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-03-20 13:39:00.194 UTC [32995][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.195 UTC [32995][client backend] [[unknown]][8/5:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.195 UTC [32995][client backend] [[unknown]][8/5:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.212 UTC [32995][client backend] [035_standby_logical_decoding.pl][8/6:0] LOG: statement: SELECT total_txns > 0 FROM pg_stat_replication_slots WHERE slot_name = 'vacuum_full_activeslot' 2024-03-20 13:39:00.217 UTC [32995][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=testdb host=[local] 2024-03-20 13:39:00.231 UTC [32999][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.235 UTC [32999][walsender] [[unknown]][24/8:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.235 UTC [32999][walsender] [[unknown]][24/8:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/9:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: acquired logical replication slot "vacuum_full_activeslot" 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] ERROR: can no longer get changes from replication slot "vacuum_full_activeslot" 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: This slot has been invalidated because it was conflicting with recovery. 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "vacuum_full_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:00.237 UTC [32999][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: released logical replication slot "vacuum_full_activeslot" 2024-03-20 13:39:00.238 UTC [32999][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=testdb host=[local] 2024-03-20 13:39:00.258 UTC [32263][postmaster] LOG: received SIGHUP, reloading configuration files 2024-03-20 13:39:00.259 UTC [32263][postmaster] LOG: parameter "hot_standby_feedback" changed to "1" 2024-03-20 13:39:00.302 UTC [32263][postmaster] LOG: received fast shutdown request 2024-03-20 13:39:00.302 UTC [32263][postmaster] LOG: aborting any active transactions 2024-03-20 13:39:00.304 UTC [32333][walreceiver] FATAL: terminating walreceiver process due to administrator command 2024-03-20 13:39:00.306 UTC [32300][checkpointer] LOG: shutting down 2024-03-20 13:39:00.308 UTC [32263][postmaster] LOG: database system is shut down 2024-03-20 13:39:00.438 UTC [33036][postmaster] LOG: starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-10.2.1, 64-bit 2024-03-20 13:39:00.439 UTC [33036][postmaster] LOG: listening on Unix socket "/tmp/7MNvflRhQD/.s.PGSQL.53315" 2024-03-20 13:39:00.449 UTC [33046][startup] LOG: database system was shut down in recovery at 2024-03-20 13:39:00 UTC cp: cannot stat '/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives/00000002.history': No such file or directory 2024-03-20 13:39:00.473 UTC [33046][startup] LOG: restored log file "000000010000000000000002" from archive 2024-03-20 13:39:00.476 UTC [33046][startup] LOG: entering standby mode 2024-03-20 13:39:00.477 UTC [33046][startup] LOG: redo starts at 0/2000028 cp: cannot stat '/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives/000000010000000000000003': No such file or directory 2024-03-20 13:39:00.500 UTC [33046][startup] LOG: consistent recovery state reached at 0/34C98D8 2024-03-20 13:39:00.500 UTC [33046][startup] LOG: invalid record length at 0/34C98D8: expected at least 24, got 0 2024-03-20 13:39:00.500 UTC [33036][postmaster] LOG: database system is ready to accept read-only connections 2024-03-20 13:39:00.513 UTC [33063][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.513 UTC [33063][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.513 UTC [33063][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.513 UTC [33059][walreceiver] LOG: started streaming WAL from primary at 0/3000000 on timeline 1 2024-03-20 13:39:00.519 UTC [33063][client backend] [035_standby_logical_decoding.pl][0/2:0] LOG: statement: select conflict_reason from pg_replication_slots where slot_name = 'vacuum_full_activeslot'; 2024-03-20 13:39:00.521 UTC [33063][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=postgres database=postgres host=[local] 2024-03-20 13:39:00.542 UTC [33066][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.544 UTC [33066][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.544 UTC [33066][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.546 UTC [33066][client backend] [035_standby_logical_decoding.pl][1/2:0] LOG: statement: select conflict_reason from pg_replication_slots where slot_name = 'vacuum_full_inactiveslot'; 2024-03-20 13:39:00.553 UTC [33066][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2024-03-20 13:39:00.576 UTC [33072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:00.577 UTC [33072][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:00.577 UTC [33072][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:00.588 UTC [33072][client backend] [035_standby_logical_decoding.pl][2/2:0] LOG: statement: SELECT restart_lsn from pg_replication_slots WHERE slot_name = 'vacuum_full_activeslot' and conflict_reason is not null; 2024-03-20 13:39:00.594 UTC [33072][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.106 UTC [33199][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.107 UTC [33199][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.107 UTC [33199][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.112 UTC [33199][client backend] [035_standby_logical_decoding.pl][3/2:0] LOG: statement: checkpoint; 2024-03-20 13:39:01.112 UTC [33044][checkpointer] LOG: restartpoint starting: immediate wait 2024-03-20 13:39:01.112 UTC [33044][checkpointer] LOG: restartpoint complete: wrote 4 buffers (3.1%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=32768 kB, estimate=32768 kB; lsn=0/4000080, redo lsn=0/4000028 2024-03-20 13:39:01.112 UTC [33044][checkpointer] LOG: recovery restart point at 0/4000028 2024-03-20 13:39:01.112 UTC [33044][checkpointer] DETAIL: Last completed transaction was at log time 2024-03-20 13:39:00.002377+00. 2024-03-20 13:39:01.113 UTC [33199][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.140 UTC [33206][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.140 UTC [33206][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.140 UTC [33206][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.141 UTC [33206][client backend] [035_standby_logical_decoding.pl][4/2:0] LOG: statement: SELECT pg_drop_replication_slot('vacuum_full_inactiveslot') 2024-03-20 13:39:01.142 UTC [33206][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.002 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.181 UTC [33216][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.182 UTC [33216][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.182 UTC [33216][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.182 UTC [33216][client backend] [035_standby_logical_decoding.pl][5/2:0] LOG: statement: SELECT pg_drop_replication_slot('vacuum_full_activeslot') 2024-03-20 13:39:01.183 UTC [33216][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.241 UTC [33237][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.242 UTC [33237][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.242 UTC [33237][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.245 UTC [33237][client backend] [035_standby_logical_decoding.pl][6/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'row_removal_inactiveslot' 2024-03-20 13:39:01.247 UTC [33237][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.252 UTC [33239][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.253 UTC [33239][walsender] [[unknown]][22/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.253 UTC [33239][walsender] [[unknown]][22/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "row_removal_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.258 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.378 UTC [33268][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.379 UTC [33268][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.379 UTC [33268][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.380 UTC [33268][client backend] [035_standby_logical_decoding.pl][7/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'row_removal_inactiveslot' 2024-03-20 13:39:01.388 UTC [33268][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.488 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: logical decoding found consistent point at 0/40000F8 2024-03-20 13:39:01.488 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] DETAIL: There are no running transactions. 2024-03-20 13:39:01.488 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.488 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] LOG: released logical replication slot "row_removal_inactiveslot" 2024-03-20 13:39:01.488 UTC [33239][walsender] [035_standby_logical_decoding.pl][22/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_inactiveslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.490 UTC [33239][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.238 user=postgres database=testdb host=[local] 2024-03-20 13:39:01.548 UTC [33332][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.549 UTC [33332][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.549 UTC [33332][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.556 UTC [33332][client backend] [035_standby_logical_decoding.pl][8/2:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'row_removal_inactiveslot' 2024-03-20 13:39:01.571 UTC [33332][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.640 UTC [33361][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.655 UTC [33367][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:01.655 UTC [33367][walsender] [[unknown]][23/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.655 UTC [33367][walsender] [[unknown]][23/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.656 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: received replication command: CREATE_REPLICATION_SLOT "row_removal_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.657 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.664 UTC [33361][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:01.664 UTC [33361][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:01.668 UTC [33361][client backend] [035_standby_logical_decoding.pl][9/2:0] LOG: statement: SELECT restart_lsn IS NOT NULL FROM pg_catalog.pg_replication_slots WHERE slot_name = 'row_removal_activeslot' 2024-03-20 13:39:01.676 UTC [33361][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=postgres database=postgres host=[local] 2024-03-20 13:39:01.889 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: logical decoding found consistent point at 0/4000130 2024-03-20 13:39:01.889 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] DETAIL: There are no running transactions. 2024-03-20 13:39:01.889 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.889 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] LOG: released logical replication slot "row_removal_activeslot" 2024-03-20 13:39:01.889 UTC [33367][walsender] [035_standby_logical_decoding.pl][23/0:0] STATEMENT: CREATE_REPLICATION_SLOT "row_removal_activeslot" LOGICAL "test_decoding" ( SNAPSHOT 'nothing') 2024-03-20 13:39:01.891 UTC [33367][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.243 user=postgres database=testdb host=[local] 2024-03-20 13:39:02.012 UTC [33397][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:02.012 UTC [33397][client backend] [[unknown]][0/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:02.012 UTC [33397][client backend] [[unknown]][0/3:0] LOG: connection authorized: user=postgres database=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:02.013 UTC [33397][client backend] [035_standby_logical_decoding.pl][0/4:0] LOG: statement: SELECT plugin, slot_type, datoid, database, active, active_pid, xmin, catalog_xmin, restart_lsn FROM pg_catalog.pg_replication_slots WHERE slot_name = 'row_removal_activeslot' 2024-03-20 13:39:02.038 UTC [33036][postmaster] LOG: received SIGHUP, reloading configuration files 2024-03-20 13:39:02.039 UTC [33036][postmaster] LOG: parameter "hot_standby_feedback" changed to "0" 2024-03-20 13:39:02.041 UTC [33397][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.033 user=postgres database=postgres host=[local] 2024-03-20 13:39:02.253 UTC [33414][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:02.253 UTC [33414][walsender] [[unknown]][24/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:02.253 UTC [33414][walsender] [[unknown]][24/1:0] LOG: replication connection authorized: user=postgres application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:02.254 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/2:0] LOG: statement: SELECT pg_catalog.set_config('search_path', '', false); 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: SHOW data_directory_mode 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: SHOW data_directory_mode 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: IDENTIFY_SYSTEM 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: IDENTIFY_SYSTEM 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: received replication command: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: acquired logical replication slot "row_removal_activeslot" 2024-03-20 13:39:02.255 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.256 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: starting logical decoding for slot "row_removal_activeslot" 2024-03-20 13:39:02.256 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: Streaming transactions committing after 0/4000168, reading WAL from 0/4000130. 2024-03-20 13:39:02.256 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.283 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: logical decoding found consistent point at 0/4000130 2024-03-20 13:39:02.283 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: There are no running transactions. 2024-03-20 13:39:02.283 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.323 UTC [33417][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:02.324 UTC [33417][client backend] [[unknown]][1/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:02.324 UTC [33417][client backend] [[unknown]][1/3:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:02.340 UTC [33417][client backend] [035_standby_logical_decoding.pl][1/4:0] LOG: statement: SELECT EXISTS (SELECT 1 FROM pg_replication_slots WHERE slot_name = 'row_removal_activeslot' AND active_pid IS NOT NULL) 2024-03-20 13:39:02.370 UTC [33417][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.051 user=postgres database=testdb host=[local] 2024-03-20 13:39:02.412 UTC [33421][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-03-20 13:39:02.412 UTC [33421][client backend] [[unknown]][2/3:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata/pg_hba.conf:117) 2024-03-20 13:39:02.412 UTC [33421][client backend] [[unknown]][2/3:0] LOG: connection authorized: user=postgres database=testdb application_name=035_standby_logical_decoding.pl 2024-03-20 13:39:02.420 UTC [33421][client backend] [035_standby_logical_decoding.pl][2/4:0] LOG: statement: select pg_stat_reset(); 2024-03-20 13:39:02.422 UTC [33421][client backend] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=postgres database=testdb host=[local] 2024-03-20 13:39:02.871 UTC [33046][startup] LOG: invalidating obsolete replication slot "row_removal_inactiveslot" 2024-03-20 13:39:02.871 UTC [33046][startup] DETAIL: The slot conflicted with xid horizon 754. 2024-03-20 13:39:02.871 UTC [33046][startup] CONTEXT: WAL redo at 0/4020988 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 754, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [48]; blkref #0: rel 1663/16384/2610, blk 0 2024-03-20 13:39:02.871 UTC [33046][startup] LOG: terminating process 33414 to release replication slot "row_removal_activeslot" 2024-03-20 13:39:02.871 UTC [33046][startup] DETAIL: The slot conflicted with xid horizon 754. 2024-03-20 13:39:02.871 UTC [33046][startup] CONTEXT: WAL redo at 0/4020988 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 754, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [48]; blkref #0: rel 1663/16384/2610, blk 0 2024-03-20 13:39:02.871 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] ERROR: canceling statement due to conflict with recovery 2024-03-20 13:39:02.871 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] DETAIL: User was using a logical replication slot that must be invalidated. 2024-03-20 13:39:02.871 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] STATEMENT: START_REPLICATION SLOT "row_removal_activeslot" LOGICAL 0/0 ("include-xids" '0', "skip-empty-xacts" '1') 2024-03-20 13:39:02.871 UTC [33414][walsender] [035_standby_logical_decoding.pl][24/0:0] LOG: released logical replication slot "row_removal_activeslot" 2024-03-20 13:39:02.872 UTC [33046][startup] LOG: invalidating obsolete replication slot "row_removal_activeslot" 2024-03-20 13:39:02.872 UTC [33046][startup] DETAIL: The slot conflicted with xid horizon 754. 2024-03-20 13:39:02.872 UTC [33046][startup] CONTEXT: WAL redo at 0/4020988 for Heap2/PRUNE_FREEZE: snapshotConflictHorizon: 754, isCatalogRel: T, nredirected: 0, ndead: 1, nunused: 0, nplans: 0,, dead: [48]; blkref #0: rel 1663/16384/2610, blk 0 TRAP: failed Assert("HeapTupleHeaderIsHeapOnly(htup)"), File: "../src/backend/access/heap/pruneheap.c", Line: 1336, PID: 33046 postgres: standby: startup recovering 000000010000000000000004(ExceptionalCondition+0x56)[0x563fdf604f1f] postgres: standby: startup recovering 000000010000000000000004(heap_page_prune_execute+0xb0c)[0x563fdec8c06b] postgres: standby: startup recovering 000000010000000000000004(+0x975507)[0x563fdec64507] postgres: standby: startup recovering 000000010000000000000004(heap2_redo+0xa3)[0x563fdec71350] postgres: standby: startup recovering 000000010000000000000004(+0xa7b5c4)[0x563fded6a5c4] postgres: standby: startup recovering 000000010000000000000004(PerformWalRecovery+0x72c)[0x563fded70414] postgres: standby: startup recovering 000000010000000000000004(StartupXLOG+0x672)[0x563fded5a0f4] postgres: standby: startup recovering 000000010000000000000004(StartupProcessMain+0x108)[0x563fdf20ade7] postgres: standby: startup recovering 000000010000000000000004(postmaster_child_launch+0x188)[0x563fdf2025b1] postgres: standby: startup recovering 000000010000000000000004(+0xf1547c)[0x563fdf20447c] postgres: standby: startup recovering 000000010000000000000004(PostmasterMain+0x13a6)[0x563fdf20a546] postgres: standby: startup recovering 000000010000000000000004(main+0x393)[0x563fdf036936] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xea)[0x7f8da394bd0a] postgres: standby: startup recovering 000000010000000000000004(_start+0x2a)[0x563fdeba421a] 2024-03-20 13:39:02.876 UTC [33414][walsender] [035_standby_logical_decoding.pl][:0] LOG: disconnection: session time: 0:00:00.623 user=postgres database=testdb host=[local] 2024-03-20 13:39:02.919 UTC [33036][postmaster] LOG: startup process (PID 33046) was terminated by signal 6: Aborted 2024-03-20 13:39:02.919 UTC [33036][postmaster] LOG: terminating any other active server processes 2024-03-20 13:39:02.920 UTC [33036][postmaster] LOG: shutting down due to startup process failure 2024-03-20 13:39:02.921 UTC [33036][postmaster] LOG: database system is shut down