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

On 9/6/19, 1:40 PM, "Dave Cramer" <davecramer(at)gmail(dot)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 and or 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 txn record
pg_recvlogical: disconnected; waiting 5 seconds to try again

Thanks,
John H