018_wal_optimize_node_minimal.log

application/octet-stream
Filename: 018_wal_optimize_node_minimal.log
Type: application/octet-stream
Part: 2
Message: RE: [Patch] Optimize dropping of relation buffers using dlist
2020-09-07 06:20:28.011 UTC [10611] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:28.011 UTC [10611] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:28.013 UTC [10612] LOG:  database system was shut down at 2020-09-07 06:20:27 UTC
2020-09-07 06:20:28.016 UTC [10611] LOG:  database system is ready to accept connections
2020-09-07 06:20:28.110 UTC [10620] 018_wal_optimize.pl LOG:  statement: CREATE TABLESPACE other LOCATION '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/tablespace_other';
2020-09-07 06:20:28.120 UTC [10622] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:28.121 UTC [10622] 018_wal_optimize.pl LOG:  statement: CREATE TABLE trunc (id serial PRIMARY KEY);
2020-09-07 06:20:28.127 UTC [10622] 018_wal_optimize.pl LOG:  statement: TRUNCATE trunc;
2020-09-07 06:20:28.128 UTC [10622] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:28.131 UTC [10611] LOG:  received immediate shutdown request
2020-09-07 06:20:28.132 UTC [10616] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:28.132 UTC [10616] 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-09-07 06:20:28.132 UTC [10616] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:28.135 UTC [10611] LOG:  database system is shut down
2020-09-07 06:20:28.253 UTC [10626] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:28.254 UTC [10626] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:28.256 UTC [10627] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:28 UTC
2020-09-07 06:20:28.256 UTC [10627] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:28.257 UTC [10627] LOG:  redo starts at 0/15E2DA0
2020-09-07 06:20:28.264 UTC [10627] LOG:  invalid record length at 0/15FF760: wanted 24, got 0
2020-09-07 06:20:28.264 UTC [10627] LOG:  redo done at 0/15FF738
2020-09-07 06:20:28.268 UTC [10626] LOG:  database system is ready to accept connections
2020-09-07 06:20:28.353 UTC [10635] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM trunc;
2020-09-07 06:20:28.364 UTC [10637] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:28.364 UTC [10637] 018_wal_optimize.pl LOG:  statement: CREATE TABLE trunc_ins (id serial PRIMARY KEY);
2020-09-07 06:20:28.369 UTC [10637] 018_wal_optimize.pl LOG:  statement: INSERT INTO trunc_ins VALUES (DEFAULT);
2020-09-07 06:20:28.369 UTC [10637] 018_wal_optimize.pl LOG:  statement: TRUNCATE trunc_ins;
2020-09-07 06:20:28.370 UTC [10637] 018_wal_optimize.pl LOG:  statement: INSERT INTO trunc_ins VALUES (DEFAULT);
2020-09-07 06:20:28.371 UTC [10637] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:28.373 UTC [10626] LOG:  received immediate shutdown request
2020-09-07 06:20:28.374 UTC [10631] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:28.374 UTC [10631] 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-09-07 06:20:28.374 UTC [10631] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:28.377 UTC [10626] LOG:  database system is shut down
2020-09-07 06:20:28.497 UTC [10641] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:28.497 UTC [10641] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:28.499 UTC [10642] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:28 UTC
2020-09-07 06:20:28.500 UTC [10642] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:28.500 UTC [10642] LOG:  redo starts at 0/15FF7D8
2020-09-07 06:20:28.501 UTC [10642] LOG:  invalid record length at 0/161B8C0: wanted 24, got 0
2020-09-07 06:20:28.501 UTC [10642] LOG:  redo done at 0/161B898
2020-09-07 06:20:28.505 UTC [10641] LOG:  database system is ready to accept connections
2020-09-07 06:20:28.597 UTC [10650] 018_wal_optimize.pl LOG:  statement: SELECT count(*), min(id) FROM trunc_ins;
2020-09-07 06:20:28.608 UTC [10652] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:28.608 UTC [10652] 018_wal_optimize.pl LOG:  statement: CREATE TABLE twophase (id serial PRIMARY KEY);
2020-09-07 06:20:28.613 UTC [10652] 018_wal_optimize.pl LOG:  statement: INSERT INTO twophase VALUES (DEFAULT);
2020-09-07 06:20:28.614 UTC [10652] 018_wal_optimize.pl LOG:  statement: TRUNCATE twophase;
2020-09-07 06:20:28.615 UTC [10652] 018_wal_optimize.pl LOG:  statement: INSERT INTO twophase VALUES (DEFAULT);
2020-09-07 06:20:28.615 UTC [10652] 018_wal_optimize.pl LOG:  statement: PREPARE TRANSACTION 't';
2020-09-07 06:20:28.616 UTC [10652] 018_wal_optimize.pl LOG:  statement: COMMIT PREPARED 't';
2020-09-07 06:20:28.618 UTC [10641] LOG:  received immediate shutdown request
2020-09-07 06:20:28.619 UTC [10646] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:28.619 UTC [10646] 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-09-07 06:20:28.619 UTC [10646] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:28.622 UTC [10641] LOG:  database system is shut down
2020-09-07 06:20:28.740 UTC [10656] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:28.741 UTC [10656] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:28.742 UTC [10657] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:28 UTC
2020-09-07 06:20:28.743 UTC [10657] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:28.743 UTC [10657] LOG:  redo starts at 0/161B938
2020-09-07 06:20:28.744 UTC [10657] LOG:  invalid record length at 0/1640340: wanted 24, got 0
2020-09-07 06:20:28.744 UTC [10657] LOG:  redo done at 0/163FEA8
2020-09-07 06:20:28.748 UTC [10656] LOG:  database system is ready to accept connections
2020-09-07 06:20:28.841 UTC [10665] 018_wal_optimize.pl LOG:  statement: SELECT count(*), min(id) FROM trunc_ins;
2020-09-07 06:20:28.851 UTC [10667] 018_wal_optimize.pl LOG:  statement: SET wal_skip_threshold = '1GB';
2020-09-07 06:20:28.851 UTC [10667] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:28.851 UTC [10667] 018_wal_optimize.pl LOG:  statement: CREATE TABLE noskip (id serial PRIMARY KEY);
2020-09-07 06:20:28.857 UTC [10667] 018_wal_optimize.pl LOG:  statement: INSERT INTO noskip (SELECT FROM generate_series(1, 20000) a) ;
2020-09-07 06:20:28.930 UTC [10667] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:28.935 UTC [10656] LOG:  received immediate shutdown request
2020-09-07 06:20:28.935 UTC [10661] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:28.935 UTC [10661] 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-09-07 06:20:28.935 UTC [10661] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:28.939 UTC [10656] LOG:  database system is shut down
2020-09-07 06:20:29.057 UTC [10672] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:29.057 UTC [10672] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:29.059 UTC [10673] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:28 UTC
2020-09-07 06:20:29.059 UTC [10673] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:29.060 UTC [10673] LOG:  redo starts at 0/16403B8
2020-09-07 06:20:29.063 UTC [10673] LOG:  invalid record length at 0/178E798: wanted 24, got 0
2020-09-07 06:20:29.063 UTC [10673] LOG:  redo done at 0/178E770
2020-09-07 06:20:29.067 UTC [10672] LOG:  database system is ready to accept connections
2020-09-07 06:20:29.157 UTC [10681] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM noskip;
2020-09-07 06:20:29.172 UTC [10683] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:29.172 UTC [10683] 018_wal_optimize.pl LOG:  statement: CREATE TABLE ins_trunc (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:29.178 UTC [10683] 018_wal_optimize.pl LOG:  statement: INSERT INTO ins_trunc VALUES (DEFAULT, generate_series(1,10000));
2020-09-07 06:20:29.213 UTC [10683] 018_wal_optimize.pl LOG:  statement: TRUNCATE ins_trunc;
2020-09-07 06:20:29.215 UTC [10683] 018_wal_optimize.pl LOG:  statement: INSERT INTO ins_trunc (id, id2) VALUES (DEFAULT, 10000);
2020-09-07 06:20:29.215 UTC [10683] 018_wal_optimize.pl LOG:  statement: COPY ins_trunc FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:29.216 UTC [10683] 018_wal_optimize.pl LOG:  statement: INSERT INTO ins_trunc (id, id2) VALUES (DEFAULT, 10000);
2020-09-07 06:20:29.216 UTC [10683] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:29.219 UTC [10672] LOG:  received immediate shutdown request
2020-09-07 06:20:29.220 UTC [10677] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:29.220 UTC [10677] 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-09-07 06:20:29.220 UTC [10677] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:29.224 UTC [10672] LOG:  database system is shut down
2020-09-07 06:20:29.344 UTC [10687] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:29.344 UTC [10687] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:29.346 UTC [10688] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:29 UTC
2020-09-07 06:20:29.347 UTC [10688] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:29.347 UTC [10688] LOG:  redo starts at 0/178E810
2020-09-07 06:20:29.350 UTC [10688] LOG:  invalid record length at 0/185F110: wanted 24, got 0
2020-09-07 06:20:29.350 UTC [10688] LOG:  redo done at 0/185F0E8
2020-09-07 06:20:29.354 UTC [10687] LOG:  database system is ready to accept connections
2020-09-07 06:20:29.443 UTC [10696] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM ins_trunc;
2020-09-07 06:20:29.455 UTC [10698] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:29.455 UTC [10698] 018_wal_optimize.pl LOG:  statement: CREATE TABLE trunc_copy (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:29.461 UTC [10698] 018_wal_optimize.pl LOG:  statement: INSERT INTO trunc_copy VALUES (DEFAULT, generate_series(1,3000));
2020-09-07 06:20:29.472 UTC [10698] 018_wal_optimize.pl LOG:  statement: TRUNCATE trunc_copy;
2020-09-07 06:20:29.474 UTC [10698] 018_wal_optimize.pl LOG:  statement: COPY trunc_copy FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:29.474 UTC [10698] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:29.477 UTC [10687] LOG:  received immediate shutdown request
2020-09-07 06:20:29.478 UTC [10692] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:29.478 UTC [10692] 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-09-07 06:20:29.478 UTC [10692] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:29.482 UTC [10687] LOG:  database system is shut down
2020-09-07 06:20:29.598 UTC [10702] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:29.598 UTC [10702] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:29.600 UTC [10703] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:29 UTC
2020-09-07 06:20:29.601 UTC [10703] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:29.601 UTC [10703] LOG:  redo starts at 0/185F188
2020-09-07 06:20:29.602 UTC [10703] LOG:  invalid record length at 0/1880678: wanted 24, got 0
2020-09-07 06:20:29.602 UTC [10703] LOG:  redo done at 0/1880650
2020-09-07 06:20:29.605 UTC [10702] LOG:  database system is ready to accept connections
2020-09-07 06:20:29.699 UTC [10711] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM trunc_copy;
2020-09-07 06:20:29.709 UTC [10713] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:29.710 UTC [10713] 018_wal_optimize.pl LOG:  statement: CREATE TABLE spc_abort (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:29.715 UTC [10713] 018_wal_optimize.pl LOG:  statement: INSERT INTO spc_abort VALUES (DEFAULT, generate_series(1,3000));
2020-09-07 06:20:29.726 UTC [10713] 018_wal_optimize.pl LOG:  statement: TRUNCATE spc_abort;
2020-09-07 06:20:29.728 UTC [10713] 018_wal_optimize.pl LOG:  statement: SAVEPOINT s;
2020-09-07 06:20:29.728 UTC [10713] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_abort SET TABLESPACE other;
2020-09-07 06:20:29.729 UTC [10713] 018_wal_optimize.pl LOG:  statement: ROLLBACK TO s;
2020-09-07 06:20:29.730 UTC [10713] 018_wal_optimize.pl LOG:  statement: COPY spc_abort FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:29.730 UTC [10713] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:29.733 UTC [10702] LOG:  received immediate shutdown request
2020-09-07 06:20:29.733 UTC [10707] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:29.733 UTC [10707] 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-09-07 06:20:29.733 UTC [10707] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:29.737 UTC [10702] LOG:  database system is shut down
2020-09-07 06:20:29.855 UTC [10717] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:29.855 UTC [10717] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:29.857 UTC [10718] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:29 UTC
2020-09-07 06:20:29.858 UTC [10718] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:29.858 UTC [10718] LOG:  redo starts at 0/18806F0
2020-09-07 06:20:29.859 UTC [10718] LOG:  invalid record length at 0/189DD30: wanted 24, got 0
2020-09-07 06:20:29.859 UTC [10718] LOG:  redo done at 0/189DD00
2020-09-07 06:20:29.863 UTC [10717] LOG:  database system is ready to accept connections
2020-09-07 06:20:29.957 UTC [10726] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM spc_abort;
2020-09-07 06:20:29.967 UTC [10728] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:29.967 UTC [10728] 018_wal_optimize.pl LOG:  statement: CREATE TABLE spc_commit (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:29.972 UTC [10728] 018_wal_optimize.pl LOG:  statement: INSERT INTO spc_commit VALUES (DEFAULT, generate_series(1,3000));
2020-09-07 06:20:29.983 UTC [10728] 018_wal_optimize.pl LOG:  statement: TRUNCATE spc_commit;
2020-09-07 06:20:29.985 UTC [10728] 018_wal_optimize.pl LOG:  statement: SAVEPOINT s;
2020-09-07 06:20:29.986 UTC [10728] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_commit SET TABLESPACE other;
2020-09-07 06:20:29.986 UTC [10728] 018_wal_optimize.pl LOG:  statement: RELEASE s;
2020-09-07 06:20:29.986 UTC [10728] 018_wal_optimize.pl LOG:  statement: COPY spc_commit FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:29.987 UTC [10728] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:29.990 UTC [10717] LOG:  received immediate shutdown request
2020-09-07 06:20:29.990 UTC [10722] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:29.990 UTC [10722] 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-09-07 06:20:29.990 UTC [10722] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:29.994 UTC [10717] LOG:  database system is shut down
2020-09-07 06:20:30.113 UTC [10733] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:30.113 UTC [10733] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:30.115 UTC [10734] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:29 UTC
2020-09-07 06:20:30.116 UTC [10734] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:30.116 UTC [10734] LOG:  redo starts at 0/189DDA8
2020-09-07 06:20:30.118 UTC [10734] LOG:  invalid record length at 0/18C3040: wanted 24, got 0
2020-09-07 06:20:30.118 UTC [10734] LOG:  redo done at 0/18C3000
2020-09-07 06:20:30.121 UTC [10733] LOG:  database system is ready to accept connections
2020-09-07 06:20:30.214 UTC [10742] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM spc_commit;
2020-09-07 06:20:30.225 UTC [10744] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:30.225 UTC [10744] 018_wal_optimize.pl LOG:  statement: CREATE TABLE spc_nest (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:30.231 UTC [10744] 018_wal_optimize.pl LOG:  statement: INSERT INTO spc_nest VALUES (DEFAULT, generate_series(1,3000));
2020-09-07 06:20:30.242 UTC [10744] 018_wal_optimize.pl LOG:  statement: TRUNCATE spc_nest;
2020-09-07 06:20:30.244 UTC [10744] 018_wal_optimize.pl LOG:  statement: SAVEPOINT s;
2020-09-07 06:20:30.244 UTC [10744] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_nest SET TABLESPACE other;
2020-09-07 06:20:30.245 UTC [10744] 018_wal_optimize.pl LOG:  statement: SAVEPOINT s2;
2020-09-07 06:20:30.245 UTC [10744] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_nest SET TABLESPACE pg_default;
2020-09-07 06:20:30.246 UTC [10744] 018_wal_optimize.pl LOG:  statement: ROLLBACK TO s2;
2020-09-07 06:20:30.246 UTC [10744] 018_wal_optimize.pl LOG:  statement: SAVEPOINT s2;
2020-09-07 06:20:30.246 UTC [10744] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_nest SET TABLESPACE pg_default;
2020-09-07 06:20:30.247 UTC [10744] 018_wal_optimize.pl LOG:  statement: RELEASE s2;
2020-09-07 06:20:30.247 UTC [10744] 018_wal_optimize.pl LOG:  statement: ROLLBACK TO s;
2020-09-07 06:20:30.247 UTC [10744] 018_wal_optimize.pl LOG:  statement: COPY spc_nest FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:30.248 UTC [10744] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:30.251 UTC [10733] LOG:  received immediate shutdown request
2020-09-07 06:20:30.251 UTC [10738] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:30.251 UTC [10738] 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-09-07 06:20:30.251 UTC [10738] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:30.255 UTC [10733] LOG:  database system is shut down
2020-09-07 06:20:30.373 UTC [10748] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:30.373 UTC [10748] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:30.375 UTC [10749] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:30 UTC
2020-09-07 06:20:30.375 UTC [10749] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:30.376 UTC [10749] LOG:  redo starts at 0/18C30B8
2020-09-07 06:20:30.378 UTC [10749] LOG:  invalid record length at 0/18E62C8: wanted 24, got 0
2020-09-07 06:20:30.378 UTC [10749] LOG:  redo done at 0/18E6298
2020-09-07 06:20:30.381 UTC [10748] LOG:  database system is ready to accept connections
2020-09-07 06:20:30.473 UTC [10757] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM spc_nest;
2020-09-07 06:20:30.484 UTC [10759] 018_wal_optimize.pl LOG:  statement: CREATE TABLE spc_hint (id int);
2020-09-07 06:20:30.487 UTC [10759] 018_wal_optimize.pl LOG:  statement: INSERT INTO spc_hint VALUES (1);
2020-09-07 06:20:30.488 UTC [10759] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:30.488 UTC [10759] 018_wal_optimize.pl LOG:  statement: ALTER TABLE spc_hint SET TABLESPACE other;
2020-09-07 06:20:30.488 UTC [10759] 018_wal_optimize.pl LOG:  statement: CHECKPOINT;
2020-09-07 06:20:30.490 UTC [10759] 018_wal_optimize.pl LOG:  statement: SELECT * FROM spc_hint;
2020-09-07 06:20:30.491 UTC [10759] 018_wal_optimize.pl LOG:  statement: INSERT INTO spc_hint VALUES (2);
2020-09-07 06:20:30.491 UTC [10759] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:30.494 UTC [10748] LOG:  received immediate shutdown request
2020-09-07 06:20:30.495 UTC [10753] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:30.495 UTC [10753] 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-09-07 06:20:30.495 UTC [10753] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:30.498 UTC [10748] LOG:  database system is shut down
2020-09-07 06:20:30.615 UTC [10763] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:30.616 UTC [10763] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:30.618 UTC [10764] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:30 UTC
2020-09-07 06:20:30.618 UTC [10764] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:30.618 UTC [10764] LOG:  redo starts at 0/18FB0C8
2020-09-07 06:20:30.619 UTC [10764] LOG:  invalid record length at 0/18FB100: wanted 24, got 0
2020-09-07 06:20:30.619 UTC [10764] LOG:  redo done at 0/18FB0C8
2020-09-07 06:20:30.622 UTC [10763] LOG:  database system is ready to accept connections
2020-09-07 06:20:30.716 UTC [10772] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM spc_hint;
2020-09-07 06:20:30.727 UTC [10774] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:30.727 UTC [10774] 018_wal_optimize.pl LOG:  statement: CREATE TABLE idx_hint (c int PRIMARY KEY);
2020-09-07 06:20:30.731 UTC [10774] 018_wal_optimize.pl LOG:  statement: SAVEPOINT q;
2020-09-07 06:20:30.731 UTC [10774] 018_wal_optimize.pl LOG:  statement: INSERT INTO idx_hint VALUES (1);
2020-09-07 06:20:30.731 UTC [10774] 018_wal_optimize.pl LOG:  statement: ROLLBACK TO q;
2020-09-07 06:20:30.732 UTC [10774] 018_wal_optimize.pl LOG:  statement: CHECKPOINT;
2020-09-07 06:20:30.734 UTC [10774] 018_wal_optimize.pl LOG:  statement: INSERT INTO idx_hint VALUES (1);
2020-09-07 06:20:30.734 UTC [10774] 018_wal_optimize.pl LOG:  statement: INSERT INTO idx_hint VALUES (2);
2020-09-07 06:20:30.734 UTC [10774] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:30.737 UTC [10763] LOG:  received immediate shutdown request
2020-09-07 06:20:30.737 UTC [10768] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:30.737 UTC [10768] 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-09-07 06:20:30.737 UTC [10768] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:30.741 UTC [10763] LOG:  database system is shut down
2020-09-07 06:20:30.862 UTC [10778] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:30.862 UTC [10778] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:30.864 UTC [10779] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:30 UTC
2020-09-07 06:20:30.865 UTC [10779] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:30.865 UTC [10779] LOG:  redo starts at 0/19176E8
2020-09-07 06:20:30.865 UTC [10779] LOG:  invalid record length at 0/1917718: wanted 24, got 0
2020-09-07 06:20:30.865 UTC [10779] LOG:  redo done at 0/19176E8
2020-09-07 06:20:30.869 UTC [10778] LOG:  database system is ready to accept connections
2020-09-07 06:20:30.978 UTC [10789] 018_wal_optimize.pl LOG:  statement: INSERT INTO idx_hint VALUES (2);
2020-09-07 06:20:30.980 UTC [10789] 018_wal_optimize.pl ERROR:  duplicate key value violates unique constraint "idx_hint_pkey"
2020-09-07 06:20:30.980 UTC [10789] 018_wal_optimize.pl DETAIL:  Key (c)=(2) already exists.
2020-09-07 06:20:30.980 UTC [10789] 018_wal_optimize.pl STATEMENT:  INSERT INTO idx_hint VALUES (2);
2020-09-07 06:20:30.990 UTC [10791] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:30.990 UTC [10791] 018_wal_optimize.pl LOG:  statement: CREATE TABLE upd (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:30.996 UTC [10791] 018_wal_optimize.pl LOG:  statement: INSERT INTO upd (id, id2) VALUES (DEFAULT, generate_series(1,10000));
2020-09-07 06:20:31.032 UTC [10791] 018_wal_optimize.pl LOG:  statement: COPY upd FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:31.033 UTC [10791] 018_wal_optimize.pl LOG:  statement: UPDATE upd SET id2 = id2 + 1;
2020-09-07 06:20:31.085 UTC [10791] 018_wal_optimize.pl LOG:  statement: DELETE FROM upd;
2020-09-07 06:20:31.092 UTC [10791] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:31.097 UTC [10778] LOG:  received immediate shutdown request
2020-09-07 06:20:31.097 UTC [10783] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:31.097 UTC [10783] 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-09-07 06:20:31.097 UTC [10783] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:31.101 UTC [10778] LOG:  database system is shut down
2020-09-07 06:20:31.221 UTC [10796] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:31.221 UTC [10796] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:31.223 UTC [10797] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:30 UTC
2020-09-07 06:20:31.224 UTC [10797] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:31.224 UTC [10797] LOG:  redo starts at 0/1917790
2020-09-07 06:20:31.225 UTC [10797] LOG:  invalid record length at 0/1935610: wanted 24, got 0
2020-09-07 06:20:31.225 UTC [10797] LOG:  redo done at 0/19355E8
2020-09-07 06:20:31.229 UTC [10796] LOG:  database system is ready to accept connections
2020-09-07 06:20:31.323 UTC [10805] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM upd;
2020-09-07 06:20:31.341 UTC [10807] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:31.341 UTC [10807] 018_wal_optimize.pl LOG:  statement: CREATE TABLE ins_copy (id serial PRIMARY KEY, id2 int);
2020-09-07 06:20:31.347 UTC [10807] 018_wal_optimize.pl LOG:  statement: INSERT INTO ins_copy VALUES (DEFAULT, 1);
2020-09-07 06:20:31.347 UTC [10807] 018_wal_optimize.pl LOG:  statement: COPY ins_copy FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:31.348 UTC [10807] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:31.351 UTC [10796] LOG:  received immediate shutdown request
2020-09-07 06:20:31.352 UTC [10801] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:31.352 UTC [10801] 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-09-07 06:20:31.352 UTC [10801] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:31.356 UTC [10796] LOG:  database system is shut down
2020-09-07 06:20:31.473 UTC [10811] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:31.474 UTC [10811] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:31.476 UTC [10812] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:31 UTC
2020-09-07 06:20:31.476 UTC [10812] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:31.476 UTC [10812] LOG:  redo starts at 0/1935688
2020-09-07 06:20:31.479 UTC [10812] LOG:  invalid record length at 0/1A16FC8: wanted 24, got 0
2020-09-07 06:20:31.479 UTC [10812] LOG:  redo done at 0/1A16FA0
2020-09-07 06:20:31.483 UTC [10811] LOG:  database system is ready to accept connections
2020-09-07 06:20:31.576 UTC [10820] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM ins_copy;
2020-09-07 06:20:31.587 UTC [10822] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:31.588 UTC [10822] 018_wal_optimize.pl LOG:  statement: CREATE TABLE ins_trig (id serial PRIMARY KEY, id2 text);
2020-09-07 06:20:31.594 UTC [10822] 018_wal_optimize.pl 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; $$;
2020-09-07 06:20:31.596 UTC [10822] 018_wal_optimize.pl 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; $$;
2020-09-07 06:20:31.597 UTC [10822] 018_wal_optimize.pl LOG:  statement: CREATE TRIGGER ins_trig_before_row_insert
			  BEFORE INSERT ON ins_trig
			  FOR EACH ROW EXECUTE PROCEDURE ins_trig_before_row_trig();
2020-09-07 06:20:31.598 UTC [10822] 018_wal_optimize.pl LOG:  statement: CREATE TRIGGER ins_trig_after_row_insert
			  AFTER INSERT ON ins_trig
			  FOR EACH ROW EXECUTE PROCEDURE ins_trig_after_row_trig();
2020-09-07 06:20:31.598 UTC [10822] 018_wal_optimize.pl LOG:  statement: COPY ins_trig FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:31.600 UTC [10822] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:31.604 UTC [10811] LOG:  received immediate shutdown request
2020-09-07 06:20:31.605 UTC [10816] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:31.605 UTC [10816] 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-09-07 06:20:31.605 UTC [10816] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:31.609 UTC [10811] LOG:  database system is shut down
2020-09-07 06:20:31.728 UTC [10826] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:31.729 UTC [10826] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:31.731 UTC [10827] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:31 UTC
2020-09-07 06:20:31.731 UTC [10827] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:31.731 UTC [10827] LOG:  redo starts at 0/1A17040
2020-09-07 06:20:31.733 UTC [10827] LOG:  invalid record length at 0/1A531E8: wanted 24, got 0
2020-09-07 06:20:31.733 UTC [10827] LOG:  redo done at 0/1A531C0
2020-09-07 06:20:31.737 UTC [10826] LOG:  database system is ready to accept connections
2020-09-07 06:20:31.828 UTC [10835] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM ins_trig;
2020-09-07 06:20:31.839 UTC [10837] 018_wal_optimize.pl LOG:  statement: BEGIN;
2020-09-07 06:20:31.839 UTC [10837] 018_wal_optimize.pl LOG:  statement: CREATE TABLE trunc_trig (id serial PRIMARY KEY, id2 text);
2020-09-07 06:20:31.845 UTC [10837] 018_wal_optimize.pl LOG:  statement: CREATE FUNCTION trunc_trig_before_stat_trig() RETURNS trigger
			  LANGUAGE plpgsql as $$
			  BEGIN
				INSERT INTO trunc_trig VALUES (DEFAULT, 'triggered stat before');
				RETURN NULL;
			  END; $$;
2020-09-07 06:20:31.847 UTC [10837] 018_wal_optimize.pl LOG:  statement: CREATE FUNCTION trunc_trig_after_stat_trig() RETURNS trigger
			  LANGUAGE plpgsql as $$
			  BEGIN
				INSERT INTO trunc_trig VALUES (DEFAULT, 'triggered stat before');
				RETURN NULL;
			  END; $$;
2020-09-07 06:20:31.848 UTC [10837] 018_wal_optimize.pl LOG:  statement: CREATE TRIGGER trunc_trig_before_stat_truncate
			  BEFORE TRUNCATE ON trunc_trig
			  FOR EACH STATEMENT EXECUTE PROCEDURE trunc_trig_before_stat_trig();
2020-09-07 06:20:31.848 UTC [10837] 018_wal_optimize.pl LOG:  statement: CREATE TRIGGER trunc_trig_after_stat_truncate
			  AFTER TRUNCATE ON trunc_trig
			  FOR EACH STATEMENT EXECUTE PROCEDURE trunc_trig_after_stat_trig();
2020-09-07 06:20:31.848 UTC [10837] 018_wal_optimize.pl LOG:  statement: INSERT INTO trunc_trig VALUES (DEFAULT, 1);
2020-09-07 06:20:31.849 UTC [10837] 018_wal_optimize.pl LOG:  statement: TRUNCATE trunc_trig;
2020-09-07 06:20:31.851 UTC [10837] 018_wal_optimize.pl LOG:  statement: COPY trunc_trig FROM '/home/postgres/PostgreSQL-Source-Dev/src/test/recovery/tmp_check/t_018_wal_optimize_node_minimal_data/copy_data.txt' DELIMITER ',';
2020-09-07 06:20:31.852 UTC [10837] 018_wal_optimize.pl LOG:  statement: COMMIT;
2020-09-07 06:20:31.855 UTC [10826] LOG:  received immediate shutdown request
2020-09-07 06:20:31.856 UTC [10831] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:31.856 UTC [10831] 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-09-07 06:20:31.856 UTC [10831] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:31.859 UTC [10826] LOG:  database system is shut down
2020-09-07 06:20:31.976 UTC [10841] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:31.977 UTC [10841] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:31.979 UTC [10842] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:31 UTC
2020-09-07 06:20:31.979 UTC [10842] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:31.979 UTC [10842] LOG:  redo starts at 0/1A53260
2020-09-07 06:20:31.981 UTC [10842] LOG:  invalid record length at 0/1A8AB40: wanted 24, got 0
2020-09-07 06:20:31.981 UTC [10842] LOG:  redo done at 0/1A8AB18
2020-09-07 06:20:31.984 UTC [10841] LOG:  database system is ready to accept connections
2020-09-07 06:20:32.078 UTC [10850] 018_wal_optimize.pl LOG:  statement: SELECT count(*) FROM trunc_trig;
2020-09-07 06:20:32.088 UTC [10852] 018_wal_optimize.pl LOG:  statement: CREATE TEMP TABLE temp (id serial PRIMARY KEY, id2 text);
2020-09-07 06:20:32.097 UTC [10841] LOG:  received immediate shutdown request
2020-09-07 06:20:32.097 UTC [10852] 018_wal_optimize.pl WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:32.097 UTC [10852] 018_wal_optimize.pl 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-09-07 06:20:32.097 UTC [10852] 018_wal_optimize.pl HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:32.097 UTC [10846] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:32.097 UTC [10846] 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-09-07 06:20:32.097 UTC [10846] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:32.101 UTC [10841] LOG:  database system is shut down
2020-09-07 06:20:32.219 UTC [10857] LOG:  starting PostgreSQL 14devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
2020-09-07 06:20:32.219 UTC [10857] LOG:  listening on Unix socket "/tmp/XOpPsnyCWo/.s.PGSQL.64745"
2020-09-07 06:20:32.222 UTC [10858] LOG:  database system was interrupted; last known up at 2020-09-07 06:20:31 UTC
2020-09-07 06:20:32.222 UTC [10858] LOG:  database system was not properly shut down; automatic recovery in progress
2020-09-07 06:20:32.223 UTC [10858] LOG:  redo starts at 0/1A8ABB8
2020-09-07 06:20:32.224 UTC [10858] LOG:  invalid record length at 0/1AB1CE0: wanted 24, got 0
2020-09-07 06:20:32.224 UTC [10858] LOG:  redo done at 0/1AB1CB8
2020-09-07 06:20:32.228 UTC [10857] LOG:  database system is ready to accept connections
2020-09-07 06:20:32.319 UTC [10866] 018_wal_optimize.pl LOG:  statement: SELECT oid FROM pg_database WHERE datname = 'postgres'
2020-09-07 06:20:32.329 UTC [10868] 018_wal_optimize.pl LOG:  statement: SELECT pg_relation_filepath(oid) FROM pg_class
		   WHERE reltablespace = 0 AND relpersistence <> 't' AND
		   pg_relation_filepath(oid) IS NOT NULL;
2020-09-07 06:20:34.003 UTC [10857] LOG:  received immediate shutdown request
2020-09-07 06:20:34.004 UTC [10862] WARNING:  terminating connection because of crash of another server process
2020-09-07 06:20:34.004 UTC [10862] 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-09-07 06:20:34.004 UTC [10862] HINT:  In a moment you should be able to reconnect to the database and repeat your command.
2020-09-07 06:20:34.007 UTC [10857] LOG:  database system is shut down