# Checking port 56499 # Found port 56499 Name: publisher Data directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata Backup directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/backup Archive directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/archives Connection string: port=56499 host=C:/Windows/TEMP/7X83e4m8Fr Log file: C:\cirrus\build/testrun/subscription/021_twophase\log/021_twophase_publisher.log [05:20:08.507](0.090s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata -l C:\cirrus\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 6152 # Checking port 56500 # Found port 56500 Name: subscriber Data directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata Backup directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/backup Archive directory: C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/archives Connection string: port=56500 host=C:/Windows/TEMP/7X83e4m8Fr Log file: C:\cirrus\build/testrun/subscription/021_twophase\log/021_twophase_subscriber.log [05:20:10.794](2.287s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata -l C:\cirrus\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 7052 #### Begin standard error 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/1520E48 on publisher done done Waiting for replication conn tap_sub's replay_lsn to pass 0/1520FD0 on publisher done [05:20:14.453](3.659s) ok 1 - transaction is prepared on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/1521020 on publisher done [05:20:15.330](0.877s) ok 2 - Row inserted via 2PC has committed on subscriber [05:20:15.593](0.263s) ok 3 - transaction is committed on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/15211A8 on publisher done [05:20:17.067](1.474s) ok 4 - transaction is prepared on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/15211F8 on publisher done [05:20:18.021](0.954s) ok 5 - Row inserted via 2PC is not present on subscriber [05:20:18.298](0.277s) ok 6 - transaction is aborted on subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D C:\cirrus\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 C:\cirrus\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 C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata -l C:\cirrus\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 7632 ### Starting node "subscriber" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata -l C:\cirrus\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 4460 Waiting for replication conn tap_sub's replay_lsn to pass 0/1525390 on publisher done [05:20:20.509](2.211s) ok 7 - Rows rolled back are not on the subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D C:\cirrus\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 C:\cirrus\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 C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_publisher_data/pgdata -l C:\cirrus\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 4244 ### Starting node "subscriber" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata -l C:\cirrus\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 2432 Waiting for replication conn tap_sub's replay_lsn to pass 0/1527978 on publisher done [05:20:22.853](2.344s) ok 8 - Rows inserted via 2PC are visible on the subscriber ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D C:\cirrus\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 C:\cirrus\build/testrun/subscription/021_twophase\data/t_021_twophase_subscriber_data/pgdata -l C:\cirrus\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 7808 Waiting for replication conn tap_sub's replay_lsn to pass 0/1527FC0 on publisher [05:26:01.109](338.255s) # poll_query_until timed out executing this query: # SELECT '0/1527FC0' <= 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 C:/cirrus/src/test/subscription/t/021_twophase.pl line 205. # Postmaster PID for node "publisher" is 4244 ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D C:\cirrus\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 7808 ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D C:\cirrus\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" [05:26:01.362](0.254s) # Tests were run but no plan was declared and done_testing() was not seen. [05:26:01.363](0.000s) # Looks like your test exited with 25 just after 8.