# Checking port 20284 # Found port 20284 Name: publisher Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/backup Archive directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/archives Connection string: port=20284 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/YqMuJvZCLw Log file: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log [14:58:42.665](0.228s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 55738 # Checking port 20285 # Found port 20285 Name: subscriber Version: 19devel Data directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata Backup directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/backup Archive directory: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/archives Connection string: port=20285 host=/var/folders/hm/d7rr9ds96qx995ns72ry9g4m0000gn/T/YqMuJvZCLw Log file: /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log [14:58:45.219](2.554s) # initializing database system by copying initdb template # Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata # Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 55845 #### Begin standard error psql::3: NOTICE: created conflict log table "pg_conflict.pg_conflict_log_16410" for subscription "sub_tab" psql::3: NOTICE: created replication slot "sub_tab" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn sub_tab's replay_lsn to pass 0/017DA998 on publisher done done [14:58:47.496](2.277s) ok 1 - Verified multiple_unique_conflicts logged into conflict log table [14:58:47.524](0.028s) ok 2 - Verified that key 2 exists in the local_conflicts [14:58:47.524](0.000s) ok 3 - multiple_unique_conflicts detected during insert [14:58:47.833](0.309s) ok 4 - Verified multiple_unique_conflicts logged into conflict log table [14:58:47.880](0.047s) ok 5 - Verified that key 6 exists in the local_conflicts [14:58:47.880](0.000s) ok 6 - multiple_unique_conflicts detected during update [14:58:48.294](0.413s) ok 7 - multiple_unique_conflicts detected on a leaf partition during insert ### Restarting node "publisher" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "publisher" is 56237 ### Restarting node "subscriber" # Running: pg_ctl --wait --pgdata /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /Users/admin/pgsql/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log restart waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 56273 #### Begin standard error psql::5: NOTICE: created replication slot "tap_sub_b_a" on publisher #### End standard error #### Begin standard error psql::5: NOTICE: created replication slot "tap_sub_a_b" on publisher #### End standard error Waiting for all subscriptions in "publisher" to synchronize data Waiting for replication conn tap_sub_a_b's replay_lsn to pass 0/0180DDA8 on subscriber done done Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/01802A50 on publisher done done [14:58:49.593](1.299s) ok 8 - Bidirectional replication setup is complete [14:58:49.640](0.047s) ok 9 - the xmin value of slot 'pg_conflict_detection' is valid on Node B [14:58:49.669](0.028s) ok 10 - altering retain_dead_tuples is not allowed for enabled subscription [14:58:49.788](0.119s) ok 11 - altering retain_dead_tuples is allowed for disabled subscription [14:58:49.949](0.161s) ok 12 - the xmin value of slot 'pg_conflict_detection' is valid on Node A [14:58:49.994](0.045s) ok 13 - warn of the possibility of receiving changes from origins other than the publisher Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/018032D0 on publisher done [14:58:50.189](0.194s) ok 14 - check replicated insert on node B #### Begin standard error psql::1: WARNING: deleted rows to detect conflicts would not be removed until the subscription is enabled HINT: Consider setting retain_dead_tuples to false. #### End standard error [14:58:50.407](0.218s) ok 15 - the deleted column is non-removable Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/018034A0 on publisher [15:03:34.887](284.480s) # poll_query_until timed out executing this query: # SELECT '0/018034A0' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('tap_sub_b_a', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: [15:03:34.933](0.046s) # Last pg_stat_replication contents: [15:03:34.934](0.001s) # die: timed out waiting for catchup at /Users/admin/pgsql/src/test/subscription/t/035_conflicts.pl line 355. [15:03:34.934](0.001s) 1..15 timed out waiting for catchup at /Users/admin/pgsql/src/test/subscription/t/035_conflicts.pl line 355. # Postmaster PID for node "publisher" is 56237 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /Users/admin/pgsql/build/testrun/subscription/035_conflicts/data/t_035_conflicts_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:03:35.070](0.135s) # Looks like your test exited with 29 just after 15.