# Checking port 51729
# Found port 51729
Name: primary_local
Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/archives
Connection string: port=51729 host=/tmp/4vlv3xfyty
Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_primary_local.log
[00:24:50.790](0.055s) # initializing database system by copying initdb template
# Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata --create-role rewind_user
### Starting node "primary_local"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_primary_local.log -o --cluster-name=primary_local start
waiting for server to start.... done
server started
# Postmaster PID for node "primary_local" is 46030
#### Begin standard error
psql:<stdin>:2: WARNING:  roles created by regression test cases should have names starting with "regress_"
#### End standard error
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLESPACE space_test LOCATION ''
WARNING:  tablespaces created by regression test cases should have names starting with "regress_"
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLE space_tbl (d text) TABLESPACE space_test
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO space_tbl VALUES ('in primary, before promotion')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLE tbl1 (d text)
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO tbl1 VALUES ('in primary')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLE trunc_tbl (d text)
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO trunc_tbl VALUES ('in primary')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLE tail_tbl (id integer, d text)
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO tail_tbl VALUES (0, 'in primary')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CREATE TABLE drop_tbl (d text)
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO drop_tbl VALUES ('in primary')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CHECKPOINT
# Checking port 51730
# Found port 51730
Name: standby_local
Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/archives
Connection string: port=51730 host=/tmp/4vlv3xfyty
Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log
# Taking pg_basebackup my_backup from node "primary_local"
# Running: pg_basebackup -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/backup/my_backup -h /tmp/4vlv3xfyty -p 51729 --checkpoint fast --no-sync
# Backup finished
# Initializing node "standby_local" from backup "my_backup" of node "primary_local"
### Starting node "standby_local"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/log/001_basic_standby_local.log -o --cluster-name=standby_local start
waiting for server to start.... done
server started
# Postmaster PID for node "standby_local" is 46158
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO tbl1 values ('in primary, before promotion')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO trunc_tbl values ('in primary, before promotion')
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c INSERT INTO tail_tbl SELECT g, 'in primary, before promotion: ' || g FROM generate_series(1, 10000) g
WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
# Running: psql -q --no-psqlrc -d port=51729 host=/tmp/4vlv3xfyty dbname='postgres' -c CHECKPOINT
Waiting for replication conn standby_local's write_lsn to pass 0/30EB438 on primary_local
[00:28:33.709](222.919s) # poll_query_until timed out executing this query:
# SELECT '0/30EB438' <= write_lsn AND state = 'streaming'
#          FROM pg_catalog.pg_stat_replication
#          WHERE application_name IN ('standby_local', 'walreceiver')
# expecting this output:
# t
# last actual query output:
# t
# with stderr:
# WARNING:  outfuncs/readfuncs failed to produce an equal rewritten parse tree
timed out waiting for catchup at /tmp/cirrus-ci-build/src/bin/pg_rewind/t/RewindTest.pm line 196.
# Postmaster PID for node "primary_local" is 46030
### Stopping node "primary_local" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_primary_local_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "primary_local"
# Postmaster PID for node "standby_local" is 46158
### Stopping node "standby_local" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/001_basic/data/t_001_basic_standby_local_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "standby_local"