ERROR: subxact logged without previous toplevel record

From: Euler Taveira <euler(at)timbira(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ERROR: subxact logged without previous toplevel record
Date: 2018-05-15 19:02:40
Message-ID: CAHE3wgi5W_anszCPk66v9DMQr=_etc_PwP-Ab=+o6Yknr-zvqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

I got the $SUBJECT error in a logical replication setup. Both versions
are 10.3. I remembered that some bugs in the piece of code around this
error were fixed in 9.6 but it seems not all of them. Unfortunately I
don't have a test case. All DEBUG3 messages from an unsuccessful
replication attempt are attached. The last few messages from the
logical replication role are:

2018-05-15 15:24:05 -03 [31783]: [474-1] DEBUG: purged committed
transactions from 63 to 63, xmin: 124517330, xmax: 124615171
2018-05-15 15:24:05 -03 [31783]: [475-1] DEBUG: xmin: 124517330,
xmax: 124615171, oldestrunning: 124517330
2018-05-15 15:24:05 -03 [31783]: [476-1] DEBUG: failed to increase
restart lsn: proposed 4C9/C9CC0938, after 4CA/8592A90, current
candidate 4C9/C9CC0938, current after 4C9/D0FF05A8, flushed up to
4CA/9A8D138
2018-05-15 15:24:05 -03 [31783]: [477-1] DEBUG: spill 4096 changes
in XID 124557507 to disk
2018-05-15 15:24:05 -03 [31783]: [478-1] ERROR: subxact logged
without previous toplevel record

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

Attachment Content-Type Size
subxact-logged.txt.gz application/gzip 4.8 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-05-15 19:08:52 Re: ERROR: subxact logged without previous toplevel record
Previous Message Tom Lane 2018-05-15 18:59:53 Re: "order by" and "order by asc" returning different results on date field