# Checking port 64530 # Found port 64530 Name: primary_local Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/archives Connection string: port=64530 host=/tmp/1f0_ovHCDi Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/log/002_databases_primary_local.log [00:24:51.334](0.050s) # initializing database system by running initdb # Running: initdb -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/pgdata -A trust -N -g The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: en_US.UTF-8 LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_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 ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... 2024-03-19 00:24:51.730 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.057 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.060 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.062 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.063 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.065 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.066 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.067 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.067 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.068 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.069 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 2024-03-19 00:24:52.184 UTC [46207] WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 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 /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_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/002_databases/data/t_002_databases_primary_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/log/002_databases_primary_local.log -o --cluster-name=primary_local start waiting for server to start.... done server started # Postmaster PID for node "primary_local" is 46350 #### Begin standard error psql::2: WARNING: roles created by regression test cases should have names starting with "regress_" #### End standard error # Running: psql -q --no-psqlrc -d port=64530 host=/tmp/1f0_ovHCDi dbname='postgres' -c CREATE DATABASE inprimary WARNING: databases created by regression test cases should have names including "regression" # Running: psql -q --no-psqlrc -d port=64530 host=/tmp/1f0_ovHCDi dbname='inprimary' -c CREATE TABLE inprimary_tab (a int) # Checking port 64531 # Found port 64531 Name: standby_local Data directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_standby_local_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_standby_local_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_standby_local_data/archives Connection string: port=64531 host=/tmp/1f0_ovHCDi Log file: /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/log/002_databases_standby_local.log # Taking pg_basebackup my_backup from node "primary_local" # Running: pg_basebackup -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_primary_local_data/backup/my_backup -h /tmp/1f0_ovHCDi -p 64530 --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/002_databases/data/t_002_databases_standby_local_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/log/002_databases_standby_local.log -o --cluster-name=standby_local start waiting for server to start.... done server started # Postmaster PID for node "standby_local" is 46415 # Running: psql -q --no-psqlrc -d port=64530 host=/tmp/1f0_ovHCDi dbname='postgres' -c CREATE DATABASE beforepromotion WARNING: databases created by regression test cases should have names including "regression" # Running: psql -q --no-psqlrc -d port=64530 host=/tmp/1f0_ovHCDi dbname='beforepromotion' -c CREATE TABLE beforepromotion_tab (a int) Waiting for replication conn standby_local's write_lsn to pass 0/34439A0 on primary_local [00:28:34.646](223.312s) # poll_query_until timed out executing this query: # SELECT '0/34439A0' <= 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 46350 ### Stopping node "primary_local" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_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 46415 ### Stopping node "standby_local" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_rewind/002_databases/data/t_002_databases_standby_local_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "standby_local"