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 |
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 |