2024-05-16 15:12:01.591 GMT [5784][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:01.598 GMT [5784][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:01.670 GMT [3652][startup] LOG: database system was shut down at 2024-05-16 15:09:57 GMT 2024-05-16 15:12:01.690 GMT [5784][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:01.904 GMT [4676][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:01.906 GMT [4676][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:01.906 GMT [4676][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:01.919 GMT [4676][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: CREATE TABLE moved (id int); 2024-05-16 15:12:01.923 GMT [4676][client backend] [018_wal_optimize.pl][0/3:0] LOG: statement: INSERT INTO moved VALUES (1); 2024-05-16 15:12:01.924 GMT [4676][client backend] [018_wal_optimize.pl][0/4:0] LOG: statement: CREATE TABLESPACE other LOCATION 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/tablespace_other'; 2024-05-16 15:12:01.925 GMT [4676][client backend] [018_wal_optimize.pl][0/5:0] LOG: statement: BEGIN; 2024-05-16 15:12:01.925 GMT [4676][client backend] [018_wal_optimize.pl][0/5:0] LOG: statement: ALTER TABLE moved SET TABLESPACE other; 2024-05-16 15:12:01.930 GMT [4676][client backend] [018_wal_optimize.pl][0/5:741] LOG: statement: CREATE TABLE originated (id int); 2024-05-16 15:12:01.931 GMT [4676][client backend] [018_wal_optimize.pl][0/5:741] LOG: statement: INSERT INTO originated VALUES (1); 2024-05-16 15:12:01.931 GMT [4676][client backend] [018_wal_optimize.pl][0/5:741] LOG: statement: CREATE UNIQUE INDEX ON originated(id) TABLESPACE other; 2024-05-16 15:12:01.934 GMT [4676][client backend] [018_wal_optimize.pl][0/5:741] LOG: statement: COMMIT; 2024-05-16 15:12:01.935 GMT [4676][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:02.019 GMT [5784][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:02.034 GMT [5784][postmaster] LOG: database system is shut down 2024-05-16 15:12:02.320 GMT [396][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:02.322 GMT [396][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:02.363 GMT [6132][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:01 GMT 2024-05-16 15:12:02.364 GMT [6132][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:02.375 GMT [6132][startup] LOG: redo starts at 0/14F8A60 2024-05-16 15:12:02.383 GMT [6132][startup] LOG: invalid record length at 0/151A100: expected at least 24, got 0 2024-05-16 15:12:02.383 GMT [6132][startup] LOG: redo done at 0/1519E30 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:02.386 GMT [6344][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:02.392 GMT [6344][checkpointer] LOG: checkpoint complete: wrote 41 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=133 kB, estimate=133 kB; lsn=0/151A100, redo lsn=0/151A100 2024-05-16 15:12:02.457 GMT [396][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:02.745 GMT [856][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:02.747 GMT [856][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:02.747 GMT [856][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:02.801 GMT [856][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM moved; 2024-05-16 15:12:02.829 GMT [856][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.087 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:03.182 GMT [5284][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:03.184 GMT [5284][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:03.184 GMT [5284][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:03.187 GMT [5284][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: INSERT INTO originated VALUES (1) ON CONFLICT (id) DO UPDATE set id = originated.id + 1 RETURNING id; 2024-05-16 15:12:03.191 GMT [5284][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:03.515 GMT [4544][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:03.516 GMT [4544][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:03.516 GMT [4544][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:03.526 GMT [4544][client backend] [018_wal_optimize.pl][2/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:03.527 GMT [4544][client backend] [018_wal_optimize.pl][2/2:0] LOG: statement: CREATE TABLE trunc (id serial PRIMARY KEY); 2024-05-16 15:12:03.582 GMT [4544][client backend] [018_wal_optimize.pl][2/2:743] LOG: statement: TRUNCATE trunc; 2024-05-16 15:12:03.583 GMT [4544][client backend] [018_wal_optimize.pl][2/2:743] LOG: statement: COMMIT; 2024-05-16 15:12:03.584 GMT [4544][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.078 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:03.754 GMT [396][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:03.841 GMT [396][postmaster] LOG: database system is shut down 2024-05-16 15:12:04.200 GMT [3984][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:04.202 GMT [3984][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:04.294 GMT [672][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:02 GMT 2024-05-16 15:12:04.295 GMT [672][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:04.301 GMT [672][startup] LOG: redo starts at 0/151A178 2024-05-16 15:12:04.327 GMT [672][startup] LOG: invalid record length at 0/153FAF0: expected at least 24, got 0 2024-05-16 15:12:04.327 GMT [672][startup] LOG: redo done at 0/153F678 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.02 s 2024-05-16 15:12:04.331 GMT [6112][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:04.347 GMT [6112][checkpointer] LOG: checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.014 s, sync=0.001 s, total=0.017 s; sync files=0, longest=0.000 s, average=0.000 s; distance=150 kB, estimate=150 kB; lsn=0/153FAF0, redo lsn=0/153FAF0 2024-05-16 15:12:04.375 GMT [3984][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:04.525 GMT [3136][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:04.527 GMT [3136][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:04.527 GMT [3136][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:04.543 GMT [3136][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM trunc; 2024-05-16 15:12:04.548 GMT [3136][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:04.738 GMT [2320][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:04.740 GMT [2320][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:04.740 GMT [2320][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:04.743 GMT [2320][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:04.743 GMT [2320][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE trunc_ins (id serial PRIMARY KEY); 2024-05-16 15:12:04.759 GMT [2320][client backend] [018_wal_optimize.pl][1/2:744] LOG: statement: INSERT INTO trunc_ins VALUES (DEFAULT); 2024-05-16 15:12:04.759 GMT [2320][client backend] [018_wal_optimize.pl][1/2:744] LOG: statement: TRUNCATE trunc_ins; 2024-05-16 15:12:04.761 GMT [2320][client backend] [018_wal_optimize.pl][1/2:744] LOG: statement: INSERT INTO trunc_ins VALUES (DEFAULT); 2024-05-16 15:12:04.761 GMT [2320][client backend] [018_wal_optimize.pl][1/2:744] LOG: statement: COMMIT; 2024-05-16 15:12:04.761 GMT [2320][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.026 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:05.083 GMT [3984][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:05.107 GMT [3984][postmaster] LOG: database system is shut down 2024-05-16 15:12:05.614 GMT [1376][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:05.616 GMT [1376][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:05.686 GMT [6284][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:04 GMT 2024-05-16 15:12:05.686 GMT [6284][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:05.692 GMT [6284][startup] LOG: redo starts at 0/153FB68 2024-05-16 15:12:05.707 GMT [6284][startup] LOG: invalid record length at 0/1568D60: expected at least 24, got 0 2024-05-16 15:12:05.707 GMT [6284][startup] LOG: redo done at 0/15688E8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s 2024-05-16 15:12:05.715 GMT [1944][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:05.720 GMT [1944][checkpointer] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=164 kB, estimate=164 kB; lsn=0/1568D60, redo lsn=0/1568D60 2024-05-16 15:12:05.857 GMT [1376][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:06.042 GMT [4920][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:06.043 GMT [4920][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:06.043 GMT [4920][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:06.062 GMT [4920][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*), min(id) FROM trunc_ins; 2024-05-16 15:12:06.068 GMT [4920][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:06.155 GMT [7040][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:06.156 GMT [7040][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:06.156 GMT [7040][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:06.167 GMT [7040][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:06.167 GMT [7040][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE twophase (id serial PRIMARY KEY); 2024-05-16 15:12:06.182 GMT [7040][client backend] [018_wal_optimize.pl][1/2:745] LOG: statement: INSERT INTO twophase VALUES (DEFAULT); 2024-05-16 15:12:06.183 GMT [7040][client backend] [018_wal_optimize.pl][1/2:745] LOG: statement: TRUNCATE twophase; 2024-05-16 15:12:06.185 GMT [7040][client backend] [018_wal_optimize.pl][1/2:745] LOG: statement: INSERT INTO twophase VALUES (DEFAULT); 2024-05-16 15:12:06.185 GMT [7040][client backend] [018_wal_optimize.pl][1/2:745] LOG: statement: PREPARE TRANSACTION 't'; 2024-05-16 15:12:06.186 GMT [7040][client backend] [018_wal_optimize.pl][1/3:0] LOG: statement: COMMIT PREPARED 't'; 2024-05-16 15:12:06.187 GMT [7040][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:06.288 GMT [1376][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:06.305 GMT [1376][postmaster] LOG: database system is shut down 2024-05-16 15:12:06.702 GMT [6888][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:06.703 GMT [6888][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:06.771 GMT [1136][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:05 GMT 2024-05-16 15:12:06.772 GMT [1136][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:06.776 GMT [1136][startup] LOG: redo starts at 0/1568DD8 2024-05-16 15:12:06.785 GMT [1136][startup] LOG: invalid record length at 0/1596630: expected at least 24, got 0 2024-05-16 15:12:06.785 GMT [1136][startup] LOG: redo done at 0/15961B0 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:06.788 GMT [2632][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:06.793 GMT [2632][checkpointer] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=182 kB, estimate=182 kB; lsn=0/1596630, redo lsn=0/1596630 2024-05-16 15:12:06.828 GMT [6888][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:06.967 GMT [5052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:06.968 GMT [5052][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:06.968 GMT [5052][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:07.012 GMT [5052][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*), min(id) FROM trunc_ins; 2024-05-16 15:12:07.019 GMT [5052][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.055 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:07.153 GMT [2960][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:07.155 GMT [2960][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:07.155 GMT [2960][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:07.157 GMT [2960][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: SET wal_skip_threshold = '1GB'; 2024-05-16 15:12:07.158 GMT [2960][client backend] [018_wal_optimize.pl][1/3:0] LOG: statement: BEGIN; 2024-05-16 15:12:07.158 GMT [2960][client backend] [018_wal_optimize.pl][1/3:0] LOG: statement: CREATE TABLE noskip (id serial PRIMARY KEY); 2024-05-16 15:12:07.171 GMT [2960][client backend] [018_wal_optimize.pl][1/3:746] LOG: statement: INSERT INTO noskip (SELECT FROM generate_series(1, 20000) a) ; 2024-05-16 15:12:07.331 GMT [2960][client backend] [018_wal_optimize.pl][1/3:746] LOG: statement: COMMIT; 2024-05-16 15:12:07.332 GMT [2960][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.181 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:07.386 GMT [6888][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:07.415 GMT [6888][postmaster] LOG: database system is shut down 2024-05-16 15:12:07.916 GMT [4756][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:07.917 GMT [4756][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:07.955 GMT [4496][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:06 GMT 2024-05-16 15:12:07.955 GMT [4496][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:07.959 GMT [4496][startup] LOG: redo starts at 0/15966A8 2024-05-16 15:12:08.017 GMT [4496][startup] LOG: invalid record length at 0/184A910: expected at least 24, got 0 2024-05-16 15:12:08.017 GMT [4496][startup] LOG: redo done at 0/184A4B8 system usage: CPU: user: 0.03 s, system: 0.03 s, elapsed: 0.05 s 2024-05-16 15:12:08.021 GMT [5224][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:08.026 GMT [5224][checkpointer] LOG: checkpoint complete: wrote 185 buffers (1.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=2768 kB, estimate=2768 kB; lsn=0/184A910, redo lsn=0/184A910 2024-05-16 15:12:08.036 GMT [4756][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:08.261 GMT [5084][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:08.262 GMT [5084][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:08.262 GMT [5084][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:08.277 GMT [5084][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM noskip; 2024-05-16 15:12:08.287 GMT [5084][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:08.395 GMT [5776][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:08.405 GMT [5776][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:08.405 GMT [5776][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:08.415 GMT [5776][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:08.416 GMT [5776][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE ins_trunc (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:08.424 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: INSERT INTO ins_trunc VALUES (DEFAULT, generate_series(1,10000)); 2024-05-16 15:12:08.502 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: TRUNCATE ins_trunc; 2024-05-16 15:12:08.505 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: INSERT INTO ins_trunc (id, id2) VALUES (DEFAULT, 10000); 2024-05-16 15:12:08.512 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: COPY ins_trunc FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:08.512 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: INSERT INTO ins_trunc (id, id2) VALUES (DEFAULT, 10000); 2024-05-16 15:12:08.513 GMT [5776][client backend] [018_wal_optimize.pl][1/2:747] LOG: statement: COMMIT; 2024-05-16 15:12:08.513 GMT [5776][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.126 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:08.599 GMT [4756][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:08.658 GMT [4756][postmaster] LOG: database system is shut down 2024-05-16 15:12:09.084 GMT [5592][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:09.086 GMT [5592][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:09.127 GMT [6232][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:08 GMT 2024-05-16 15:12:09.128 GMT [6232][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:09.134 GMT [6232][startup] LOG: redo starts at 0/184A988 2024-05-16 15:12:09.171 GMT [6232][startup] LOG: invalid record length at 0/1A6C1B0: expected at least 24, got 0 2024-05-16 15:12:09.171 GMT [6232][startup] LOG: redo done at 0/1A6BD00 system usage: CPU: user: 0.03 s, system: 0.00 s, elapsed: 0.03 s 2024-05-16 15:12:09.179 GMT [5144][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:09.184 GMT [5144][checkpointer] LOG: checkpoint complete: wrote 131 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=2182 kB, estimate=2182 kB; lsn=0/1A6C1B0, redo lsn=0/1A6C1B0 2024-05-16 15:12:09.204 GMT [5592][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:09.350 GMT [6092][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:09.351 GMT [6092][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:09.351 GMT [6092][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:09.363 GMT [6092][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM ins_trunc; 2024-05-16 15:12:09.371 GMT [6092][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:09.543 GMT [2816][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:09.548 GMT [2816][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:09.548 GMT [2816][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:09.551 GMT [2816][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:09.551 GMT [2816][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE trunc_copy (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:09.559 GMT [2816][client backend] [018_wal_optimize.pl][1/2:748] LOG: statement: INSERT INTO trunc_copy VALUES (DEFAULT, generate_series(1,3000)); 2024-05-16 15:12:09.583 GMT [2816][client backend] [018_wal_optimize.pl][1/2:748] LOG: statement: TRUNCATE trunc_copy; 2024-05-16 15:12:09.585 GMT [2816][client backend] [018_wal_optimize.pl][1/2:748] LOG: statement: COPY trunc_copy FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:09.586 GMT [2816][client backend] [018_wal_optimize.pl][1/2:748] LOG: statement: COMMIT; 2024-05-16 15:12:09.586 GMT [2816][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.046 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:09.690 GMT [5592][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:09.731 GMT [5592][postmaster] LOG: database system is shut down 2024-05-16 15:12:10.181 GMT [3924][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:10.184 GMT [3924][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:10.244 GMT [4408][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:09 GMT 2024-05-16 15:12:10.245 GMT [4408][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:10.249 GMT [4408][startup] LOG: redo starts at 0/1A6C228 2024-05-16 15:12:10.264 GMT [4408][startup] LOG: invalid record length at 0/1AFD6B8: expected at least 24, got 0 2024-05-16 15:12:10.264 GMT [4408][startup] LOG: redo done at 0/1AFD220 system usage: CPU: user: 0.00 s, system: 0.01 s, elapsed: 0.01 s 2024-05-16 15:12:10.268 GMT [4956][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:10.274 GMT [4956][checkpointer] LOG: checkpoint complete: wrote 46 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=581 kB, estimate=581 kB; lsn=0/1AFD6B8, redo lsn=0/1AFD6B8 2024-05-16 15:12:10.305 GMT [3924][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:10.429 GMT [3972][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:10.430 GMT [3972][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:10.430 GMT [3972][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:10.464 GMT [3972][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM trunc_copy; 2024-05-16 15:12:10.474 GMT [3972][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:10.693 GMT [4744][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:10.697 GMT [4744][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:10.697 GMT [4744][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:10.700 GMT [4744][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:10.700 GMT [4744][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE spc_abort (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:10.708 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: INSERT INTO spc_abort VALUES (DEFAULT, generate_series(1,3000)); 2024-05-16 15:12:10.731 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: TRUNCATE spc_abort; 2024-05-16 15:12:10.737 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: SAVEPOINT s; 2024-05-16 15:12:10.737 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: ALTER TABLE spc_abort SET TABLESPACE other; 2024-05-16 15:12:10.741 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: ROLLBACK TO s; 2024-05-16 15:12:10.742 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: COPY spc_abort FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:10.743 GMT [4744][client backend] [018_wal_optimize.pl][1/2:749] LOG: statement: COMMIT; 2024-05-16 15:12:10.744 GMT [4744][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.054 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:10.895 GMT [3924][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:10.938 GMT [3924][postmaster] LOG: database system is shut down 2024-05-16 15:12:11.329 GMT [5460][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:11.331 GMT [5460][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:11.435 GMT [5552][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:10 GMT 2024-05-16 15:12:11.435 GMT [5552][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:11.439 GMT [5552][startup] LOG: redo starts at 0/1AFD730 2024-05-16 15:12:11.459 GMT [5552][startup] LOG: invalid record length at 0/1B8A650: expected at least 24, got 0 2024-05-16 15:12:11.459 GMT [5552][startup] LOG: redo done at 0/1B8A1B0 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.02 s 2024-05-16 15:12:11.462 GMT [6716][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:11.471 GMT [6716][checkpointer] LOG: checkpoint complete: wrote 41 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.001 s, total=0.009 s; sync files=0, longest=0.000 s, average=0.000 s; distance=563 kB, estimate=563 kB; lsn=0/1B8A650, redo lsn=0/1B8A650 2024-05-16 15:12:11.488 GMT [5460][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:11.634 GMT [2912][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:11.635 GMT [2912][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:11.635 GMT [2912][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:11.682 GMT [2912][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM spc_abort; 2024-05-16 15:12:11.691 GMT [2912][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.060 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:11.828 GMT [2264][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:11.830 GMT [2264][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:11.830 GMT [2264][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:11.832 GMT [2264][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:11.833 GMT [2264][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE spc_commit (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:11.842 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: INSERT INTO spc_commit VALUES (DEFAULT, generate_series(1,3000)); 2024-05-16 15:12:11.869 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: TRUNCATE spc_commit; 2024-05-16 15:12:11.871 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: SAVEPOINT s; 2024-05-16 15:12:11.872 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: ALTER TABLE spc_commit SET TABLESPACE other; 2024-05-16 15:12:11.875 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: RELEASE s; 2024-05-16 15:12:11.875 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: COPY spc_commit FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:11.876 GMT [2264][client backend] [018_wal_optimize.pl][1/2:752] LOG: statement: COMMIT; 2024-05-16 15:12:11.877 GMT [2264][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.052 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:11.955 GMT [5460][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:12.034 GMT [5460][postmaster] LOG: database system is shut down 2024-05-16 15:12:12.428 GMT [4052][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:12.430 GMT [4052][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:12.466 GMT [4924][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:11 GMT 2024-05-16 15:12:12.467 GMT [4924][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:12.471 GMT [4924][startup] LOG: redo starts at 0/1B8A6C8 2024-05-16 15:12:12.489 GMT [4924][startup] LOG: invalid record length at 0/1C17178: expected at least 24, got 0 2024-05-16 15:12:12.489 GMT [4924][startup] LOG: redo done at 0/1C16C98 system usage: CPU: user: 0.01 s, system: 0.00 s, elapsed: 0.01 s 2024-05-16 15:12:12.525 GMT [5440][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:12.532 GMT [5440][checkpointer] LOG: checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=562 kB, estimate=562 kB; lsn=0/1C17178, redo lsn=0/1C17178 2024-05-16 15:12:12.560 GMT [4052][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:12.697 GMT [5912][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:12.698 GMT [5912][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:12.698 GMT [5912][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:12.720 GMT [5912][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM spc_commit; 2024-05-16 15:12:12.729 GMT [5912][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:12.851 GMT [5748][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:12.852 GMT [5748][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:12.852 GMT [5748][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:12.862 GMT [5748][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:12.863 GMT [5748][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE spc_nest (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:12.872 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: INSERT INTO spc_nest VALUES (DEFAULT, generate_series(1,3000)); 2024-05-16 15:12:12.897 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: TRUNCATE spc_nest; 2024-05-16 15:12:12.899 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: SAVEPOINT s; 2024-05-16 15:12:12.900 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: ALTER TABLE spc_nest SET TABLESPACE other; 2024-05-16 15:12:12.904 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: SAVEPOINT s2; 2024-05-16 15:12:12.904 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: ALTER TABLE spc_nest SET TABLESPACE pg_default; 2024-05-16 15:12:12.905 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: ROLLBACK TO s2; 2024-05-16 15:12:12.906 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: SAVEPOINT s2; 2024-05-16 15:12:12.906 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: ALTER TABLE spc_nest SET TABLESPACE pg_default; 2024-05-16 15:12:12.908 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: RELEASE s2; 2024-05-16 15:12:12.908 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: ROLLBACK TO s; 2024-05-16 15:12:12.911 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: COPY spc_nest FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:12.911 GMT [5748][client backend] [018_wal_optimize.pl][1/2:754] LOG: statement: COMMIT; 2024-05-16 15:12:12.912 GMT [5748][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.064 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:13.006 GMT [4052][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:13.031 GMT [4052][postmaster] LOG: database system is shut down 2024-05-16 15:12:13.472 GMT [4300][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:13.473 GMT [4300][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:13.549 GMT [4848][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:12 GMT 2024-05-16 15:12:13.550 GMT [4848][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:13.555 GMT [4848][startup] LOG: redo starts at 0/1C171F0 2024-05-16 15:12:13.596 GMT [4848][startup] LOG: invalid record length at 0/1CADE00: expected at least 24, got 0 2024-05-16 15:12:13.596 GMT [4848][startup] LOG: redo done at 0/1CAD960 system usage: CPU: user: 0.01 s, system: 0.01 s, elapsed: 0.04 s 2024-05-16 15:12:13.599 GMT [1136][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:13.605 GMT [1136][checkpointer] LOG: checkpoint complete: wrote 40 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=603 kB, estimate=603 kB; lsn=0/1CADE00, redo lsn=0/1CADE00 2024-05-16 15:12:13.656 GMT [4300][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:13.967 GMT [3596][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:13.977 GMT [3596][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:13.977 GMT [3596][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:14.033 GMT [3596][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM spc_nest; 2024-05-16 15:12:14.042 GMT [3596][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.079 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:14.788 GMT [6120][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:14.790 GMT [6120][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:14.790 GMT [6120][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:14.794 GMT [6120][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE spc_hint (id int); 2024-05-16 15:12:14.797 GMT [6120][client backend] [018_wal_optimize.pl][1/3:0] LOG: statement: INSERT INTO spc_hint VALUES (1); 2024-05-16 15:12:14.799 GMT [6120][client backend] [018_wal_optimize.pl][1/4:0] LOG: statement: BEGIN; 2024-05-16 15:12:14.799 GMT [6120][client backend] [018_wal_optimize.pl][1/4:0] LOG: statement: ALTER TABLE spc_hint SET TABLESPACE other; 2024-05-16 15:12:14.803 GMT [6120][client backend] [018_wal_optimize.pl][1/4:762] LOG: statement: CHECKPOINT; 2024-05-16 15:12:14.803 GMT [1136][checkpointer] LOG: checkpoint starting: immediate force wait 2024-05-16 15:12:14.815 GMT [1136][checkpointer] LOG: checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.010 s, sync=0.001 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s; distance=128 kB, estimate=555 kB; lsn=0/1CCE028, redo lsn=0/1CCDF88 2024-05-16 15:12:14.816 GMT [6120][client backend] [018_wal_optimize.pl][1/4:762] LOG: statement: SELECT * FROM spc_hint; 2024-05-16 15:12:14.819 GMT [6120][client backend] [018_wal_optimize.pl][1/4:762] LOG: statement: INSERT INTO spc_hint VALUES (2); 2024-05-16 15:12:14.820 GMT [6120][client backend] [018_wal_optimize.pl][1/4:762] LOG: statement: COMMIT; 2024-05-16 15:12:14.821 GMT [6120][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:14.954 GMT [4300][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:15.061 GMT [4300][postmaster] LOG: database system is shut down 2024-05-16 15:12:15.526 GMT [3908][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:15.527 GMT [3908][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:15.716 GMT [2080][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:14 GMT 2024-05-16 15:12:15.717 GMT [2080][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:15.721 GMT [2080][startup] LOG: redo starts at 0/1CCDF88 2024-05-16 15:12:15.724 GMT [2080][startup] LOG: invalid record length at 0/1CCE1C8: expected at least 24, got 0 2024-05-16 15:12:15.724 GMT [2080][startup] LOG: redo done at 0/1CCE150 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:15.727 GMT [1212][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:15.731 GMT [1212][checkpointer] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/1CCE1C8, redo lsn=0/1CCE1C8 2024-05-16 15:12:15.758 GMT [3908][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:15.974 GMT [5616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:15.976 GMT [5616][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:15.976 GMT [5616][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:15.989 GMT [5616][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM spc_hint; 2024-05-16 15:12:15.995 GMT [5616][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.024 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:16.132 GMT [5732][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:16.134 GMT [5732][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:16.134 GMT [5732][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:16.140 GMT [5732][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:16.140 GMT [5732][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE idx_hint (c int PRIMARY KEY); 2024-05-16 15:12:16.147 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: SAVEPOINT q; 2024-05-16 15:12:16.148 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: INSERT INTO idx_hint VALUES (1); 2024-05-16 15:12:16.149 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: ROLLBACK TO q; 2024-05-16 15:12:16.149 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: CHECKPOINT; 2024-05-16 15:12:16.149 GMT [1212][checkpointer] LOG: checkpoint starting: immediate force wait 2024-05-16 15:12:16.154 GMT [1212][checkpointer] LOG: checkpoint complete: wrote 33 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=145 kB, estimate=145 kB; lsn=0/1CF2A00, redo lsn=0/1CF2970 2024-05-16 15:12:16.155 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: INSERT INTO idx_hint VALUES (1); 2024-05-16 15:12:16.156 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: INSERT INTO idx_hint VALUES (2); 2024-05-16 15:12:16.156 GMT [5732][client backend] [018_wal_optimize.pl][1/2:763] LOG: statement: COMMIT; 2024-05-16 15:12:16.156 GMT [5732][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.030 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:16.235 GMT [3908][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:16.276 GMT [3908][postmaster] LOG: database system is shut down 2024-05-16 15:12:16.853 GMT [3060][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:16.854 GMT [3060][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:16.889 GMT [5868][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:16 GMT 2024-05-16 15:12:16.890 GMT [5868][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:16.907 GMT [5868][startup] LOG: redo starts at 0/1CF2970 2024-05-16 15:12:16.907 GMT [5868][startup] LOG: invalid record length at 0/1CF2ED0: expected at least 24, got 0 2024-05-16 15:12:16.907 GMT [5868][startup] LOG: redo done at 0/1CF2C40 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:16.932 GMT [6904][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:16.935 GMT [6904][checkpointer] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1 kB, estimate=1 kB; lsn=0/1CF2ED0, redo lsn=0/1CF2ED0 2024-05-16 15:12:17.000 GMT [3060][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:17.315 GMT [1728][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:17.317 GMT [1728][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:17.317 GMT [1728][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:17.349 GMT [1728][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.037 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:17.481 GMT [4628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:17.482 GMT [4628][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:17.482 GMT [4628][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:17.485 GMT [4628][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: INSERT INTO idx_hint VALUES (2); 2024-05-16 15:12:17.487 GMT [4628][client backend] [018_wal_optimize.pl][1/2:766] ERROR: duplicate key value violates unique constraint "idx_hint_pkey" 2024-05-16 15:12:17.487 GMT [4628][client backend] [018_wal_optimize.pl][1/2:766] DETAIL: Key (c)=(2) already exists. 2024-05-16 15:12:17.487 GMT [4628][client backend] [018_wal_optimize.pl][1/2:766] STATEMENT: INSERT INTO idx_hint VALUES (2); 2024-05-16 15:12:17.499 GMT [4628][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:17.699 GMT [2500][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:17.701 GMT [2500][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:17.701 GMT [2500][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:17.708 GMT [2500][client backend] [018_wal_optimize.pl][2/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:17.708 GMT [2500][client backend] [018_wal_optimize.pl][2/2:0] LOG: statement: CREATE TABLE upd (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:17.719 GMT [2500][client backend] [018_wal_optimize.pl][2/2:767] LOG: statement: INSERT INTO upd (id, id2) VALUES (DEFAULT, generate_series(1,10000)); 2024-05-16 15:12:17.802 GMT [2500][client backend] [018_wal_optimize.pl][2/2:767] LOG: statement: COPY upd FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:17.803 GMT [2500][client backend] [018_wal_optimize.pl][2/2:767] LOG: statement: UPDATE upd SET id2 = id2 + 1; 2024-05-16 15:12:18.042 GMT [2500][client backend] [018_wal_optimize.pl][2/2:767] LOG: statement: DELETE FROM upd; 2024-05-16 15:12:18.059 GMT [2500][client backend] [018_wal_optimize.pl][2/2:767] LOG: statement: COMMIT; 2024-05-16 15:12:18.067 GMT [2500][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.376 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:18.476 GMT [3060][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:18.621 GMT [3060][postmaster] LOG: database system is shut down 2024-05-16 15:12:19.475 GMT [6588][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:19.518 GMT [6588][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:19.731 GMT [6464][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:16 GMT 2024-05-16 15:12:19.732 GMT [6464][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:19.736 GMT [6464][startup] LOG: redo starts at 0/1CF2F48 2024-05-16 15:12:19.830 GMT [6464][startup] LOG: invalid record length at 0/21057B0: expected at least 24, got 0 2024-05-16 15:12:19.830 GMT [6464][startup] LOG: redo done at 0/2105338 system usage: CPU: user: 0.09 s, system: 0.00 s, elapsed: 0.09 s 2024-05-16 15:12:19.833 GMT [5724][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:19.841 GMT [5724][checkpointer] LOG: checkpoint complete: wrote 182 buffers (1.1%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.006 s, sync=0.001 s, total=0.008 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4170 kB, estimate=4170 kB; lsn=0/21057B0, redo lsn=0/21057B0 2024-05-16 15:12:19.878 GMT [6588][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:20.142 GMT [5876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:20.143 GMT [5876][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:20.143 GMT [5876][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:20.157 GMT [5876][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM upd; 2024-05-16 15:12:20.170 GMT [5876][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.031 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:20.420 GMT [3540][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:20.422 GMT [3540][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:20.422 GMT [3540][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:20.427 GMT [3540][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:20.428 GMT [3540][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE ins_copy (id serial PRIMARY KEY, id2 int); 2024-05-16 15:12:20.436 GMT [3540][client backend] [018_wal_optimize.pl][1/2:768] LOG: statement: INSERT INTO ins_copy VALUES (DEFAULT, 1); 2024-05-16 15:12:20.437 GMT [3540][client backend] [018_wal_optimize.pl][1/2:768] LOG: statement: COPY ins_copy FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:20.437 GMT [3540][client backend] [018_wal_optimize.pl][1/2:768] LOG: statement: COMMIT; 2024-05-16 15:12:20.438 GMT [3540][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:20.526 GMT [6588][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:20.564 GMT [6588][postmaster] LOG: database system is shut down 2024-05-16 15:12:20.975 GMT [5328][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:20.977 GMT [5328][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:21.036 GMT [5572][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:19 GMT 2024-05-16 15:12:21.036 GMT [5572][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:21.041 GMT [5572][startup] LOG: redo starts at 0/2105828 2024-05-16 15:12:21.050 GMT [5572][startup] LOG: invalid record length at 0/21EF4E0: expected at least 24, got 0 2024-05-16 15:12:21.050 GMT [5572][startup] LOG: redo done at 0/21EF068 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:21.054 GMT [5292][checkpointer] LOG: checkpoint starting: end-of-recovery immediate wait 2024-05-16 15:12:21.059 GMT [5292][checkpointer] LOG: checkpoint complete: wrote 132 buffers (0.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=935 kB, estimate=935 kB; lsn=0/21EF4E0, redo lsn=0/21EF4E0 2024-05-16 15:12:21.100 GMT [5328][postmaster] LOG: database system is ready to accept connections 2024-05-16 15:12:21.331 GMT [5296][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:21.332 GMT [5296][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:21.332 GMT [5296][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:21.808 GMT [5296][client backend] [018_wal_optimize.pl][0/2:0] LOG: statement: SELECT count(*) FROM ins_copy; 2024-05-16 15:12:21.814 GMT [5296][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.486 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:22.154 GMT [5896][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-05-16 15:12:22.155 GMT [5896][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/recovery/018_wal_optimize/data/t_018_wal_optimize_node_replica_data/pgdata/pg_hba.conf:117) 2024-05-16 15:12:22.155 GMT [5896][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=018_wal_optimize.pl 2024-05-16 15:12:22.159 GMT [5896][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: BEGIN; 2024-05-16 15:12:22.159 GMT [5896][client backend] [018_wal_optimize.pl][1/2:0] LOG: statement: CREATE TABLE ins_trig (id serial PRIMARY KEY, id2 text); 2024-05-16 15:12:22.176 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: CREATE FUNCTION ins_trig_before_row_trig() RETURNS trigger LANGUAGE plpgsql as $$ BEGIN IF new.id2 NOT LIKE 'triggered%' THEN INSERT INTO ins_trig VALUES (DEFAULT, 'triggered row before' || NEW.id2); END IF; RETURN NEW; END; $$; 2024-05-16 15:12:22.178 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: CREATE FUNCTION ins_trig_after_row_trig() RETURNS trigger LANGUAGE plpgsql as $$ BEGIN IF new.id2 NOT LIKE 'triggered%' THEN INSERT INTO ins_trig VALUES (DEFAULT, 'triggered row after' || NEW.id2); END IF; RETURN NEW; END; $$; 2024-05-16 15:12:22.179 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: CREATE TRIGGER ins_trig_before_row_insert BEFORE INSERT ON ins_trig FOR EACH ROW EXECUTE PROCEDURE ins_trig_before_row_trig(); 2024-05-16 15:12:22.183 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: CREATE TRIGGER ins_trig_after_row_insert AFTER INSERT ON ins_trig FOR EACH ROW EXECUTE PROCEDURE ins_trig_after_row_trig(); 2024-05-16 15:12:22.183 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: COPY ins_trig FROM 'C:\cirrus\build/testrun/recovery/018_wal_optimize\data/t_018_wal_optimize_node_replica_data/copy_data.txt' DELIMITER ','; 2024-05-16 15:12:22.186 GMT [5896][client backend] [018_wal_optimize.pl][1/2:769] LOG: statement: COMMIT; 2024-05-16 15:12:22.186 GMT [5896][client backend] [018_wal_optimize.pl][:0] LOG: disconnection: session time: 0:00:00.036 user=SYSTEM database=postgres host=[local] 2024-05-16 15:12:22.318 GMT [5328][postmaster] LOG: received immediate shutdown request 2024-05-16 15:12:22.403 GMT [5328][postmaster] LOG: database system is shut down 2024-05-16 15:12:22.769 GMT [5052][postmaster] LOG: starting PostgreSQL 17devel on x86_64-windows, compiled by msvc-19.29.30151, 64-bit 2024-05-16 15:12:22.771 GMT [5052][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/WLWJeQnwsI/.s.PGSQL.55282" 2024-05-16 15:12:22.817 GMT [4032][startup] LOG: database system was interrupted; last known up at 2024-05-16 15:12:21 GMT 2024-05-16 15:12:22.818 GMT [4032][startup] LOG: database system was not properly shut down; automatic recovery in progress 2024-05-16 15:12:22.821 GMT [5440][not initialized] FATAL: incorrect checksum in control file 2024-05-16 15:12:22.823 GMT [4032][startup] LOG: redo starts at 0/21EF558 2024-05-16 15:12:22.831 GMT [4032][startup] LOG: invalid record length at 0/22236D8: expected at least 24, got 0 2024-05-16 15:12:22.832 GMT [4032][startup] LOG: redo done at 0/2222F10 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-05-16 15:12:22.858 GMT [5052][postmaster] LOG: checkpointer process (PID 5440) exited with exit code 1 2024-05-16 15:12:22.858 GMT [5052][postmaster] LOG: terminating any other active server processes 2024-05-16 15:12:22.878 GMT [5052][postmaster] LOG: shutting down because restart_after_crash is off 2024-05-16 15:12:22.879 GMT [5052][postmaster] LOG: database system is shut down