# Checking port 31474 # Found port 31474 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=31474 host=/tmp/chagwFPDmx Log file: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/log/035_conflicts_publisher.log [14:58:24.992](0.018s) # 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 io_method=io_uring 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: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.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 ... Etc/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 82130 # Checking port 31475 # Found port 31475 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=31475 host=/tmp/chagwFPDmx Log file: /tmp/cirrus-ci-build/build/testrun/subscription/035_conflicts/log/035_conflicts_subscriber.log [14:58:26.366](1.374s) # 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 io_method=io_uring 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: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.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 ... Etc/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 82406 #### 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/017F49C8 on publisher done done [14:58:28.198](1.831s) ok 1 - Verified multiple_unique_conflicts logged into conflict log table [14:58:28.218](0.020s) ok 2 - Verified that key 2 exists in the local_conflicts [14:58:28.218](0.000s) ok 3 - multiple_unique_conflicts detected during insert [14:58:28.448](0.230s) ok 4 - Verified multiple_unique_conflicts logged into conflict log table [14:58:28.463](0.015s) ok 5 - Verified that key 6 exists in the local_conflicts [14:58:28.463](0.000s) ok 6 - multiple_unique_conflicts detected during update [14:58:28.920](0.456s) 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 82690 ### 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 82713 #### 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/01826F88 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/0181CA58 on publisher done done [14:58:29.660](0.740s) ok 8 - Bidirectional replication setup is complete [14:58:29.680](0.021s) ok 9 - the xmin value of slot 'pg_conflict_detection' is valid on Node B [14:58:29.701](0.020s) ok 10 - altering retain_dead_tuples is not allowed for enabled subscription [14:58:29.766](0.065s) ok 11 - altering retain_dead_tuples is allowed for disabled subscription [14:58:29.806](0.040s) ok 12 - the xmin value of slot 'pg_conflict_detection' is valid on Node A [14:58:29.840](0.034s) 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/0181D2D8 on publisher done [14:58:29.945](0.106s) 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:30.040](0.094s) ok 15 - the deleted column is non-removable Waiting for replication conn tap_sub_b_a's replay_lsn to pass 0/0181D4A8 on publisher [15:02:03.866](213.826s) # poll_query_until timed out executing this query: # SELECT '0/0181D4A8' <= 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:02:03.886](0.020s) # Last pg_stat_replication contents: [15:02:03.886](0.000s) # die: timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/035_conflicts.pl line 355. [15:02:03.887](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 82690 ### 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:02:03.993](0.106s) # Looks like your test exited with 29 just after 15.