2024-12-14 21:08:45.592 GMT [7136][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-12-14 21:08:45.594 GMT [7136][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/LXgdHMbnS6/.s.PGSQL.31006" 2024-12-14 21:08:45.622 GMT [4808][startup] LOG: database system was shut down at 2024-12-14 21:01:09 GMT 2024-12-14 21:08:45.632 GMT [7136][postmaster] LOG: database system is ready to accept connections 2024-12-14 21:08:45.902 GMT [1196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:45.903 GMT [1196][client backend] [[unknown]][0/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:45.903 GMT [1196][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:45.920 GMT [1196][client backend] [014_binary.pl][0/2:0] LOG: statement: CREATE TABLE public.test_numerical ( a INTEGER PRIMARY KEY, b NUMERIC, c FLOAT, d BIGINT ); 2024-12-14 21:08:45.931 GMT [1196][client backend] [014_binary.pl][0/3:0] LOG: statement: CREATE TABLE public.test_arrays ( a INTEGER[] PRIMARY KEY, b NUMERIC[], c TEXT[] ); 2024-12-14 21:08:45.937 GMT [1196][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.038 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:46.273 GMT [7856][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:46.275 GMT [7856][client backend] [[unknown]][1/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:46.275 GMT [7856][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:46.278 GMT [7856][client backend] [014_binary.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION tsub CONNECTION 'port=31005 host=C:/Windows/TEMP/LXgdHMbnS6 dbname=postgres' PUBLICATION tpub WITH (slot_name = tpub_slot, binary = true) 2024-12-14 21:08:46.338 GMT [7856][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.068 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:46.348 GMT [6996][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:46.403 GMT [5868][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has started 2024-12-14 21:08:46.437 GMT [3500][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has started 2024-12-14 21:08:46.466 GMT [5868][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has finished 2024-12-14 21:08:46.496 GMT [3500][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has finished 2024-12-14 21:08:46.551 GMT [4016][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:46.553 GMT [4016][client backend] [[unknown]][2/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:46.553 GMT [4016][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:46.557 GMT [4016][client backend] [014_binary.pl][2/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:46.563 GMT [4016][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:46.885 GMT [4892][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:46.886 GMT [4892][client backend] [[unknown]][3/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:46.886 GMT [4892][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:46.892 GMT [4892][client backend] [014_binary.pl][3/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a; 2024-12-14 21:08:46.896 GMT [4892][client backend] [014_binary.pl][3/3:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a; 2024-12-14 21:08:46.900 GMT [4892][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:47.312 GMT [7876][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:47.313 GMT [7876][client backend] [[unknown]][4/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:47.313 GMT [7876][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:47.316 GMT [7876][client backend] [014_binary.pl][4/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2024-12-14 21:08:47.320 GMT [7876][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:47.847 GMT [7160][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:47.850 GMT [7160][client backend] [[unknown]][5/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:47.850 GMT [7160][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:47.854 GMT [7160][client backend] [014_binary.pl][5/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2024-12-14 21:08:47.917 GMT [7160][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.074 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:48.092 GMT [2464][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:48.093 GMT [2464][client backend] [[unknown]][6/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:48.093 GMT [2464][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:48.096 GMT [2464][client backend] [014_binary.pl][6/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2024-12-14 21:08:48.100 GMT [2464][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:48.196 GMT [3228][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:48.198 GMT [3228][client backend] [[unknown]][7/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:48.198 GMT [3228][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:48.202 GMT [3228][client backend] [014_binary.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2024-12-14 21:08:48.203 GMT [3228][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:48.204 GMT [6996][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2024-12-14 21:08:48.237 GMT [4552][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:48.626 GMT [2896][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:48.628 GMT [2896][client backend] [[unknown]][8/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:48.628 GMT [2896][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:48.631 GMT [2896][client backend] [014_binary.pl][8/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2024-12-14 21:08:48.635 GMT [2896][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:48.717 GMT [6864][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:48.718 GMT [6864][client backend] [[unknown]][9/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:48.718 GMT [6864][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:48.721 GMT [6864][client backend] [014_binary.pl][9/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = true); 2024-12-14 21:08:48.721 GMT [4552][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2024-12-14 21:08:48.721 GMT [6864][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:48.745 GMT [3772][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:49.312 GMT [6116][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:49.313 GMT [6116][client backend] [[unknown]][10/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:49.313 GMT [6116][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:49.316 GMT [6116][client backend] [014_binary.pl][10/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2024-12-14 21:08:49.364 GMT [6116][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.056 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:49.581 GMT [4480][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:49.582 GMT [4480][client backend] [[unknown]][11/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:49.582 GMT [4480][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:49.585 GMT [4480][client backend] [014_binary.pl][11/2:0] LOG: statement: CREATE TYPE myvarchar; 2024-12-14 21:08:49.587 GMT [4480][client backend] [014_binary.pl][11/3:0] LOG: statement: CREATE FUNCTION myvarcharin(cstring, oid, integer) RETURNS myvarchar LANGUAGE internal IMMUTABLE PARALLEL SAFE STRICT AS 'varcharin'; 2024-12-14 21:08:49.599 GMT [4480][client backend] [014_binary.pl][11/4:0] LOG: statement: CREATE FUNCTION myvarcharout(myvarchar) RETURNS cstring LANGUAGE internal IMMUTABLE PARALLEL SAFE STRICT AS 'varcharout'; 2024-12-14 21:08:49.609 GMT [4480][client backend] [014_binary.pl][11/5:0] LOG: statement: CREATE TYPE myvarchar ( input = myvarcharin, output = myvarcharout); 2024-12-14 21:08:49.610 GMT [4480][client backend] [014_binary.pl][11/6:0] LOG: statement: CREATE TABLE public.test_myvarchar ( a myvarchar ); 2024-12-14 21:08:49.612 GMT [4480][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.034 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:49.763 GMT [884][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:49.765 GMT [884][client backend] [[unknown]][12/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:49.765 GMT [884][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:49.767 GMT [884][client backend] [014_binary.pl][12/2:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION 2024-12-14 21:08:49.815 GMT [884][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.055 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:49.833 GMT [6812][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2024-12-14 21:08:49.881 GMT [6812][logical replication tablesync worker] ERROR: no binary input function available for type public.myvarchar 2024-12-14 21:08:49.888 GMT [7136][postmaster] LOG: background worker "logical replication tablesync worker" (PID 6812) exited with exit code 1 2024-12-14 21:08:50.110 GMT [5964][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.112 GMT [5964][client backend] [[unknown]][13/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.112 GMT [5964][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.117 GMT [5964][client backend] [014_binary.pl][13/2:0] LOG: statement: CREATE FUNCTION myvarcharsend(myvarchar) RETURNS bytea LANGUAGE internal STABLE PARALLEL SAFE STRICT AS 'varcharsend'; 2024-12-14 21:08:50.118 GMT [5964][client backend] [014_binary.pl][13/3:0] LOG: statement: CREATE FUNCTION myvarcharrecv(internal, oid, integer) RETURNS myvarchar LANGUAGE internal STABLE PARALLEL SAFE STRICT AS 'varcharrecv'; 2024-12-14 21:08:50.119 GMT [5964][client backend] [014_binary.pl][13/4:0] LOG: statement: ALTER TYPE myvarchar SET ( send = myvarcharsend, receive = myvarcharrecv ); 2024-12-14 21:08:50.120 GMT [5964][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:50.185 GMT [5900][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.186 GMT [5900][client backend] [[unknown]][14/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.186 GMT [5900][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.189 GMT [5900][client backend] [014_binary.pl][14/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:50.193 GMT [5900][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:50.361 GMT [7076][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.363 GMT [7076][client backend] [[unknown]][15/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.363 GMT [7076][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.365 GMT [7076][client backend] [014_binary.pl][15/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:50.369 GMT [7076][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:50.548 GMT [4804][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.549 GMT [4804][client backend] [[unknown]][16/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.549 GMT [4804][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.552 GMT [4804][client backend] [014_binary.pl][16/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:50.556 GMT [4804][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:50.725 GMT [4716][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.727 GMT [4716][client backend] [[unknown]][17/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.727 GMT [4716][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.732 GMT [4716][client backend] [014_binary.pl][17/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:50.767 GMT [4716][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:50.965 GMT [5684][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:50.966 GMT [5684][client backend] [[unknown]][18/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:50.966 GMT [5684][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:50.974 GMT [5684][client backend] [014_binary.pl][18/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:50.979 GMT [5684][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.017 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:51.043 GMT [5572][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2024-12-14 21:08:51.092 GMT [5572][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has finished 2024-12-14 21:08:51.140 GMT [6344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:51.141 GMT [6344][client backend] [[unknown]][19/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:51.141 GMT [6344][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:51.144 GMT [6344][client backend] [014_binary.pl][19/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:51.148 GMT [6344][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:51.476 GMT [6468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:51.478 GMT [6468][client backend] [[unknown]][20/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:51.478 GMT [6468][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:51.481 GMT [6468][client backend] [014_binary.pl][20/2:0] LOG: statement: SELECT a FROM test_myvarchar; 2024-12-14 21:08:51.484 GMT [6468][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:51.581 GMT [3772][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2024-12-14 21:08:51.581 GMT [3772][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 767, finished at 0/17B2C08 2024-12-14 21:08:51.624 GMT [2428][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:51.649 GMT [7136][postmaster] LOG: background worker "logical replication apply worker" (PID 3772) exited with exit code 1 2024-12-14 21:08:51.664 GMT [2428][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2024-12-14 21:08:51.664 GMT [2428][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 767, finished at 0/17B2C08 2024-12-14 21:08:51.672 GMT [7136][postmaster] LOG: background worker "logical replication apply worker" (PID 2428) exited with exit code 1 2024-12-14 21:08:51.698 GMT [7160][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:51.699 GMT [7160][client backend] [[unknown]][21/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:51.699 GMT [7160][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:51.702 GMT [7160][client backend] [014_binary.pl][21/2:0] LOG: statement: CREATE TABLE public.test_mismatching_types ( a int PRIMARY KEY ); 2024-12-14 21:08:51.707 GMT [7160][client backend] [014_binary.pl][21/3:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION; 2024-12-14 21:08:51.738 GMT [7160][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.043 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:52.149 GMT [7764][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:52.241 GMT [88][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2024-12-14 21:08:52.311 GMT [88][logical replication tablesync worker] ERROR: incorrect binary data format 2024-12-14 21:08:52.311 GMT [88][logical replication tablesync worker] CONTEXT: COPY test_mismatching_types, line 1, column a 2024-12-14 21:08:52.318 GMT [7136][postmaster] LOG: background worker "logical replication tablesync worker" (PID 88) exited with exit code 1 2024-12-14 21:08:52.431 GMT [932][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:52.432 GMT [932][client backend] [[unknown]][22/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:52.432 GMT [932][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:52.435 GMT [932][client backend] [014_binary.pl][22/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2024-12-14 21:08:52.435 GMT [7764][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2024-12-14 21:08:52.436 GMT [932][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:52.455 GMT [7856][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2024-12-14 21:08:52.503 GMT [4512][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2024-12-14 21:08:52.555 GMT [4512][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has finished 2024-12-14 21:08:52.608 GMT [2616][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:52.609 GMT [2616][client backend] [[unknown]][23/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:52.609 GMT [2616][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:52.612 GMT [2616][client backend] [014_binary.pl][23/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2024-12-14 21:08:52.617 GMT [2616][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:53.083 GMT [3376][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2024-12-14 21:08:53.084 GMT [3376][client backend] [[unknown]][24/1:0] LOG: connection authenticated: user="SYSTEM" method=trust (C:/cirrus/build/testrun/subscription/014_binary/data/t_014_binary_subscriber_data/pgdata/pg_hba.conf:117) 2024-12-14 21:08:53.084 GMT [3376][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2024-12-14 21:08:53.087 GMT [3376][client backend] [014_binary.pl][24/2:0] LOG: statement: SELECT a FROM test_mismatching_types ORDER BY a; 2024-12-14 21:08:53.092 GMT [3376][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2024-12-14 21:08:53.123 GMT [7136][postmaster] LOG: received fast shutdown request 2024-12-14 21:08:53.123 GMT [7136][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2901, PID: 7136 abort() has been called