ERROR: subtransaction logged without previous top-level txn record

[Silvio Brandani - SDB Information Technology Srl <silvio.brandani@xxxxxxxxxxx>]

 

 

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

 

 

 

 

This message is for the recipients only. If you receive it in error, please notify the sender and delete it together with any attachments. Please refer to our client-supplier disclosure on https://www.savinodelbene.com/en/privacy/