# Checking port 27305 # Found port 27305 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=27305 host=/tmp/Z4qaA9XL9a Log file: /home/postgres/postgres/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log [15:01:04.936](0.064s) # 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 25619 # Checking port 27306 # Found port 27306 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=27306 host=/tmp/Z4qaA9XL9a Log file: /home/postgres/postgres/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log [15:01:05.540](0.604s) # 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 65550 #### 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/017C45D0 on publisher done done [15:01:07.485](1.945s) ok 1 - Verified multiple_unique_conflicts logged into conflict log table [15:01:07.563](0.078s) ok 2 - Verified that key 2 exists in the local_conflicts [15:01:07.563](0.000s) ok 3 - multiple_unique_conflicts detected during insert [15:01:08.000](0.437s) ok 4 - Verified multiple_unique_conflicts logged into conflict log table [15:01:08.048](0.048s) ok 5 - Verified that key 6 exists in the local_conflicts [15:01:08.048](0.000s) ok 6 - multiple_unique_conflicts detected during update [15:01:08.385](0.338s) 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 308 ### 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 90168 #### 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/017F7960 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/017EC660 on publisher done done [15:01:09.561](1.176s) ok 8 - Bidirectional replication setup is complete [15:01:09.640](0.079s) ok 9 - the xmin value of slot 'pg_conflict_detection' is valid on Node B [15:01:09.675](0.035s) ok 10 - altering retain_dead_tuples is not allowed for enabled subscription [15:01:09.821](0.146s) ok 11 - altering retain_dead_tuples is allowed for disabled subscription [15:01:09.964](0.143s) ok 12 - the xmin value of slot 'pg_conflict_detection' is valid on Node A [15:01:10.015](0.052s) 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/017ECEE0 on publisher done [15:01:10.345](0.330s) 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 [15:01:10.683](0.338s) ok 15 - the deleted column is non-removable Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/017ED0B0 on publisher [15:05:41.246](270.562s) # poll_query_until timed out executing this query: # SELECT '0/017ED0B0' <= 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:05:41.272](0.026s) # Last pg_stat_replication contents: [15:05:41.273](0.001s) # die: timed out waiting for catchup at /home/postgres/postgres/src/test/subscription/t/035_conflicts.pl line 355. [15:05:41.273](0.000s) 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 308 ### 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" [15:05:41.389](0.116s) # Looks like your test exited with 4 just after 15.