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