# Checking port 53880
# Found port 53880
Name: publisher
Data directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata
Backup directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/backup
Archive directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/archives
Connection string: port=53880 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/vif5xJkGHr
Log file: /Users/admin/pgsql/build/testrun/subscription/021_twophase/log/021_twophase_publisher.log
[22:19:09.015](0.016s) # initializing database system by copying initdb template
# Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata
# Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /Users/admin/pgsql/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 34747
# Checking port 53881
# Found port 53881
Name: subscriber
Data directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata
Backup directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/backup
Archive directory: /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/archives
Connection string: port=53881 host=/var/folders/n8/pp_chp6x3jlfy1n94r6hdjv40000gn/T/vif5xJkGHr
Log file: /Users/admin/pgsql/build/testrun/subscription/021_twophase/log/021_twophase_subscriber.log
[22:19:09.531](0.516s) # initializing database system by copying initdb template
# Running: cp -RPp /Users/admin/pgsql/build/tmp_install/initdb-template /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata
# Running: /Users/admin/pgsql/build/src/test/regress/pg_regress --config-auth /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /Users/admin/pgsql/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 34926
#### Begin standard error
psql:<stdin>: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/152F4D8 on publisher
done
done
Waiting for replication conn tap_sub's replay_lsn to pass 0/152F660 on publisher
done
[22:19:10.684](1.153s) ok 1 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/152F6B0 on publisher
done
[22:19:10.822](0.138s) ok 2 - Row inserted via 2PC has committed on subscriber
[22:19:11.018](0.197s) ok 3 - transaction is committed on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/152F838 on publisher
done
[22:19:11.097](0.078s) ok 4 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/152F888 on publisher
done
[22:19:11.189](0.092s) ok 5 - Row inserted via 2PC is not present on subscriber
[22:19:11.205](0.016s) ok 6 - transaction is aborted on subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/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 /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /Users/admin/pgsql/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 35489
### Starting node "subscriber"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /Users/admin/pgsql/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 35535
Waiting for replication conn tap_sub's replay_lsn to pass 0/1533A20 on publisher
done
[22:19:11.827](0.621s) ok 7 - Rows rolled back are not on the subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/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 /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_publisher_data/pgdata -l /Users/admin/pgsql/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 35723
### Starting node "subscriber"
# Running: pg_ctl -w -D /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /Users/admin/pgsql/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 35800
Waiting for replication conn tap_sub's replay_lsn to pass 0/1536020 on publisher
done
[22:19:12.498](0.672s) ok 8 - Rows inserted via 2PC are visible on the subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/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 /Users/admin/pgsql/build/testrun/subscription/021_twophase/data/t_021_twophase_subscriber_data/pgdata -l /Users/admin/pgsql/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 36020
Waiting for replication conn tap_sub's replay_lsn to pass 0/1536668 on publisher
[22:23:28.104](255.605s) # poll_query_until timed out executing this query:
# SELECT '0/1536668' <= 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 /Users/admin/pgsql/src/test/subscription/t/021_twophase.pl line 205.
# Postmaster PID for node "publisher" is 35723
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/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 36020
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /Users/admin/pgsql/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"
[22:23:28.333](0.229s) # Tests were run but no plan was declared and done_testing() was not seen.
[22:23:28.333](0.000s) # Looks like your test exited with 60 just after 8.