# Checking port 63652 # Found port 63652 Name: primary1_FILE_COPY Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/archives Connection string: port=63652 host=/tmp/j0wABvPTsG Log file: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/log/033_replay_tsp_drops_primary1_FILE_COPY.log [13:47:49.859](0.012s) # 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/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/pgdata ### Starting node "primary1_FILE_COPY" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/log/033_replay_tsp_drops_primary1_FILE_COPY.log -o --cluster-name=primary1_FILE_COPY start waiting for server to start.... done server started # Postmaster PID for node "primary1_FILE_COPY" is 89502 psql::3: WARNING: tablespaces created by regression test cases should have names starting with "regress_" psql::4: WARNING: tablespaces created by regression test cases should have names starting with "regress_" psql::5: WARNING: tablespaces created by regression test cases should have names starting with "regress_" psql::6: WARNING: tablespaces created by regression test cases should have names starting with "regress_" psql::7: WARNING: databases created by regression test cases should have names including "regression" (slot,0/151B0E8) # Taking pg_basebackup my_backup from node "primary1_FILE_COPY" # Running: pg_basebackup -D /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/backup/my_backup -h /tmp/j0wABvPTsG -p 63652 --checkpoint fast --no-sync # Backup finished # Checking port 63653 # Found port 63653 Name: standby2_FILE_COPY Data directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_standby2_FILE_COPY_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_standby2_FILE_COPY_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_standby2_FILE_COPY_data/archives Connection string: port=63653 host=/tmp/j0wABvPTsG Log file: /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/log/033_replay_tsp_drops_standby2_FILE_COPY.log # Initializing node "standby2_FILE_COPY" from backup "my_backup" of node "primary1_FILE_COPY" ### Enabling streaming replication for node "standby2_FILE_COPY" ### Starting node "standby2_FILE_COPY" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_standby2_FILE_COPY_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/log/033_replay_tsp_drops_standby2_FILE_COPY.log -o --cluster-name=standby2_FILE_COPY start waiting for server to start.... done server started # Postmaster PID for node "standby2_FILE_COPY" is 89554 Waiting for replication conn standby2_FILE_COPY's write_lsn to pass 0/3000000 on primary1_FILE_COPY [13:51:30.856](220.997s) # poll_query_until timed out executing this query: # SELECT '0/3000000' <= write_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('standby2_FILE_COPY', '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/test/recovery/t/033_replay_tsp_drops.pl line 44. # Postmaster PID for node "primary1_FILE_COPY" is 89502 ### Stopping node "primary1_FILE_COPY" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_primary1_FILE_COPY_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "primary1_FILE_COPY" # Postmaster PID for node "standby2_FILE_COPY" is 89554 ### Stopping node "standby2_FILE_COPY" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/recovery/033_replay_tsp_drops/data/t_033_replay_tsp_drops_standby2_FILE_COPY_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby2_FILE_COPY"