2023-08-06 17:20:34.436 UTC [1274721] LOG:  starting PostgreSQL 17devel (Ubuntu 17~~devel-1) on s390x-ibm-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2023-08-06 17:20:34.437 UTC [1274721] LOG:  listening on Unix socket "/tmp/N8KG4BCXAf/.s.PGSQL.53738"
2023-08-06 17:20:34.505 UTC [1274726] LOG:  database system was shut down at 2023-08-06 17:20:33 UTC
2023-08-06 17:20:34.513 UTC [1274721] LOG:  database system is ready to accept connections
2023-08-06 17:20:35.499 UTC [1274748] 031_recovery_conflict.pl LOG:  statement: CREATE TABLESPACE test_recovery_conflict_tblspc LOCATION ''
2023-08-06 17:20:35.664 UTC [1274757] 031_recovery_conflict.pl LOG:  received replication command: SHOW data_directory_mode
2023-08-06 17:20:35.664 UTC [1274757] 031_recovery_conflict.pl STATEMENT:  SHOW data_directory_mode
2023-08-06 17:20:35.684 UTC [1274757] 031_recovery_conflict.pl LOG:  received replication command: SHOW wal_segment_size
2023-08-06 17:20:35.684 UTC [1274757] 031_recovery_conflict.pl STATEMENT:  SHOW wal_segment_size
2023-08-06 17:20:35.689 UTC [1274757] 031_recovery_conflict.pl LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-06 17:20:35.689 UTC [1274757] 031_recovery_conflict.pl STATEMENT:  IDENTIFY_SYSTEM
2023-08-06 17:20:35.694 UTC [1274757] 031_recovery_conflict.pl LOG:  received replication command: BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-08-06 17:20:35.694 UTC [1274757] 031_recovery_conflict.pl STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-08-06 17:20:35.735 UTC [1274724] LOG:  checkpoint starting: immediate force wait
2023-08-06 17:20:35.752 UTC [1274724] LOG:  checkpoint complete: wrote 7 buffers (5.5%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=11360 kB, estimate=11360 kB; lsn=0/2000060, redo lsn=0/2000028
2023-08-06 17:20:35.877 UTC [1274760] 031_recovery_conflict.pl LOG:  received replication command: SHOW data_directory_mode
2023-08-06 17:20:35.877 UTC [1274760] 031_recovery_conflict.pl STATEMENT:  SHOW data_directory_mode
2023-08-06 17:20:35.877 UTC [1274760] 031_recovery_conflict.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_1274760" TEMPORARY PHYSICAL ( RESERVE_WAL)
2023-08-06 17:20:35.877 UTC [1274760] 031_recovery_conflict.pl STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_1274760" TEMPORARY PHYSICAL ( RESERVE_WAL)
2023-08-06 17:20:36.012 UTC [1274760] 031_recovery_conflict.pl LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-06 17:20:36.012 UTC [1274760] 031_recovery_conflict.pl STATEMENT:  IDENTIFY_SYSTEM
2023-08-06 17:20:36.017 UTC [1274760] 031_recovery_conflict.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_1274760" 0/2000000 TIMELINE 1
2023-08-06 17:20:36.017 UTC [1274760] 031_recovery_conflict.pl STATEMENT:  START_REPLICATION SLOT "pg_basebackup_1274760" 0/2000000 TIMELINE 1
2023-08-06 17:20:37.707 UTC [1274757] 031_recovery_conflict.pl LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp1274757.0", size 137324
2023-08-06 17:20:37.707 UTC [1274757] 031_recovery_conflict.pl STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-08-06 17:20:52.532 UTC [1274953] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-06 17:20:52.532 UTC [1274953] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-06 17:20:52.558 UTC [1274953] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:20:52.558 UTC [1274953] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:20:53.333 UTC [1274960] 031_recovery_conflict.pl LOG:  statement: CREATE DATABASE test_db
2023-08-06 17:21:05.491 UTC [1275162] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table1(a int, b int);
2023-08-06 17:21:05.596 UTC [1275162] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 SELECT i % 3, 0 FROM generate_series(1,20) i;
2023-08-06 17:21:05.729 UTC [1275162] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table2(a int, b int);
2023-08-06 17:21:05.910 UTC [1275187] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:06.117 UTC [1275191] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3429BC8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:06.872 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-06 17:21:06.886 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 VALUES (1,0);
2023-08-06 17:21:06.892 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: ROLLBACK;
2023-08-06 17:21:06.897 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-06 17:21:06.902 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: LOCK test_recovery_conflict_table1;
2023-08-06 17:21:06.908 UTC [1275204] 031_recovery_conflict.pl LOG:  statement: COMMIT;
2023-08-06 17:21:06.934 UTC [1275215] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:06.969 UTC [1275217] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3429C88' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:07.146 UTC [1275220] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-06 17:21:07.174 UTC [1275223] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:07.196 UTC [1275227] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3430000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:08.219 UTC [1275243] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3430000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:08.918 UTC [1275258] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 SELECT i, 0 FROM generate_series(1,20) i
2023-08-06 17:21:09.209 UTC [1275272] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:09.229 UTC [1275274] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34324E0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:09.267 UTC [1275276] 031_recovery_conflict.pl LOG:  statement: UPDATE test_recovery_conflict_table1 SET a = a + 1 WHERE a > 2;
2023-08-06 17:21:09.974 UTC [1275278] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-06 17:21:10.035 UTC [1275280] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:10.053 UTC [1275282] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3432BF8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:10.177 UTC [1275284] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3432BF8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:10.286 UTC [1275293] 031_recovery_conflict.pl LOG:  statement: DROP TABLE test_recovery_conflict_table1;
2023-08-06 17:21:10.853 UTC [1275309] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:10.922 UTC [1275311] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3433130' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:11.394 UTC [1275340] 031_recovery_conflict.pl LOG:  statement: DROP TABLESPACE test_recovery_conflict_tblspc;
2023-08-06 17:21:11.558 UTC [1275352] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:11.576 UTC [1275354] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34331D0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:11.732 UTC [1275356] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34331D0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:16.090 UTC [1275434] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-06 17:21:16.090 UTC [1275434] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-06 17:21:16.095 UTC [1275434] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:21:16.095 UTC [1275434] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:21:16.563 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table1(a int, b int);
2023-08-06 17:21:17.197 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 VALUES (1);
2023-08-06 17:21:17.198 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-06 17:21:17.198 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1(a) SELECT generate_series(1, 100) i;
2023-08-06 17:21:17.950 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: ROLLBACK;
2023-08-06 17:21:17.950 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-06 17:21:17.950 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: LOCK TABLE test_recovery_conflict_table2;
2023-08-06 17:21:17.950 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: PREPARE TRANSACTION 'lock';
2023-08-06 17:21:17.950 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1(a) VALUES (170);
2023-08-06 17:21:17.951 UTC [1275442] 031_recovery_conflict.pl LOG:  statement: SELECT txid_current();
2023-08-06 17:21:18.043 UTC [1275463] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:18.959 UTC [1275466] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3435EF0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:21.091 UTC [1275494] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-06 17:21:21.321 UTC [1275497] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:21.341 UTC [1275499] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3436000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:21.597 UTC [1275505] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3436000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:21:21.779 UTC [1275514] 031_recovery_conflict.pl LOG:  statement: ROLLBACK PREPARED 'lock';
2023-08-06 17:21:22.573 UTC [1275546] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-06 17:21:22.573 UTC [1275546] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-06 17:21:22.578 UTC [1275546] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:21:22.578 UTC [1275546] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-06 17:21:23.043 UTC [1275575] 031_recovery_conflict.pl LOG:  statement: DROP DATABASE test_db;
2023-08-06 17:21:23.102 UTC [1274724] LOG:  checkpoint starting: immediate force wait
2023-08-06 17:21:23.986 UTC [1274724] LOG:  checkpoint complete: wrote 2 buffers (1.6%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.001 s, sync=0.001 s, total=0.884 s; sync files=0, longest=0.000 s, average=0.000 s; distance=20721 kB, estimate=20721 kB; lsn=0/343C488, redo lsn=0/343C450
2023-08-06 17:21:24.086 UTC [1275589] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-06 17:21:24.110 UTC [1275591] 031_recovery_conflict.pl LOG:  statement: SELECT '0/343C740' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-06 17:24:30.314 UTC [1274721] LOG:  received immediate shutdown request
2023-08-06 17:24:31.534 UTC [1274721] LOG:  database system is shut down