2024-04-20 01:18:03.141 UTC [50135][postmaster] LOG: starting PostgreSQL 17devel on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-04-20 01:18:03.141 UTC [50135][postmaster] LOG: listening on Unix socket "/tmp/PUsRhvj6DJ/.s.PGSQL.54364" 2024-04-20 01:18:03.156 UTC [50138][startup] LOG: database system was shut down at 2024-04-20 01:11:19 UTC 2024-04-20 01:18:03.184 UTC [50135][postmaster] LOG: database system is ready to accept connections 2024-04-20 01:18:03.326 UTC [50145][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.327 UTC [50145][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.327 UTC [50145][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.342 UTC [50145][client backend] [099_twophase_added.pl][0/2:0] LOG: statement: CREATE TABLE tab_full (a int PRIMARY KEY) 2024-04-20 01:18:03.356 UTC [50145][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.029 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.413 UTC [50149][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.414 UTC [50149][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.414 UTC [50149][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.417 UTC [50149][client backend] [099_twophase_added.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION sub CONNECTION 'port=54363 host=/tmp/PUsRhvj6DJ dbname=postgres' PUBLICATION pub WITH (two_phase = off, copy_data = off) 2024-04-20 01:18:03.532 UTC [50149][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.118 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.558 UTC [50151][logical replication apply worker] LOG: logical replication apply worker for subscription "sub" has started 2024-04-20 01:18:03.706 UTC [50162][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.707 UTC [50162][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.707 UTC [50162][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.708 UTC [50162][client backend] [099_twophase_added.pl][2/2:0] LOG: statement: SELECT count(*) FROM pg_prepared_xacts; 2024-04-20 01:18:03.713 UTC [50162][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.006 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.723 UTC [50164][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.724 UTC [50164][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.724 UTC [50164][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.725 UTC [50164][client backend] [099_twophase_added.pl][3/2:0] LOG: statement: ALTER SUBSCRIPTION sub DISABLE; 2024-04-20 01:18:03.726 UTC [50151][logical replication apply worker] LOG: logical replication worker for subscription "sub" will stop because the subscription was disabled 2024-04-20 01:18:03.726 UTC [50164][client backend] [099_twophase_added.pl][3/3:0] LOG: statement: ALTER SUBSCRIPTION sub SET (two_phase = on); 2024-04-20 01:18:03.742 UTC [50164][client backend] [099_twophase_added.pl][3/4:0] LOG: statement: ALTER SUBSCRIPTION sub ENABLE; 2024-04-20 01:18:03.746 UTC [50164][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.748 UTC [50166][logical replication apply worker] LOG: logical replication apply worker for subscription "sub" has started 2024-04-20 01:18:03.814 UTC [50177][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.814 UTC [50177][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.814 UTC [50177][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.816 UTC [50177][client backend] [099_twophase_added.pl][4/2:0] LOG: statement: SELECT count(*) FROM tab_full; 2024-04-20 01:18:03.817 UTC [50177][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.878 UTC [50187][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.879 UTC [50187][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.879 UTC [50187][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.880 UTC [50187][client backend] [099_twophase_added.pl][5/2:0] LOG: statement: SELECT count(*) FROM pg_prepared_xacts; 2024-04-20 01:18:03.884 UTC [50187][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.005 user=postgres database=postgres host=[local] 2024-04-20 01:18:03.894 UTC [50189][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-20 01:18:03.894 UTC [50189][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="postgres" method=trust (/tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_099_twophase_added_subscriber_data/pgdata/pg_hba.conf:117) 2024-04-20 01:18:03.894 UTC [50189][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-20 01:18:03.896 UTC [50189][client backend] [099_twophase_added.pl][6/2:0] LOG: statement: ALTER SUBSCRIPTION sub DISABLE; 2024-04-20 01:18:03.896 UTC [50166][logical replication apply worker] LOG: logical replication worker for subscription "sub" will stop because the subscription was disabled 2024-04-20 01:18:03.896 UTC [50189][client backend] [099_twophase_added.pl][6/3:0] LOG: statement: ALTER SUBSCRIPTION sub SET (two_phase = off); AddressSanitizer:DEADLYSIGNAL ================================================================= ==50189==ERROR: AddressSanitizer: SEGV on unknown address (pc 0x55e7f22c6a20 bp 0x000000000001 sp 0x7ffddfcac600 T0) ==50189==The signal is caused by a READ memory access. ==50189==Hint: this fault was caused by a dereference of a high value address (see register values below). Dissassemble the provided pc to learn which register was used. #0 0x55e7f22c6a20 in AlterSubscription /tmp/cirrus-ci-build/src/backend/commands/subscriptioncmds.c:1216 #1 0x55e7f28da4de in ProcessUtilitySlow /tmp/cirrus-ci-build/src/backend/tcop/utility.c:1863 #2 0x55e7f28d7c7f in standard_ProcessUtility /tmp/cirrus-ci-build/src/backend/tcop/utility.c:1067 #3 0x55e7f28d7e26 in ProcessUtility /tmp/cirrus-ci-build/src/backend/tcop/utility.c:523 #4 0x55e7f28d2a97 in PortalRunUtility /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:1158 #5 0x55e7f28d2fb4 in PortalRunMulti /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:1315 #6 0x55e7f28d3c58 in PortalRun /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:791 #7 0x55e7f28cb2f3 in exec_simple_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:1274 #8 0x55e7f28ceede in PostgresMain /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:4680 #9 0x55e7f28c1883 in BackendMain /tmp/cirrus-ci-build/src/backend/tcop/backend_startup.c:105 #10 0x55e7f270dd87 in postmaster_child_launch /tmp/cirrus-ci-build/src/backend/postmaster/launch_backend.c:265 #11 0x55e7f2715c94 in BackendStartup /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:3593 #12 0x55e7f27163a8 in ServerLoop /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1674 #13 0x55e7f2718648 in PostmasterMain /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1372 #14 0x55e7f24b1644 in main /tmp/cirrus-ci-build/src/backend/main/main.c:197 #15 0x7fa628019d09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #16 0x55e7f1e27499 in _start (/tmp/cirrus-ci-build/tmp_install/usr/local/pgsql/bin/postgres+0x40c499) AddressSanitizer can not provide additional info. SUMMARY: AddressSanitizer: SEGV /tmp/cirrus-ci-build/src/backend/commands/subscriptioncmds.c:1216 in AlterSubscription ==50189==ABORTING 2024-04-20 01:18:04.429 UTC [50135][postmaster] LOG: received immediate shutdown request 2024-04-20 01:18:05.038 UTC [50135][postmaster] LOG: database system is shut down