regress_log_021_row_visibility

text/plain

Filename: regress_log_021_row_visibility
Type: text/plain
Part: 2
Message: Re: buildfarm windows checks / tap tests on windows
# Checking port 57417
# Found port 57417
Name: primary
Data directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata
Backup directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/backup
Archive directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/archives
Connection string: port=57417 host=127.0.0.1
Log file: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_primary.log
# Running: initdb -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -A trust -N
The files belonging to this database system will be owned by user "IEUser".
This user must also own the server process.

The database cluster will be initialized with locale "English_United States.1252".
The default database encoding has accordingly been set to "WIN1252".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... windows
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... US/Pacific
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 C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -l logfile start

# Running: C:/Users/IEUser/git/postgres/Release/pg_regress/pg_regress --config-auth C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata
### Starting node "primary"
# Running: pg_ctl -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/pgdata -l C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_primary.log -o --cluster-name=primary start
waiting for server to start.... done
server started
# Postmaster PID for node "primary" is 3428
# Taking pg_basebackup my_backup from node "primary"
# Running: pg_basebackup -D C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_primary_data/backup/my_backup -h 127.0.0.1 -p 57417 --checkpoint fast --no-sync
# Backup finished
# Checking port 57418
# Found port 57418
Name: standby
Data directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/pgdata
Backup directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/backup
Archive directory: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/archives
Connection string: port=57418 host=127.0.0.1
Log file: C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_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 C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/t_021_row_visibility_standby_data/pgdata -l C:/Users/IEUser/git/postgres/src/test/recovery/tmp_check/log/021_row_visibility_standby.log -o --cluster-name=standby start
waiting for server to start.... done
server started
# Postmaster PID for node "standby" is 3144
ok 1 - data not visible
Waiting for replication conn standby's replay_lsn to pass '0/3002640' on primary
done
ok 2 - insert visible
ok 3 - UPDATE
541
Waiting for replication conn standby's replay_lsn to pass '0/30026B8' on primary
done
ok 4 - uncommitted update invisible
ok 5 - COMMIT
Waiting for replication conn standby's replay_lsn to pass '0/30026E0' on primary
done
ok 6 - committed update visible
ok 7 - prepared will_commit
ok 8 - prepared will_abort
Waiting for replication conn standby's replay_lsn to pass '0/30029E0' on primary
done
ok 9 - uncommitted prepared invisible
Waiting for replication conn standby's replay_lsn to pass '0/3002A40' on primary
done
ok 10 - finished prepared visible
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)
Terminating on signal SIGBREAK(21)