ERROR: subtransaction logged without previous top-level txn record - Mailing list pgsql-admin

From Silvio Brandani - SDB Information Technology Srl
Subject ERROR: subtransaction logged without previous top-level txn record
Date
Msg-id DB7PR04MB510030498CB46121650A1C20BD2D0@DB7PR04MB5100.eurprd04.prod.outlook.com
Whole thread Raw
List pgsql-admin

 

 

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/

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: How to insert from linux to postgreSQL
Next
From: "Peter M. Groen"
Date:
Subject: Re: How to insert from linux to postgreSQL