# Checking port 50216 # Found port 50216 Name: publisher Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/archives Connection string: port=50216 host=/tmp/pKrOjVdLj1 Log file: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_publisher.log [13:02:33.729](0.030s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 30679 # Checking port 50217 # Found port 50217 Name: subscriber Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/archives Connection string: port=50217 host=/tmp/pKrOjVdLj1 Log file: /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log [13:02:33.965](0.236s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 30775 #### 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" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub's replay_lsn to pass 0/1543158 on publisher done done Waiting for replication conn tap_sub's replay_lsn to pass 0/15432E0 on publisher done [13:02:34.502](0.537s) ok 1 - transaction is prepared on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/1543330 on publisher done [13:02:34.552](0.050s) ok 2 - Row inserted via 2PC has committed on subscriber [13:02:34.566](0.014s) ok 3 - transaction is committed on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/15434B8 on publisher done [13:02:34.640](0.074s) ok 4 - transaction is prepared on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/1543508 on publisher done [13:02:34.709](0.068s) ok 5 - Row inserted via 2PC is not present on subscriber [13:02:34.725](0.017s) ok 6 - transaction is aborted on subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Starting node "publisher" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 31274 ### Starting node "subscriber" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 31335 Waiting for replication conn tap_sub's replay_lsn to pass 0/15476B0 on publisher done [13:02:35.264](0.539s) ok 7 - Rows rolled back are not on the subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Starting node "publisher" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 31564 ### Starting node "subscriber" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 31655 Waiting for replication conn tap_sub's replay_lsn to pass 0/1549CA8 on publisher done [13:02:35.905](0.641s) ok 8 - Rows inserted via 2PC are visible on the subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "subscriber" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 31871 Waiting for replication conn tap_sub's replay_lsn to pass 0/154A308 on publisher [13:06:07.901](211.996s) # poll_query_until timed out executing this query: # SELECT '0/154A308' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('tap_sub', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/021_twophase.pl line 205. # Postmaster PID for node "publisher" is 31564 ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # Postmaster PID for node "subscriber" is 31871 ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" [13:06:08.116](0.214s) # Tests were run but no plan was declared and done_testing() was not seen. [13:06:08.116](0.000s) # Looks like your test exited with 29 just after 8.