# Checking port 51817
# Found port 51817
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/archives
Connection string: port=51817 host=/tmp/Wz8S1yC1Pf
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "nm".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US
  LC_CTYPE:    en_US
  LC_MESSAGES: C
  LC_MONETARY: en_US
  LC_NUMERIC:  en_US
  LC_TIME:     en_US
The default database encoding has accordingly been set to "LATIN1".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_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 ... CUT0
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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -l logfile start

# Running: /home/nm/src/pg/postgresql/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 4391508
# Checking port 51818
# Found port 51818
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/archives
Connection string: port=51818 host=/tmp/Wz8S1yC1Pf
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "nm".
This user must also own the server process.

The database cluster will be initialized with this locale configuration:
  provider:    libc
  LC_COLLATE:  en_US
  LC_CTYPE:    en_US
  LC_MESSAGES: C
  LC_MONETARY: en_US
  LC_NUMERIC:  en_US
  LC_TIME:     en_US
The default database encoding has accordingly been set to "LATIN1".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_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 ... CUT0
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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -l logfile start

# Running: /home/nm/src/pg/postgresql/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 55443948
#### Begin standard error
psql:<stdin>:5: NOTICE:  created replication slot "tap_sub" on publisher
#### End standard error
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EB6E0 on publisher
done
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EB898 on publisher
done
ok 1 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EB8E8 on publisher
done
ok 2 - Row inserted via 2PC has committed on subscriber
ok 3 - transaction is committed on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EBA68 on publisher
done
ok 4 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EBAB8 on publisher
done
ok 5 - Row inserted via 2PC is not present on subscriber
ok 6 - transaction is aborted on subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 18022720
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 6816320
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EBD00 on publisher
done
ok 7 - Rows rolled back are not on the subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 42729748
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 55443956
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EBF48 on publisher
done
ok 8 - Rows inserted via 2PC are visible on the subscriber
### Stopping node "subscriber" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 4391520
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC1A8 on publisher
done
ok 9 - Rows inserted via 2PC are visible on the subscriber
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/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 /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/021_twophase_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 58327384
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC3F0 on publisher
done
ok 10 - Rows inserted via 2PC are visible on the subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC608 on publisher
done
ok 11 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC640 on publisher
done
ok 12 - transaction is ended on subscriber
ok 13 - Rows committed are on the subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC7B0 on publisher
done
ok 14 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/14EC7E8 on publisher
done
ok 15 - transaction is aborted on subscriber
ok 16 - initial data in subscriber table
#### Begin standard error
psql:<stdin>:5: NOTICE:  created replication slot "tap_sub_copy" on publisher
#### End standard error
Waiting for replication conn appname_copy's replay_lsn to pass 0/14F20F8 on publisher
done
ok 17 - initial data in subscriber table
Waiting for replication conn appname_copy's replay_lsn to pass 0/14F2268 on publisher
done
Waiting for replication conn tap_sub's replay_lsn to pass 0/14F2268 on publisher
done
ok 18 - transaction is prepared on subscriber
ok 19 - publisher inserted data
Waiting for replication conn appname_copy's replay_lsn to pass 0/14F22A0 on publisher
done
ok 20 - replicated data in subscriber table
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub_copy" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
ok 21 - check subscription was dropped on subscriber
ok 22 - check replication slot was dropped on publisher
ok 23 - check subscription relation status was dropped on subscriber
ok 24 - check replication origin was dropped on subscriber
### Stopping node "subscriber" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_subscriber_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "subscriber"
### Stopping node "publisher" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_021_twophase_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
1..24
