regress_log_025_stuck_on_old_timeline
application/octet-stream
Filename: regress_log_025_stuck_on_old_timeline
Type: application/octet-stream
Part: 3
Message:
Re: Race condition in recovery?
# Checking port 50636
# Found port 50636
Name: primary
Data directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata
Backup directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/backup
Archive directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/archives
Connection string: port=50636 host=/var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK
Log file: /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_primary.log
# Running: initdb -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "rhaas".
This user must also own the server process.
The database cluster will be initialized with locales
COLLATE: en_US.UTF-8
CTYPE: en_US.UTF-8
MESSAGES: C
MONETARY: en_US.UTF-8
NUMERIC: en_US.UTF-8
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 /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_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 ... America/New_York
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 /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata -l logfile start
# Running: /Users/rhaas/pgsql/src/test/recovery/../../../src/test/regress/pg_regress --config-auth /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata
### Enabling WAL archiving for node "primary"
### Starting node "primary"
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata -l /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 47734
# Taking pg_basebackup my_backup from node "primary"
# Running: pg_basebackup -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/backup/my_backup -h /var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK -p 50636 --checkpoint fast --no-sync
# Backup finished
# Checking port 50637
# Found port 50637
Name: standby
Data directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/pgdata
Backup directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/backup
Archive directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/archives
Connection string: port=50637 host=/var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK
Log file: /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_standby.log
# Initializing node "standby" from backup "my_backup" of node "primary"
### Enabling streaming replication for node "standby"
### Starting node "standby"
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/pgdata -l /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_standby.log -o --cluster-name=standby start
waiting for server to start.... done
server started
# Postmaster PID for node "standby" is 47753
# Taking pg_basebackup my_backup from node "standby"
# Running: pg_basebackup -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/backup/my_backup -h /var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK -p 50637 --checkpoint fast --no-sync -Xnone
NOTICE: WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup
# Backup finished
# Checking port 50638
# Found port 50638
Name: cascade
Data directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_cascade_data/pgdata
Backup directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_cascade_data/backup
Archive directory: /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_cascade_data/archives
Connection string: port=50638 host=/var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK
Log file: /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_cascade.log
# Initializing node "cascade" from backup "my_backup" of node "standby"
### Enabling streaming replication for node "cascade"
### Enabling WAL restore for node "cascade"
t
### Starting node "cascade"
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_cascade_data/pgdata -l /Users/rhaas/pgsql/src/test/recovery/tmp_check/log/025_stuck_on_old_timeline_cascade.log -o --cluster-name=cascade start
waiting for server to start.... done
server started
# Postmaster PID for node "cascade" is 47790
Waiting for replication conn cascade's replay_lsn to pass '0/3000000' on standby
done
error running SQL: 'psql:<stdin>:1: ERROR: relation "tab_int" does not exist
LINE 1: SELECT count(*) FROM tab_int
^'
while running 'psql -XAtq -d port=50638 host=/var/folders/jh/925hn4t97mb_sby_1s37k7dc0000gs/T/sdk3QMgbuK dbname='postgres' -f - -v ON_ERROR_STOP=1' with sql 'SELECT count(*) FROM tab_int' at /Users/rhaas/pgsql/src/test/recovery/../../../src/test/perl/PostgresNode.pm line 1771.
### Stopping node "primary" using mode immediate
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_primary_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "primary"
### Stopping node "standby" using mode immediate
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_standby_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "standby"
### Stopping node "cascade" using mode immediate
# Running: pg_ctl -D /Users/rhaas/pgsql/src/test/recovery/tmp_check/t_025_stuck_on_old_timeline_cascade_data/pgdata -m immediate stop
waiting for server to shut down.... done
server stopped
# No postmaster PID for node "cascade"
# Looks like your test exited with 29 before it could output anything.