2024-11-14 22:01:10.938 GMT postmaster[5364] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-14 22:01:10.939 GMT postmaster[5364] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40045" 2024-11-14 22:01:10.991 GMT startup[1500] LOG: database system was shut down at 2024-11-14 21:57:22 GMT 2024-11-14 22:01:11.035 GMT client backend[7724] [unknown] FATAL: the database system is starting up 2024-11-14 22:01:11.036 GMT postmaster[5364] LOG: database system is ready to accept connections 2024-11-14 22:01:12.316 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-14 22:01:12.316 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.316 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BA98A8, reading WAL from 0/1BA9870. 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.319 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BA98A8, reading WAL from 0/1BA9870. 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.329 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.343 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-14 22:01:12.343 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.343 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BBB508, reading WAL from 0/1BBB4D0. 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.345 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BBB508, reading WAL from 0/1BBB4D0. 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:12.354 GMT client backend[1160] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.818 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-14 22:01:12.818 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-14 22:01:12.818 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:12.963 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-14 22:01:12.963 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:12.963 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD670, reading WAL from 0/1BCD5D0. 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:12.975 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD670, reading WAL from 0/1BCD5D0. 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:12.979 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD758, reading WAL from 0/1BCD670. 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD670 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:12.986 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD758, reading WAL from 0/1BCD670. 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD670 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:12.988 GMT client backend[5992] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.390 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found initial starting point at 0/1BD3988 2024-11-14 22:01:13.390 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 766 to end. 2024-11-14 22:01:13.390 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:13.575 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found initial consistent point at 0/1BD3D30 2024-11-14 22:01:13.575 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 767 to end. 2024-11-14 22:01:13.575 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:13.795 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3D98 2024-11-14 22:01:13.795 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: There are no old transactions anymore. 2024-11-14 22:01:13.795 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:13.800 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:13.882 GMT checkpointer[4108] LOG: checkpoint complete: wrote 956 buffers (5.8%), wrote 4 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.077 s, sync=0.001 s, total=0.082 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4552 kB, estimate=4552 kB; lsn=0/1BD3FD0, redo lsn=0/1BD3F78 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Streaming transactions committing after 0/1BD3DD0, reading WAL from 0/1BD3988. 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found initial starting point at 0/1BD3988 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 766 to end. 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found initial consistent point at 0/1BD3D30 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 767 to end. 2024-11-14 22:01:13.911 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.913 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3D98 2024-11-14 22:01:13.913 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: There are no old transactions anymore. 2024-11-14 22:01:13.913 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: Streaming transactions committing after 0/1BD4060, reading WAL from 0/1BD3F98. 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3F98 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:13.922 GMT client backend[3212] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-14 22:01:14.511 GMT client backend[6100] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-14 22:01:14.511 GMT client backend[6100] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:14.511 GMT client backend[6100] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:14.515 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.520 GMT checkpointer[4108] LOG: checkpoint complete: wrote 23 buffers (0.1%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=140 kB, estimate=4110 kB; lsn=0/1BF7370, redo lsn=0/1BF72E0 2024-11-14 22:01:14.522 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.522 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BF7008, reading WAL from 0/1BF6FD0. 2024-11-14 22:01:14.522 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.523 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-14 22:01:14.523 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.523 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.548 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.553 GMT checkpointer[4108] LOG: checkpoint complete: wrote 3 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.005 s; sync files=0, longest=0.000 s, average=0.000 s; distance=11 kB, estimate=3700 kB; lsn=0/1BFA050, redo lsn=0/1BF9FE0 2024-11-14 22:01:14.555 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.555 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BF73E8, reading WAL from 0/1BF6FD0. 2024-11-14 22:01:14.555 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.556 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-14 22:01:14.556 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.556 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.566 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.566 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BFA0C8, reading WAL from 0/1BF7330. 2024-11-14 22:01:14.566 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.567 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF7330 2024-11-14 22:01:14.567 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:14.567 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.590 GMT client backend[6100] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-14 22:01:14.590 GMT client backend[6100] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:14.590 GMT client backend[6100] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:14.600 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.620 GMT checkpointer[4108] LOG: checkpoint complete: wrote 16 buffers (0.1%), wrote 1 SLRU buffers; 1 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.020 s; sync files=0, longest=0.000 s, average=0.000 s; distance=114 kB, estimate=3342 kB; lsn=0/1C16AD0, redo lsn=0/1C16A38 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C164E8, reading WAL from 0/1C164B0. 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.621 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.625 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.628 GMT checkpointer[4108] LOG: checkpoint complete: wrote 2 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=4 kB, estimate=3008 kB; lsn=0/1C17C88, redo lsn=0/1C17BF8 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C16B48, reading WAL from 0/1C164B0. 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.630 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.634 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.638 GMT checkpointer[4108] LOG: checkpoint complete: wrote 0 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=2707 kB; lsn=0/1C17DD0, redo lsn=0/1C17D78 2024-11-14 22:01:14.639 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.639 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C17D00, reading WAL from 0/1C164B0. 2024-11-14 22:01:14.639 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.640 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-14 22:01:14.640 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.640 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.644 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.644 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C17E48, reading WAL from 0/1C16A90. 2024-11-14 22:01:14.644 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.645 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C16A90 2024-11-14 22:01:14.645 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:14.645 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.658 GMT client backend[6100] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1C36090 2024-11-14 22:01:14.658 GMT client backend[6100] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:14.658 GMT client backend[6100] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:14.660 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.702 GMT checkpointer[4108] LOG: checkpoint complete: wrote 17 buffers (0.1%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.040 s, sync=0.001 s, total=0.042 s; sync files=0, longest=0.000 s, average=0.000 s; distance=120 kB, estimate=2449 kB; lsn=0/1C36198, redo lsn=0/1C36138 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C360C8, reading WAL from 0/1C36090. 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36090 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.703 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.706 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:14.709 GMT checkpointer[4108] LOG: checkpoint complete: wrote 4 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=8 kB, estimate=2205 kB; lsn=0/1C38440, redo lsn=0/1C383E8 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C36210, reading WAL from 0/1C36090. 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36090 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:14.711 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C384B8, reading WAL from 0/1C36158. 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36158 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:14.742 GMT client backend[3004] isolation/catalog_change_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:15.035 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C5C108 2024-11-14 22:01:15.035 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.035 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C5C140, reading WAL from 0/1C5C108. 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C5C108 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.063 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.075 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C6C810 2024-11-14 22:01:15.075 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.075 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.112 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.112 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C6C848, reading WAL from 0/1C6C810. 2024-11-14 22:01:15.112 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.113 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C6C810 2024-11-14 22:01:15.113 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.113 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.122 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C75700 2024-11-14 22:01:15.122 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.122 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C75738, reading WAL from 0/1C75700. 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C75700 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.139 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.149 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C88140 2024-11-14 22:01:15.149 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.149 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.180 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.180 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C88178, reading WAL from 0/1C88140. 2024-11-14 22:01:15.180 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.181 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C88140 2024-11-14 22:01:15.181 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.181 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.192 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C9B248 2024-11-14 22:01:15.192 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.192 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C9B280, reading WAL from 0/1C9B248. 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C9B248 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.206 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.216 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CA1EE0 2024-11-14 22:01:15.216 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.216 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.242 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.242 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CA1F18, reading WAL from 0/1CA1EE0. 2024-11-14 22:01:15.242 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.243 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CA1EE0 2024-11-14 22:01:15.243 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.243 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.254 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CB7898 2024-11-14 22:01:15.254 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.254 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.315 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.315 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CB78D0, reading WAL from 0/1CB7898. 2024-11-14 22:01:15.315 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.317 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CB7898 2024-11-14 22:01:15.317 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.317 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.327 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CC0D60 2024-11-14 22:01:15.327 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.327 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.349 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.349 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CC0D98, reading WAL from 0/1CC0D60. 2024-11-14 22:01:15.349 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.351 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CC0D60 2024-11-14 22:01:15.351 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.351 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.363 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CDAB40 2024-11-14 22:01:15.363 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.363 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CDAB78, reading WAL from 0/1CDAB40. 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CDAB40 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.376 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.390 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CE8038 2024-11-14 22:01:15.390 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.390 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.413 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.413 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CE8070, reading WAL from 0/1CE8038. 2024-11-14 22:01:15.413 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.414 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CE8038 2024-11-14 22:01:15.414 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.414 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.428 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CFE2B0 2024-11-14 22:01:15.428 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.428 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.431 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-14 22:01:15.431 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-14 22:01:15.431 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl2 ALTER COLUMN val2 TYPE boolean; 2024-11-14 22:01:15.432 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.432 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CFE2E8, reading WAL from 0/1CFE2B0. 2024-11-14 22:01:15.432 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.433 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CFE2B0 2024-11-14 22:01:15.433 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.433 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.443 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D026F8 2024-11-14 22:01:15.443 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.443 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.446 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-14 22:01:15.446 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-14 22:01:15.446 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl2 ALTER COLUMN val2 TYPE boolean; 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl1 ALTER COLUMN val2 TYPE boolean; 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D02730, reading WAL from 0/1D026F8. 2024-11-14 22:01:15.451 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.452 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D026F8 2024-11-14 22:01:15.452 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.452 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.460 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D06BA0 2024-11-14 22:01:15.460 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.460 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D06BD8, reading WAL from 0/1D06BA0. 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D06BA0 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.465 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.476 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D0B590 2024-11-14 22:01:15.476 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.476 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D0B5C8, reading WAL from 0/1D0B590. 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D0B590 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.481 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.492 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D110F0 2024-11-14 22:01:15.492 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.492 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.496 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.496 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D11128, reading WAL from 0/1D110F0. 2024-11-14 22:01:15.496 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.497 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D110F0 2024-11-14 22:01:15.497 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.497 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.514 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D158D8 2024-11-14 22:01:15.514 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.514 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.519 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.519 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D15910, reading WAL from 0/1D158D8. 2024-11-14 22:01:15.519 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.520 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D158D8 2024-11-14 22:01:15.520 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.520 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.538 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D1A5F8 2024-11-14 22:01:15.538 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.538 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.548 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.548 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D1A630, reading WAL from 0/1D1A5F8. 2024-11-14 22:01:15.548 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.549 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D1A5F8 2024-11-14 22:01:15.549 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.549 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.559 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D21C50 2024-11-14 22:01:15.559 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.559 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D21C88, reading WAL from 0/1D21C50. 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D21C50 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.569 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.579 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D293F0 2024-11-14 22:01:15.579 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.579 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D29428, reading WAL from 0/1D293F0. 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D293F0 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.594 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.614 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D2E240 2024-11-14 22:01:15.614 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.614 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.641 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.641 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D2E278, reading WAL from 0/1D2E240. 2024-11-14 22:01:15.641 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.642 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D2E240 2024-11-14 22:01:15.642 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.642 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.652 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-14 22:01:15.652 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.652 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D32DA8, reading WAL from 0/1D32D70. 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.673 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D33468, reading WAL from 0/1D32D70. 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.713 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D35BB0, reading WAL from 0/1D32D70. 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.722 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.731 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D3DE60 2024-11-14 22:01:15.731 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.731 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D3DE98, reading WAL from 0/1D3DE60. 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D3DE60 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.774 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.786 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D456D8 2024-11-14 22:01:15.786 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.786 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.830 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.830 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D45710, reading WAL from 0/1D456D8. 2024-11-14 22:01:15.830 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.832 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D456D8 2024-11-14 22:01:15.832 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.832 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.850 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D4CFE0 2024-11-14 22:01:15.850 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.850 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D4D018, reading WAL from 0/1D4CFE0. 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D4CFE0 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.875 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.888 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D54B30 2024-11-14 22:01:15.888 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.888 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D54B68, reading WAL from 0/1D54B30. 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D54B30 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.900 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.918 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D5CCD8 2024-11-14 22:01:15.918 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:15.918 GMT client backend[3688] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-14 22:01:15.933 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:15.933 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D5CD10, reading WAL from 0/1D5CCD8. 2024-11-14 22:01:15.933 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:15.934 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D5CCD8 2024-11-14 22:01:15.934 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:15.934 GMT client backend[2940] isolation/concurrent_ddl_dml/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.305 GMT client backend[4944] isolation/oldest_xmin/control connection LOG: logical decoding found consistent point at 0/1D618C0 2024-11-14 22:01:16.305 GMT client backend[4944] isolation/oldest_xmin/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:16.305 GMT client backend[4944] isolation/oldest_xmin/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- must be first write in xact DROP TYPE IF EXISTS basket; CREATE TYPE basket AS (apples integer, pears integer, mangos integer); DROP TABLE IF EXISTS harvest; CREATE TABLE harvest(fruits basket); 2024-11-14 22:01:16.323 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:16.349 GMT checkpointer[4108] LOG: checkpoint complete: wrote 78 buffers (0.5%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.027 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1217 kB, estimate=2106 kB; lsn=0/1D68BE0, redo lsn=0/1D68B88 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D618F8, reading WAL from 0/1D618C0. 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:16.352 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D68C58, reading WAL from 0/1D618C0. 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:16.360 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.365 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:16.365 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D68C58, reading WAL from 0/1D618C0. 2024-11-14 22:01:16.365 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.366 GMT client backend[7636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-14 22:01:16.366 GMT client backend[7636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:16.366 GMT client backend[7636] isolation/oldest_xmin/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.753 GMT client backend[7108] isolation/snapshot_transfer/control connection LOG: logical decoding found consistent point at 0/1D94AA8 2024-11-14 22:01:16.753 GMT client backend[7108] isolation/snapshot_transfer/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:16.753 GMT client backend[7108] isolation/snapshot_transfer/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- must be first write in xact DROP TABLE IF EXISTS dummy; CREATE TABLE dummy(i int); DROP TABLE IF EXISTS harvest; CREATE TABLE harvest(apples int, pears int); 2024-11-14 22:01:16.764 GMT client backend[5216] isolation/snapshot_transfer/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:16.764 GMT client backend[5216] isolation/snapshot_transfer/s0 DETAIL: Streaming transactions committing after 0/1D94AE0, reading WAL from 0/1D94AA8. 2024-11-14 22:01:16.764 GMT client backend[5216] isolation/snapshot_transfer/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.765 GMT client backend[5216] isolation/snapshot_transfer/s0 LOG: logical decoding found consistent point at 0/1D94AA8 2024-11-14 22:01:16.765 GMT client backend[5216] isolation/snapshot_transfer/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:16.765 GMT client backend[5216] isolation/snapshot_transfer/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.780 GMT client backend[7108] isolation/snapshot_transfer/control connection LOG: logical decoding found consistent point at 0/1DA7C88 2024-11-14 22:01:16.780 GMT client backend[7108] isolation/snapshot_transfer/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:16.780 GMT client backend[7108] isolation/snapshot_transfer/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- must be first write in xact DROP TABLE IF EXISTS dummy; CREATE TABLE dummy(i int); DROP TABLE IF EXISTS harvest; CREATE TABLE harvest(apples int, pears int); 2024-11-14 22:01:16.788 GMT client backend[5216] isolation/snapshot_transfer/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:16.788 GMT client backend[5216] isolation/snapshot_transfer/s0 DETAIL: Streaming transactions committing after 0/1DA7CC0, reading WAL from 0/1DA7C88. 2024-11-14 22:01:16.788 GMT client backend[5216] isolation/snapshot_transfer/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:16.789 GMT client backend[5216] isolation/snapshot_transfer/s0 LOG: logical decoding found consistent point at 0/1DA7C88 2024-11-14 22:01:16.789 GMT client backend[5216] isolation/snapshot_transfer/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:16.789 GMT client backend[5216] isolation/snapshot_transfer/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:17.273 GMT client backend[5572] isolation/subxact_without_top/control connection LOG: logical decoding found consistent point at 0/1DAC310 2024-11-14 22:01:17.273 GMT client backend[5572] isolation/subxact_without_top/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:17.273 GMT client backend[5572] isolation/subxact_without_top/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- must be first write in xact CREATE TABLE harvest(apples integer); CREATE OR REPLACE FUNCTION subxacts() returns void as $$ BEGIN FOR i in 1 .. 128 LOOP BEGIN INSERT INTO harvest VALUES (42); EXCEPTION WHEN OTHERS THEN RAISE; END; END LOOP; END; $$LANGUAGE 'plpgsql'; 2024-11-14 22:01:17.283 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:17.292 GMT checkpointer[4108] LOG: checkpoint complete: wrote 53 buffers (0.3%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.009 s; sync files=0, longest=0.000 s, average=0.000 s; distance=297 kB, estimate=1925 kB; lsn=0/1DB32A8, redo lsn=0/1DB3248 2024-11-14 22:01:17.300 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:17.303 GMT checkpointer[4108] LOG: checkpoint complete: wrote 2 buffers (0.0%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.004 s; sync files=0, longest=0.000 s, average=0.000 s; distance=17 kB, estimate=1734 kB; lsn=0/1DB77D0, redo lsn=0/1DB7778 2024-11-14 22:01:17.305 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:17.305 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DAC348, reading WAL from 0/1DAC310. 2024-11-14 22:01:17.305 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT null n FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY n; 2024-11-14 22:01:17.306 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DAC310 2024-11-14 22:01:17.306 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:17.306 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT null n FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY n; 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DB7848, reading WAL from 0/1DB3268. 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT null n FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY n; 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DB3268 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:17.317 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT null n FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY n; 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DB7848, reading WAL from 0/1DB3268. 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DB3268 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:17.321 GMT client backend[7308] isolation/subxact_without_top/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); 2024-11-14 22:01:17.694 GMT client backend[6228] isolation/concurrent_stream/control connection LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-14 22:01:17.694 GMT client backend[6228] isolation/concurrent_stream/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:17.694 GMT client backend[6228] isolation/concurrent_stream/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- consume DDL SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); CREATE OR REPLACE FUNCTION large_val() RETURNS bytea LANGUAGE SQL AS $$ select string_agg(sha256(g::text::bytea), '') from generate_series(1, 83000) g $$; 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection DETAIL: Streaming transactions committing after 0/1DBCD68, reading WAL from 0/1DBCD30. 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- consume DDL SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); CREATE OR REPLACE FUNCTION large_val() RETURNS bytea LANGUAGE SQL AS $$ select string_agg(sha256(g::text::bytea), '') from generate_series(1, 83000) g $$; 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection DETAIL: There are no running transactions. 2024-11-14 22:01:17.696 GMT client backend[6228] isolation/concurrent_stream/control connection STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); -- consume DDL SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); CREATE OR REPLACE FUNCTION large_val() RETURNS bytea LANGUAGE SQL AS $$ select string_agg(sha256(g::text::bytea), '') from generate_series(1, 83000) g $$; 2024-11-14 22:01:17.899 GMT client backend[3348] isolation/concurrent_stream/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:17.899 GMT client backend[3348] isolation/concurrent_stream/s1 DETAIL: Streaming transactions committing after 0/1DBCD68, reading WAL from 0/1DBCD30. 2024-11-14 22:01:17.899 GMT client backend[3348] isolation/concurrent_stream/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-11-14 22:01:17.901 GMT client backend[3348] isolation/concurrent_stream/s1 LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-14 22:01:17.901 GMT client backend[3348] isolation/concurrent_stream/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:17.901 GMT client backend[3348] isolation/concurrent_stream/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL,NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'stream-changes', '1'); 2024-11-14 22:01:18.316 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-14 22:01:18.316 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-14 22:01:18.316 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-14 22:01:18.508 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-14 22:01:18.508 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-14 22:01:18.508 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-14 22:01:18.726 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-14 22:01:18.726 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-14 22:01:18.726 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Streaming transactions committing after 0/20B2110, reading WAL from 0/20B1D90. 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-14 22:01:18.744 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.745 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-14 22:01:18.745 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-14 22:01:18.745 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Streaming transactions committing after 0/20B21C0, reading WAL from 0/20B1D90. 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-14 22:01:18.749 GMT client backend[7976] isolation/twophase_snapshot/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false', 'skip-empty-xacts', '1'); 2024-11-14 22:01:19.025 GMT client backend[2932] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B3F18 2024-11-14 22:01:19.025 GMT client backend[2932] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1082 to end. 2024-11-14 22:01:19.025 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.058 GMT client backend[2932] isolation/slot_creation_error/s2 ERROR: canceling statement due to user request 2024-11-14 22:01:19.058 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.064 GMT client backend[2932] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B3FB8 2024-11-14 22:01:19.064 GMT client backend[2932] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1083 to end. 2024-11-14 22:01:19.064 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.541 GMT client backend[2932] isolation/slot_creation_error/s2 LOG: logical decoding found consistent point at 0/20B4038 2024-11-14 22:01:19.541 GMT client backend[2932] isolation/slot_creation_error/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:19.541 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.549 GMT client backend[2932] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B4070 2024-11-14 22:01:19.549 GMT client backend[2932] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1084 to end. 2024-11-14 22:01:19.549 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.559 GMT client backend[2932] isolation/slot_creation_error/s2 FATAL: terminating connection due to administrator command 2024-11-14 22:01:19.559 GMT client backend[2932] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-14 22:01:19.736 GMT client backend[6692] isolation/skip_snapshot_restore/s0 LOG: logical decoding found consistent point at 0/20B5640 2024-11-14 22:01:19.736 GMT client backend[6692] isolation/skip_snapshot_restore/s0 DETAIL: There are no running transactions. 2024-11-14 22:01:19.736 GMT client backend[6692] isolation/skip_snapshot_restore/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot0', 'test_decoding'); 2024-11-14 22:01:19.742 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: logical decoding found initial starting point at 0/20B56B8 2024-11-14 22:01:19.742 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: Waiting for transactions (approximately 1) older than 1086 to end. 2024-11-14 22:01:19.742 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot1', 'test_decoding'); 2024-11-14 22:01:19.751 GMT checkpointer[4108] LOG: checkpoint starting: immediate force wait 2024-11-14 22:01:19.761 GMT checkpointer[4108] LOG: checkpoint complete: wrote 55 buffers (0.3%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 recycled; write=0.006 s, sync=0.001 s, total=0.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=3063 kB, estimate=3063 kB; lsn=0/20B5748, redo lsn=0/20B56F0 2024-11-14 22:01:19.779 GMT client backend[6900] isolation/skip_snapshot_restore/s2 LOG: starting logical decoding for slot "slot0" 2024-11-14 22:01:19.779 GMT client backend[6900] isolation/skip_snapshot_restore/s2 DETAIL: Streaming transactions committing after 0/20B5678, reading WAL from 0/20B5640. 2024-11-14 22:01:19.779 GMT client backend[6900] isolation/skip_snapshot_restore/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot0', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:19.780 GMT client backend[6900] isolation/skip_snapshot_restore/s2 LOG: logical decoding found consistent point at 0/20B5640 2024-11-14 22:01:19.780 GMT client backend[6900] isolation/skip_snapshot_restore/s2 DETAIL: There are no running transactions. 2024-11-14 22:01:19.780 GMT client backend[6900] isolation/skip_snapshot_restore/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot0', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:19.950 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B5890 2024-11-14 22:01:19.950 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:19.950 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot1', 'test_decoding'); 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: starting logical decoding for slot "slot0" 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: Streaming transactions committing after 0/20B57C0, reading WAL from 0/20B5640. 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot0', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B5640 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: There are no running transactions. 2024-11-14 22:01:19.958 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot0', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: starting logical decoding for slot "slot1" 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: Streaming transactions committing after 0/20B58C8, reading WAL from 0/20B56B8. 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot1', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B56B8 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-14 22:01:19.964 GMT client backend[3720] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('slot1', NULL, NULL, 'skip-empty-xacts', '1', 'include-xids', '0'); 2024-11-14 22:01:20.095 GMT postmaster[5364] LOG: received fast shutdown request 2024-11-14 22:01:20.095 GMT postmaster[5364] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 5364 abort() has been called