2024-11-21 04:56:53.478 GMT [7512][postmaster] LOG:  starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit
2024-11-21 04:56:53.481 GMT [7512][postmaster] LOG:  listening on Unix socket "C:/Windows/TEMP/_VqGUgVOp1/.s.PGSQL.11163"
2024-11-21 04:56:53.510 GMT [6948][startup] LOG:  database system was shut down at 2024-11-21 04:49:12 GMT
2024-11-21 04:56:53.524 GMT [7512][postmaster] LOG:  database system is ready to accept connections
2024-11-21 04:56:53.798 GMT [5572][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:53.800 GMT [5572][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-11-21 04:56:53.800 GMT [5572][client backend] [[unknown]][0/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:53.827 GMT [5572][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-11-21 04:56:53.849 GMT [5572][client backend] [014_binary.pl][0/3:0] LOG:  statement: CREATE TABLE public.test_arrays (
			a INTEGER[] PRIMARY KEY,
			b NUMERIC[],
			c TEXT[]
			);
2024-11-21 04:56:53.856 GMT [5572][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.067 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:54.222 GMT [4480][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:54.223 GMT [4480][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-11-21 04:56:54.223 GMT [4480][client backend] [[unknown]][1/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:54.230 GMT [4480][client backend] [014_binary.pl][1/2:0] LOG:  statement: CREATE SUBSCRIPTION tsub CONNECTION 'port=11162 host=C:/Windows/TEMP/_VqGUgVOp1 dbname=postgres' PUBLICATION tpub WITH (slot_name = tpub_slot, binary = true)
2024-11-21 04:56:54.327 GMT [4480][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.108 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:54.332 GMT [6032][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:56:54.392 GMT [3796][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_arrays" has started
2024-11-21 04:56:54.418 GMT [7708][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_numerical" has started
2024-11-21 04:56:54.461 GMT [3796][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_arrays" has finished
2024-11-21 04:56:54.492 GMT [7708][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_numerical" has finished
2024-11-21 04:56:54.578 GMT [6968][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:54.579 GMT [6968][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-11-21 04:56:54.579 GMT [6968][client backend] [[unknown]][2/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:54.582 GMT [6968][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-11-21 04:56:54.596 GMT [6968][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.021 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:55.099 GMT [1572][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:55.101 GMT [1572][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-11-21 04:56:55.101 GMT [1572][client backend] [[unknown]][3/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:55.110 GMT [1572][client backend] [014_binary.pl][3/2:0] LOG:  statement: SELECT a, b, c, d FROM test_numerical ORDER BY a;
2024-11-21 04:56:55.121 GMT [1572][client backend] [014_binary.pl][3/3:0] LOG:  statement: SELECT a, b, c FROM test_arrays ORDER BY a;
2024-11-21 04:56:55.126 GMT [1572][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.033 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:55.751 GMT [7300][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:55.752 GMT [7300][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-11-21 04:56:55.752 GMT [7300][client backend] [[unknown]][4/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:55.755 GMT [7300][client backend] [014_binary.pl][4/2:0] LOG:  statement: SELECT a, b, c, d FROM test_numerical ORDER BY a
2024-11-21 04:56:55.759 GMT [7300][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:56.246 GMT [7332][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:56.248 GMT [7332][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-11-21 04:56:56.248 GMT [7332][client backend] [[unknown]][5/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:56.252 GMT [7332][client backend] [014_binary.pl][5/2:0] LOG:  statement: SELECT a, b, c FROM test_arrays ORDER BY a
2024-11-21 04:56:56.258 GMT [7332][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:56.340 GMT [7644][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:56.342 GMT [7644][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-11-21 04:56:56.342 GMT [7644][client backend] [[unknown]][6/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:56.345 GMT [7644][client backend] [014_binary.pl][6/2:0] LOG:  statement: SELECT a, b, c, d FROM test_numerical ORDER BY a
2024-11-21 04:56:56.352 GMT [7644][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:56.452 GMT [6324][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:56.454 GMT [6324][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-11-21 04:56:56.454 GMT [6324][client backend] [[unknown]][7/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:56.459 GMT [6324][client backend] [014_binary.pl][7/2:0] LOG:  statement: ALTER SUBSCRIPTION tsub SET (binary = false);
2024-11-21 04:56:56.460 GMT [6032][logical replication apply worker] LOG:  logical replication worker for subscription "tsub" will restart because of a parameter change
2024-11-21 04:56:56.462 GMT [6324][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:56.499 GMT [6552][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:56:57.140 GMT [7920][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:57.141 GMT [7920][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-11-21 04:56:57.141 GMT [7920][client backend] [[unknown]][8/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:57.144 GMT [7920][client backend] [014_binary.pl][8/2:0] LOG:  statement: SELECT a, b, c, d FROM test_numerical ORDER BY a
2024-11-21 04:56:57.148 GMT [7920][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.011 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:57.285 GMT [4260][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:57.286 GMT [4260][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-11-21 04:56:57.286 GMT [4260][client backend] [[unknown]][9/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:57.290 GMT [4260][client backend] [014_binary.pl][9/2:0] LOG:  statement: ALTER SUBSCRIPTION tsub SET (binary = true);
2024-11-21 04:56:57.291 GMT [6552][logical replication apply worker] LOG:  logical replication worker for subscription "tsub" will restart because of a parameter change
2024-11-21 04:56:57.291 GMT [4260][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.009 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:57.313 GMT [5084][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:56:57.730 GMT [7740][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:57.732 GMT [7740][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-11-21 04:56:57.732 GMT [7740][client backend] [[unknown]][10/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:57.735 GMT [7740][client backend] [014_binary.pl][10/2:0] LOG:  statement: SELECT a, b, c FROM test_arrays ORDER BY a
2024-11-21 04:56:57.739 GMT [7740][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:57.936 GMT [7972][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:57.938 GMT [7972][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-11-21 04:56:57.938 GMT [7972][client backend] [[unknown]][11/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:57.962 GMT [7972][client backend] [014_binary.pl][11/2:0] LOG:  statement: CREATE TYPE myvarchar;
2024-11-21 04:56:57.963 GMT [7972][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-11-21 04:56:58.023 GMT [7972][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-11-21 04:56:58.035 GMT [7972][client backend] [014_binary.pl][11/5:0] LOG:  statement: CREATE TYPE myvarchar (
	        input = myvarcharin,
	        output = myvarcharout);
2024-11-21 04:56:58.037 GMT [7972][client backend] [014_binary.pl][11/6:0] LOG:  statement: CREATE TABLE public.test_myvarchar (
	        a myvarchar
	    );
2024-11-21 04:56:58.041 GMT [7972][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.116 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:58.330 GMT [6092][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:58.331 GMT [6092][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-11-21 04:56:58.331 GMT [6092][client backend] [[unknown]][12/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:58.334 GMT [6092][client backend] [014_binary.pl][12/2:0] LOG:  statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION
2024-11-21 04:56:58.387 GMT [6092][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.062 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:58.439 GMT [4964][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started
2024-11-21 04:56:58.502 GMT [4964][logical replication tablesync worker] ERROR:  no binary input function available for type public.myvarchar
2024-11-21 04:56:58.540 GMT [7512][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 4964) exited with exit code 1
2024-11-21 04:56:58.735 GMT [6924][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:58.737 GMT [6924][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-11-21 04:56:58.737 GMT [6924][client backend] [[unknown]][13/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:58.747 GMT [6924][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-11-21 04:56:58.749 GMT [6924][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-11-21 04:56:58.749 GMT [6924][client backend] [014_binary.pl][13/4:0] LOG:  statement: ALTER TYPE myvarchar SET (
	        send = myvarcharsend,
	        receive = myvarcharrecv
	    );
2024-11-21 04:56:58.750 GMT [6924][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.018 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:58.858 GMT [5796][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:58.859 GMT [5796][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-11-21 04:56:58.859 GMT [5796][client backend] [[unknown]][14/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:58.862 GMT [5796][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-11-21 04:56:58.868 GMT [5796][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:59.074 GMT [5748][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:59.076 GMT [5748][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-11-21 04:56:59.076 GMT [5748][client backend] [[unknown]][15/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:59.079 GMT [5748][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-11-21 04:56:59.083 GMT [5748][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:59.271 GMT [7752][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:59.272 GMT [7752][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-11-21 04:56:59.272 GMT [7752][client backend] [[unknown]][16/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:59.275 GMT [7752][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-11-21 04:56:59.279 GMT [7752][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:59.448 GMT [4376][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:59.450 GMT [4376][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-11-21 04:56:59.450 GMT [4376][client backend] [[unknown]][17/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:59.454 GMT [4376][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-11-21 04:56:59.459 GMT [4376][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.014 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:59.665 GMT [6244][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:59.667 GMT [6244][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-11-21 04:56:59.667 GMT [6244][client backend] [[unknown]][18/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:59.683 GMT [6416][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has started
2024-11-21 04:56:59.688 GMT [6244][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-11-21 04:56:59.696 GMT [6244][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.035 user=SYSTEM database=postgres host=[local]
2024-11-21 04:56:59.754 GMT [6416][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_myvarchar" has finished
2024-11-21 04:56:59.935 GMT [5712][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:56:59.937 GMT [5712][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-11-21 04:56:59.937 GMT [5712][client backend] [[unknown]][19/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:56:59.940 GMT [5712][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-11-21 04:56:59.945 GMT [5712][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.016 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:00.390 GMT [6328][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:57:00.393 GMT [6328][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-11-21 04:57:00.393 GMT [6328][client backend] [[unknown]][20/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:57:00.400 GMT [6328][client backend] [014_binary.pl][20/2:0] LOG:  statement: SELECT a FROM test_myvarchar;
2024-11-21 04:57:00.411 GMT [6328][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.027 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:00.509 GMT [5084][logical replication apply worker] ERROR:  logical replication target relation "public.test_mismatching_types" does not exist
2024-11-21 04:57:00.509 GMT [5084][logical replication apply worker] CONTEXT:  processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 767, finished at 0/17B1F60
2024-11-21 04:57:00.517 GMT [7512][postmaster] LOG:  background worker "logical replication apply worker" (PID 5084) exited with exit code 1
2024-11-21 04:57:00.535 GMT [6924][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:57:00.580 GMT [6924][logical replication apply worker] ERROR:  logical replication target relation "public.test_mismatching_types" does not exist
2024-11-21 04:57:00.580 GMT [6924][logical replication apply worker] CONTEXT:  processing remote data for replication origin "pg_16400" during message type "INSERT" in transaction 767, finished at 0/17B1F60
2024-11-21 04:57:00.587 GMT [6908][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:57:00.589 GMT [6908][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-11-21 04:57:00.589 GMT [6908][client backend] [[unknown]][21/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:57:00.593 GMT [6908][client backend] [014_binary.pl][21/2:0] LOG:  statement: CREATE TABLE public.test_mismatching_types (
	        a int PRIMARY KEY
	    );
2024-11-21 04:57:00.597 GMT [7512][postmaster] LOG:  background worker "logical replication apply worker" (PID 6924) exited with exit code 1
2024-11-21 04:57:00.600 GMT [6908][client backend] [014_binary.pl][21/3:0] LOG:  statement: ALTER SUBSCRIPTION tsub REFRESH PUBLICATION;
2024-11-21 04:57:00.656 GMT [6908][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.071 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:01.049 GMT [2028][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:57:01.113 GMT [784][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started
2024-11-21 04:57:01.162 GMT [784][logical replication tablesync worker] ERROR:  incorrect binary data format
2024-11-21 04:57:01.162 GMT [784][logical replication tablesync worker] CONTEXT:  COPY test_mismatching_types, line 1, column a
2024-11-21 04:57:01.198 GMT [7512][postmaster] LOG:  background worker "logical replication tablesync worker" (PID 784) exited with exit code 1
2024-11-21 04:57:01.360 GMT [7120][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:57:01.362 GMT [7120][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-11-21 04:57:01.362 GMT [7120][client backend] [[unknown]][22/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:57:01.368 GMT [7120][client backend] [014_binary.pl][22/2:0] LOG:  statement: ALTER SUBSCRIPTION tsub SET (binary = false);
2024-11-21 04:57:01.369 GMT [7120][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.012 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:01.370 GMT [2028][logical replication apply worker] LOG:  logical replication worker for subscription "tsub" will restart because of a parameter change
2024-11-21 04:57:01.423 GMT [5840][logical replication apply worker] LOG:  logical replication apply worker for subscription "tsub" has started
2024-11-21 04:57:01.486 GMT [5860][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has started
2024-11-21 04:57:01.555 GMT [5860][logical replication tablesync worker] LOG:  logical replication table synchronization worker for subscription "tsub", table "test_mismatching_types" has finished
2024-11-21 04:57:01.709 GMT [3552][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:57:01.710 GMT [3552][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-11-21 04:57:01.710 GMT [3552][client backend] [[unknown]][23/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:57:01.714 GMT [3552][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-11-21 04:57:01.718 GMT [3552][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.013 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:02.162 GMT [7120][not initialized] [[unknown]][:0] LOG:  connection received: host=[local]
2024-11-21 04:57:02.164 GMT [7120][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-11-21 04:57:02.164 GMT [7120][client backend] [[unknown]][24/1:0] LOG:  connection authorized: user=SYSTEM database=postgres application_name=014_binary.pl
2024-11-21 04:57:02.168 GMT [7120][client backend] [014_binary.pl][24/2:0] LOG:  statement: SELECT a FROM test_mismatching_types ORDER BY a;
2024-11-21 04:57:02.172 GMT [7120][client backend] [014_binary.pl][:0] LOG:  disconnection: session time: 0:00:00.015 user=SYSTEM database=postgres host=[local]
2024-11-21 04:57:02.229 GMT [7512][postmaster] LOG:  received fast shutdown request
2024-11-21 04:57:02.230 GMT [7512][postmaster] LOG:  aborting any active transactions
TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 7512
abort() has been called