Author: paul
Date: 2008-04-23 19:32:38 +0200 (Wed, 23 Apr 2008)
New Revision: 10569
Log:
r30908@frost: paul | 2008-04-23 12:30:48 -0500
Document bugfix:
Bug#10374: GET_LOCK does not let connection to close on the server side if it's aborted
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/it/refman-5.1/functions-core.xml
trunk/pt/refman-5.1/functions-core.xml
trunk/refman-4.1/functions-core.xml
trunk/refman-5.0/functions-core.xml
trunk/refman-5.1/functions-core.xml
trunk/refman-6.0/functions-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:30890
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30908
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:30908
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:30908
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 33, Lines Deleted: 0; 1176 bytes
@@ -17239,4 +17239,37 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="GET_LOCK()"/>
+ <manual type="SLEEP()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="10374"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ If a connection was waiting for a
+ <function role="sql">GET_LOCK()</function> lock or a
+ <function role="sql">SLEEP()</function> call, and the connection
+ aborted, the server did not detect this and thus did not close
+ the connection. This caused a waste of system resources
+ allocated to dead connections. Now the server checks such a
+ connection every five seconds to see whether it has been
+ aborted. If so, the connection is killed (and any lock request
+ is aborted).
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/it/refman-5.1/functions-core.xml
===================================================================
--- trunk/it/refman-5.1/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/it/refman-5.1/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 7; 1231 bytes
@@ -16902,13 +16902,16 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ If a client attempts to acquire a lock that is already
+ held by another client, it blocks according to the
+ <replaceable>timeout</replaceable> argument. If the
+ blocked client terminates, its thread does not die until
+ the lock request times out. This is a known bug (fixed in
+ MySQL 6.0).
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/pt/refman-5.1/functions-core.xml
===================================================================
--- trunk/pt/refman-5.1/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/pt/refman-5.1/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 7; 1231 bytes
@@ -16902,13 +16902,16 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ If a client attempts to acquire a lock that is already
+ held by another client, it blocks according to the
+ <replaceable>timeout</replaceable> argument. If the
+ blocked client terminates, its thread does not die until
+ the lock request times out. This is a known bug (fixed in
+ MySQL 6.0).
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/refman-4.1/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 7; 1222 bytes
@@ -15401,13 +15401,16 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ If a client attempts to acquire a lock that is already
+ held by another client, it blocks according to the
+ <replaceable>timeout</replaceable> argument. If the
+ blocked client terminates, its thread does not die until
+ the lock request times out. This is a known bug (fixed in
+ MySQL 6.0).
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/refman-5.0/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 7; 1222 bytes
@@ -15651,13 +15651,16 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ If a client attempts to acquire a lock that is already
+ held by another client, it blocks according to the
+ <replaceable>timeout</replaceable> argument. If the
+ blocked client terminates, its thread does not die until
+ the lock request times out. This is a known bug (fixed in
+ MySQL 6.0).
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/refman-5.1/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 7; 1222 bytes
@@ -16909,13 +16909,16 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ If a client attempts to acquire a lock that is already
+ held by another client, it blocks according to the
+ <replaceable>timeout</replaceable> argument. If the
+ blocked client terminates, its thread does not die until
+ the lock request times out. This is a known bug (fixed in
+ MySQL 6.0).
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml 2008-04-22 19:31:45 UTC (rev 10568)
+++ trunk/refman-6.0/functions-core.xml 2008-04-23 17:32:38 UTC (rev 10569)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 7; 1186 bytes
@@ -17340,13 +17340,15 @@
second <function role="sql">GET_LOCK()</function> call.
</para>
- <para>
- Note: If a client attempts to acquire a lock that is already
- held by another client, it blocks according to the
- <replaceable>timeout</replaceable> argument. If the blocked
- client terminates, its thread does not die until the lock
- request times out. This is a known bug.
- </para>
+ <note>
+ <para>
+ Before MySQL 6.0.6, if a client attempts to acquire a lock
+ that is already held by another client, it blocks
+ according to the <replaceable>timeout</replaceable>
+ argument. If the blocked client terminates, its thread
+ does not die until the lock request times out.
+ </para>
+ </note>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10569 - in trunk: . dynamic-docs/changelog it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 23 Apr |
