ERROR: subtransaction logged without previous top-level txn record

From: Silvio Brandani - SDB Information Technology Srl <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: ERROR: subtransaction logged without previous top-level txn record
Date: 2019-04-09 14:11:30
Message-ID: DB7PR04MB510030498CB46121650A1C20BD2D0@DB7PR04MB5100.eurprd04.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-admin by date

  From Date Subject
Next Message Peter M. Groen 2019-04-09 16:07:19 Re: How to insert from linux to postgreSQL
Previous Message Rui DeSousa 2019-04-08 19:33:42 Re: How to insert from linux to postgreSQL