2025-01-25 11:19:50.772 GMT [6540][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-25 11:19:50.775 GMT [6540][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/thiRWbm6Bk/.s.PGSQL.28525" 2025-01-25 11:19:50.804 GMT [4916][startup] LOG: database system was shut down at 2025-01-25 11:11:57 GMT 2025-01-25 11:19:50.814 GMT [6540][postmaster] LOG: database system is ready to accept connections 2025-01-25 11:19:51.183 GMT [2196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:51.185 GMT [2196][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) 2025-01-25 11:19:51.185 GMT [2196][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:51.201 GMT [2196][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 ); 2025-01-25 11:19:51.213 GMT [2196][client backend] [014_binary.pl][0/3:0] LOG: statement: CREATE TABLE public.test_arrays ( a INTEGER[] PRIMARY KEY, b NUMERIC[], c TEXT[] ); 2025-01-25 11:19:51.219 GMT [2196][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.039 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:51.619 GMT [3836][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:51.621 GMT [3836][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) 2025-01-25 11:19:51.621 GMT [3836][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:51.624 GMT [3836][client backend] [014_binary.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION tsub CONNECTION 'port=28524 host=C:/Windows/TEMP/thiRWbm6Bk dbname=postgres' PUBLICATION tpub WITH (slot_name = tpub_slot, binary = true) 2025-01-25 11:19:51.686 GMT [3836][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.069 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:51.697 GMT [3808][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:51.766 GMT [2412][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has started 2025-01-25 11:19:51.791 GMT [5588][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has started 2025-01-25 11:19:51.817 GMT [2412][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has finished 2025-01-25 11:19:51.869 GMT [5588][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has finished 2025-01-25 11:19:51.954 GMT [6492][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:51.956 GMT [6492][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) 2025-01-25 11:19:51.956 GMT [6492][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:51.958 GMT [6492][client backend] [014_binary.pl][2/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:51.964 GMT [6492][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:52.352 GMT [2352][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:52.354 GMT [2352][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) 2025-01-25 11:19:52.354 GMT [2352][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:52.361 GMT [2352][client backend] [014_binary.pl][3/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a; 2025-01-25 11:19:52.367 GMT [2352][client backend] [014_binary.pl][3/3:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a; 2025-01-25 11:19:52.372 GMT [2352][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.025 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:52.907 GMT [2960][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:52.908 GMT [2960][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) 2025-01-25 11:19:52.908 GMT [2960][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:52.912 GMT [2960][client backend] [014_binary.pl][4/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-25 11:19:52.917 GMT [2960][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:53.430 GMT [6020][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:53.431 GMT [6020][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) 2025-01-25 11:19:53.431 GMT [6020][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:53.443 GMT [6020][client backend] [014_binary.pl][5/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2025-01-25 11:19:53.448 GMT [6020][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.022 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:53.539 GMT [5216][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:53.541 GMT [5216][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) 2025-01-25 11:19:53.541 GMT [5216][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:53.550 GMT [5216][client backend] [014_binary.pl][6/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-25 11:19:53.555 GMT [5216][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:53.629 GMT [7072][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:53.631 GMT [7072][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) 2025-01-25 11:19:53.631 GMT [7072][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:53.634 GMT [7072][client backend] [014_binary.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2025-01-25 11:19:53.635 GMT [7072][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:53.635 GMT [3808][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-25 11:19:53.660 GMT [740][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:54.178 GMT [1796][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:54.180 GMT [1796][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) 2025-01-25 11:19:54.180 GMT [1796][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:54.186 GMT [1796][client backend] [014_binary.pl][8/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-25 11:19:54.189 GMT [1796][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:54.370 GMT [6732][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:54.372 GMT [6732][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) 2025-01-25 11:19:54.372 GMT [6732][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:54.375 GMT [6732][client backend] [014_binary.pl][9/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = true); 2025-01-25 11:19:54.375 GMT [740][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-25 11:19:54.377 GMT [6732][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:54.437 GMT [4484][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:54.833 GMT [400][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:54.834 GMT [400][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) 2025-01-25 11:19:54.834 GMT [400][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:54.841 GMT [400][client backend] [014_binary.pl][10/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2025-01-25 11:19:54.846 GMT [400][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:55.173 GMT [3752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:55.174 GMT [3752][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) 2025-01-25 11:19:55.174 GMT [3752][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:55.179 GMT [3752][client backend] [014_binary.pl][11/2:0] LOG: statement: CREATE TYPE myvarchar; 2025-01-25 11:19:55.180 GMT [3752][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'; 2025-01-25 11:19:55.192 GMT [3752][client backend] [014_binary.pl][11/4:0] LOG: statement: CREATE FUNCTION myvarcharout(myvarchar) RETURNS cstring LANGUAGE internal IMMUTABLE PARALLEL SAFE STRICT AS 'varcharout'; 2025-01-25 11:19:55.200 GMT [3752][client backend] [014_binary.pl][11/5:0] LOG: statement: CREATE TYPE myvarchar ( input = myvarcharin, output = myvarcharout); 2025-01-25 11:19:55.202 GMT [3752][client backend] [014_binary.pl][11/6:0] LOG: statement: CREATE TABLE public.test_myvarchar ( a myvarchar ); 2025-01-25 11:19:55.204 GMT [3752][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:55.392 GMT [3016][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:55.393 GMT [3016][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) 2025-01-25 11:19:55.393 GMT [3016][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:55.396 GMT [3016][client backend] [014_binary.pl][12/2:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION 2025-01-25 11:19:55.437 GMT [3016][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.048 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:55.463 GMT [6116][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2025-01-25 11:19:55.512 GMT [6116][logical replication tablesync worker] ERROR: no binary input function available for type public.myvarchar 2025-01-25 11:19:55.535 GMT [6540][postmaster] LOG: background worker "logical replication tablesync worker" (PID 6116) exited with exit code 1 2025-01-25 11:19:55.700 GMT [5988][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:55.701 GMT [5988][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) 2025-01-25 11:19:55.701 GMT [5988][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:55.704 GMT [5988][client backend] [014_binary.pl][13/2:0] LOG: statement: CREATE FUNCTION myvarcharsend(myvarchar) RETURNS bytea LANGUAGE internal STABLE PARALLEL SAFE STRICT AS 'varcharsend'; 2025-01-25 11:19:55.706 GMT [5988][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'; 2025-01-25 11:19:55.707 GMT [5988][client backend] [014_binary.pl][13/4:0] LOG: statement: ALTER TYPE myvarchar SET ( send = myvarcharsend, receive = myvarcharrecv ); 2025-01-25 11:19:55.708 GMT [5988][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:55.777 GMT [1832][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:55.778 GMT [1832][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) 2025-01-25 11:19:55.778 GMT [1832][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:55.787 GMT [1832][client backend] [014_binary.pl][14/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:55.792 GMT [1832][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:56.014 GMT [5324][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:56.018 GMT [5324][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) 2025-01-25 11:19:56.018 GMT [5324][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:56.022 GMT [5324][client backend] [014_binary.pl][15/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:56.029 GMT [5324][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.040 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:56.206 GMT [5828][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:56.207 GMT [5828][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) 2025-01-25 11:19:56.207 GMT [5828][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:56.211 GMT [5828][client backend] [014_binary.pl][16/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:56.214 GMT [5828][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:56.416 GMT [1432][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:56.417 GMT [1432][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) 2025-01-25 11:19:56.417 GMT [1432][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:56.424 GMT [1432][client backend] [014_binary.pl][17/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:56.429 GMT [1432][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:56.637 GMT [3348][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:56.638 GMT [3348][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) 2025-01-25 11:19:56.638 GMT [3348][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:56.641 GMT [3348][client backend] [014_binary.pl][18/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:56.644 GMT [3348][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:56.663 GMT [6320][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2025-01-25 11:19:56.716 GMT [6320][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has finished 2025-01-25 11:19:56.847 GMT [4892][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:56.848 GMT [4892][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) 2025-01-25 11:19:56.848 GMT [4892][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:56.851 GMT [4892][client backend] [014_binary.pl][19/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:56.856 GMT [4892][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:57.311 GMT [2516][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:57.313 GMT [2516][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) 2025-01-25 11:19:57.313 GMT [2516][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:57.317 GMT [2516][client backend] [014_binary.pl][20/2:0] LOG: statement: SELECT a FROM test_myvarchar; 2025-01-25 11:19:57.320 GMT [2516][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:57.409 GMT [4484][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2025-01-25 11:19:57.409 GMT [4484][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 768, finished at 0/17B16E8 2025-01-25 11:19:57.436 GMT [4708][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:57.437 GMT [6540][postmaster] LOG: background worker "logical replication apply worker" (PID 4484) exited with exit code 1 2025-01-25 11:19:57.493 GMT [4708][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2025-01-25 11:19:57.493 GMT [4708][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 768, finished at 0/17B16E8 2025-01-25 11:19:57.519 GMT [5828][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:57.521 GMT [5828][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) 2025-01-25 11:19:57.521 GMT [5828][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:57.524 GMT [5828][client backend] [014_binary.pl][21/2:0] LOG: statement: CREATE TABLE public.test_mismatching_types ( a int PRIMARY KEY ); 2025-01-25 11:19:57.525 GMT [6540][postmaster] LOG: background worker "logical replication apply worker" (PID 4708) exited with exit code 1 2025-01-25 11:19:57.529 GMT [5828][client backend] [014_binary.pl][21/3:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION; 2025-01-25 11:19:57.579 GMT [5828][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.062 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:57.940 GMT [4500][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:57.991 GMT [2768][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2025-01-25 11:19:58.037 GMT [2768][logical replication tablesync worker] ERROR: incorrect binary data format 2025-01-25 11:19:58.037 GMT [2768][logical replication tablesync worker] CONTEXT: COPY test_mismatching_types, line 1, column a 2025-01-25 11:19:58.042 GMT [6540][postmaster] LOG: background worker "logical replication tablesync worker" (PID 2768) exited with exit code 1 2025-01-25 11:19:58.093 GMT [3028][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:58.094 GMT [3028][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) 2025-01-25 11:19:58.094 GMT [3028][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:58.097 GMT [3028][client backend] [014_binary.pl][22/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2025-01-25 11:19:58.098 GMT [3028][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:58.099 GMT [4500][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-25 11:19:58.126 GMT [3112][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-25 11:19:58.184 GMT [5404][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2025-01-25 11:19:58.245 GMT [5404][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has finished 2025-01-25 11:19:58.297 GMT [4344][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:58.298 GMT [4344][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) 2025-01-25 11:19:58.298 GMT [4344][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:58.304 GMT [4344][client backend] [014_binary.pl][23/2:0] LOG: statement: SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r', 's'); 2025-01-25 11:19:58.309 GMT [4344][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:58.590 GMT [5880][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-25 11:19:58.591 GMT [5880][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) 2025-01-25 11:19:58.591 GMT [5880][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-25 11:19:58.594 GMT [5880][client backend] [014_binary.pl][24/2:0] LOG: statement: SELECT a FROM test_mismatching_types ORDER BY a; 2025-01-25 11:19:58.599 GMT [5880][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-25 11:19:58.640 GMT [6540][postmaster] LOG: received fast shutdown request 2025-01-25 11:19:58.640 GMT [6540][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2964, PID: 6540 abort() has been called