2024-04-18 06:40:30.798 UTC [50203][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-18 06:40:30.798 UTC [50203][postmaster] LOG: listening on Unix socket "/tmp/m7B9LuH5iW/.s.PGSQL.61081" 2024-04-18 06:40:30.801 UTC [50206][startup] LOG: database system was shut down at 2024-04-18 06:35:58 UTC 2024-04-18 06:40:30.808 UTC [50203][postmaster] LOG: database system is ready to accept connections 2024-04-18 06:40:31.092 UTC [50251][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:31.093 UTC [50251][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-18 06:40:31.093 UTC [50251][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:31.164 UTC [50251][client backend] [099_twophase_added.pl][0/2:0] LOG: statement: CREATE TABLE tab_full (a int PRIMARY KEY) 2024-04-18 06:40:31.186 UTC [50251][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.095 user=postgres database=postgres host=[local] 2024-04-18 06:40:31.276 UTC [50255][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:31.280 UTC [50255][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-18 06:40:31.280 UTC [50255][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:31.287 UTC [50255][client backend] [099_twophase_added.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION sub CONNECTION 'port=61080 host=/tmp/m7B9LuH5iW dbname=postgres' PUBLICATION pub WITH (two_phase = off, copy_data = off) 2024-04-18 06:40:31.410 UTC [50255][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.134 user=postgres database=postgres host=[local] 2024-04-18 06:40:31.418 UTC [50257][logical replication apply worker] LOG: logical replication apply worker for subscription "sub" has started 2024-04-18 06:40:31.627 UTC [50268][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:31.635 UTC [50268][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-18 06:40:31.635 UTC [50268][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:31.636 UTC [50268][client backend] [099_twophase_added.pl][2/2:0] LOG: statement: SELECT count(*) FROM pg_prepared_xacts; 2024-04-18 06:40:31.642 UTC [50268][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=postgres database=postgres host=[local] 2024-04-18 06:40:31.672 UTC [50270][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:31.674 UTC [50270][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-18 06:40:31.674 UTC [50270][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:31.675 UTC [50270][client backend] [099_twophase_added.pl][3/2:0] LOG: statement: ALTER SUBSCRIPTION sub DISABLE; 2024-04-18 06:40:31.676 UTC [50257][logical replication apply worker] LOG: logical replication worker for subscription "sub" will stop because the subscription was disabled 2024-04-18 06:40:31.685 UTC [50270][client backend] [099_twophase_added.pl][3/3:0] LOG: statement: ALTER SUBSCRIPTION sub SET (two_phase = on); 2024-04-18 06:40:31.705 UTC [50270][client backend] [099_twophase_added.pl][3/4:0] LOG: statement: ALTER SUBSCRIPTION sub ENABLE; 2024-04-18 06:40:31.707 UTC [50270][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=postgres database=postgres host=[local] 2024-04-18 06:40:31.721 UTC [50273][logical replication apply worker] LOG: logical replication apply worker for subscription "sub" has started 2024-04-18 06:40:31.934 UTC [50285][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:31.935 UTC [50285][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-18 06:40:31.935 UTC [50285][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:31.937 UTC [50285][client backend] [099_twophase_added.pl][4/2:0] LOG: statement: SELECT count(*) FROM tab_full; 2024-04-18 06:40:31.943 UTC [50285][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=postgres database=postgres host=[local] 2024-04-18 06:40:32.167 UTC [50295][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:32.168 UTC [50295][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-18 06:40:32.168 UTC [50295][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:32.170 UTC [50295][client backend] [099_twophase_added.pl][5/2:0] LOG: statement: SELECT count(*) FROM pg_prepared_xacts; 2024-04-18 06:40:32.178 UTC [50295][client backend] [099_twophase_added.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=postgres database=postgres host=[local] 2024-04-18 06:40:32.191 UTC [50297][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-04-18 06:40:32.192 UTC [50297][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-18 06:40:32.192 UTC [50297][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=postgres database=postgres application_name=099_twophase_added.pl 2024-04-18 06:40:32.193 UTC [50297][client backend] [099_twophase_added.pl][6/2:0] LOG: statement: ALTER SUBSCRIPTION sub DISABLE; 2024-04-18 06:40:32.194 UTC [50273][logical replication apply worker] LOG: logical replication worker for subscription "sub" will stop because the subscription was disabled 2024-04-18 06:40:32.202 UTC [50297][client backend] [099_twophase_added.pl][6/3:0] LOG: statement: ALTER SUBSCRIPTION sub SET (two_phase = off); AddressSanitizer:DEADLYSIGNAL ================================================================= ==50297==ERROR: AddressSanitizer: SEGV on unknown address (pc 0x5623549c3cdc bp 0x000000000001 sp 0x7fffe19d8040 T0) ==50297==The signal is caused by a READ memory access. ==50297==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 0x5623549c3cdc in AlterSubscription /tmp/cirrus-ci-build/src/backend/commands/subscriptioncmds.c:1216 #1 0x562354fd6f58 in ProcessUtilitySlow /tmp/cirrus-ci-build/src/backend/tcop/utility.c:1863 #2 0x562354fd46f9 in standard_ProcessUtility /tmp/cirrus-ci-build/src/backend/tcop/utility.c:1067 #3 0x562354fd48a0 in ProcessUtility /tmp/cirrus-ci-build/src/backend/tcop/utility.c:523 #4 0x562354fcf511 in PortalRunUtility /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:1158 #5 0x562354fcfa2e in PortalRunMulti /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:1315 #6 0x562354fd06d2 in PortalRun /tmp/cirrus-ci-build/src/backend/tcop/pquery.c:791 #7 0x562354fc7d6d in exec_simple_query /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:1274 #8 0x562354fcb958 in PostgresMain /tmp/cirrus-ci-build/src/backend/tcop/postgres.c:4680 #9 0x562354fbe2fd in BackendMain /tmp/cirrus-ci-build/src/backend/tcop/backend_startup.c:105 #10 0x562354e0a801 in postmaster_child_launch /tmp/cirrus-ci-build/src/backend/postmaster/launch_backend.c:265 #11 0x562354e1270e in BackendStartup /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:3593 #12 0x562354e12e22 in ServerLoop /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1674 #13 0x562354e150c2 in PostmasterMain /tmp/cirrus-ci-build/src/backend/postmaster/postmaster.c:1372 #14 0x562354bae402 in main /tmp/cirrus-ci-build/src/backend/main/main.c:197 #15 0x7f1a541efd09 in __libc_start_main (/lib/x86_64-linux-gnu/libc.so.6+0x23d09) #16 0x562354525499 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 ==50297==ABORTING 2024-04-18 06:40:32.562 UTC [50203][postmaster] LOG: received immediate shutdown request 2024-04-18 06:40:33.064 UTC [50203][postmaster] LOG: database system is shut down