# Checking port 20612 # Found port 20612 Name: publisher Version: 19devel Data directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/backup Archive directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/archives Connection string: port=20612 host=/tmp/JOZDN4LKnp Log file: /home/postgres/postgres/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log [14:54:15.825](0.017s) # initializing database system by copying initdb template # Running: cp -RPp /home/postgres/postgres/build/tmp_install/initdb-template /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /home/postgres/postgres/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 13957 # Checking port 20613 # Found port 20613 Name: subscriber Version: 19devel Data directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata Backup directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/backup Archive directory: /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/archives Connection string: port=20613 host=/tmp/JOZDN4LKnp Log file: /home/postgres/postgres/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log [14:54:16.027](0.201s) # initializing database system by copying initdb template # Running: cp -RPp /home/postgres/postgres/build/tmp_install/initdb-template /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata # Running: /home/postgres/postgres/build/src/test/regress/pg_regress --config-auth /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /home/postgres/postgres/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 272 #### 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/017DA9A8 on publisher done done [14:54:16.671](0.644s) ok 1 - Verified multiple_unique_conflicts logged into conflict log table [14:54:16.687](0.017s) ok 2 - Verified that key 2 exists in the local_conflicts [14:54:16.687](0.000s) ok 3 - multiple_unique_conflicts detected during insert [14:54:17.028](0.341s) ok 4 - Verified multiple_unique_conflicts logged into conflict log table [14:54:17.045](0.017s) ok 5 - Verified that key 6 exists in the local_conflicts [14:54:17.045](0.000s) ok 6 - multiple_unique_conflicts detected during update [14:54:17.421](0.376s) ok 7 - multiple_unique_conflicts detected on a leaf partition during insert ### Restarting node "publisher" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /home/postgres/postgres/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 1805 ### Restarting node "subscriber" # Running: pg_ctl --wait --pgdata /home/postgres/postgres/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /home/postgres/postgres/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 4750 #### 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/0180D200 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/01802A78 on publisher done done [14:54:18.373](0.952s) ok 8 - Bidirectional replication setup is complete [14:54:18.432](0.059s) ok 9 - the xmin value of slot 'pg_conflict_detection' is valid on Node B [14:54:18.452](0.020s) ok 10 - altering retain_dead_tuples is not allowed for enabled subscription [14:54:18.530](0.078s) ok 11 - altering retain_dead_tuples is allowed for disabled subscription [14:54:18.585](0.056s) ok 12 - the xmin value of slot 'pg_conflict_detection' is valid on Node A [14:54:18.618](0.032s) 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/018032F8 on publisher done [14:54:18.744](0.126s) 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:54:18.869](0.125s) ok 15 - the deleted column is non-removable Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/018034C8 on publisher [14:58:00.961](222.092s) # poll_query_until timed out executing this query: # SELECT '0/018034C8' <= 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: [14:58:00.980](0.019s) # Last pg_stat_replication contents: [14:58:00.982](0.002s) # die: timed out waiting for catchup at /home/postgres/postgres/src/test/subscription/t/035_conflicts.pl line 355. [14:58:00.983](0.001s) 1..15 timed out waiting for catchup at /home/postgres/postgres/src/test/subscription/t/035_conflicts.pl line 355. # Postmaster PID for node "publisher" is 1805 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /home/postgres/postgres/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" [14:58:01.093](0.110s) # Looks like your test exited with 4 just after 15.