# Checking port 62870
# Found port 62870
Name: publisher
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_publisher_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_publisher_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_publisher_data/archives
Connection string: port=62870 host=/tmp/8ie0OihH4_
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_publisher.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_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_023_twophase_stream_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_023_twophase_stream_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_023_twophase_stream_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 32309722
# Checking port 62871
# Found port 62871
Name: subscriber
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_subscriber_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_subscriber_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_subscriber_data/archives
Connection string: port=62871 host=/tmp/8ie0OihH4_
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_subscriber.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_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_023_twophase_stream_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_023_twophase_stream_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_023_twophase_stream_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 51052934
#### 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/14F18F0 on publisher
done
ok 1 - check initial data was copied to subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/166BE78 on publisher
done
ok 2 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/166BEF8 on publisher
done
ok 3 - Rows inserted by 2PC have committed on subscriber, and extra columns contain local defaults
ok 4 - transaction is committed on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1811900 on publisher
done
ok 5 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1811948 on publisher
done
ok 6 - Rows inserted by 2PC are rolled back, leaving only the original 2 rows
ok 7 - 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_023_twophase_stream_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_023_twophase_stream_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_023_twophase_stream_publisher_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 2556434
### Starting node "subscriber"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_023_twophase_stream_subscriber_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/023_twophase_stream_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 51052940
Waiting for replication conn tap_sub's replay_lsn to pass 0/1985DE0 on publisher
done
ok 8 - Rows inserted by 2PC have committed on subscriber, and extra columns contain local defaults
Waiting for replication conn tap_sub's replay_lsn to pass 0/1B2CE30 on publisher
done
ok 9 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1B2CF30 on publisher
done
ok 10 - check the outside insert was copied to subscriber
ok 11 - transaction is aborted on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1CA0A08 on publisher
done
ok 12 - transaction is prepared on subscriber
Waiting for replication conn tap_sub's replay_lsn to pass 0/1CA0B08 on publisher
done
ok 13 - Rows inserted by 2PC (as well as outside insert) have committed on subscriber, and extra columns contain local defaults
ok 14 - transaction is committed on subscriber
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub" on publisher
#### End standard error
ok 15 - check subscription was dropped on subscriber
ok 16 - check replication slot was dropped on publisher
ok 17 - check subscription relation status was dropped on subscriber
ok 18 - 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_023_twophase_stream_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_023_twophase_stream_publisher_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "publisher"
1..18
