# Checking port 24926 # Found port 24926 Name: publisher Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/archives Connection string: port=24926 host=/tmp/kD87SeIw7n Log file: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log [14:56:44.103](0.017s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /tmp/cirrus-ci-build/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 67124 # Checking port 24927 # Found port 24927 Name: subscriber Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/archives Connection string: port=24927 host=/tmp/kD87SeIw7n Log file: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log [14:56:45.365](1.261s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /tmp/cirrus-ci-build/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 67514 #### Begin standard error psql::3: WARNING: subscriptions created by regression test cases should have names starting with "regress_" 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/017DB478 on publisher done done [14:56:47.354](1.989s) ok 1 - Verified multiple_unique_conflicts logged into conflict log table [14:56:47.394](0.040s) ok 2 - Verified that key 2 exists in the local_conflicts [14:56:47.396](0.002s) ok 3 - multiple_unique_conflicts detected during insert [14:56:47.603](0.207s) ok 4 - Verified multiple_unique_conflicts logged into conflict log table [14:56:47.618](0.016s) ok 5 - Verified that key 6 exists in the local_conflicts [14:56:47.620](0.002s) ok 6 - multiple_unique_conflicts detected during update [14:56:47.978](0.359s) ok 7 - multiple_unique_conflicts detected on a leaf partition during insert ### Restarting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_publisher_data/pgdata --log /tmp/cirrus-ci-build/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 68282 ### Restarting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/data/t_035_conflicts_subscriber_data/pgdata --log /tmp/cirrus-ci-build/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 68406 #### Begin standard error psql::5: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::5: NOTICE: created replication slot "tap_sub_b_a" on publisher #### End standard error #### Begin standard error psql::5: WARNING: subscriptions created by regression test cases should have names starting with "regress_" 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/0180DD00 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/01803508 on publisher done done [14:56:48.706](0.727s) ok 8 - Bidirectional replication setup is complete [14:56:48.724](0.019s) ok 9 - the xmin value of slot 'pg_conflict_detection' is valid on Node B [14:56:48.736](0.012s) ok 10 - altering retain_dead_tuples is not allowed for enabled subscription [14:56:48.778](0.042s) ok 11 - altering retain_dead_tuples is allowed for disabled subscription [14:56:48.816](0.038s) ok 12 - the xmin value of slot 'pg_conflict_detection' is valid on Node A [14:56:48.859](0.043s) 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/01803D88 on publisher done [14:56:48.951](0.092s) 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:56:49.011](0.060s) ok 15 - the deleted column is non-removable Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/01803F58 on publisher [15:00:23.141](214.130s) # poll_query_until timed out executing this query: # SELECT '0/01803F58' <= 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:00:23.154](0.013s) # Last pg_stat_replication contents: [15:00:23.154](0.000s) # die: timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/035_conflicts.pl line 355. [15:00:23.155](0.000s) 1..15 timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/035_conflicts.pl line 355. # Postmaster PID for node "publisher" is 68282 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/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:00:23.265](0.110s) # Looks like your test exited with 29 just after 15.