MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:jon Date:January 21 2009 4:31pm
Subject:svn commit - mysqldoc@docsrva: r13314 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0
View as plain text  
Author: jstephens
Date: 2009-01-21 17:31:14 +0100 (Wed, 21 Jan 2009)
New Revision: 13314

Log:

SHOW SLAVE STATUS: Possible for Last_Errno/Last_SQL_Errno to be nonzero
even though Slave_SQL_Running still shows Yes (Thanks, Sven!)



Modified:
   trunk/refman-4.1/sql-syntax-server-administration.xml
   trunk/refman-5.0/sql-syntax-server-administration.xml
   trunk/refman-5.1/sql-syntax-server-administration.xml
   trunk/refman-6.0/sql-syntax-server-administration.xml


Modified: trunk/refman-4.1/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-4.1/sql-syntax-server-administration.xml	2009-01-21 15:35:02 UTC (rev 13313)
+++ trunk/refman-4.1/sql-syntax-server-administration.xml	2009-01-21 16:31:14 UTC (rev 13314)
Changed blocks: 3, Lines Added: 18, Lines Deleted: 6; 2170 bytes

@@ -774,9 +774,9 @@
 </programlisting>
 
       <para>
-        <literal role="stmt">GRANT</literal> supports host names up to 60
-        characters long. Database, table, and column names can be up to
-        64 characters. Usernames can be up to 16 characters.
+        <literal role="stmt">GRANT</literal> supports host names up to
+        60 characters long. Database, table, and column names can be up
+        to 64 characters. Usernames can be up to 16 characters.
       </para>
 
       <note>

@@ -5392,9 +5392,9 @@
           </para>
 
           <para>
-            The host name of the client issuing the statement (except for
-            <literal>system user</literal> where there is no host). As
-            of MySQL 4.0.12, <literal role="stmt">SHOW
+            The host name of the client issuing the statement (except
+            for <literal>system user</literal> where there is no host).
+            As of MySQL 4.0.12, <literal role="stmt">SHOW
             PROCESSLIST</literal> reports the host name for TCP/IP
             connections in
             <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>

@@ -5873,6 +5873,18 @@
             example, if you forget to copy the table to the slave when
             setting up replication.)
           </para>
+
+          <note>
+            <para>
+              When the slave SQL thread receives an error, it reports
+              the error first, then stops the SQL thread. This means
+              that there is a small window of time during which
+              <literal>SHOW SLAVE STATUS</literal> shows a nonzero value
+              for <literal>Last_Errno</literal> even though
+              <literal>Slave_SQL_Running</literal> still displays
+              <literal>Yes</literal>.
+            </para>
+          </note>
         </listitem>
 
         <listitem>


Modified: trunk/refman-5.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.0/sql-syntax-server-administration.xml	2009-01-21 15:35:02 UTC (rev 13313)
+++ trunk/refman-5.0/sql-syntax-server-administration.xml	2009-01-21 16:31:14 UTC (rev 13314)
Changed blocks: 3, Lines Added: 18, Lines Deleted: 5; 2107 bytes

@@ -936,9 +936,10 @@
 </programlisting>
 
       <para>
-        <literal role="stmt">GRANT</literal> supports host names up to 60
-        characters long. Database, table, column, and routine names can
-        be up to 64 characters. Usernames can be up to 16 characters.
+        <literal role="stmt">GRANT</literal> supports host names up to
+        60 characters long. Database, table, column, and routine names
+        can be up to 64 characters. Usernames can be up to 16
+        characters.
       </para>
 
       <note>

@@ -6504,8 +6505,8 @@
           </para>
 
           <para>
-            The host name of the client issuing the statement (except for
-            <literal>system user</literal> where there is no host).
+            The host name of the client issuing the statement (except
+            for <literal>system user</literal> where there is no host).
             <literal role="stmt">SHOW PROCESSLIST</literal> reports the
             host name for TCP/IP connections in
             <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>

@@ -7316,6 +7317,18 @@
             example, if you forget to copy the table to the slave when
             setting up replication.)
           </para>
+
+          <note>
+            <para>
+              When the slave SQL thread receives an error, it reports
+              the error first, then stops the SQL thread. This means
+              that there is a small window of time during which
+              <literal>SHOW SLAVE STATUS</literal> shows a nonzero value
+              for <literal>Last_Errno</literal> even though
+              <literal>Slave_SQL_Running</literal> still displays
+              <literal>Yes</literal>.
+            </para>
+          </note>
         </listitem>
 
         <listitem>


Modified: trunk/refman-5.1/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-server-administration.xml	2009-01-21 15:35:02 UTC (rev 13313)
+++ trunk/refman-5.1/sql-syntax-server-administration.xml	2009-01-21 16:31:14 UTC (rev 13314)
Changed blocks: 4, Lines Added: 20, Lines Deleted: 7; 2645 bytes

@@ -894,9 +894,10 @@
 </programlisting>
 
       <para>
-        <literal role="stmt">GRANT</literal> supports host names up to 60
-        characters long. Database, table, column, and routine names can
-        be up to 64 characters. User names can be up to 16 characters.
+        <literal role="stmt">GRANT</literal> supports host names up to
+        60 characters long. Database, table, column, and routine names
+        can be up to 64 characters. User names can be up to 16
+        characters.
       </para>
 
       <note>

@@ -5669,8 +5670,8 @@
             </row>
             <row>
               <entry><literal>connected_host</literal></entry>
-              <entry>The host name or IP address of the cluster management server to which the
-                MySQL server is connected</entry>
+              <entry>The host name or IP address of the cluster management server to which
+                the MySQL server is connected</entry>
             </row>
             <row>
               <entry><literal>connected_port</literal></entry>

@@ -7428,8 +7429,8 @@
           </para>
 
           <para>
-            The host name of the client issuing the statement (except for
-            <literal>system user</literal> where there is no host).
+            The host name of the client issuing the statement (except
+            for <literal>system user</literal> where there is no host).
             <literal role="stmt">SHOW PROCESSLIST</literal> reports the
             host name for TCP/IP connections in
             <literal><replaceable>host_name</replaceable>:<replaceable>client_port</replaceable></literal>

@@ -8285,6 +8286,18 @@
             the <literal>Last_Error</literal> value is not empty, it
             also appears as a message in the slave's error log.
           </para>
+
+          <note>
+            <para>
+              When the slave SQL thread receives an error, it reports
+              the error first, then stops the SQL thread. This means
+              that there is a small window of time during which
+              <literal>SHOW SLAVE STATUS</literal> shows a nonzero value
+              for <literal>Last_Errno</literal> even though
+              <literal>Slave_SQL_Running</literal> still displays
+              <literal>Yes</literal>.
+            </para>
+          </note>
         </listitem>
 
         <listitem>


Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml	2009-01-21 15:35:02 UTC (rev 13313)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml	2009-01-21 16:31:14 UTC (rev 13314)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 1012 bytes

@@ -8055,6 +8055,18 @@
             <literal>Last_SQL_Errno</literal> and
             <literal>Last_SQL_Error</literal>.
           </para>
+
+          <note>
+            <para>
+              When the slave SQL thread receives an error, it reports
+              the error first, then stops the SQL thread. This means
+              that there is a small window of time during which
+              <literal>SHOW SLAVE STATUS</literal> shows a nonzero value
+              for <literal>Last_SQL_Errno</literal> even though
+              <literal>Slave_SQL_Running</literal> still displays
+              <literal>Yes</literal>.
+            </para>
+          </note>
         </listitem>
 
         <listitem>


Thread
svn commit - mysqldoc@docsrva: r13314 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0jon21 Jan