diff options
author | Amit Kapila <akapila@postgresql.org> | 2021-06-24 09:13:46 +0530 |
---|---|---|
committer | Amit Kapila <akapila@postgresql.org> | 2021-06-24 09:13:46 +0530 |
commit | c66fb78ebb4f473bb4fd8773de3cda9339e14f81 (patch) | |
tree | bc756af23ff8398206c3293d2e080341aff12d3a | |
parent | a443c1b2d6a646cf90a8afc193c07ed12a2bf045 (diff) | |
download | postgresql-c66fb78ebb4f473bb4fd8773de3cda9339e14f81.tar.gz postgresql-c66fb78ebb4f473bb4fd8773de3cda9339e14f81.zip |
Doc: Update caveats in synchronous logical replication.
Reported-by: Simon Riggs
Author: Takamichi Osumi
Reviewed-by: Amit Kapila
Backpatch-through: 9.6
Discussion: https://www.postgresql.org/message-id/20210222222847.tpnb6eg3yiykzpky@alap3.anarazel.de
-rw-r--r-- | doc/src/sgml/logicaldecoding.sgml | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index 1765ea6c87e..53f1466e429 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -1097,16 +1097,18 @@ OutputPluginWrite(ctx, true); <para> In synchronous replication setup, a deadlock can happen, if the transaction - has locked [user] catalog tables exclusively. This is because logical decoding of - transactions can lock catalog tables to access them. To avoid this users - must refrain from taking an exclusive lock on [user] catalog tables. This can - happen in the following ways: + has locked [user] catalog tables exclusively. See + <xref linkend="logicaldecoding-capabilities"/> for information on user + catalog tables. This is because logical decoding of transactions can lock + catalog tables to access them. To avoid this users must refrain from taking + an exclusive lock on [user] catalog tables. This can happen in the following + ways: <itemizedlist> <listitem> <para> Issuing an explicit <command>LOCK</command> on <structname>pg_class</structname> - (or any other catalog table) in a transaction. + in a transaction. </para> </listitem> @@ -1141,6 +1143,10 @@ OutputPluginWrite(ctx, true); </para> </listitem> </itemizedlist> + + Note that these commands that can cause deadlock apply to not only explicitly + indicated system catalog tables above but also to any other [user] catalog + table. </para> </sect2> </sect1> @@ -1311,7 +1317,7 @@ stream_commit_cb(...); <-- commit of the streamed transaction [user] catalog tables exclusively. To avoid this users must refrain from having locks on catalog tables (e.g. explicit <command>LOCK</command> command) in such transactions. - (See <xref linkend="logicaldecoding-synchronous-caveats"/> for the details.) + See <xref linkend="logicaldecoding-synchronous-caveats"/> for the details. </para> </listitem> </itemizedlist> |