($INBOX_DIR/description missing)help / color / mirror / Atom feed
Re: docs: pg_replication_origin_oid() description does not match behaviour 4+ messages / 3 participants [nested] [flat]
* Re: docs: pg_replication_origin_oid() description does not match behaviour @ 2022-01-19 03:25 Ian Lawrence Barwick <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Ian Lawrence Barwick @ 2022-01-19 03:25 UTC (permalink / raw) To: Michael Paquier <[email protected]>; +Cc: Bossart, Nathan <[email protected]>; pgsql-hackers 2022年1月19日(水) 10:40 Michael Paquier <[email protected]>: > > On Tue, Jan 18, 2022 at 06:20:22PM +0000, Bossart, Nathan wrote: > > +1 > > And done. Thanks! Ian Barwick -- EnterpriseDB: https://www.enterprisedb.com ^ permalink raw reply [nested|flat] 4+ messages in thread
* [PATCH 04/19] doc: s/in local server/on local server/ 94c49d53402240ad7ddbcae9049ff2840a54b9c6 @ 2022-02-18 03:08 Justin Pryzby <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Justin Pryzby @ 2022-02-18 03:08 UTC (permalink / raw) many similar things were fixed in 410aa248e5a883fde4832999cc9b23c7ace0f2ff --- doc/src/sgml/postgres-fdw.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index d8dc7155874..92d89c0fc99 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -1040,7 +1040,7 @@ postgres=# SELECT postgres_fdw_disconnect_all(); <row> <entry><literal>%C</literal></entry> <entry> - Cluster name in local server + Cluster name on local server (see <xref linkend="guc-cluster-name"/> for details) </entry> </row> -- 2.17.1 --8X7/QrJGcKSMr1RN Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0005-doc-pg_column_compression-we-say-method-not-algorith.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
* [PATCH 08/17] doc: s/in local server/on local server/ 94c49d53402240ad7ddbcae9049ff2840a54b9c6 @ 2022-02-18 03:08 Justin Pryzby <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Justin Pryzby @ 2022-02-18 03:08 UTC (permalink / raw) many similar things were fixed in 410aa248e5a883fde4832999cc9b23c7ace0f2ff --- doc/src/sgml/postgres-fdw.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/src/sgml/postgres-fdw.sgml b/doc/src/sgml/postgres-fdw.sgml index 88f564d7fd8..88a864eb57a 100644 --- a/doc/src/sgml/postgres-fdw.sgml +++ b/doc/src/sgml/postgres-fdw.sgml @@ -1040,7 +1040,7 @@ postgres=# SELECT postgres_fdw_disconnect_all(); <row> <entry><literal>%C</literal></entry> <entry> - Cluster name in local server + Cluster name on local server (see <xref linkend="guc-cluster-name"/> for details) </entry> </row> -- 2.17.1 --juZjCTNxrMaZdGZC Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0009-doc-pg_column_compression-we-say-method-not-algorith.patch" ^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: WaitEventSetWaitBlock() can still hang on Windows due to connection reset @ 2025-04-17 07:10 Hayato Kuroda (Fujitsu) <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Hayato Kuroda (Fujitsu) @ 2025-04-17 07:10 UTC (permalink / raw) To: 'Alexander Lakhin' <[email protected]>; +Cc: pgsql-hackers; Thomas Munro <[email protected]> Dear Alexander, While analyzing the BF failure [1], I noticed that the same issue may happen here, which means apply worker waited something. According to the log, apply worker (PID 2820) stucked so that logical replication could not restart. Regress log: ``` ### Restarting node "pub" # Running: pg_ctl --wait --pgdata C:\\prog\\bf\\root\\HEAD\\pgsql.build/... waiting for server to shut down.... done server stopped waiting for server to start.... done server started # Postmaster PID for node "pub" is 980 timed out waiting for match: (?^:Streaming transactions committing after ([A-F0-9]+/[A-F0-9]+), ... ``` Subscriber log; ``` 2025-04-12 05:08:44.630 UTC [2820:1] LOG: logical replication apply worker for subscription "sub" has started 2025-04-12 05:08:44.642 UTC [5652:6] LOG: background worker "logical replication apply worker" (PID 6344) exited with exit code 1 2025-04-12 05:13:27.352 UTC [3988:1] LOG: checkpoint starting: time 2025-04-12 05:13:36.825 UTC [3988:2] LOG: checkpoint complete: wrote 62 buffers ... 2025-04-12 05:15:01.265 UTC [5652:7] LOG: received immediate shutdown request 2025-04-12 05:15:01.353 UTC [5652:8] LOG: database system is shut down ``` Publisher log; ``` 2025-04-12 05:08:44.634 UTC [1112:7] LOG: database system is shut down 2025-04-12 05:08:45.685 UTC [980:1] LOG: starting PostgreSQL 18devel on... 2025-04-12 05:08:45.687 UTC [980:2] LOG: listening on IPv4 address "127.0.0.1", port 18057 2025-04-12 05:08:46.225 UTC [4392:1] LOG: database system was shut down at 2025-04-12 05:08:43 UTC 2025-04-12 05:08:46.319 UTC [980:3] LOG: database system is ready to accept connections 2025-04-12 05:15:00.408 UTC [980:4] LOG: received immediate shutdown request 2025-04-12 05:15:00.942 UTC [980:5] LOG: database system is shut down ``` Now the report has been reported for both physical and logical replication, but I suspected that this can happen for all the application. [1]: https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=drongo&dt=2025-04-12%2003%3A59%3A3... Best regards, Hayato Kuroda FUJITSU LIMITED ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-04-17 07:10 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-01-19 03:25 Re: docs: pg_replication_origin_oid() description does not match behaviour Ian Lawrence Barwick <[email protected]> 2022-02-18 03:08 [PATCH 04/19] doc: s/in local server/on local server/ 94c49d53402240ad7ddbcae9049ff2840a54b9c6 Justin Pryzby <[email protected]> 2022-02-18 03:08 [PATCH 08/17] doc: s/in local server/on local server/ 94c49d53402240ad7ddbcae9049ff2840a54b9c6 Justin Pryzby <[email protected]> 2025-04-17 07:10 RE: WaitEventSetWaitBlock() can still hang on Windows due to connection reset Hayato Kuroda (Fujitsu) <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox