2025-01-18 18:41:53.509 GMT [6080][postmaster] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30158, 64-bit 2025-01-18 18:41:53.511 GMT [6080][postmaster] LOG: listening on Unix socket "C:/Windows/TEMP/0TPiMnT02_/.s.PGSQL.28125" 2025-01-18 18:41:53.537 GMT [4000][startup] LOG: database system was shut down at 2025-01-18 18:33:55 GMT 2025-01-18 18:41:53.549 GMT [6080][postmaster] LOG: database system is ready to accept connections 2025-01-18 18:41:53.893 GMT [3916][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:53.895 GMT [3916][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-18 18:41:53.895 GMT [3916][client backend] [[unknown]][0/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:53.911 GMT [3916][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-18 18:41:53.933 GMT [3916][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-18 18:41:53.943 GMT [3916][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.053 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:54.307 GMT [1252][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:54.308 GMT [1252][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-18 18:41:54.308 GMT [1252][client backend] [[unknown]][1/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:54.312 GMT [1252][client backend] [014_binary.pl][1/2:0] LOG: statement: CREATE SUBSCRIPTION tsub CONNECTION 'port=28124 host=C:/Windows/TEMP/0TPiMnT02_ dbname=postgres' PUBLICATION tpub WITH (slot_name = tpub_slot, binary = true) 2025-01-18 18:41:54.378 GMT [1252][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.074 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:54.401 GMT [4536][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:41:54.456 GMT [2712][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has started 2025-01-18 18:41:54.487 GMT [4840][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has started 2025-01-18 18:41:54.513 GMT [2712][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_arrays" has finished 2025-01-18 18:41:54.563 GMT [4840][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_numerical" has finished 2025-01-18 18:41:54.570 GMT [6512][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:54.572 GMT [6512][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-18 18:41:54.572 GMT [6512][client backend] [[unknown]][2/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:54.575 GMT [6512][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-18 18:41:54.580 GMT [6512][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:54.961 GMT [7956][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:54.963 GMT [7956][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-18 18:41:54.963 GMT [7956][client backend] [[unknown]][3/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:54.965 GMT [7956][client backend] [014_binary.pl][3/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a; 2025-01-18 18:41:54.968 GMT [7956][client backend] [014_binary.pl][3/3:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a; 2025-01-18 18:41:54.971 GMT [7956][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:55.524 GMT [4752][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:55.526 GMT [4752][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-18 18:41:55.526 GMT [4752][client backend] [[unknown]][4/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:55.529 GMT [4752][client backend] [014_binary.pl][4/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-18 18:41:55.532 GMT [4752][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:56.136 GMT [7608][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:56.138 GMT [7608][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-18 18:41:56.138 GMT [7608][client backend] [[unknown]][5/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:56.143 GMT [7608][client backend] [014_binary.pl][5/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2025-01-18 18:41:56.148 GMT [7608][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:56.267 GMT [7548][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:56.270 GMT [7548][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-18 18:41:56.270 GMT [7548][client backend] [[unknown]][6/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:56.274 GMT [7548][client backend] [014_binary.pl][6/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-18 18:41:56.277 GMT [7548][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:56.389 GMT [7468][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:56.391 GMT [7468][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-18 18:41:56.391 GMT [7468][client backend] [[unknown]][7/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:56.394 GMT [7468][client backend] [014_binary.pl][7/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2025-01-18 18:41:56.394 GMT [4536][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-18 18:41:56.395 GMT [7468][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.008 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:56.418 GMT [5904][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:41:56.883 GMT [7704][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:56.885 GMT [7704][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-18 18:41:56.885 GMT [7704][client backend] [[unknown]][8/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:56.888 GMT [7704][client backend] [014_binary.pl][8/2:0] LOG: statement: SELECT a, b, c, d FROM test_numerical ORDER BY a 2025-01-18 18:41:56.892 GMT [7704][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:56.982 GMT [5140][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:56.984 GMT [5140][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-18 18:41:56.984 GMT [5140][client backend] [[unknown]][9/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:56.990 GMT [5140][client backend] [014_binary.pl][9/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = true); 2025-01-18 18:41:56.991 GMT [5904][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-18 18:41:56.997 GMT [5140][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:57.026 GMT [1800][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:41:57.588 GMT [5624][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:57.591 GMT [5624][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-18 18:41:57.592 GMT [5624][client backend] [[unknown]][10/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:57.595 GMT [5624][client backend] [014_binary.pl][10/2:0] LOG: statement: SELECT a, b, c FROM test_arrays ORDER BY a 2025-01-18 18:41:57.600 GMT [5624][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.019 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:57.769 GMT [4872][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:57.771 GMT [4872][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-18 18:41:57.771 GMT [4872][client backend] [[unknown]][11/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:57.786 GMT [4872][client backend] [014_binary.pl][11/2:0] LOG: statement: CREATE TYPE myvarchar; 2025-01-18 18:41:57.787 GMT [4872][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-18 18:41:57.796 GMT [4872][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-18 18:41:57.804 GMT [4872][client backend] [014_binary.pl][11/5:0] LOG: statement: CREATE TYPE myvarchar ( input = myvarcharin, output = myvarcharout); 2025-01-18 18:41:57.806 GMT [4872][client backend] [014_binary.pl][11/6:0] LOG: statement: CREATE TABLE public.test_myvarchar ( a myvarchar ); 2025-01-18 18:41:57.808 GMT [4872][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.044 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:57.947 GMT [7668][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:57.949 GMT [7668][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-18 18:41:57.949 GMT [7668][client backend] [[unknown]][12/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:57.952 GMT [7668][client backend] [014_binary.pl][12/2:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION 2025-01-18 18:41:57.992 GMT [7668][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.049 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:58.023 GMT [6712][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2025-01-18 18:41:58.087 GMT [6712][logical replication tablesync worker] ERROR: no binary input function available for type public.myvarchar 2025-01-18 18:41:58.095 GMT [6080][postmaster] LOG: background worker "logical replication tablesync worker" (PID 6712) exited with exit code 1 2025-01-18 18:41:58.251 GMT [8052][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:58.253 GMT [8052][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-18 18:41:58.253 GMT [8052][client backend] [[unknown]][13/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:58.256 GMT [8052][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-18 18:41:58.257 GMT [8052][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-18 18:41:58.258 GMT [8052][client backend] [014_binary.pl][13/4:0] LOG: statement: ALTER TYPE myvarchar SET ( send = myvarcharsend, receive = myvarcharrecv ); 2025-01-18 18:41:58.259 GMT [8052][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:58.309 GMT [1064][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:58.310 GMT [1064][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-18 18:41:58.310 GMT [1064][client backend] [[unknown]][14/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:58.313 GMT [1064][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-18 18:41:58.317 GMT [1064][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:58.474 GMT [6628][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:58.475 GMT [6628][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-18 18:41:58.475 GMT [6628][client backend] [[unknown]][15/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:58.478 GMT [6628][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-18 18:41:58.482 GMT [6628][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:58.648 GMT [5336][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:58.650 GMT [5336][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-18 18:41:58.650 GMT [5336][client backend] [[unknown]][16/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:58.652 GMT [5336][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-18 18:41:58.656 GMT [5336][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:58.856 GMT [2128][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:58.857 GMT [2128][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-18 18:41:58.857 GMT [2128][client backend] [[unknown]][17/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:58.862 GMT [2128][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-18 18:41:58.866 GMT [2128][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:59.083 GMT [3668][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:59.084 GMT [3668][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-18 18:41:59.084 GMT [3668][client backend] [[unknown]][18/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:59.088 GMT [3668][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-18 18:41:59.091 GMT [3668][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:59.226 GMT [4152][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started 2025-01-18 18:41:59.285 GMT [4152][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has finished 2025-01-18 18:41:59.308 GMT [2800][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:59.309 GMT [2800][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-18 18:41:59.309 GMT [2800][client backend] [[unknown]][19/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:59.324 GMT [2800][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-18 18:41:59.328 GMT [2800][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.023 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:59.841 GMT [7800][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:59.843 GMT [7800][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-18 18:41:59.843 GMT [7800][client backend] [[unknown]][20/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:59.845 GMT [7800][client backend] [014_binary.pl][20/2:0] LOG: statement: SELECT a FROM test_myvarchar; 2025-01-18 18:41:59.848 GMT [7800][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.010 user=SYSTEM database=postgres host=[local] 2025-01-18 18:41:59.918 GMT [1800][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2025-01-18 18:41:59.918 GMT [1800][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 768, finished at 0/17B1518 2025-01-18 18:41:59.924 GMT [6080][postmaster] LOG: background worker "logical replication apply worker" (PID 1800) exited with exit code 1 2025-01-18 18:41:59.938 GMT [8036][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:41:59.970 GMT [8036][logical replication apply worker] ERROR: logical replication target relation "public.test_mismatching_types" does not exist 2025-01-18 18:41:59.970 GMT [8036][logical replication apply worker] CONTEXT: processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 768, finished at 0/17B1518 2025-01-18 18:41:59.973 GMT [6080][postmaster] LOG: background worker "logical replication apply worker" (PID 8036) exited with exit code 1 2025-01-18 18:41:59.976 GMT [2236][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:41:59.977 GMT [2236][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-18 18:41:59.977 GMT [2236][client backend] [[unknown]][21/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:41:59.980 GMT [2236][client backend] [014_binary.pl][21/2:0] LOG: statement: CREATE TABLE public.test_mismatching_types ( a int PRIMARY KEY ); 2025-01-18 18:41:59.987 GMT [2236][client backend] [014_binary.pl][21/3:0] LOG: statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION; 2025-01-18 18:42:00.023 GMT [2236][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.050 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:00.518 GMT [7188][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:42:00.635 GMT [5580][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2025-01-18 18:42:00.713 GMT [5580][logical replication tablesync worker] ERROR: incorrect binary data format 2025-01-18 18:42:00.713 GMT [5580][logical replication tablesync worker] CONTEXT: COPY test_mismatching_types, line 1, column a 2025-01-18 18:42:00.733 GMT [6080][postmaster] LOG: background worker "logical replication tablesync worker" (PID 5580) exited with exit code 1 2025-01-18 18:42:00.862 GMT [1196][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:00.863 GMT [1196][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-18 18:42:00.863 GMT [1196][client backend] [[unknown]][22/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:42:00.866 GMT [1196][client backend] [014_binary.pl][22/2:0] LOG: statement: ALTER SUBSCRIPTION tsub SET (binary = false); 2025-01-18 18:42:00.867 GMT [7188][logical replication apply worker] LOG: logical replication worker for subscription "tsub" will restart because of a parameter change 2025-01-18 18:42:00.867 GMT [1196][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.007 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:00.904 GMT [980][logical replication apply worker] LOG: logical replication apply worker for subscription "tsub" has started 2025-01-18 18:42:00.996 GMT [704][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started 2025-01-18 18:42:01.054 GMT [704][logical replication tablesync worker] LOG: logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has finished 2025-01-18 18:42:01.159 GMT [6364][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:01.160 GMT [6364][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-18 18:42:01.160 GMT [6364][client backend] [[unknown]][23/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:42:01.165 GMT [6364][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-18 18:42:01.169 GMT [6364][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:01.759 GMT [5252][not initialized] [[unknown]][:0] LOG: connection received: host=[local] 2025-01-18 18:42:01.760 GMT [5252][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-18 18:42:01.760 GMT [5252][client backend] [[unknown]][24/1:0] LOG: connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl 2025-01-18 18:42:01.763 GMT [5252][client backend] [014_binary.pl][24/2:0] LOG: statement: SELECT a FROM test_mismatching_types ORDER BY a; 2025-01-18 18:42:01.767 GMT [5252][client backend] [014_binary.pl][:0] LOG: disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local] 2025-01-18 18:42:01.853 GMT [6080][postmaster] LOG: received fast shutdown request 2025-01-18 18:42:01.853 GMT [6080][postmaster] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2909, PID: 6080 abort() has been called