# Checking port 58531
# Found port 58531
Name: node_A
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_data/archives
Connection string: port=58531 host=/tmp/CRwqEaZ4tm
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_A.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_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_022_twophase_cascade_node_A_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_022_twophase_cascade_node_A_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_022_twophase_cascade_node_A_data/pgdata
### Starting node "node_A"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_A.log -o --cluster-name=node_A start
waiting for server to start.... done
server started
# Postmaster PID for node "node_A" is 25166286
# Checking port 58532
# Found port 58532
Name: node_B
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_data/archives
Connection string: port=58532 host=/tmp/CRwqEaZ4tm
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_B.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_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_022_twophase_cascade_node_B_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_022_twophase_cascade_node_B_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_022_twophase_cascade_node_B_data/pgdata
### Starting node "node_B"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_B.log -o --cluster-name=node_B start
waiting for server to start.... done
server started
# Postmaster PID for node "node_B" is 50331986
# Checking port 58533
# Found port 58533
Name: node_C
Data directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_data/pgdata
Backup directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_data/backup
Archive directory: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_data/archives
Connection string: port=58533 host=/tmp/CRwqEaZ4tm
Log file: /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_C.log
# Running: initdb -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_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_022_twophase_cascade_node_C_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_022_twophase_cascade_node_C_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_022_twophase_cascade_node_C_data/pgdata
### Starting node "node_C"
# Running: pg_ctl -w -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_data/pgdata -l /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/log/022_twophase_cascade_node_C.log -o --cluster-name=node_C start
waiting for server to start.... done
server started
# Postmaster PID for node "node_C" is 60031326
#### Begin standard error
psql:<stdin>:5: NOTICE:  created replication slot "tap_sub_b" on publisher
#### End standard error
#### Begin standard error
psql:<stdin>:5: NOTICE:  created replication slot "tap_sub_c" on publisher
#### End standard error
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8598 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FAA88 on node_B
done
ok 1 - Cascade setup is complete
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8718 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FAD80 on node_B
done
ok 2 - transaction is prepared on subscriber B
ok 3 - transaction is prepared on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8768 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FB0B8 on node_B
done
ok 4 - Row inserted via 2PC has committed on subscriber B
ok 5 - Row inserted via 2PC has committed on subscriber C
ok 6 - transaction is committed on subscriber B
ok 7 - transaction is committed on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F88E8 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FB238 on node_B
done
ok 8 - transaction is prepared on subscriber B
ok 9 - transaction is prepared on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8938 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FB400 on node_B
done
ok 10 - Row inserted via 2PC is not present on subscriber B
ok 11 - Row inserted via 2PC is not present on subscriber C
ok 12 - transaction is ended on subscriber B
ok 13 - transaction is ended on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8B50 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FB6F0 on node_B
done
ok 14 - transaction is prepared on subscriber B
ok 15 - transaction is prepared on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/14F8B88 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/14FBA28 on node_B
done
ok 16 - transaction is ended on subscriber B
ok 17 - transaction is ended on subscriber C
ok 18 - Rows committed are present on subscriber B
ok 19 - Rows committed are present on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/1673110 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/16DE990 on node_B
done
ok 20 - transaction is prepared on subscriber B
ok 21 - transaction is prepared on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/1673158 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/16DEB58 on node_B
done
ok 22 - Rows inserted by 2PC have committed on subscriber B, and extra columns have local defaults
ok 23 - Rows inserted by 2PC have committed on subscriber C, and extra columns have local defaults
ok 24 - transaction is committed on subscriber B
ok 25 - transaction is committed on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/1818C28 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/174A668 on node_B
done
ok 26 - transaction is prepared on subscriber B
ok 27 - transaction is prepared on subscriber C
Waiting for replication conn tap_sub_B's replay_lsn to pass 0/1818C60 on node_A
done
Waiting for replication conn tap_sub_C's replay_lsn to pass 0/174A9A0 on node_B
done
ok 28 - transaction is ended on subscriber B
ok 29 - transaction is ended on subscriber C
ok 30 - Rows committed are present on subscriber B
ok 31 - Rows committed are present on subscriber B
ok 32 - Rows committed are present on subscriber C
ok 33 - Rows committed are present on subscriber C
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub_c" on publisher
#### End standard error
ok 34 - check subscription was dropped on subscriber node C
ok 35 - check subscription relation status was dropped on subscriber node C
ok 36 - check replication origin was dropped on subscriber node C
ok 37 - check replication slot was dropped on publisher node B
#### Begin standard error
psql:<stdin>:1: NOTICE:  dropped replication slot "tap_sub_b" on publisher
#### End standard error
ok 38 - check subscription was dropped on subscriber node B
ok 39 - check subscription relation status was dropped on subscriber node B
ok 40 - check replication origin was dropped on subscriber node B
ok 41 - check replication slot was dropped on publisher node A
### Stopping node "node_C" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_C_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "node_C"
### Stopping node "node_B" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_B_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "node_B"
### Stopping node "node_A" using mode fast
# Running: pg_ctl -D /home/nm/src/pg/postgresql/src/test/subscription/tmp_check/t_022_twophase_cascade_node_A_data/pgdata -m fast stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "node_A"
1..41
