Re: BUG #15808: ERROR: subtransaction logged without previoustop-level txn record (SQLSTATE XX000)

On 9/6/19, 1:40 PM, "Dave Cramer" <davecramer@gmail.com> wrote:
> It's possible that I have someone that would be able to run this in a non-RDS environment.
>
> It's unlikely we have a reproducible test case, but it's likely we can modify the code on their boxes for debugging
andor get  WAL files for inspection.
 
>
> This is in a version of 9.6.14 so the above fix should be in it.
>
> I'm willing to facilitate if you can provide some direction.

Hey Dave,

I have a repro for this issue here:
https://www.postgresql.org/message-id/flat/AB5978B2-1772-4FEE-A245-74C91704ECB0%40amazon.com

I can still reproduce it on REL_11_STABLE as  of the latest commit (7babff18).

postgres=# select version();
                                                version                                                 
--------------------------------------------------------------------------------------------------------
 PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180303 (Red Hat 7.3.1-5), 64-bit
(1 row)

postgres=# \q

[ec2-user.... postgres]$ pg_recvlogical -d postgres --start --slot test_slot_1 -f /dev/null
pg_recvlogical: unexpected termination of replication stream: ERROR:  subtransaction logged without previous top-level
txnrecord
 
pg_recvlogical: disconnected; waiting 5 seconds to try again

Thanks,
John H