Обсуждение: ERROR: subtransaction logged without previous top-level txn record

Hi,

We get error loading changes from replication slot

select * from pg_replication_slots ;

   slot_name    |   plugin    | slot_type | datoid | database | temporary | active | active_pid |  xmin  | catalog_xmin | restart_lsn | confirmed_flush_lsn

-----------------+-------------+-----------+--------+----------+-----------+--------+------------+--------+--------------+-------------+---------------------

lon_walslot_raw | decoder_raw | logical   |  16385 | glftest  | f         | f      |     [null] | [null] |       139364 | 0/4FBC6B48  | 0/510FF0F8

Select * FROM pg_logical_slot_get_changes('lon_walslot_raw', NULL, NULL) ;

result in

ERROR:  subtransaction logged without previous top-level txn record

How can  we fix this ?

Thanks

SB