Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita3e5f72

Browse files
committed
[Doc]: apply mvcc patch
1 parent82ad0e6 commita3e5f72

File tree

1 file changed

+82
-4
lines changed

1 file changed

+82
-4
lines changed

‎doc/src/sgml/mvcc.sgml

Lines changed: 82 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1001,12 +1001,12 @@ ERROR: could not serialize access due to read/write dependencies among transact
10011001
</term>
10021002
<listitem>
10031003
<para>
1004-
Conflicts with locks ofall modes (<literal>ACCESS
1004+
Conflicts with locks of <literal>ACCESS
10051005
SHARE</literal>, <literal>ROW SHARE</literal>, <literal>ROW
10061006
EXCLUSIVE</literal>, <literal>SHARE UPDATE
10071007
EXCLUSIVE</literal>, <literal>SHARE</literal>, <literal>SHARE
10081008
ROW EXCLUSIVE</literal>, <literal>EXCLUSIVE</literal>, and
1009-
<literal>ACCESS EXCLUSIVE</literal>).
1009+
<literal>ACCESS EXCLUSIVE</literal> mode.
10101010
This mode guarantees that the
10111011
holder is the only transaction accessing the table in any way.
10121012
</para>
@@ -1034,6 +1034,40 @@ ERROR: could not serialize access due to read/write dependencies among transact
10341034
</para>
10351035
</tip>
10361036

1037+
<para>
1038+
Besides, there are two additional lock modes designed to support
1039+
<application>1C Enterprise</application>. These modes do not conflict
1040+
with any other lock modes described above. They use is possible, but not
1041+
encouraged, as <link linkend="advisory-locks">advisory locks</link> provide
1042+
the same functionality.
1043+
</para>
1044+
1045+
<variablelist>
1046+
<varlistentry>
1047+
<term>
1048+
<literal>APPLICATION SHARE</literal>
1049+
</term>
1050+
<listitem>
1051+
<para>
1052+
Conflicts with the <literal>APPLICATION EXCLUSIVE</literal> lock
1053+
mode only.
1054+
</para>
1055+
</listitem>
1056+
</varlistentry>
1057+
1058+
<varlistentry>
1059+
<term>
1060+
<literal>APPLICATION EXCLUSIVE</literal>
1061+
</term>
1062+
<listitem>
1063+
<para>
1064+
Conflicts with the <literal>APPLICATION SHARE</literal> and
1065+
<literal>APPLICATION EXCLUSIVE</literal> lock modes.
1066+
</para>
1067+
</listitem>
1068+
</varlistentry>
1069+
</variablelist>
1070+
10371071
<para>
10381072
Once acquired, a lock is normally held till end of transaction. But if a
10391073
lock is acquired after establishing a savepoint, the lock is released
@@ -1048,9 +1082,9 @@ ERROR: could not serialize access due to read/write dependencies among transact
10481082

10491083
<table tocentry="1" id="table-lock-compatibility">
10501084
<title> Conflicting Lock Modes</title>
1051-
<tgroup cols="9">
1085+
<tgroup cols="11">
10521086
<colspec colnum="2" colname="lockst">
1053-
<colspec colnum="9" colname="lockend">
1087+
<colspec colnum="11" colname="lockend">
10541088
<spanspec namest="lockst" nameend="lockend" spanname="lockreq">
10551089
<thead>
10561090
<row>
@@ -1066,6 +1100,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
10661100
<entry>SHARE ROW EXCLUSIVE</entry>
10671101
<entry>EXCLUSIVE</entry>
10681102
<entry>ACCESS EXCLUSIVE</entry>
1103+
<entry>APPLICATION SHARE</entry>
1104+
<entry>APPLICATION EXCLUSIVE</entry>
10691105
</row>
10701106
</thead>
10711107
<tbody>
@@ -1079,6 +1115,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
10791115
<entry align="center"></entry>
10801116
<entry align="center"></entry>
10811117
<entry align="center">X</entry>
1118+
<entry align="center"></entry>
1119+
<entry align="center"></entry>
10821120
</row>
10831121
<row>
10841122
<entry>ROW SHARE</entry>
@@ -1090,6 +1128,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
10901128
<entry align="center"></entry>
10911129
<entry align="center">X</entry>
10921130
<entry align="center">X</entry>
1131+
<entry align="center"></entry>
1132+
<entry align="center"></entry>
10931133
</row>
10941134
<row>
10951135
<entry>ROW EXCLUSIVE</entry>
@@ -1101,6 +1141,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
11011141
<entry align="center">X</entry>
11021142
<entry align="center">X</entry>
11031143
<entry align="center">X</entry>
1144+
<entry align="center"></entry>
1145+
<entry align="center"></entry>
11041146
</row>
11051147
<row>
11061148
<entry>SHARE UPDATE EXCLUSIVE</entry>
@@ -1112,6 +1154,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
11121154
<entry align="center">X</entry>
11131155
<entry align="center">X</entry>
11141156
<entry align="center">X</entry>
1157+
<entry align="center"></entry>
1158+
<entry align="center"></entry>
11151159
</row>
11161160
<row>
11171161
<entry>SHARE</entry>
@@ -1123,6 +1167,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
11231167
<entry align="center">X</entry>
11241168
<entry align="center">X</entry>
11251169
<entry align="center">X</entry>
1170+
<entry align="center"></entry>
1171+
<entry align="center"></entry>
11261172
</row>
11271173
<row>
11281174
<entry>SHARE ROW EXCLUSIVE</entry>
@@ -1134,6 +1180,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
11341180
<entry align="center">X</entry>
11351181
<entry align="center">X</entry>
11361182
<entry align="center">X</entry>
1183+
<entry align="center"></entry>
1184+
<entry align="center"></entry>
11371185
</row>
11381186
<row>
11391187
<entry>EXCLUSIVE</entry>
@@ -1145,6 +1193,8 @@ ERROR: could not serialize access due to read/write dependencies among transact
11451193
<entry align="center">X</entry>
11461194
<entry align="center">X</entry>
11471195
<entry align="center">X</entry>
1196+
<entry align="center"></entry>
1197+
<entry align="center"></entry>
11481198
</row>
11491199
<row>
11501200
<entry>ACCESS EXCLUSIVE</entry>
@@ -1156,6 +1206,34 @@ ERROR: could not serialize access due to read/write dependencies among transact
11561206
<entry align="center">X</entry>
11571207
<entry align="center">X</entry>
11581208
<entry align="center">X</entry>
1209+
<entry align="center"></entry>
1210+
<entry align="center"></entry>
1211+
</row>
1212+
<row>
1213+
<entry>APPLICATION SHARE</entry>
1214+
<entry align="center"></entry>
1215+
<entry align="center"></entry>
1216+
<entry align="center"></entry>
1217+
<entry align="center"></entry>
1218+
<entry align="center"></entry>
1219+
<entry align="center"></entry>
1220+
<entry align="center"></entry>
1221+
<entry align="center"></entry>
1222+
<entry align="center"></entry>
1223+
<entry align="center">X</entry>
1224+
</row>
1225+
<row>
1226+
<entry>APPLICATION EXCLUSIVE</entry>
1227+
<entry align="center"></entry>
1228+
<entry align="center"></entry>
1229+
<entry align="center"></entry>
1230+
<entry align="center"></entry>
1231+
<entry align="center"></entry>
1232+
<entry align="center"></entry>
1233+
<entry align="center"></entry>
1234+
<entry align="center"></entry>
1235+
<entry align="center">X</entry>
1236+
<entry align="center">X</entry>
11591237
</row>
11601238
</tbody>
11611239
</tgroup>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp