2025-12-28 15:07:40.526 UTC postmaster[25915] LOG: starting PostgreSQL 19devel on x86_64-netbsd, compiled by gcc-10.5.0, 64-bit 2025-12-28 15:07:40.526 UTC postmaster[25915] LOG: listening on Unix socket "/tmp/pg_regress-4N2DQM/.s.PGSQL.40050" 2025-12-28 15:07:40.535 UTC startup[10236] LOG: database system was shut down at 2025-12-28 15:01:08 UTC 2025-12-28 15:07:40.538 UTC client backend[24285] [unknown] FATAL: the database system is starting up 2025-12-28 15:07:40.550 UTC postmaster[25915] LOG: database system is ready to accept connections 2025-12-28 15:07:40.749 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2808 2025-12-28 15:07:40.749 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.749 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:40.750 UTC client backend[12639] pg_regress/ddl ERROR: replication slot "regression_slot" already exists 2025-12-28 15:07:40.750 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:40.750 UTC client backend[12639] pg_regress/ddl ERROR: replication slot name "Invalid Name" contains invalid character 2025-12-28 15:07:40.750 UTC client backend[12639] pg_regress/ddl HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. 2025-12-28 15:07:40.750 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('Invalid Name', 'test_decoding'); 2025-12-28 15:07:40.751 UTC client backend[12639] pg_regress/ddl ERROR: could not parse value "frakbar" for parameter "include-xids" 2025-12-28 15:07:40.751 UTC client backend[12639] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2025-12-28 15:07:40.751 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', 'frakbar'); 2025-12-28 15:07:40.752 UTC client backend[12639] pg_regress/ddl ERROR: option "nonexistent-option" = "frakbar" is unknown 2025-12-28 15:07:40.752 UTC client backend[12639] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2025-12-28 15:07:40.752 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'nonexistent-option', 'frakbar'); 2025-12-28 15:07:40.753 UTC client backend[12639] pg_regress/ddl ERROR: could not parse value "frakbar" for parameter "include-xids" 2025-12-28 15:07:40.753 UTC client backend[12639] pg_regress/ddl CONTEXT: slot "regression_slot", output plugin "test_decoding", in the startup callback 2025-12-28 15:07:40.753 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', 'frakbar'); 2025-12-28 15:07:40.754 UTC client backend[12639] pg_regress/ddl ERROR: replication slot "regression_slot" does not exist 2025-12-28 15:07:40.754 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT pg_drop_replication_slot('regression_slot'); 2025-12-28 15:07:40.755 UTC client backend[12639] pg_regress/ddl ERROR: cannot use physical replication slot for logical decoding 2025-12-28 15:07:40.755 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('repl', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.757 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.757 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.757 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BE2878, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.777 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BE81D0, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.796 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.803 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.803 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BEB760, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.803 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.804 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.804 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.804 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:40.809 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.809 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BEC0B8, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.809 UTC client backend[12639] 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'); 2025-12-28 15:07:40.809 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.809 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.809 UTC client backend[12639] 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'); 2025-12-28 15:07:40.816 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.816 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BED478, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.816 UTC client backend[12639] 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'); 2025-12-28 15:07:40.816 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.816 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.816 UTC client backend[12639] 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'); 2025-12-28 15:07:40.832 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.832 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BEDD80, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.832 UTC client backend[12639] 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'); 2025-12-28 15:07:40.833 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.833 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.833 UTC client backend[12639] 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'); 2025-12-28 15:07:40.837 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:40.837 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BF91F0, reading WAL from 0/01BE2840. 2025-12-28 15:07:40.837 UTC client backend[12639] 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'); 2025-12-28 15:07:40.838 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:40.838 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:40.838 UTC client backend[12639] 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'); 2025-12-28 15:07:41.009 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.009 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01BF9398, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.009 UTC client backend[12639] 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; 2025-12-28 15:07:41.010 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.010 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.010 UTC client backend[12639] 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; 2025-12-28 15:07:41.251 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.251 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01EB9C30, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.251 UTC client backend[12639] 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'; 2025-12-28 15:07:41.251 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.251 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.251 UTC client backend[12639] 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'; 2025-12-28 15:07:41.470 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.470 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/01F4ED78, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.470 UTC client backend[12639] 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); 2025-12-28 15:07:41.470 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.470 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.470 UTC client backend[12639] 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); 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/02031640, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.593 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:41.711 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.711 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/020382E0, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.711 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:41.712 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.712 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.712 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:41.888 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:41.888 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/020387E0, reading WAL from 0/01BE2840. 2025-12-28 15:07:41.888 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:41.889 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:41.889 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:41.889 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/02038A80, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.033 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/02038C60, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.155 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.350 UTC client backend[12639] pg_regress/ddl ERROR: cannot rewrite table "replication_metadata" used as a catalog table 2025-12-28 15:07:42.350 UTC client backend[12639] pg_regress/ddl STATEMENT: ALTER TABLE replication_metadata ALTER COLUMN rewritemeornot TYPE text; 2025-12-28 15:07:42.376 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.376 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/02043FC8, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.376 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.377 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.377 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.377 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.538 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.538 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/0204C0F0, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.538 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.539 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.539 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.539 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/02076F70, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.676 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl DETAIL: Streaming transactions committing after 0/0207DD20, reading WAL from 0/01BE2840. 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl LOG: logical decoding found consistent point at 0/01BE2840 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl DETAIL: There are no running transactions. 2025-12-28 15:07:42.799 UTC client backend[12639] pg_regress/ddl STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.046 UTC client backend[22693] pg_regress/xact LOG: logical decoding found consistent point at 0/0207DD58 2025-12-28 15:07:43.046 UTC client backend[22693] pg_regress/xact DETAIL: There are no running transactions. 2025-12-28 15:07:43.046 UTC client backend[22693] pg_regress/xact STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact DETAIL: Streaming transactions committing after 0/0207DD90, reading WAL from 0/0207DD58. 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact LOG: logical decoding found consistent point at 0/0207DD58 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact DETAIL: There are no running transactions. 2025-12-28 15:07:43.072 UTC client backend[22693] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.076 UTC client backend[22693] pg_regress/xact LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:43.076 UTC client backend[22693] pg_regress/xact DETAIL: Streaming transactions committing after 0/020816C0, reading WAL from 0/0207DD58. 2025-12-28 15:07:43.076 UTC client backend[22693] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.077 UTC client backend[22693] pg_regress/xact LOG: logical decoding found consistent point at 0/0207DD58 2025-12-28 15:07:43.077 UTC client backend[22693] pg_regress/xact DETAIL: There are no running transactions. 2025-12-28 15:07:43.077 UTC client backend[22693] pg_regress/xact STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.164 UTC client backend[22105] pg_regress/rewrite LOG: logical decoding found consistent point at 0/0208DB70 2025-12-28 15:07:43.164 UTC client backend[22105] pg_regress/rewrite DETAIL: There are no running transactions. 2025-12-28 15:07:43.164 UTC client backend[22105] pg_regress/rewrite STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:43.169 UTC client backend[22105] pg_regress/rewrite LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:43.169 UTC client backend[22105] pg_regress/rewrite DETAIL: Streaming transactions committing after 0/0208DBA8, reading WAL from 0/0208DB70. 2025-12-28 15:07:43.169 UTC client backend[22105] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.170 UTC client backend[22105] pg_regress/rewrite LOG: logical decoding found consistent point at 0/0208DB70 2025-12-28 15:07:43.170 UTC client backend[22105] pg_regress/rewrite DETAIL: There are no running transactions. 2025-12-28 15:07:43.170 UTC client backend[22105] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.568 UTC checkpointer[12124] LOG: checkpoint starting: fast force wait 2025-12-28 15:07:43.591 UTC checkpointer[12124] LOG: checkpoint complete: wrote 913 buffers (5.6%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.020 s, sync=0.001 s, total=0.023 s; sync files=0, longest=0.000 s, average=0.000 s; distance=12201 kB, estimate=12201 kB; lsn=0/02374570, redo lsn=0/02374518 2025-12-28 15:07:43.592 UTC client backend[22105] pg_regress/rewrite LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:43.592 UTC client backend[22105] pg_regress/rewrite DETAIL: Streaming transactions committing after 0/020924F8, reading WAL from 0/0208DB70. 2025-12-28 15:07:43.592 UTC client backend[22105] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.593 UTC client backend[22105] pg_regress/rewrite LOG: logical decoding found consistent point at 0/0208DB70 2025-12-28 15:07:43.593 UTC client backend[22105] pg_regress/rewrite DETAIL: There are no running transactions. 2025-12-28 15:07:43.593 UTC client backend[22105] pg_regress/rewrite STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); TRAP: failed Assert("record->xl_tot_len >= SizeOfXLogRecord"), File: "../src/backend/access/transam/xlogreader.c", Line: 1237, PID: 22105 0x934e4f at postgres 0x5721f2 at postgres 0x573f53 at postgres 0x574382 at postgres 0x57440b at postgres 0x784d1f at postgres 0x64e823 at postgres 0x6612cf at postgres 0x64f064 at postgres 0x643a4d at postgres 0x804cfc at postgres 0x806137 at postgres 0x801ef9 at postgres 0x803caa at postgres 0x7fe2d0 at postgres 0x753290 at postgres 0x756d16 at postgres 0x758839 at postgres 0xab8c3c at postgres 2025-12-28 15:07:43.756 UTC postmaster[25915] LOG: client backend (PID 22105) was terminated by signal 6: Abort trap 2025-12-28 15:07:43.756 UTC postmaster[25915] DETAIL: Failed process was running: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:43.756 UTC postmaster[25915] LOG: terminating any other active server processes 2025-12-28 15:07:43.764 UTC client backend[12450] [unknown] FATAL: the database system is in recovery mode 2025-12-28 15:07:43.765 UTC postmaster[25915] LOG: all server processes terminated; reinitializing 2025-12-28 15:07:43.842 UTC startup[12625] LOG: database system was interrupted; last known up at 2025-12-28 15:07:43 UTC 2025-12-28 15:07:43.843 UTC startup[12625] LOG: database system was not properly shut down; automatic recovery in progress 2025-12-28 15:07:43.877 UTC startup[12625] LOG: redo starts at 0/02374518 2025-12-28 15:07:43.877 UTC startup[12625] LOG: invalid record length at 0/023745F0: expected at least 24, got 0 2025-12-28 15:07:43.877 UTC startup[12625] LOG: redo done at 0/02374570 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2025-12-28 15:07:43.933 UTC checkpointer[8831] LOG: checkpoint starting: end-of-recovery fast wait 2025-12-28 15:07:43.936 UTC checkpointer[8831] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 3 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.003 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/02374570, redo lsn=0/02374570 2025-12-28 15:07:43.942 UTC postmaster[25915] LOG: database system is ready to accept connections 2025-12-28 15:07:44.083 UTC client backend[9382] pg_regress/permissions ERROR: replication slot "regression_slot" already exists 2025-12-28 15:07:44.083 UTC client backend[9382] pg_regress/permissions STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('regression_slot', 'test_decoding'); 2025-12-28 15:07:44.085 UTC client backend[9382] pg_regress/permissions LOG: starting logical decoding for slot "regression_slot" 2025-12-28 15:07:44.085 UTC client backend[9382] pg_regress/permissions DETAIL: Streaming transactions committing after 0/020924F8, reading WAL from 0/0208DB70. 2025-12-28 15:07:44.085 UTC client backend[9382] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:44.099 UTC client backend[9382] pg_regress/permissions LOG: logical decoding found consistent point at 0/0208DB70 2025-12-28 15:07:44.099 UTC client backend[9382] pg_regress/permissions DETAIL: There are no running transactions. 2025-12-28 15:07:44.099 UTC client backend[9382] pg_regress/permissions STATEMENT: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:44.337 UTC postmaster[25915] LOG: client backend (PID 9382) was terminated by signal 11: Segmentation fault 2025-12-28 15:07:44.337 UTC postmaster[25915] DETAIL: Failed process was running: SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2025-12-28 15:07:44.337 UTC postmaster[25915] LOG: terminating any other active server processes 2025-12-28 15:07:44.342 UTC postmaster[25915] LOG: all server processes terminated; reinitializing 2025-12-28 15:07:44.371 UTC startup[27174] LOG: database system was interrupted; last known up at 2025-12-28 15:07:43 UTC 2025-12-28 15:07:44.372 UTC startup[27174] LOG: record with incorrect prev-link 0/02374570 at 0/02374570 2025-12-28 15:07:44.372 UTC startup[27174] LOG: invalid checkpoint record 2025-12-28 15:07:44.372 UTC startup[27174] PANIC: could not locate a valid checkpoint record at 0/02374570 2025-12-28 15:07:44.397 UTC client backend[9604] [unknown] FATAL: the database system is in recovery mode 2025-12-28 15:07:44.527 UTC client backend[26367] [unknown] FATAL: the database system is in recovery mode 2025-12-28 15:07:44.541 UTC postmaster[25915] LOG: startup process (PID 27174) was terminated by signal 6: Abort trap 2025-12-28 15:07:44.541 UTC postmaster[25915] LOG: aborting startup due to startup process failure 2025-12-28 15:07:44.575 UTC postmaster[25915] LOG: database system is shut down