2023-08-07 10:21:53.073 UTC [3132659] LOG:  starting PostgreSQL 17devel (Debian 17~~devel-1) on s390x-ibm-linux-gnu, compiled by gcc (Debian 13.2.0-1) 13.2.0, 64-bit
2023-08-07 10:21:53.074 UTC [3132659] LOG:  listening on Unix socket "/tmp/Ew0sehtBKm/.s.PGSQL.52786"
2023-08-07 10:21:53.075 UTC [3132664] LOG:  database system was shut down at 2023-08-07 10:21:52 UTC
2023-08-07 10:21:53.086 UTC [3132659] LOG:  database system is ready to accept connections
2023-08-07 10:21:53.523 UTC [3132690] 031_recovery_conflict.pl LOG:  statement: CREATE TABLESPACE test_recovery_conflict_tblspc LOCATION ''
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl LOG:  received replication command: SHOW data_directory_mode
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl STATEMENT:  SHOW data_directory_mode
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl LOG:  received replication command: SHOW wal_segment_size
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl STATEMENT:  SHOW wal_segment_size
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl STATEMENT:  IDENTIFY_SYSTEM
2023-08-07 10:21:53.536 UTC [3132700] 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-07 10:21:53.536 UTC [3132700] 031_recovery_conflict.pl STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-08-07 10:21:53.542 UTC [3132662] LOG:  checkpoint starting: immediate force wait
2023-08-07 10:21:53.548 UTC [3132662] 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.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=11350 kB, estimate=11350 kB; lsn=0/2000060, redo lsn=0/2000028
2023-08-07 10:21:53.561 UTC [3132701] 031_recovery_conflict.pl LOG:  received replication command: SHOW data_directory_mode
2023-08-07 10:21:53.561 UTC [3132701] 031_recovery_conflict.pl STATEMENT:  SHOW data_directory_mode
2023-08-07 10:21:53.566 UTC [3132701] 031_recovery_conflict.pl LOG:  received replication command: CREATE_REPLICATION_SLOT "pg_basebackup_3132701" TEMPORARY PHYSICAL ( RESERVE_WAL)
2023-08-07 10:21:53.566 UTC [3132701] 031_recovery_conflict.pl STATEMENT:  CREATE_REPLICATION_SLOT "pg_basebackup_3132701" TEMPORARY PHYSICAL ( RESERVE_WAL)
2023-08-07 10:21:53.576 UTC [3132701] 031_recovery_conflict.pl LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-07 10:21:53.576 UTC [3132701] 031_recovery_conflict.pl STATEMENT:  IDENTIFY_SYSTEM
2023-08-07 10:21:53.581 UTC [3132701] 031_recovery_conflict.pl LOG:  received replication command: START_REPLICATION SLOT "pg_basebackup_3132701" 0/2000000 TIMELINE 1
2023-08-07 10:21:53.581 UTC [3132701] 031_recovery_conflict.pl STATEMENT:  START_REPLICATION SLOT "pg_basebackup_3132701" 0/2000000 TIMELINE 1
2023-08-07 10:21:53.774 UTC [3132700] 031_recovery_conflict.pl LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp3132700.0", size 137324
2023-08-07 10:21:53.774 UTC [3132700] 031_recovery_conflict.pl STATEMENT:  BASE_BACKUP ( LABEL 'pg_basebackup base backup',  PROGRESS,  CHECKPOINT 'fast',  WAIT 0,  MANIFEST 'yes',  TARGET 'client')
2023-08-07 10:21:54.341 UTC [3132754] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-07 10:21:54.341 UTC [3132754] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-07 10:21:54.348 UTC [3132754] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:21:54.348 UTC [3132754] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:21:54.361 UTC [3132760] 031_recovery_conflict.pl LOG:  statement: CREATE DATABASE test_db
2023-08-07 10:21:54.395 UTC [3132770] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table1(a int, b int);
2023-08-07 10:21:54.396 UTC [3132770] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 SELECT i % 3, 0 FROM generate_series(1,20) i;
2023-08-07 10:21:54.396 UTC [3132770] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table2(a int, b int);
2023-08-07 10:21:54.419 UTC [3132776] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:54.436 UTC [3132788] 031_recovery_conflict.pl LOG:  statement: SELECT '0/342B100' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:54.554 UTC [3132811] 031_recovery_conflict.pl LOG:  statement: SELECT '0/342B100' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:54.581 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-07 10:21:54.585 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 VALUES (1,0);
2023-08-07 10:21:54.586 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: ROLLBACK;
2023-08-07 10:21:54.589 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-07 10:21:54.594 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: LOCK test_recovery_conflict_table1;
2023-08-07 10:21:54.596 UTC [3132817] 031_recovery_conflict.pl LOG:  statement: COMMIT;
2023-08-07 10:21:54.609 UTC [3132820] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:54.624 UTC [3132823] 031_recovery_conflict.pl LOG:  statement: SELECT '0/342B1C0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:54.744 UTC [3132845] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-07 10:21:54.758 UTC [3132847] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:54.781 UTC [3132858] 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-07 10:21:54.900 UTC [3132883] 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-07 10:21:55.045 UTC [3132890] 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-07 10:21:55.243 UTC [3132918] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 SELECT i, 0 FROM generate_series(1,20) i
2023-08-07 10:21:55.269 UTC [3132920] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:55.374 UTC [3132931] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34339C8' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:55.433 UTC [3132934] 031_recovery_conflict.pl LOG:  statement: UPDATE test_recovery_conflict_table1 SET a = a + 1 WHERE a > 2;
2023-08-07 10:21:55.444 UTC [3132943] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-07 10:21:55.453 UTC [3132945] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:55.466 UTC [3132948] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3434000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:55.582 UTC [3132955] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3434000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:55.854 UTC [3132962] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3434000' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:56.204 UTC [3133012] 031_recovery_conflict.pl LOG:  statement: DROP TABLE test_recovery_conflict_table1;
2023-08-07 10:21:56.222 UTC [3133014] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:56.234 UTC [3133018] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3434630' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:56.360 UTC [3133036] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3434630' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:56.435 UTC [3133053] 031_recovery_conflict.pl LOG:  statement: DROP TABLESPACE test_recovery_conflict_tblspc;
2023-08-07 10:21:56.452 UTC [3133055] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:56.471 UTC [3133059] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34346D0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:56.771 UTC [3133086] 031_recovery_conflict.pl LOG:  statement: SELECT '0/34346D0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:57.809 UTC [3133191] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-07 10:21:57.809 UTC [3133191] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-07 10:21:57.809 UTC [3133191] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:21:57.809 UTC [3133191] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:21:58.025 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: CREATE TABLE test_recovery_conflict_table1(a int, b int);
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1 VALUES (1);
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1(a) SELECT generate_series(1, 100) i;
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: ROLLBACK;
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: BEGIN;
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: LOCK TABLE test_recovery_conflict_table2;
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: PREPARE TRANSACTION 'lock';
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: INSERT INTO test_recovery_conflict_table1(a) VALUES (170);
2023-08-07 10:21:58.026 UTC [3133220] 031_recovery_conflict.pl LOG:  statement: SELECT txid_current();
2023-08-07 10:21:58.199 UTC [3133223] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:58.221 UTC [3133238] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3437418' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:58.270 UTC [3133252] 031_recovery_conflict.pl LOG:  statement: VACUUM test_recovery_conflict_table1;
2023-08-07 10:21:58.288 UTC [3133256] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:21:58.304 UTC [3133260] 031_recovery_conflict.pl LOG:  statement: SELECT '0/3437418' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:21:58.480 UTC [3133289] 031_recovery_conflict.pl LOG:  statement: ROLLBACK PREPARED 'lock';
2023-08-07 10:22:00.092 UTC [3133521] standby LOG:  received replication command: IDENTIFY_SYSTEM
2023-08-07 10:22:00.092 UTC [3133521] standby STATEMENT:  IDENTIFY_SYSTEM
2023-08-07 10:22:00.261 UTC [3133521] standby LOG:  received replication command: START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:22:00.261 UTC [3133521] standby STATEMENT:  START_REPLICATION 0/3000000 TIMELINE 1
2023-08-07 10:22:00.314 UTC [3133545] 031_recovery_conflict.pl LOG:  statement: DROP DATABASE test_db;
2023-08-07 10:22:00.314 UTC [3132662] LOG:  checkpoint starting: immediate force wait
2023-08-07 10:22:00.315 UTC [3132662] 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.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=20726 kB, estimate=20726 kB; lsn=0/343D970, redo lsn=0/343D938
2023-08-07 10:22:00.464 UTC [3133564] 031_recovery_conflict.pl LOG:  statement: SELECT pg_current_wal_flush_lsn()
2023-08-07 10:22:00.502 UTC [3133571] 031_recovery_conflict.pl LOG:  statement: SELECT '0/343DBF0' <= replay_lsn AND state = 'streaming'
	         FROM pg_catalog.pg_stat_replication
	         WHERE application_name IN ('standby', 'walreceiver')
2023-08-07 10:22:00.622 UTC [3132659] LOG:  received fast shutdown request
2023-08-07 10:22:00.622 UTC [3132659] LOG:  aborting any active transactions
2023-08-07 10:22:00.628 UTC [3132659] LOG:  background worker "logical replication launcher" (PID 3132670) exited with exit code 1
2023-08-07 10:22:00.650 UTC [3132662] LOG:  shutting down
2023-08-07 10:22:00.650 UTC [3132662] LOG:  checkpoint starting: shutdown immediate
2023-08-07 10:22:00.650 UTC [3132662] LOG:  checkpoint complete: wrote 2 buffers (1.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=18653 kB; lsn=0/343DBF0, redo lsn=0/343DBF0
2023-08-07 10:22:00.652 UTC [3132659] LOG:  database system is shut down