2024-12-18 07:23:46.810 UTC postmaster[20343] LOG: starting PostgreSQL 18devel on x86_64-freebsd, compiled by clang-17.0.6, 64-bit 2024-12-18 07:23:46.810 UTC postmaster[20343] LOG: listening on Unix socket "/tmp/pg_regress-ALWupf/.s.PGSQL.40045" 2024-12-18 07:23:46.811 UTC startup[20346] LOG: database system was shut down at 2024-12-18 07:23:46 UTC 2024-12-18 07:23:46.813 UTC postmaster[20343] LOG: database system is ready to accept connections 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4808 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl ERROR: replication slot "regression_slot" already exists 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl ERROR: replication slot name "Invalid Name" contains invalid character 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. 2024-12-18 07:23:46.890 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('Invalid Name', 'test_decoding'); 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl ERROR: could not parse value "frakbar" for parameter "include-xids" 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', 'frakbar'); 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl ERROR: option "nonexistent-option" = "frakbar" is unknown 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2024-12-18 07:23:46.891 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'nonexistent-option', 'frakbar'); 2024-12-18 07:23:46.892 UTC client backend[20354] pg_regress/ddl ERROR: could not parse value "frakbar" for parameter "include-xids" 2024-12-18 07:23:46.892 UTC client backend[20354] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2024-12-18 07:23:46.892 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', 'frakbar'); 2024-12-18 07:23:46.892 UTC client backend[20354] pg_regress/ddl ERROR: replication slot "regression_slot" does not exist 2024-12-18 07:23:46.892 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT pg_drop_replication_slot('regression_slot'); 2024-12-18 07:23:46.893 UTC client backend[20354] pg_regress/ddl ERROR: cannot use physical replication slot for logical decoding 2024-12-18 07:23:46.893 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('repl', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.894 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.894 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.894 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BC4878, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.906 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BCA350, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.910 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BCD8F8, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.914 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BCE260, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.917 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BCF620, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.921 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BCFF28, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'include-rewrites', '1'); 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.930 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'include-rewrites', '1'); 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BDB110, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.933 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results */ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1BDB2B8, reading WAL from 0/1BC4840. 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results, but hide most of the output */ SELECT count(*), min(data), max(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY substring(data, 1, 24) ORDER BY 1,2; 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:46.993 UTC client backend[20354] pg_regress/ddl STATEMENT: /* display results, but hide most of the output */ SELECT count(*), min(data), max(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY substring(data, 1, 24) ORDER BY 1,2; 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1E9BE20, reading WAL from 0/1BC4840. 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WHERE data ~ 'UPDATE'; 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:47.631 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WHERE data ~ 'UPDATE'; 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/1F30F88, reading WAL from 0/1BC4840. 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT substring(data, 1, 29), count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WITH ORDINALITY GROUP BY 1 ORDER BY min(ordinality); 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:47.762 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT substring(data, 1, 29), count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WITH ORDINALITY GROUP BY 1 ORDER BY min(ordinality); 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/2013850, reading WAL from 0/1BC4840. 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:47.915 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/201A3B0, reading WAL from 0/1BC4840. 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:47.951 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/201A8B0, reading WAL from 0/1BC4840. 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:47.984 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/201AB50, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.016 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/201AD30, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.053 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.135 UTC client backend[20354] pg_regress/ddl ERROR: cannot rewrite table "replication_metadata" used as a catalog table 2024-12-18 07:23:48.135 UTC client backend[20354] pg_regress/ddl STATEMENT: ALTER TABLE replication_metadata ALTER COLUMN rewritemeornot TYPE text; 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/20259B8, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.147 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/202DFA0, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.223 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/2058E80, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.264 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl DETAIL: Streaming transactions committing after 0/205FC30, reading WAL from 0/1BC4840. 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl LOG: logical decoding found consistent point at 0/1BC4840 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl DETAIL: There are no running transactions. 2024-12-18 07:23:48.296 UTC client backend[20354] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.339 UTC client backend[20381] pg_regress/xact LOG: logical decoding found consistent point at 0/205FC70 2024-12-18 07:23:48.339 UTC client backend[20381] pg_regress/xact DETAIL: There are no running transactions. 2024-12-18 07:23:48.339 UTC client backend[20381] pg_regress/xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact DETAIL: Streaming transactions committing after 0/205FCA8, reading WAL from 0/205FC70. 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact LOG: logical decoding found consistent point at 0/205FC70 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact DETAIL: There are no running transactions. 2024-12-18 07:23:48.342 UTC client backend[20381] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact DETAIL: Streaming transactions committing after 0/2063570, reading WAL from 0/205FC70. 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact LOG: logical decoding found consistent point at 0/205FC70 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact DETAIL: There are no running transactions. 2024-12-18 07:23:48.344 UTC client backend[20381] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.437 UTC client backend[20384] pg_regress/rewrite LOG: logical decoding found consistent point at 0/206F878 2024-12-18 07:23:48.437 UTC client backend[20384] pg_regress/rewrite DETAIL: There are no running transactions. 2024-12-18 07:23:48.437 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite DETAIL: Streaming transactions committing after 0/206F8B0, reading WAL from 0/206F878. 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite LOG: logical decoding found consistent point at 0/206F878 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite DETAIL: There are no running transactions. 2024-12-18 07:23:48.441 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.506 UTC checkpointer[20344] LOG: checkpoint starting: immediate force wait 2024-12-18 07:23:48.514 UTC checkpointer[20344] LOG: checkpoint complete: wrote 907 buffers (5.5%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.008 s, sync=0.001 s, total=0.009 s; sync files=0, longest=0.000 s, average=0.000 s; distance=12115 kB, estimate=12115 kB; lsn=0/234E038, redo lsn=0/234DFC8 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite DETAIL: Streaming transactions committing after 0/20743D8, reading WAL from 0/206F878. 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite LOG: logical decoding found consistent point at 0/206F878 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite DETAIL: There are no running transactions. 2024-12-18 07:23:48.515 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite DETAIL: Streaming transactions committing after 0/234E0B0, reading WAL from 0/234DFE8. 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite LOG: logical decoding found consistent point at 0/234DFE8 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite DETAIL: There are no running transactions. 2024-12-18 07:23:48.568 UTC client backend[20384] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.587 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:48.587 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:48.587 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast DETAIL: Streaming transactions committing after 0/26DF568, reading WAL from 0/26DF530. 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:48.611 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.638 UTC client backend[20389] pg_regress/toast LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.638 UTC client backend[20389] pg_regress/toast DETAIL: Streaming transactions committing after 0/270EF90, reading WAL from 0/26DF530. 2024-12-18 07:23:48.638 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.639 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:48.639 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:48.639 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast DETAIL: Streaming transactions committing after 0/270EF90, reading WAL from 0/26DF530. 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:48.647 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast DETAIL: Streaming transactions committing after 0/27B45A8, reading WAL from 0/26DF530. 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WHERE data NOT LIKE '%INSERT: %'; 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:48.814 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT regexp_replace(data, '^(.{100}).*(.{100})$', '\1..\2') FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') WHERE data NOT LIKE '%INSERT: %'; 2024-12-18 07:23:49.179 UTC client backend[20389] pg_regress/toast LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.179 UTC client backend[20389] pg_regress/toast DETAIL: Streaming transactions committing after 0/2A7F1C0, reading WAL from 0/26DF530. 2024-12-18 07:23:49.179 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.180 UTC client backend[20389] pg_regress/toast LOG: logical decoding found consistent point at 0/26DF530 2024-12-18 07:23:49.180 UTC client backend[20389] pg_regress/toast DETAIL: There are no running transactions. 2024-12-18 07:23:49.180 UTC client backend[20389] pg_regress/toast STATEMENT: SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.205 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A95FC0 2024-12-18 07:23:49.205 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.205 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions DETAIL: Streaming transactions committing after 0/2A95FF8, reading WAL from 0/2A95FC0. 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A95FC0 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.206 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A960F8 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions ERROR: permission denied for table lr_test 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions STATEMENT: INSERT INTO lr_test VALUES('lr_superuser_init'); 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions DETAIL: Streaming transactions committing after 0/2A96130, reading WAL from 0/2A960F8. 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A960F8 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.208 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.209 UTC client backend[20435] pg_regress/permissions ERROR: permission denied to use replication slots 2024-12-18 07:23:49.209 UTC client backend[20435] pg_regress/permissions DETAIL: Only roles with the REPLICATION attribute may use replication slots. 2024-12-18 07:23:49.209 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions ERROR: permission denied for table lr_test 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions STATEMENT: INSERT INTO lr_test VALUES('lr_superuser_init'); 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions ERROR: permission denied to use replication slots 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions DETAIL: Only roles with the REPLICATION attribute may use replication slots. 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions ERROR: permission denied to use replication slots 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions DETAIL: Only roles with the REPLICATION attribute may use replication slots. 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT pg_drop_replication_slot('regression_slot'); 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions ERROR: permission denied to use replication slots 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions DETAIL: Only roles with the REPLICATION attribute may use replication slots. 2024-12-18 07:23:49.210 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT pg_sync_replication_slots(); 2024-12-18 07:23:49.211 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A96130 2024-12-18 07:23:49.211 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.211 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions LOG: logical decoding found consistent point at 0/2A96168 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions DETAIL: There are no running transactions. 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions ERROR: permission denied to use replication slots 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions DETAIL: Only roles with the REPLICATION attribute may use replication slots. 2024-12-18 07:23:49.212 UTC client backend[20435] pg_regress/permissions STATEMENT: SELECT pg_drop_replication_slot('regression_slot'); 2024-12-18 07:23:49.225 UTC client backend[20444] pg_regress/decoding_in_xact ERROR: cannot create logical replication slot in transaction that has performed writes 2024-12-18 07:23:49.225 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.226 UTC client backend[20444] pg_regress/decoding_in_xact ERROR: cannot create logical replication slot in transaction that has performed writes 2024-12-18 07:23:49.226 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.226 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C08 2024-12-18 07:23:49.226 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.226 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.227 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.227 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.227 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2A97C78, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.233 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2AA03D8, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.235 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2AA0538, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.240 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2AAABC8, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.241 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.245 UTC checkpointer[20344] LOG: checkpoint starting: immediate force wait 2024-12-18 07:23:49.247 UTC checkpointer[20344] LOG: checkpoint complete: wrote 138 buffers (0.8%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=7557 kB, estimate=11659 kB; lsn=0/2AAF5A0, redo lsn=0/2AAF500 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2AAB3D0, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.247 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: Streaming transactions committing after 0/2AAF618, reading WAL from 0/2A97C40. 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact LOG: logical decoding found consistent point at 0/2A97C40 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact DETAIL: There are no running transactions. 2024-12-18 07:23:49.249 UTC client backend[20444] pg_regress/decoding_in_xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2AAFAC8, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.259 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2AAFAC8, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: CREATE TABLE changeresult AS SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.266 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: CREATE TABLE changeresult AS SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2ADB698, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: INSERT INTO changeresult SELECT data FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.268 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: INSERT INTO changeresult SELECT data FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2ADB698, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: INSERT INTO changeresult SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.269 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: INSERT INTO changeresult SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2AE2BA0, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel CONTEXT: SQL statement "SELECT data FROM pg_logical_slot_peek_changes(slot_name, NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1')" PL/pgSQL function slot_changes_wrapper(name) line 3 at RETURN QUERY 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT * FROM slot_changes_wrapper('regression_slot'); 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel CONTEXT: SQL statement "SELECT data FROM pg_logical_slot_peek_changes(slot_name, NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1')" PL/pgSQL function slot_changes_wrapper(name) line 3 at RETURN QUERY 2024-12-18 07:23:49.275 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT * FROM slot_changes_wrapper('regression_slot'); 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: Streaming transactions committing after 0/2AE2BA0, reading WAL from 0/2AAFA90. 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel LOG: logical decoding found consistent point at 0/2AAFA90 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel DETAIL: There are no running transactions. 2024-12-18 07:23:49.277 UTC client backend[20449] pg_regress/decoding_into_rel STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary LOG: logical decoding found consistent point at 0/2AE9BE8 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary DETAIL: There are no running transactions. 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary DETAIL: Streaming transactions committing after 0/2AE9C20, reading WAL from 0/2AE9BE8. 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary LOG: logical decoding found consistent point at 0/2AE9BE8 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary DETAIL: There are no running transactions. 2024-12-18 07:23:49.287 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary DETAIL: Streaming transactions committing after 0/2AE9C20, reading WAL from 0/2AE9BE8. 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '1', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary ERROR: logical decoding output plugin "test_decoding" produces binary output, but function "pg_logical_slot_get_changes(name,pg_lsn,integer,text[])" expects textual data 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '1', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary DETAIL: Streaming transactions committing after 0/2AE9C20, reading WAL from 0/2AE9BE8. 2024-12-18 07:23:49.288 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_binary_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary LOG: logical decoding found consistent point at 0/2AE9BE8 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary DETAIL: There are no running transactions. 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_binary_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary DETAIL: Streaming transactions committing after 0/2AE9C20, reading WAL from 0/2AE9BE8. 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_binary_changes('regression_slot', NULL, NULL, 'force-binary', '1', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary LOG: logical decoding found consistent point at 0/2AE9BE8 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary DETAIL: There are no running transactions. 2024-12-18 07:23:49.289 UTC client backend[20455] pg_regress/binary STATEMENT: SELECT data FROM pg_logical_slot_get_binary_changes('regression_slot', NULL, NULL, 'force-binary', '1', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.298 UTC client backend[20458] pg_regress/prepared LOG: logical decoding found consistent point at 0/2AE9C20 2024-12-18 07:23:49.298 UTC client backend[20458] pg_regress/prepared DETAIL: There are no running transactions. 2024-12-18 07:23:49.298 UTC client backend[20458] pg_regress/prepared STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared DETAIL: Streaming transactions committing after 0/2AE9C58, reading WAL from 0/2AE9C20. 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared LOG: logical decoding found consistent point at 0/2AE9C20 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared DETAIL: There are no running transactions. 2024-12-18 07:23:49.306 UTC client backend[20458] pg_regress/prepared STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.315 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_advance 2024-12-18 07:23:49.315 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_advance('regress_test_decoding: perm', '0/1'); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_create 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_create('regress_test_decoding: perm'); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_drop 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_drop('regress_test_decoding: perm'); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_oid 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_oid('regress_test_decoding: perm'); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_progress 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_progress('regress_test_decoding: perm', false); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_session_is_setup 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_is_setup(); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_session_progress 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_progress(false); 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_session_reset 2024-12-18 07:23:49.316 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_reset(); 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_session_setup 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_setup('regress_test_decoding: perm'); 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_xact_reset 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_xact_reset(); 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_replication_origin_xact_setup 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_xact_setup('0/1', '2013-01-01 00:00'); 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin ERROR: permission denied for function pg_show_replication_origin_status 2024-12-18 07:23:49.317 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_show_replication_origin_status(); 2024-12-18 07:23:49.326 UTC client backend[20463] pg_regress/replorigin ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" 2024-12-18 07:23:49.326 UTC client backend[20463] pg_regress/replorigin DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. 2024-12-18 07:23:49.326 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin "regress_test_decoding: temp" does not exist 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_drop('regress_test_decoding: temp'); 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin name "any" is reserved 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_create('any'); 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin name "none" is reserved 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_create('none'); 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin name "pg_replication_origin" is reserved 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_create('pg_replication_origin'); 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin "regress_test_decoding: temp" does not exist 2024-12-18 07:23:49.327 UTC client backend[20463] pg_regress/replorigin STATEMENT: select pg_replication_origin_advance('regress_test_decoding: temp', '0/1'); 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin "regress_test_decoding: temp" does not exist 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin STATEMENT: select pg_replication_origin_session_setup('regress_test_decoding: temp'); 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin ERROR: replication origin "regress_test_decoding: temp" does not exist 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin STATEMENT: select pg_replication_origin_progress('regress_test_decoding: temp', true); 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.328 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.329 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.329 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B021D0, reading WAL from 0/2B02198. 2024-12-18 07:23:49.329 UTC client backend[20463] pg_regress/replorigin STATEMENT: INSERT INTO target_tbl(data) SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.330 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.330 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.330 UTC client backend[20463] pg_regress/replorigin STATEMENT: INSERT INTO target_tbl(data) SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B023B0, reading WAL from 0/2B02198. 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.331 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.332 UTC client backend[20463] pg_regress/replorigin ERROR: cannot setup replication origin when one is already setup 2024-12-18 07:23:49.332 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_setup('regress_test_decoding: regression_slot'); 2024-12-18 07:23:49.333 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.333 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B026A0, reading WAL from 0/2B02198. 2024-12-18 07:23:49.333 UTC client backend[20463] pg_regress/replorigin STATEMENT: INSERT INTO target_tbl(data) SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.334 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.334 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.334 UTC client backend[20463] pg_regress/replorigin STATEMENT: INSERT INTO target_tbl(data) SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin ERROR: no replication origin is configured 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT pg_replication_origin_session_reset(); 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B02778, reading WAL from 0/2B02198. 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.336 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B02A18, reading WAL from 0/2B02198. 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02198 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.338 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); 2024-12-18 07:23:49.339 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02C08 2024-12-18 07:23:49.339 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.339 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_no_lsn', 'test_decoding'); 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot_no_lsn" 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B02C40, reading WAL from 0/2B02C08. 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot_no_lsn', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B02C08 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.344 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot_no_lsn', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-12-18 07:23:49.345 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B03548 2024-12-18 07:23:49.345 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.345 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'pgoutput'); 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B03580, reading WAL from 0/2B03548. 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT count(*) = 0 FROM pg_logical_slot_peek_binary_changes('regression_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub', 'origin', 'none'); 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B03548 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.348 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT count(*) = 0 FROM pg_logical_slot_peek_binary_changes('regression_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub', 'origin', 'none'); 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin DETAIL: Streaming transactions committing after 0/2B03580, reading WAL from 0/2B03548. 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT count(*) != 0 FROM pg_logical_slot_peek_binary_changes('regression_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub'); 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin LOG: logical decoding found consistent point at 0/2B03548 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin DETAIL: There are no running transactions. 2024-12-18 07:23:49.349 UTC client backend[20463] pg_regress/replorigin STATEMENT: SELECT count(*) != 0 FROM pg_logical_slot_peek_binary_changes('regression_slot', NULL, NULL, 'proto_version', '4', 'publication_names', 'pub'); 2024-12-18 07:23:49.363 UTC client backend[20472] pg_regress/time LOG: logical decoding found consistent point at 0/2B09B88 2024-12-18 07:23:49.363 UTC client backend[20472] pg_regress/time DETAIL: There are no running transactions. 2024-12-18 07:23:49.363 UTC client backend[20472] pg_regress/time STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time DETAIL: Streaming transactions committing after 0/2B09BC0, reading WAL from 0/2B09B88. 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time STATEMENT: SELECT set_config('test.time_after', regexp_replace(data, '^COMMIT \(at (.*)\)$', '\1'), false) IS NOT NULL FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'include-timestamp', '1') WHERE data ~ 'COMMIT' LIMIT 1; 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time LOG: logical decoding found consistent point at 0/2B09B88 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time DETAIL: There are no running transactions. 2024-12-18 07:23:49.364 UTC client backend[20472] pg_regress/time STATEMENT: SELECT set_config('test.time_after', regexp_replace(data, '^COMMIT \(at (.*)\)$', '\1'), false) IS NOT NULL FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'include-timestamp', '1') WHERE data ~ 'COMMIT' LIMIT 1; 2024-12-18 07:23:49.375 UTC client backend[20475] pg_regress/messages LOG: logical decoding found consistent point at 0/2B0BC80 2024-12-18 07:23:49.375 UTC client backend[20475] pg_regress/messages DETAIL: There are no running transactions. 2024-12-18 07:23:49.375 UTC client backend[20475] pg_regress/messages STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages DETAIL: Streaming transactions committing after 0/2B0BCB8, reading WAL from 0/2B0BC80. 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages LOG: logical decoding found consistent point at 0/2B0BC80 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages DETAIL: There are no running transactions. 2024-12-18 07:23:49.377 UTC client backend[20475] pg_regress/messages STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages DETAIL: Streaming transactions committing after 0/2B0BF78, reading WAL from 0/2B0BC80. 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages LOG: logical decoding found consistent point at 0/2B0BC80 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages DETAIL: There are no running transactions. 2024-12-18 07:23:49.386 UTC client backend[20477] pg_regress/messages STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.395 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.395 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.395 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2B0C078, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.398 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2B0F748, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.406 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2B736E0, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.472 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2BD76B0, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.546 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2CAEEB8, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.676 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2D228B8, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.762 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2DFA0C0, reading WAL from 0/2B0C040. 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:49.908 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2ED1888, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.060 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.166 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.166 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/2F45258, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.166 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.167 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.167 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.167 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/301CA80, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.324 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/3090488, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.436 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/3103E80, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.556 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/31EF008, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.733 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/3264968, reading WAL from 0/2B0C040. 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:50.863 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill DETAIL: Streaming transactions committing after 0/32DA2C8, reading WAL from 0/2B0C040. 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill LOG: logical decoding found consistent point at 0/2B0C040 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill DETAIL: There are no running transactions. 2024-12-18 07:23:51.008 UTC client backend[20481] pg_regress/spill STATEMENT: SELECT (regexp_split_to_array(data, ':'))[4] COLLATE "C", COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)] FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT' GROUP BY 1 ORDER BY 1; 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot LOG: logical decoding found consistent point at 0/34636F0 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_p', 'test_decoding'); 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot LOG: logical decoding found consistent point at 0/3463728 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.209 UTC client backend[20529] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_t', 'test_decoding', true); 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot LOG: logical decoding found consistent point at 0/3463760 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_p', 'test_decoding', false); 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot LOG: logical decoding found consistent point at 0/3463798 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_t2', 'test_decoding', true); 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot ERROR: could not access file "nonexistent": No such file or directory 2024-12-18 07:23:51.210 UTC client backend[20529] pg_regress/slot STATEMENT: SELECT pg_create_logical_replication_slot('foo', 'nonexistent'); 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot LOG: slot test looped 0 times 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot CONTEXT: PL/pgSQL function inline_code_block line 4 at RAISE 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot STATEMENT: do 'declare c int = 0; begin while (select count(*) from pg_replication_slots where active_pid = ' '20529' ') > 0 loop c := c + 1; perform pg_sleep(0.01); end loop; raise log ''slot test looped % times'', c; end'; 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot_t" does not exist 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_drop_replication_slot('regression_slot_t'); 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot_t2" does not exist 2024-12-18 07:23:51.218 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_drop_replication_slot('regression_slot_t2'); 2024-12-18 07:23:51.219 UTC client backend[20530] pg_regress/slot ERROR: replication slot "not_existing_slot" does not exist 2024-12-18 07:23:51.219 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT count(*) >= 0 AS ok FROM pg_ls_replslotdir('not_existing_slot'); 2024-12-18 07:23:51.220 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/3463808 2024-12-18 07:23:51.220 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.220 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot1', 'test_decoding', true); 2024-12-18 07:23:51.225 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.225 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.225 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot2', 'test_decoding', true); 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot1" 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/3463840, reading WAL from 0/3463808. 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot1', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/3463808 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.226 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot1', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot2" 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/346D798, reading WAL from 0/346D760. 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot2', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.227 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot2', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot1" 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/346D850, reading WAL from 0/346D760. 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT end_lsn FROM pg_replication_slot_advance('regression_slot1', '0/346D9C0') 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.229 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT end_lsn FROM pg_replication_slot_advance('regression_slot1', '0/346D9C0') 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot2" 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/346D850, reading WAL from 0/346D760. 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT slot_name FROM pg_replication_slot_advance('regression_slot2', pg_current_wal_lsn()); 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.230 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT slot_name FROM pg_replication_slot_advance('regression_slot2', pg_current_wal_lsn()); 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot1" 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/346D9C0, reading WAL from 0/346D760. 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot1', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.231 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot1', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot LOG: starting logical decoding for slot "regression_slot2" 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot DETAIL: Streaming transactions committing after 0/346DA78, reading WAL from 0/346D760. 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot2', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346D760 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.232 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot2', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.234 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot1" already exists 2024-12-18 07:23:51.234 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot1', 'test_decoding', true); 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot1" does not exist 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_drop_replication_slot('regression_slot1'); 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot2" does not exist 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_drop_replication_slot('regression_slot2'); 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot ERROR: invalid target WAL LSN 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_replication_slot_advance('regression_slot3', '0/0'); 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot ERROR: replication slot "regression_slot3" cannot be advanced 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot DETAIL: This slot has never previously reserved WAL, or it has been invalidated. 2024-12-18 07:23:51.235 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT pg_replication_slot_advance('regression_slot3', '0/1'); 2024-12-18 07:23:51.236 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346F840 2024-12-18 07:23:51.236 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.236 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('orig_slot1', 'test_decoding', false); 2024-12-18 07:23:51.241 UTC client backend[20530] pg_regress/slot ERROR: all replication slots are in use 2024-12-18 07:23:51.241 UTC client backend[20530] pg_regress/slot HINT: Free one or increase "max_replication_slots". 2024-12-18 07:23:51.241 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'copy' FROM pg_copy_logical_replication_slot('orig_slot1', 'failed'); 2024-12-18 07:23:51.242 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346F878 2024-12-18 07:23:51.242 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.242 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('orig_slot2', 'test_decoding', true); 2024-12-18 07:23:51.245 UTC client backend[20530] pg_regress/slot ERROR: cannot copy physical replication slot "orig_slot2" as a logical replication slot 2024-12-18 07:23:51.245 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'copy' FROM pg_copy_physical_replication_slot('orig_slot2', 'failed'); 2024-12-18 07:23:51.247 UTC client backend[20530] pg_regress/slot ERROR: cannot copy logical replication slot "orig_slot1" as a physical replication slot 2024-12-18 07:23:51.247 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'copy' FROM pg_copy_logical_replication_slot('orig_slot1', 'failed'); 2024-12-18 07:23:51.248 UTC client backend[20530] pg_regress/slot ERROR: cannot copy a replication slot that doesn't reserve WAL 2024-12-18 07:23:51.248 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'copy' FROM pg_copy_physical_replication_slot('orig_slot2', 'failed'); 2024-12-18 07:23:51.251 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346F8B0 2024-12-18 07:23:51.251 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.251 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('failover_true_slot', 'test_decoding', false, false, true); 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346F8E8 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('failover_false_slot', 'test_decoding', false, false, false); 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot LOG: logical decoding found consistent point at 0/346F920 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot DETAIL: There are no running transactions. 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('failover_default_slot', 'test_decoding', false, false); 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot ERROR: cannot enable failover for a temporary replication slot 2024-12-18 07:23:51.252 UTC client backend[20530] pg_regress/slot STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('failover_true_temp_slot', 'test_decoding', true, false, true); 2024-12-18 07:23:51.261 UTC client backend[20533] pg_regress/truncate LOG: logical decoding found consistent point at 0/346F958 2024-12-18 07:23:51.261 UTC client backend[20533] pg_regress/truncate DETAIL: There are no running transactions. 2024-12-18 07:23:51.261 UTC client backend[20533] pg_regress/truncate STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate DETAIL: Streaming transactions committing after 0/346F990, reading WAL from 0/346F958. 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate LOG: logical decoding found consistent point at 0/346F958 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate DETAIL: There are no running transactions. 2024-12-18 07:23:51.268 UTC client backend[20533] pg_regress/truncate STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.277 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.277 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.277 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2024-12-18 07:23:51.279 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.279 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/34786F8, reading WAL from 0/34786C0. 2024-12-18 07:23:51.279 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.280 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.280 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.280 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/347BD80, reading WAL from 0/34786C0. 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.283 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/348E840, reading WAL from 0/34786C0. 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.285 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/348E9F8, reading WAL from 0/34786C0. 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.288 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/34A0DC0, reading WAL from 0/34786C0. 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.291 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream DETAIL: Streaming transactions committing after 0/34B42F8, reading WAL from 0/34786C0. 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream LOG: logical decoding found consistent point at 0/34786C0 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.295 UTC client backend[20536] pg_regress/stream STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.306 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC430 2024-12-18 07:23:51.306 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.306 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_stats1', 'test_decoding') s1, pg_create_logical_replication_slot('regression_slot_stats2', 'test_decoding') s2, pg_create_logical_replication_slot('regression_slot_stats3', 'test_decoding') s3; 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC468 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_stats1', 'test_decoding') s1, pg_create_logical_replication_slot('regression_slot_stats2', 'test_decoding') s2, pg_create_logical_replication_slot('regression_slot_stats3', 'test_decoding') s3; 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC4A0 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.307 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot_stats1', 'test_decoding') s1, pg_create_logical_replication_slot('regression_slot_stats2', 'test_decoding') s2, pg_create_logical_replication_slot('regression_slot_stats3', 'test_decoding') s3; 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats LOG: starting logical decoding for slot "regression_slot_stats1" 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats DETAIL: Streaming transactions committing after 0/34EC468, reading WAL from 0/34EC430. 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats1', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC430 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.310 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats1', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats LOG: starting logical decoding for slot "regression_slot_stats2" 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats DETAIL: Streaming transactions committing after 0/34EC4A0, reading WAL from 0/34EC468. 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats2', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC468 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.311 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats2', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats LOG: starting logical decoding for slot "regression_slot_stats3" 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats DETAIL: Streaming transactions committing after 0/34EC4D8, reading WAL from 0/34EC4A0. 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats3', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC4A0 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.312 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot_stats3', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.319 UTC client backend[20539] pg_regress/stats ERROR: replication slot "do-not-exist" does not exist 2024-12-18 07:23:51.319 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT pg_stat_reset_replication_slot('do-not-exist'); 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats LOG: starting logical decoding for slot "regression_slot_stats1" 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats DETAIL: Streaming transactions committing after 0/34EFC90, reading WAL from 0/34EC4A0. 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_peek_changes('regression_slot_stats1', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats LOG: logical decoding found consistent point at 0/34EC4A0 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats DETAIL: There are no running transactions. 2024-12-18 07:23:51.325 UTC client backend[20539] pg_regress/stats STATEMENT: SELECT count(*) FROM pg_logical_slot_peek_changes('regression_slot_stats1', NULL, NULL, 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.378 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.378 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.378 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding', false, true); 2024-12-18 07:23:51.383 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.383 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/3555360, reading WAL from 0/3555328. 2024-12-18 07:23:51.383 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355A438, reading WAL from 0/3555328. 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.384 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355A698, reading WAL from 0/3555328. 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.385 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355A6E0, reading WAL from 0/3555328. 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.386 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355A860, reading WAL from 0/3555328. 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.387 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.391 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.391 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355A8A8, reading WAL from 0/3555328. 2024-12-18 07:23:51.391 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.392 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.392 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.392 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355D020, reading WAL from 0/3555328. 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.393 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355D130, reading WAL from 0/3555328. 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.394 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355D460, reading WAL from 0/3555328. 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.395 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.402 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.402 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/355D5C0, reading WAL from 0/3555328. 2024-12-18 07:23:51.402 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.403 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.403 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.403 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/3568280, reading WAL from 0/3555328. 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.404 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/3568CC8, reading WAL from 0/3555328. 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.406 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.407 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.407 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356A9A8, reading WAL from 0/3555328. 2024-12-18 07:23:51.407 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.408 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.408 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.408 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356AB60, reading WAL from 0/3555328. 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.409 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356ACE8, reading WAL from 0/3555328. 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.410 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356AD38, reading WAL from 0/3555328. 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.419 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT count(*) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356F258, reading WAL from 0/3555328. 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.421 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase DETAIL: Streaming transactions committing after 0/356F2A8, reading WAL from 0/3555328. 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase LOG: logical decoding found consistent point at 0/3555328 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase DETAIL: There are no running transactions. 2024-12-18 07:23:51.426 UTC client backend[20542] pg_regress/twophase STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.435 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.435 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.435 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding', false, true); 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream DETAIL: Streaming transactions committing after 0/3574530, reading WAL from 0/35744F8. 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.438 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream DETAIL: Streaming transactions committing after 0/3577C48, reading WAL from 0/35744F8. 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.442 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream DETAIL: Streaming transactions committing after 0/358A7D8, reading WAL from 0/35744F8. 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.443 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream DETAIL: Streaming transactions committing after 0/358A818, reading WAL from 0/35744F8. 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.447 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream LOG: starting logical decoding for slot "regression_slot" 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream DETAIL: Streaming transactions committing after 0/359F378, reading WAL from 0/35744F8. 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream LOG: logical decoding found consistent point at 0/35744F8 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream DETAIL: There are no running transactions. 2024-12-18 07:23:51.448 UTC client backend[20545] pg_regress/twophase_stream STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-12-18 07:23:51.453 UTC postmaster[20343] LOG: received fast shutdown request 2024-12-18 07:23:51.453 UTC postmaster[20343] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2896, PID: 20343 0xaa4ae2 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89fc67 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89e169 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres 0x89d544 at /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres