# Checking port 12972 # Found port 12972 Name: publisher Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/backup Archive directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/archives Connection string: port=12972 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/JsPJ2lo6lW Log file: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/log/001_rep_changes_publisher.log [14:56:47.993](0.160s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/log/001_rep_changes_publisher.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 45404 # Checking port 12973 # Found port 12973 Name: subscriber Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/backup Archive directory: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/archives Connection string: port=12973 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/JsPJ2lo6lW Log file: /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/log/001_rep_changes_subscriber.log [14:56:49.843](1.850s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_subscriber_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/log/001_rep_changes_subscriber.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 45622 #### Begin standard error psql::1: NOTICE: created replication slot "tap_sub" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub's replay_lsn to pass 0/01819EC0 on publisher done done [14:56:54.538](4.695s) ok 1 - check non-replicated table is empty on subscriber [14:56:54.615](0.078s) ok 2 - check initial data was copied to subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/018301E8 on publisher done [14:56:55.580](0.965s) ok 3 - check replicated inserts on subscriber [14:56:55.625](0.045s) ok 4 - check replicated changes on subscriber [14:56:55.655](0.030s) ok 5 - check replicated changes with different column order [14:56:55.722](0.067s) ok 6 - check replicated changes with REPLICA IDENTITY NOTHING [14:56:55.775](0.053s) ok 7 - check replicated changes with primary key index with included columns [14:56:55.812](0.037s) ok 8 - value replicated to subscriber without replica identity index [14:56:55.844](0.032s) ok 9 - check replicated changes for table having no columns [14:56:56.061](0.217s) ok 10 - check rows on subscriber before table drop from publication Waiting for replication conn tap_sub's replay_lsn to pass 0/01830748 on publisher done [14:56:56.518](0.457s) ok 11 - check rows on subscriber after table drop from publication #### Begin standard error psql::1: NOTICE: created replication slot "tap_sub_temp1" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub_temp1's replay_lsn to pass 0/01834418 on publisher done done [14:56:57.753](1.235s) ok 12 - check initial rows on subscriber with multiple publications Waiting for replication conn tap_sub_temp1's replay_lsn to pass 0/01834488 on publisher done [14:56:58.076](0.323s) ok 13 - check rows on subscriber with multiple publications #### Begin standard error psql::1: NOTICE: dropped replication slot "tap_sub_temp1" on publisher #### End standard error Waiting for replication conn tap_sub's replay_lsn to pass 0/01836C68 on publisher done [14:56:59.328](1.253s) ok 14 - update works with REPLICA IDENTITY FULL and duplicate tuples [14:56:59.384](0.056s) ok 15 - update works with REPLICA IDENTITY FULL and text datums [14:56:59.445](0.061s) ok 16 - update works with different column order and subscriber local values [14:56:59.485](0.039s) ok 17 - update works with REPLICA IDENTITY FULL and a primary key Waiting for replication conn tap_sub's replay_lsn to pass 0/01836E40 on publisher [15:02:21.561](322.076s) # poll_query_until timed out executing this query: # SELECT '0/01836E40' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('tap_sub', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: [15:02:21.629](0.069s) # Last pg_stat_replication contents: [15:02:21.631](0.001s) # die: timed out waiting for catchup at /Users/admin/pgsql/src/test/subscription/t/001_rep_changes.pl line 365. [15:02:21.632](0.001s) 1..17 timed out waiting for catchup at /Users/admin/pgsql/src/test/subscription/t/001_rep_changes.pl line 365. # Postmaster PID for node "publisher" is 45404 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /Users/admin/pgsql/build/testrun/subscription/001_rep_changes/data/t_001_rep_changes_publisher_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # No postmaster PID for node "subscriber" [15:02:21.758](0.126s) # Looks like your test exited with 29 just after 17.