# Checking port 51824 # Found port 51824 Name: primary Data directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives Connection string: port=51824 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU Log file: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_primary.log # Checking port 51825 # Found port 51825 Name: standby Data directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/archives Connection string: port=51825 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU Log file: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_standby.log # Checking port 51826 # Found port 51826 Name: cascading_standby Data directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_cascading_standby_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_cascading_standby_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_cascading_standby_data/archives Connection string: port=51826 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU Log file: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_cascading_standby.log # Checking port 51827 # Found port 51827 Name: subscriber Data directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/archives Connection string: port=51827 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU Log file: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_subscriber.log [00:50:41.969](0.181s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata ### Enabling WAL archiving for node "primary" Name: primary Version: 17devel Data directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/backup Archive directory: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/archives Connection string: port=51824 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU Log file: /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_primary.log ### Starting node "primary" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata -l /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_primary.log -o --cluster-name=primary start waiting for server to start.... done server started # Postmaster PID for node "primary" is 14829 [00:50:46.742](4.774s) ok 1 - Physical slot reports conflict_reason as NULL # Taking pg_basebackup b1 from node "primary" # Running: pg_basebackup -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/backup/b1 -h /var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/mC2fCuLRAU -p 51824 --checkpoint fast --no-sync # Backup finished # Initializing node "standby" from backup "b1" of node "primary" ### Enabling streaming replication for node "standby" ### Enabling WAL restore for node "standby" ### Starting node "standby" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata -l /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_standby.log -o --cluster-name=standby start waiting for server to start.... done server started # Postmaster PID for node "standby" is 14950 Waiting for replication conn standby's replay_lsn to pass 0/3019E10 on primary done [00:50:51.040](4.298s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/pgdata -l /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 15020 [00:50:53.257](2.217s) ok 2 - behaves_ok_inactiveslot on standby created [00:50:53.462](0.205s) ok 3 - behaves_ok_activeslot on standby created Waiting for replication conn standby's replay_lsn to pass 0/3026730 on primary done [00:50:53.542](0.080s) ok 4 - Decoding produced 14 rows (2 BEGIN/COMMIT and 10 rows) Waiting for replication conn standby's replay_lsn to pass 0/3026860 on primary done [00:50:54.489](0.947s) ok 5 - got expected output from SQL decoding session Waiting for replication conn standby's replay_lsn to pass 0/3027410 on primary done [00:50:54.582](0.094s) ok 6 - got same expected output from pg_recvlogical decoding session [00:50:54.620](0.037s) ok 7 - pg_recvlogical acknowledged changes Waiting for replication conn standby's replay_lsn to pass 0/3463408 on primary done [00:50:54.847](0.228s) ok 8 - replaying logical slot from another database fails Waiting for replication conn standby's replay_lsn to pass 0/348AC40 on primary done Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub's replay_lsn to pass 0/348AC78 on standby done done Waiting for replication conn standby's replay_lsn to pass 0/348B208 on primary done Waiting for replication conn tap_sub's replay_lsn to pass 0/348B208 on standby done [00:50:56.903](2.055s) ok 9 - check replicated inserts after subscription on standby #### Begin standard error psql::1: NOTICE: dropped replication slot "tap_sub" on publisher #### End standard error ### Stopping node "subscriber" using mode fast # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_subscriber_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" [00:50:58.141](1.238s) ok 10 - vacuum_full_inactiveslot on standby created [00:50:58.904](0.763s) ok 11 - vacuum_full_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled #### Begin standard error psql::1: INFO: vacuuming "pg_catalog.pg_class" psql::1: INFO: "pg_catalog.pg_class": found 5 removable, 420 nonremovable row versions in 14 pages DETAIL: 0 dead row versions cannot be removed yet. CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s. #### End standard error Waiting for replication conn standby's replay_lsn to pass 0/34BBB90 on primary done [00:51:00.167](1.263s) ok 12 - inactiveslot slot invalidation is logged with vacuum FULL on pg_class [00:51:00.167](0.000s) ok 13 - activeslot slot invalidation is logged with vacuum FULL on pg_class [00:51:00.383](0.216s) ok 14 - confl_active_logicalslot updated [00:51:00.412](0.029s) ok 15 - vacuum_full_activeslot conflict_reason is rows_removed [00:51:00.444](0.031s) ok 16 - vacuum_full_inactiveslot conflict_reason is rows_removed [00:51:00.467](0.023s) ok 17 - pg_recvlogical exited non-zero [00:51:00.467](0.000s) ok 18 - slot has been invalidated ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled ### Restarting node "standby" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata -l /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_standby.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "standby" is 15609 [00:51:01.509](1.042s) ok 19 - vacuum_full_activeslot conflict_reason is rows_removed [00:51:01.539](0.030s) ok 20 - vacuum_full_inactiveslot conflict_reason is rows_removed Waiting for replication conn standby's replay_lsn to pass 0/40000F8 on primary done [00:51:04.563](3.024s) ok 21 - invalidated logical slots do not lead to retaining WAL [00:51:04.941](0.378s) ok 22 - row_removal_inactiveslot on standby created [00:51:05.151](0.209s) ok 23 - row_removal_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled #### Begin standard error psql::1: INFO: vacuuming "testdb.pg_catalog.pg_class" psql::1: INFO: finished vacuuming "testdb.pg_catalog.pg_class": index scans: 1 pages: 0 removed, 11 remain, 11 scanned (100.00% of total) tuples: 4 removed, 419 remain, 0 are dead but not yet removable removable cutoff: 754, which was 0 XIDs old when operation ended frozen: 0 pages from table (0.00% of total) had 0 tuples frozen index scan needed: 3 pages from table (27.27% of total) had 5 dead item identifiers removed index "pg_class_oid_index": pages: 4 in total, 0 newly deleted, 0 currently deleted, 0 reusable index "pg_class_relname_nsp_index": pages: 5 in total, 0 newly deleted, 0 currently deleted, 0 reusable index "pg_class_tblspc_relfilenode_index": pages: 2 in total, 0 newly deleted, 0 currently deleted, 0 reusable avg read rate: 57.710 MB/s, avg write rate: 108.206 MB/s buffer usage: 77 hits, 8 misses, 15 dirtied WAL usage: 28 records, 15 full page images, 122841 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s #### End standard error Waiting for replication conn standby's replay_lsn to pass 0/403EDC0 on primary done [00:51:05.863](0.712s) ok 24 - inactiveslot slot invalidation is logged with vacuum on pg_class [00:51:05.863](0.000s) ok 25 - activeslot slot invalidation is logged with vacuum on pg_class [00:51:05.923](0.060s) ok 26 - confl_active_logicalslot updated [00:51:05.949](0.026s) ok 27 - row_removal_activeslot conflict_reason is rows_removed [00:51:05.989](0.040s) ok 28 - row_removal_inactiveslot conflict_reason is rows_removed [00:51:06.018](0.029s) ok 29 - pg_recvlogical exited non-zero [00:51:06.019](0.000s) ok 30 - slot has been invalidated [00:51:06.825](0.807s) ok 31 - shared_row_removal_inactiveslot on standby created [00:51:07.567](0.741s) ok 32 - shared_row_removal_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled #### Begin standard error psql::1: INFO: vacuuming "testdb.pg_catalog.pg_authid" psql::1: INFO: finished vacuuming "testdb.pg_catalog.pg_authid": index scans: 1 pages: 0 removed, 1 remain, 1 scanned (100.00% of total) tuples: 1 removed, 15 remain, 0 are dead but not yet removable removable cutoff: 757, which was 0 XIDs old when operation ended new relfrozenxid: 757, which is 27 XIDs ahead of previous value frozen: 0 pages from table (0.00% of total) had 0 tuples frozen index scan needed: 1 pages from table (100.00% of total) had 1 dead item identifiers removed index "pg_authid_rolname_index": pages: 2 in total, 0 newly deleted, 0 currently deleted, 0 reusable index "pg_authid_oid_index": pages: 2 in total, 0 newly deleted, 0 currently deleted, 0 reusable avg read rate: 81.806 MB/s, avg write rate: 40.903 MB/s buffer usage: 35 hits, 2 misses, 1 dirtied WAL usage: 6 records, 1 full page images, 8692 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s psql::1: INFO: vacuuming "testdb.pg_toast.pg_toast_1260" psql::1: INFO: finished vacuuming "testdb.pg_toast.pg_toast_1260": index scans: 0 pages: 0 removed, 0 remain, 0 scanned (100.00% of total) tuples: 0 removed, 0 remain, 0 are dead but not yet removable removable cutoff: 757, which was 0 XIDs old when operation ended new relfrozenxid: 757, which is 27 XIDs ahead of previous value frozen: 0 pages from table (100.00% of total) had 0 tuples frozen index scan not needed: 0 pages from table (100.00% of total) had 0 dead item identifiers removed avg read rate: 101.461 MB/s, avg write rate: 101.461 MB/s buffer usage: 24 hits, 1 misses, 1 dirtied WAL usage: 1 records, 0 full page images, 188 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s #### End standard error Waiting for replication conn standby's replay_lsn to pass 0/4042098 on primary done [00:51:08.252](0.685s) ok 33 - inactiveslot slot invalidation is logged with vacuum on pg_authid [00:51:08.252](0.000s) ok 34 - activeslot slot invalidation is logged with vacuum on pg_authid [00:51:08.311](0.059s) ok 35 - confl_active_logicalslot updated [00:51:08.336](0.025s) ok 36 - shared_row_removal_activeslot conflict_reason is rows_removed [00:51:08.357](0.021s) ok 37 - shared_row_removal_inactiveslot conflict_reason is rows_removed [00:51:08.388](0.031s) ok 38 - pg_recvlogical exited non-zero [00:51:08.389](0.000s) ok 39 - slot has been invalidated [00:51:08.797](0.408s) ok 40 - no_conflict_inactiveslot on standby created [00:51:08.974](0.177s) ok 41 - no_conflict_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled #### Begin standard error psql::1: INFO: vacuuming "testdb.public.conflict_test" psql::1: INFO: finished vacuuming "testdb.public.conflict_test": index scans: 0 pages: 0 removed, 1 remain, 1 scanned (100.00% of total) tuples: 4 removed, 4 remain, 0 are dead but not yet removable removable cutoff: 761, which was 0 XIDs old when operation ended new relfrozenxid: 760, which is 2 XIDs ahead of previous value frozen: 0 pages from table (0.00% of total) had 0 tuples frozen index scan not needed: 0 pages from table (0.00% of total) had 0 dead item identifiers removed avg read rate: 78.649 MB/s, avg write rate: 104.866 MB/s buffer usage: 19 hits, 3 misses, 4 dirtied WAL usage: 6 records, 4 full page images, 33238 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s psql::1: INFO: vacuuming "testdb.pg_toast.pg_toast_16418" psql::1: INFO: finished vacuuming "testdb.pg_toast.pg_toast_16418": index scans: 0 pages: 0 removed, 0 remain, 0 scanned (100.00% of total) tuples: 0 removed, 0 remain, 0 are dead but not yet removable removable cutoff: 761, which was 0 XIDs old when operation ended new relfrozenxid: 761, which is 3 XIDs ahead of previous value frozen: 0 pages from table (100.00% of total) had 0 tuples frozen index scan not needed: 0 pages from table (100.00% of total) had 0 dead item identifiers removed avg read rate: 110.035 MB/s, avg write rate: 0.000 MB/s buffer usage: 24 hits, 1 misses, 0 dirtied WAL usage: 1 records, 0 full page images, 188 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s #### End standard error Waiting for replication conn standby's replay_lsn to pass 0/404E1F0 on primary done [00:51:09.632](0.659s) ok 42 - inactiveslot slot invalidation is not logged with vacuum on conflict_test [00:51:09.633](0.000s) ok 43 - activeslot slot invalidation is not logged with vacuum on conflict_test [00:51:09.675](0.042s) ok 44 - confl_active_logicalslot not updated [00:51:10.164](0.490s) ok 45 - Logical slots are reported as non conflicting ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled ### Restarting node "standby" # Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata -l /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/log/035_standby_logical_decoding_standby.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "standby" is 16623 [00:51:11.446](1.282s) ok 46 - pruning_inactiveslot on standby created [00:51:11.636](0.190s) ok 47 - pruning_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled Waiting for replication conn standby's replay_lsn to pass 0/405A6E0 on primary done [00:51:12.994](1.359s) ok 48 - inactiveslot slot invalidation is logged with on-access pruning [00:51:12.995](0.000s) ok 49 - activeslot slot invalidation is logged with on-access pruning [00:51:13.010](0.015s) ok 50 - confl_active_logicalslot updated [00:51:13.023](0.013s) ok 51 - pruning_activeslot conflict_reason is rows_removed [00:51:13.034](0.011s) ok 52 - pruning_inactiveslot conflict_reason is rows_removed [00:51:13.043](0.009s) ok 53 - pg_recvlogical exited non-zero [00:51:13.043](0.000s) ok 54 - slot has been invalidated ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled [00:51:13.446](0.403s) ok 55 - injection_inactiveslot on standby created [00:51:13.657](0.211s) ok 56 - injection_activeslot on standby created ### Reloading node "standby" # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata reload server signaled Waiting for replication conn standby's replay_lsn to pass 0/406ABC0 on primary done #### Begin standard error psql::1: INFO: vacuuming "testdb.pg_catalog.pg_class" psql::1: INFO: finished vacuuming "testdb.pg_catalog.pg_class": index scans: 1 pages: 0 removed, 11 remain, 11 scanned (100.00% of total) tuples: 0 removed, 426 remain, 0 are dead but not yet removable removable cutoff: 772, which was 0 XIDs old when operation ended frozen: 0 pages from table (0.00% of total) had 0 tuples frozen index scan needed: 2 pages from table (18.18% of total) had 2 dead item identifiers removed index "pg_class_oid_index": pages: 4 in total, 0 newly deleted, 0 currently deleted, 0 reusable index "pg_class_relname_nsp_index": pages: 5 in total, 0 newly deleted, 0 currently deleted, 0 reusable index "pg_class_tblspc_relfilenode_index": pages: 2 in total, 0 newly deleted, 0 currently deleted, 0 reusable avg read rate: 276.549 MB/s, avg write rate: 276.549 MB/s buffer usage: 78 hits, 8 misses, 8 dirtied WAL usage: 13 records, 0 full page images, 1303 bytes system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s #### End standard error [00:51:14.994](1.338s) ok 57 - terminating process holding the active slot is logged with injection point [00:55:31.480](256.486s) # poll_query_until timed out executing this query: # SELECT (SELECT catalog_xmin::text::int - 770 from pg_catalog.pg_replication_slots where slot_name = 'injection_activeslot') > 0 # expecting this output: # t # last actual query output: # f # with stderr: catalog_xmin did not advance at /Users/admin/pgsql/src/test/recovery/t/035_standby_logical_decoding.pl line 808. # Postmaster PID for node "primary" is 14829 ### Stopping node "primary" using mode immediate # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_primary_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary" # Postmaster PID for node "standby" is 16623 ### Stopping node "standby" using mode immediate # Running: pg_ctl -D /Users/admin/pgsql/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby" # No postmaster PID for node "cascading_standby" # No postmaster PID for node "subscriber" [00:55:31.750](0.269s) # Tests were run but no plan was declared and done_testing() was not seen. [00:55:31.750](0.000s) # Looks like your test exited with 60 just after 57.