Re: ERROR: subxact logged without previous toplevel record

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: ERROR: subxact logged without previous toplevel record
Date: 2018-05-15 21:26:32
Message-ID: CAHE3wgh0giRymt7a6vf1KxWcFRzJSXw86=JnOGDpMfapAartAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

2018-05-15 16:43 GMT-03:00 Euler Taveira <euler(at)timbira(dot)com(dot)br>:
> 2018-05-15 16:08 GMT-03:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:
>> Can you find in pg_waldump all the records for this transaction,
>> xid=124557507?
>>
> I don't know this ML size limit but it seems huge to attach at this
> email (~900 kb gzipped). Grab it at [1].
>
I forgot to mention that I have 16 replicas subscribed at the same
publication. This problematic replica was setup only 10 minutes after
the error. All of the other replicas are working fine since they were
setup a few days ago. I am thinking if it is somewhat related to the
replication start point.

--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message reader 1001 2018-05-16 03:42:16 Re: Abnormal JSON query performance
Previous Message Tom Lane 2018-05-15 20:06:35 Re: "order by" and "order by asc" returning different results on date field