2024-11-27 10:07:46.766 GMT postmaster[7912] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-27 10:07:46.767 GMT postmaster[7912] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40045" 2024-11-27 10:07:46.824 GMT startup[4748] LOG: database system was shut down at 2024-11-27 10:04:17 GMT 2024-11-27 10:07:46.879 GMT client backend[1884] [unknown] FATAL: the database system is starting up 2024-11-27 10:07:46.894 GMT postmaster[7912] LOG: database system is ready to accept connections 2024-11-27 10:07:47.664 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-27 10:07:47.664 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.664 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:47.669 GMT client backend[436] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:47.669 GMT client backend[436] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BA98A8, reading WAL from 0/1BA9870. 2024-11-27 10:07:47.669 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.670 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-27 10:07:47.670 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.670 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BA98A8, reading WAL from 0/1BA9870. 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BA9870 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.685 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.727 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-27 10:07:47.727 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.727 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:47.729 GMT client backend[436] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:47.729 GMT client backend[436] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BBB508, reading WAL from 0/1BBB4D0. 2024-11-27 10:07:47.729 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.730 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-27 10:07:47.730 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.730 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 DETAIL: Streaming transactions committing after 0/1BBB508, reading WAL from 0/1BBB4D0. 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 LOG: logical decoding found consistent point at 0/1BBB4D0 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:47.739 GMT client backend[436] isolation/mxact/s0 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:47.997 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-27 10:07:47.997 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-27 10:07:47.997 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:48.014 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-27 10:07:48.014 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:48.014 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:48.016 GMT client backend[5256] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:48.016 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD670, reading WAL from 0/1BCD5D0. 2024-11-27 10:07:48.016 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:48.017 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD670, reading WAL from 0/1BCD5D0. 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found initial starting point at 0/1BCD5D0 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Waiting for transactions (approximately 1) older than 761 to end. 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD638 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:48.020 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.025 GMT client backend[5256] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:48.025 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD758, reading WAL from 0/1BCD670. 2024-11-27 10:07:48.025 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.026 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD670 2024-11-27 10:07:48.026 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:48.026 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: Streaming transactions committing after 0/1BCD758, reading WAL from 0/1BCD670. 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 LOG: logical decoding found consistent point at 0/1BCD670 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:48.027 GMT client backend[5256] isolation/delayed_startup/s2 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:48.592 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found initial starting point at 0/1BD3988 2024-11-27 10:07:48.592 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 766 to end. 2024-11-27 10:07:48.592 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:48.861 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found initial consistent point at 0/1BD3D30 2024-11-27 10:07:48.861 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 767 to end. 2024-11-27 10:07:48.861 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:49.064 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3D98 2024-11-27 10:07:49.064 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: There are no old transactions anymore. 2024-11-27 10:07:49.064 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:49.070 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.188 GMT checkpointer[1624] LOG: checkpoint complete: wrote 956 buffers (5.8%), wrote 4 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.112 s, sync=0.001 s, total=0.118 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-27 10:07:49.204 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.204 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Streaming transactions committing after 0/1BD3DD0, reading WAL from 0/1BD3988. 2024-11-27 10:07:49.204 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found initial starting point at 0/1BD3988 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 766 to end. 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found initial consistent point at 0/1BD3D30 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Waiting for transactions (approximately 1) older than 767 to end. 2024-11-27 10:07:49.205 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.206 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3D98 2024-11-27 10:07:49.206 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: There are no old transactions anymore. 2024-11-27 10:07:49.206 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.216 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.216 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: Streaming transactions committing after 0/1BD4060, reading WAL from 0/1BD3F98. 2024-11-27 10:07:49.216 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.217 GMT client backend[6396] isolation/ondisk_startup/s1 LOG: logical decoding found consistent point at 0/1BD3F98 2024-11-27 10:07:49.217 GMT client backend[6396] isolation/ondisk_startup/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.217 GMT client backend[6396] isolation/ondisk_startup/s1 STATEMENT: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); 2024-11-27 10:07:49.659 GMT client backend[7992] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-27 10:07:49.659 GMT client backend[7992] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:49.659 GMT client backend[7992] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:49.662 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.668 GMT checkpointer[1624] 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.006 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-27 10:07:49.670 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.670 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BF7008, reading WAL from 0/1BF6FD0. 2024-11-27 10:07:49.670 GMT client backend[6616] 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-27 10:07:49.671 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-27 10:07:49.671 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.671 GMT client backend[6616] 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-27 10:07:49.675 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.679 GMT checkpointer[1624] 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.004 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-27 10:07:49.680 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.680 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BF73E8, reading WAL from 0/1BF6FD0. 2024-11-27 10:07:49.680 GMT client backend[6616] 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-27 10:07:49.680 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF6FD0 2024-11-27 10:07:49.680 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.680 GMT client backend[6616] 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-27 10:07:49.685 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.685 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1BFA0C8, reading WAL from 0/1BF7330. 2024-11-27 10:07:49.685 GMT client backend[6616] 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-27 10:07:49.686 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1BF7330 2024-11-27 10:07:49.686 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:49.686 GMT client backend[6616] 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-27 10:07:49.700 GMT client backend[7992] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-27 10:07:49.700 GMT client backend[7992] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:49.700 GMT client backend[7992] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:49.704 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.724 GMT checkpointer[1624] LOG: checkpoint complete: wrote 16 buffers (0.1%), wrote 1 SLRU buffers; 1 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.001 s, total=0.021 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-27 10:07:49.726 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.726 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C164E8, reading WAL from 0/1C164B0. 2024-11-27 10:07:49.726 GMT client backend[6616] 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-27 10:07:49.726 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-27 10:07:49.726 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.726 GMT client backend[6616] 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-27 10:07:49.729 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.744 GMT checkpointer[1624] LOG: checkpoint complete: wrote 2 buffers (0.0%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.001 s, total=0.015 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-27 10:07:49.745 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.745 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C16B48, reading WAL from 0/1C164B0. 2024-11-27 10:07:49.745 GMT client backend[6616] 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-27 10:07:49.745 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-27 10:07:49.745 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.745 GMT client backend[6616] 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-27 10:07:49.749 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.752 GMT checkpointer[1624] LOG: checkpoint complete: wrote 0 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=0 kB, estimate=2707 kB; lsn=0/1C17DD0, redo lsn=0/1C17D78 2024-11-27 10:07:49.753 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.753 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C17D00, reading WAL from 0/1C164B0. 2024-11-27 10:07:49.753 GMT client backend[6616] 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-27 10:07:49.754 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C164B0 2024-11-27 10:07:49.754 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.754 GMT client backend[6616] 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-27 10:07:49.759 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.759 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C17E48, reading WAL from 0/1C16A90. 2024-11-27 10:07:49.759 GMT client backend[6616] 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-27 10:07:49.759 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C16A90 2024-11-27 10:07:49.759 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:49.759 GMT client backend[6616] 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-27 10:07:49.771 GMT client backend[7992] isolation/catalog_change_snapshot/s0 LOG: logical decoding found consistent point at 0/1C36090 2024-11-27 10:07:49.771 GMT client backend[7992] isolation/catalog_change_snapshot/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:49.771 GMT client backend[7992] isolation/catalog_change_snapshot/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:49.774 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.778 GMT checkpointer[1624] LOG: checkpoint complete: wrote 17 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=120 kB, estimate=2449 kB; lsn=0/1C36198, redo lsn=0/1C36138 2024-11-27 10:07:49.784 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.784 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C360C8, reading WAL from 0/1C36090. 2024-11-27 10:07:49.784 GMT client backend[6616] 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-27 10:07:49.784 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36090 2024-11-27 10:07:49.784 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.784 GMT client backend[6616] 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-27 10:07:49.787 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:49.793 GMT checkpointer[1624] LOG: checkpoint complete: wrote 4 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.006 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-27 10:07:49.794 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.794 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C36210, reading WAL from 0/1C36090. 2024-11-27 10:07:49.794 GMT client backend[6616] 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-27 10:07:49.795 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36090 2024-11-27 10:07:49.795 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:49.795 GMT client backend[6616] 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-27 10:07:49.802 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:49.802 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Streaming transactions committing after 0/1C384B8, reading WAL from 0/1C36158. 2024-11-27 10:07:49.802 GMT client backend[6616] 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-27 10:07:49.802 GMT client backend[6616] isolation/catalog_change_snapshot/s1 LOG: logical decoding found consistent point at 0/1C36158 2024-11-27 10:07:49.802 GMT client backend[6616] isolation/catalog_change_snapshot/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:49.802 GMT client backend[6616] 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-27 10:07:50.131 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C5C108 2024-11-27 10:07:50.131 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.131 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.173 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.173 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C5C140, reading WAL from 0/1C5C108. 2024-11-27 10:07:50.173 GMT client backend[1496] 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-27 10:07:50.174 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C5C108 2024-11-27 10:07:50.174 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.174 GMT client backend[1496] 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-27 10:07:50.188 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C6C810 2024-11-27 10:07:50.188 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.188 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.216 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.216 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C6C848, reading WAL from 0/1C6C810. 2024-11-27 10:07:50.216 GMT client backend[1496] 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-27 10:07:50.216 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C6C810 2024-11-27 10:07:50.216 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.216 GMT client backend[1496] 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-27 10:07:50.225 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C75700 2024-11-27 10:07:50.225 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.225 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.263 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.263 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C75738, reading WAL from 0/1C75700. 2024-11-27 10:07:50.263 GMT client backend[1496] 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-27 10:07:50.263 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C75700 2024-11-27 10:07:50.263 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.263 GMT client backend[1496] 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-27 10:07:50.273 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C88140 2024-11-27 10:07:50.273 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.273 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.315 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.315 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C88178, reading WAL from 0/1C88140. 2024-11-27 10:07:50.315 GMT client backend[1496] 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-27 10:07:50.316 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C88140 2024-11-27 10:07:50.316 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.316 GMT client backend[1496] 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-27 10:07:50.343 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1C9B248 2024-11-27 10:07:50.343 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.343 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.353 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.353 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1C9B280, reading WAL from 0/1C9B248. 2024-11-27 10:07:50.353 GMT client backend[1496] 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-27 10:07:50.353 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1C9B248 2024-11-27 10:07:50.353 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.353 GMT client backend[1496] 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-27 10:07:50.364 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CA1EE0 2024-11-27 10:07:50.364 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.364 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.390 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.390 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CA1F18, reading WAL from 0/1CA1EE0. 2024-11-27 10:07:50.390 GMT client backend[1496] 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-27 10:07:50.390 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CA1EE0 2024-11-27 10:07:50.390 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.390 GMT client backend[1496] 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-27 10:07:50.408 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CB7898 2024-11-27 10:07:50.408 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.408 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.429 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.429 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CB78D0, reading WAL from 0/1CB7898. 2024-11-27 10:07:50.429 GMT client backend[1496] 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-27 10:07:50.429 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CB7898 2024-11-27 10:07:50.429 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.429 GMT client backend[1496] 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-27 10:07:50.451 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CC0D60 2024-11-27 10:07:50.451 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.451 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.496 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.496 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CC0D98, reading WAL from 0/1CC0D60. 2024-11-27 10:07:50.496 GMT client backend[1496] 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-27 10:07:50.497 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CC0D60 2024-11-27 10:07:50.497 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.497 GMT client backend[1496] 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-27 10:07:50.522 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CDAB40 2024-11-27 10:07:50.522 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.522 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.536 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.536 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CDAB78, reading WAL from 0/1CDAB40. 2024-11-27 10:07:50.536 GMT client backend[1496] 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-27 10:07:50.536 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CDAB40 2024-11-27 10:07:50.536 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.536 GMT client backend[1496] 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-27 10:07:50.547 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CE8038 2024-11-27 10:07:50.547 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.547 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.610 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.610 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CE8070, reading WAL from 0/1CE8038. 2024-11-27 10:07:50.610 GMT client backend[1496] 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-27 10:07:50.611 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CE8038 2024-11-27 10:07:50.611 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.611 GMT client backend[1496] 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-27 10:07:50.627 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1CFE2B0 2024-11-27 10:07:50.627 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.627 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.630 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-27 10:07:50.630 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-27 10:07:50.630 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl2 ALTER COLUMN val2 TYPE boolean; 2024-11-27 10:07:50.631 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.631 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1CFE2E8, reading WAL from 0/1CFE2B0. 2024-11-27 10:07:50.631 GMT client backend[1496] 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-27 10:07:50.632 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1CFE2B0 2024-11-27 10:07:50.632 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.632 GMT client backend[1496] 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-27 10:07:50.640 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D026F8 2024-11-27 10:07:50.640 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.640 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.643 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-27 10:07:50.643 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-27 10:07:50.643 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl2 ALTER COLUMN val2 TYPE boolean; 2024-11-27 10:07:50.645 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 ERROR: column "val2" cannot be cast automatically to type boolean 2024-11-27 10:07:50.645 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 HINT: You might need to specify "USING val2::boolean". 2024-11-27 10:07:50.645 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 STATEMENT: ALTER TABLE tbl1 ALTER COLUMN val2 TYPE boolean; 2024-11-27 10:07:50.645 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.645 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D02730, reading WAL from 0/1D026F8. 2024-11-27 10:07:50.645 GMT client backend[1496] 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-27 10:07:50.646 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D026F8 2024-11-27 10:07:50.646 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.646 GMT client backend[1496] 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-27 10:07:50.654 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D06BA0 2024-11-27 10:07:50.654 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.654 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.658 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.658 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D06BD8, reading WAL from 0/1D06BA0. 2024-11-27 10:07:50.658 GMT client backend[1496] 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-27 10:07:50.659 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D06BA0 2024-11-27 10:07:50.659 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.659 GMT client backend[1496] 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-27 10:07:50.702 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D0B590 2024-11-27 10:07:50.702 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.702 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.709 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.709 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D0B5C8, reading WAL from 0/1D0B590. 2024-11-27 10:07:50.709 GMT client backend[1496] 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-27 10:07:50.709 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D0B590 2024-11-27 10:07:50.709 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.709 GMT client backend[1496] 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-27 10:07:50.727 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D110F0 2024-11-27 10:07:50.727 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.727 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.732 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.732 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D11128, reading WAL from 0/1D110F0. 2024-11-27 10:07:50.732 GMT client backend[1496] 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-27 10:07:50.732 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D110F0 2024-11-27 10:07:50.732 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.732 GMT client backend[1496] 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-27 10:07:50.741 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D158D8 2024-11-27 10:07:50.741 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.741 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.746 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.746 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D15910, reading WAL from 0/1D158D8. 2024-11-27 10:07:50.746 GMT client backend[1496] 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-27 10:07:50.746 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D158D8 2024-11-27 10:07:50.746 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.746 GMT client backend[1496] 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-27 10:07:50.762 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D1A5F8 2024-11-27 10:07:50.762 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.762 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.788 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.788 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D1A630, reading WAL from 0/1D1A5F8. 2024-11-27 10:07:50.788 GMT client backend[1496] 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-27 10:07:50.789 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D1A5F8 2024-11-27 10:07:50.789 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.789 GMT client backend[1496] 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-27 10:07:50.798 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D21C50 2024-11-27 10:07:50.798 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.798 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.805 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.805 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D21C88, reading WAL from 0/1D21C50. 2024-11-27 10:07:50.805 GMT client backend[1496] 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-27 10:07:50.805 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D21C50 2024-11-27 10:07:50.805 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.805 GMT client backend[1496] 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-27 10:07:50.815 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D293F0 2024-11-27 10:07:50.815 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.815 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.835 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.835 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D29428, reading WAL from 0/1D293F0. 2024-11-27 10:07:50.835 GMT client backend[1496] 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-27 10:07:50.835 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D293F0 2024-11-27 10:07:50.835 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.835 GMT client backend[1496] 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-27 10:07:50.845 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D2E240 2024-11-27 10:07:50.845 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.845 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.883 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.883 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D2E278, reading WAL from 0/1D2E240. 2024-11-27 10:07:50.883 GMT client backend[1496] 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-27 10:07:50.883 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D2E240 2024-11-27 10:07:50.883 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.883 GMT client backend[1496] 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-27 10:07:50.893 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-27 10:07:50.893 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.893 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.913 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.913 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D32DA8, reading WAL from 0/1D32D70. 2024-11-27 10:07:50.913 GMT client backend[1496] 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-27 10:07:50.913 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-27 10:07:50.913 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.913 GMT client backend[1496] 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-27 10:07:50.944 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.944 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D33468, reading WAL from 0/1D32D70. 2024-11-27 10:07:50.944 GMT client backend[1496] 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-27 10:07:50.944 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-27 10:07:50.944 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.944 GMT client backend[1496] 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-27 10:07:50.953 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.953 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D35BB0, reading WAL from 0/1D32D70. 2024-11-27 10:07:50.953 GMT client backend[1496] 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-27 10:07:50.954 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D32D70 2024-11-27 10:07:50.954 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.954 GMT client backend[1496] 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-27 10:07:50.964 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D3DE60 2024-11-27 10:07:50.964 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:50.964 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:50.991 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:50.991 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D3DE98, reading WAL from 0/1D3DE60. 2024-11-27 10:07:50.991 GMT client backend[1496] 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-27 10:07:50.992 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D3DE60 2024-11-27 10:07:50.992 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:50.992 GMT client backend[1496] 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-27 10:07:51.007 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D456D8 2024-11-27 10:07:51.007 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:51.007 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:51.038 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.038 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D45710, reading WAL from 0/1D456D8. 2024-11-27 10:07:51.038 GMT client backend[1496] 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-27 10:07:51.039 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D456D8 2024-11-27 10:07:51.039 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:51.039 GMT client backend[1496] 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-27 10:07:51.056 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D4CFE0 2024-11-27 10:07:51.056 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:51.056 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:51.068 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.068 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D4D018, reading WAL from 0/1D4CFE0. 2024-11-27 10:07:51.068 GMT client backend[1496] 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-27 10:07:51.068 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D4CFE0 2024-11-27 10:07:51.068 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:51.068 GMT client backend[1496] 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-27 10:07:51.079 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D54B30 2024-11-27 10:07:51.079 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:51.079 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:51.089 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.089 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D54B68, reading WAL from 0/1D54B30. 2024-11-27 10:07:51.089 GMT client backend[1496] 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-27 10:07:51.090 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D54B30 2024-11-27 10:07:51.090 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:51.090 GMT client backend[1496] 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-27 10:07:51.110 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 LOG: logical decoding found consistent point at 0/1D5CCD8 2024-11-27 10:07:51.110 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:51.110 GMT client backend[7896] isolation/concurrent_ddl_dml/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding'); 2024-11-27 10:07:51.119 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.119 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: Streaming transactions committing after 0/1D5CD10, reading WAL from 0/1D5CCD8. 2024-11-27 10:07:51.119 GMT client backend[1496] 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-27 10:07:51.119 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 LOG: logical decoding found consistent point at 0/1D5CCD8 2024-11-27 10:07:51.119 GMT client backend[1496] isolation/concurrent_ddl_dml/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:51.119 GMT client backend[1496] 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-27 10:07:51.409 GMT client backend[7500] isolation/oldest_xmin/control connection LOG: logical decoding found consistent point at 0/1D618C0 2024-11-27 10:07:51.409 GMT client backend[7500] isolation/oldest_xmin/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:51.409 GMT client backend[7500] 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-27 10:07:51.419 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:51.434 GMT checkpointer[1624] LOG: checkpoint complete: wrote 78 buffers (0.5%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.015 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-27 10:07:51.435 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.435 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D618F8, reading WAL from 0/1D618C0. 2024-11-27 10:07:51.435 GMT client backend[5636] 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-27 10:07:51.436 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-27 10:07:51.436 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:51.436 GMT client backend[5636] 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-27 10:07:51.440 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.440 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D68C58, reading WAL from 0/1D618C0. 2024-11-27 10:07:51.440 GMT client backend[5636] 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-27 10:07:51.440 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-27 10:07:51.440 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:51.440 GMT client backend[5636] 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-27 10:07:51.444 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.444 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: Streaming transactions committing after 0/1D68C58, reading WAL from 0/1D618C0. 2024-11-27 10:07:51.444 GMT client backend[5636] 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-27 10:07:51.445 GMT client backend[5636] isolation/oldest_xmin/s0 LOG: logical decoding found consistent point at 0/1D618C0 2024-11-27 10:07:51.445 GMT client backend[5636] isolation/oldest_xmin/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:51.445 GMT client backend[5636] 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-27 10:07:51.609 GMT client backend[5324] isolation/snapshot_transfer/control connection LOG: logical decoding found consistent point at 0/1D94AA8 2024-11-27 10:07:51.609 GMT client backend[5324] isolation/snapshot_transfer/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:51.609 GMT client backend[5324] 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-27 10:07:51.619 GMT client backend[3148] isolation/snapshot_transfer/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.619 GMT client backend[3148] isolation/snapshot_transfer/s0 DETAIL: Streaming transactions committing after 0/1D94AE0, reading WAL from 0/1D94AA8. 2024-11-27 10:07:51.619 GMT client backend[3148] 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-27 10:07:51.619 GMT client backend[3148] isolation/snapshot_transfer/s0 LOG: logical decoding found consistent point at 0/1D94AA8 2024-11-27 10:07:51.619 GMT client backend[3148] isolation/snapshot_transfer/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:51.619 GMT client backend[3148] 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-27 10:07:51.627 GMT client backend[5324] isolation/snapshot_transfer/control connection LOG: logical decoding found consistent point at 0/1DA7C88 2024-11-27 10:07:51.627 GMT client backend[5324] isolation/snapshot_transfer/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:51.627 GMT client backend[5324] 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-27 10:07:51.633 GMT client backend[3148] isolation/snapshot_transfer/s0 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.633 GMT client backend[3148] isolation/snapshot_transfer/s0 DETAIL: Streaming transactions committing after 0/1DA7CC0, reading WAL from 0/1DA7C88. 2024-11-27 10:07:51.633 GMT client backend[3148] 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-27 10:07:51.633 GMT client backend[3148] isolation/snapshot_transfer/s0 LOG: logical decoding found consistent point at 0/1DA7C88 2024-11-27 10:07:51.633 GMT client backend[3148] isolation/snapshot_transfer/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:51.633 GMT client backend[3148] 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-27 10:07:51.837 GMT client backend[5812] isolation/subxact_without_top/control connection LOG: logical decoding found consistent point at 0/1DAC310 2024-11-27 10:07:51.837 GMT client backend[5812] isolation/subxact_without_top/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:51.837 GMT client backend[5812] 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-27 10:07:51.854 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:51.863 GMT checkpointer[1624] 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-27 10:07:51.869 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:51.892 GMT checkpointer[1624] LOG: checkpoint complete: wrote 2 buffers (0.0%), wrote 2 SLRU buffers; 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.023 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-27 10:07:51.894 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.894 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DAC348, reading WAL from 0/1DAC310. 2024-11-27 10:07:51.894 GMT client backend[7276] 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-27 10:07:51.894 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DAC310 2024-11-27 10:07:51.894 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:51.894 GMT client backend[7276] 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-27 10:07:51.906 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.906 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DB7848, reading WAL from 0/1DB3268. 2024-11-27 10:07:51.906 GMT client backend[7276] 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-27 10:07:51.906 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DB3268 2024-11-27 10:07:51.906 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:51.906 GMT client backend[7276] 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-27 10:07:51.908 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:51.908 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: Streaming transactions committing after 0/1DB7848, reading WAL from 0/1DB3268. 2024-11-27 10:07:51.908 GMT client backend[7276] 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-27 10:07:51.909 GMT client backend[7276] isolation/subxact_without_top/s2 LOG: logical decoding found consistent point at 0/1DB3268 2024-11-27 10:07:51.909 GMT client backend[7276] isolation/subxact_without_top/s2 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:51.909 GMT client backend[7276] 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-27 10:07:52.392 GMT client backend[6444] isolation/concurrent_stream/control connection LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-27 10:07:52.392 GMT client backend[6444] isolation/concurrent_stream/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:52.392 GMT client backend[6444] 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-27 10:07:52.394 GMT client backend[6444] isolation/concurrent_stream/control connection LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:52.394 GMT client backend[6444] isolation/concurrent_stream/control connection DETAIL: Streaming transactions committing after 0/1DBCD68, reading WAL from 0/1DBCD30. 2024-11-27 10:07:52.394 GMT client backend[6444] 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-27 10:07:52.394 GMT client backend[6444] isolation/concurrent_stream/control connection LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-27 10:07:52.394 GMT client backend[6444] isolation/concurrent_stream/control connection DETAIL: There are no running transactions. 2024-11-27 10:07:52.394 GMT client backend[6444] 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-27 10:07:52.800 GMT client backend[6608] isolation/concurrent_stream/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:52.800 GMT client backend[6608] isolation/concurrent_stream/s1 DETAIL: Streaming transactions committing after 0/1DBCD68, reading WAL from 0/1DBCD30. 2024-11-27 10:07:52.800 GMT client backend[6608] 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-27 10:07:52.801 GMT client backend[6608] isolation/concurrent_stream/s1 LOG: logical decoding found consistent point at 0/1DBCD30 2024-11-27 10:07:52.801 GMT client backend[6608] isolation/concurrent_stream/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:52.801 GMT client backend[6608] 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-27 10:07:53.430 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-27 10:07:53.430 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-27 10:07:53.430 GMT client backend[6480] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-27 10:07:53.606 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-27 10:07:53.606 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-27 10:07:53.606 GMT client backend[6480] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-27 10:07:53.810 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-27 10:07:53.810 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-27 10:07:53.810 GMT client backend[6480] isolation/twophase_snapshot/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding', false, true); 2024-11-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Streaming transactions committing after 0/20B2110, reading WAL from 0/20B1D90. 2024-11-27 10:07:53.813 GMT client backend[6480] 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-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-27 10:07:53.813 GMT client backend[6480] 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-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-27 10:07:53.813 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-27 10:07:53.813 GMT client backend[6480] 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-27 10:07:53.815 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-27 10:07:53.815 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-27 10:07:53.815 GMT client backend[6480] 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-27 10:07:53.818 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: starting logical decoding for slot "isolation_slot" 2024-11-27 10:07:53.818 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Streaming transactions committing after 0/20B21C0, reading WAL from 0/20B1D90. 2024-11-27 10:07:53.818 GMT client backend[6480] 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-27 10:07:53.818 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial starting point at 0/20B1D90 2024-11-27 10:07:53.818 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1077 to end. 2024-11-27 10:07:53.818 GMT client backend[6480] 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-27 10:07:53.819 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found initial consistent point at 0/20B1DF8 2024-11-27 10:07:53.819 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: Waiting for transactions (approximately 1) older than 1078 to end. 2024-11-27 10:07:53.819 GMT client backend[6480] 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-27 10:07:53.819 GMT client backend[6480] isolation/twophase_snapshot/s1 LOG: logical decoding found consistent point at 0/20B20D8 2024-11-27 10:07:53.819 GMT client backend[6480] isolation/twophase_snapshot/s1 DETAIL: There are no old transactions anymore. 2024-11-27 10:07:53.819 GMT client backend[6480] 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-27 10:07:54.232 GMT client backend[7644] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B3F18 2024-11-27 10:07:54.232 GMT client backend[7644] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1082 to end. 2024-11-27 10:07:54.232 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.267 GMT client backend[7644] isolation/slot_creation_error/s2 ERROR: canceling statement due to user request 2024-11-27 10:07:54.267 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.273 GMT client backend[7644] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B3FB8 2024-11-27 10:07:54.273 GMT client backend[7644] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1083 to end. 2024-11-27 10:07:54.273 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.654 GMT client backend[7644] isolation/slot_creation_error/s2 LOG: logical decoding found consistent point at 0/20B4038 2024-11-27 10:07:54.654 GMT client backend[7644] isolation/slot_creation_error/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:54.654 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.662 GMT client backend[7644] isolation/slot_creation_error/s2 LOG: logical decoding found initial starting point at 0/20B4070 2024-11-27 10:07:54.662 GMT client backend[7644] isolation/slot_creation_error/s2 DETAIL: Waiting for transactions (approximately 1) older than 1084 to end. 2024-11-27 10:07:54.662 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.671 GMT client backend[7644] isolation/slot_creation_error/s2 FATAL: terminating connection due to administrator command 2024-11-27 10:07:54.671 GMT client backend[7644] isolation/slot_creation_error/s2 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot_creation_error', 'test_decoding'); 2024-11-27 10:07:54.940 GMT client backend[5632] isolation/skip_snapshot_restore/s0 LOG: logical decoding found consistent point at 0/20B5640 2024-11-27 10:07:54.940 GMT client backend[5632] isolation/skip_snapshot_restore/s0 DETAIL: There are no running transactions. 2024-11-27 10:07:54.940 GMT client backend[5632] isolation/skip_snapshot_restore/s0 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot0', 'test_decoding'); 2024-11-27 10:07:54.945 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: logical decoding found initial starting point at 0/20B56B8 2024-11-27 10:07:54.945 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: Waiting for transactions (approximately 1) older than 1086 to end. 2024-11-27 10:07:54.945 GMT client backend[7928] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot1', 'test_decoding'); 2024-11-27 10:07:54.951 GMT checkpointer[1624] LOG: checkpoint starting: immediate force wait 2024-11-27 10:07:54.960 GMT checkpointer[1624] LOG: checkpoint complete: wrote 55 buffers (0.3%), wrote 1 SLRU buffers; 0 WAL file(s) added, 0 removed, 1 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=3063 kB, estimate=3063 kB; lsn=0/20B5748, redo lsn=0/20B56F0 2024-11-27 10:07:54.968 GMT client backend[4192] isolation/skip_snapshot_restore/s2 LOG: starting logical decoding for slot "slot0" 2024-11-27 10:07:54.968 GMT client backend[4192] isolation/skip_snapshot_restore/s2 DETAIL: Streaming transactions committing after 0/20B5678, reading WAL from 0/20B5640. 2024-11-27 10:07:54.968 GMT client backend[4192] 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-27 10:07:54.968 GMT client backend[4192] isolation/skip_snapshot_restore/s2 LOG: logical decoding found consistent point at 0/20B5640 2024-11-27 10:07:54.968 GMT client backend[4192] isolation/skip_snapshot_restore/s2 DETAIL: There are no running transactions. 2024-11-27 10:07:54.968 GMT client backend[4192] 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-27 10:07:55.264 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B5890 2024-11-27 10:07:55.264 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:55.264 GMT client backend[7928] isolation/skip_snapshot_restore/s1 STATEMENT: SELECT 'init' FROM pg_create_logical_replication_slot('slot1', 'test_decoding'); 2024-11-27 10:07:55.266 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: starting logical decoding for slot "slot0" 2024-11-27 10:07:55.266 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: Streaming transactions committing after 0/20B57C0, reading WAL from 0/20B5640. 2024-11-27 10:07:55.266 GMT client backend[7928] 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-27 10:07:55.266 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B5640 2024-11-27 10:07:55.266 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: There are no running transactions. 2024-11-27 10:07:55.266 GMT client backend[7928] 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-27 10:07:55.270 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: starting logical decoding for slot "slot1" 2024-11-27 10:07:55.270 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: Streaming transactions committing after 0/20B58C8, reading WAL from 0/20B56B8. 2024-11-27 10:07:55.270 GMT client backend[7928] 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-27 10:07:55.270 GMT client backend[7928] isolation/skip_snapshot_restore/s1 LOG: logical decoding found consistent point at 0/20B56B8 2024-11-27 10:07:55.270 GMT client backend[7928] isolation/skip_snapshot_restore/s1 DETAIL: Logical decoding will begin using saved snapshot. 2024-11-27 10:07:55.270 GMT client backend[7928] 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-27 10:07:55.379 GMT postmaster[7912] LOG: received fast shutdown request 2024-11-27 10:07:55.379 GMT postmaster[7912] 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: 7912 abort() has been called