ERROR: subtransaction logged without previous top-level txn record
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