003_corruption_master.log

application/octet-stream

Filename: 003_corruption_master.log
Type: application/octet-stream
Part: 0
Message: Re: backup manifests
2020-03-24 09:04:37.175 IST [7428] LOG:  starting PostgreSQL 13devel, compiled by Visual C++ build 1915, 64-bit
2020-03-24 09:04:37.179 IST [7428] LOG:  listening on IPv4 address "127.0.0.1", port 55000
2020-03-24 09:04:37.349 IST [6464] LOG:  database system was shut down at 2020-03-24 09:04:36 IST
2020-03-24 09:04:37.373 IST [7428] LOG:  database system is ready to accept connections
2020-03-24 09:04:37.612 IST [7916] 003_corruption.pl LOG:  statement: CREATE TABLE x1 (a int);
2020-03-24 09:04:37.673 IST [7916] 003_corruption.pl LOG:  statement: INSERT INTO x1 VALUES (111);
2020-03-24 09:04:37.675 IST [7916] 003_corruption.pl LOG:  statement: CREATE TABLESPACE ts1 LOCATION 'E:\WorkSpace\PostgreSQL\master\postgresql\src\bin\pg_validatebackup\tmp_check\tmp_test_rQQI';
2020-03-24 09:04:37.686 IST [7916] 003_corruption.pl LOG:  statement: CREATE TABLE x2 (a int) TABLESPACE ts1;
2020-03-24 09:04:37.695 IST [7916] 003_corruption.pl LOG:  statement: INSERT INTO x1 VALUES (222);
2020-03-24 09:04:37.902 IST [4968] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:04:37.903 IST [4968] 003_corruption.pl LOG:  received replication command: SHOW wal_segment_size
2020-03-24 09:04:37.904 IST [4968] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:04:37.904 IST [4968] 003_corruption.pl LOG:  received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' PROGRESS   NOWAIT    MANIFEST 'yes' 
2020-03-24 09:04:41.919 IST [380] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:04:41.919 IST [380] 003_corruption.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_380" TEMPORARY PHYSICAL RESERVE_WAL
2020-03-24 09:04:41.952 IST [380] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:04:41.952 IST [380] 003_corruption.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_380" 0/2000000 TIMELINE 1
2020-03-24 09:04:50.719 IST [3736] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:04:50.720 IST [3736] 003_corruption.pl LOG:  received replication command: SHOW wal_segment_size
2020-03-24 09:04:50.720 IST [3736] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:04:50.721 IST [3736] 003_corruption.pl LOG:  received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' PROGRESS   NOWAIT    MANIFEST 'yes' 
2020-03-24 09:04:50.858 IST [7792] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:04:50.858 IST [7792] 003_corruption.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_7792" TEMPORARY PHYSICAL RESERVE_WAL
2020-03-24 09:04:50.883 IST [7792] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:04:50.883 IST [7792] 003_corruption.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_7792" 0/3000000 TIMELINE 1
2020-03-24 09:05:02.637 IST [3908] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:05:02.639 IST [3908] 003_corruption.pl LOG:  received replication command: SHOW wal_segment_size
2020-03-24 09:05:02.639 IST [3908] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:05:02.639 IST [3908] 003_corruption.pl LOG:  received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' PROGRESS   NOWAIT    MANIFEST 'yes' 
2020-03-24 09:05:02.845 IST [5212] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:05:02.845 IST [5212] 003_corruption.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_5212" TEMPORARY PHYSICAL RESERVE_WAL
2020-03-24 09:05:02.866 IST [5212] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:05:02.866 IST [5212] 003_corruption.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_5212" 0/5000000 TIMELINE 1
2020-03-24 09:05:16.883 IST [7196] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:05:16.885 IST [7196] 003_corruption.pl LOG:  received replication command: SHOW wal_segment_size
2020-03-24 09:05:16.885 IST [7196] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:05:16.885 IST [7196] 003_corruption.pl LOG:  received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' PROGRESS   NOWAIT    MANIFEST 'yes' 
2020-03-24 09:05:17.048 IST [5740] 003_corruption.pl LOG:  received replication command: SHOW data_directory_mode
2020-03-24 09:05:17.048 IST [5740] 003_corruption.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_5740" TEMPORARY PHYSICAL RESERVE_WAL
2020-03-24 09:05:17.066 IST [5740] 003_corruption.pl LOG:  received replication command: IDENTIFY_SYSTEM
2020-03-24 09:05:17.066 IST [5740] 003_corruption.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_5740" 0/6000000 TIMELINE 1
2020-03-24 09:05:30.648 IST [7428] LOG:  received immediate shutdown request
2020-03-24 09:05:30.653 IST [5644] WARNING:  terminating connection because of crash of another server process
2020-03-24 09:05:30.653 IST [5644] DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2020-03-24 09:05:30.653 IST [5644] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-03-24 09:05:30.685 IST [7428] LOG:  database system is shut down