RE: BUG #18898: replication process not working... sometimes - Mailing list pgsql-bugs

From Hayato Kuroda (Fujitsu)
Subject RE: BUG #18898: replication process not working... sometimes
Date
Msg-id OSCPR01MB14966AE1462D381AF27CA6FD9F5BF2@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to BUG #18898: replication process not working... sometimes  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Dear Jaime,

> The following bug has been logged on the website:

Thanks for reporting the issue. Could you please provide scripts which can
reproduce the issue? This is very helpful to analyze and fix.

I roughly emulated the situation like attached but I could not reproduce. Maybe
it missed something.

> Any way to debug the real problem here? or is there something i'm missing?

Not sure it is related, but I could come up with [1] and [2]. This issue could happen
when ALTER PUBLICATION or ALTER TYPE commands are run during the replication.

[1]: https://www.postgresql.org/message-id/flat/de52b282-1166-1180-45a2-8d8917ca74c6%40enterprisedb.com
[2]: https://github.com/postgres/postgres/commit/4909b38af034fa4d2c67c5c71fd8509f870c1695

Best regards,
Hayato Kuroda
FUJITSU LIMITED


Attachment

pgsql-bugs by date:

Previous
From: Nico Williams
Date:
Subject: Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Next
From: PG Bug reporting form
Date:
Subject: BUG #18899: FreeBSD, assembly by means of GCC with ASAN ends with error: undef reference to backtrace_symbols_fd