ERROR: subtransaction logged without previous top-level txn record

Поиск
Список
Период
Сортировка
От Silvio Brandani - SDB Information Technology Srl
Тема ERROR: subtransaction logged without previous top-level txn record
Дата
Msg-id DB7PR04MB510030498CB46121650A1C20BD2D0@DB7PR04MB5100.eurprd04.prod.outlook.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: How to insert from linux to postgreSQL
Следующее
От: "Peter M. Groen"
Дата:
Сообщение: Re: How to insert from linux to postgreSQL