List:Commits« Previous MessageNext Message »
From:jon.stephens Date:March 10 2011 5:05pm
Subject:svn commit - mysqldoc@oter02: r25348 - in trunk: dynamic-docs/changelog refman-5.6
View as plain text  
Author: js221926
Date: 2011-03-10 18:05:57 +0100 (Thu, 10 Mar 2011)
New Revision: 25348

Log:

New Last_IO_Error_Timestamp, Last_IO_Error_Timestamp columns for SHOW SLAVE STATUS

(Replication BUG#11765599 / BUG#58584)



Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml
   trunk/refman-5.6/sql-syntax-server-administration.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2011-03-10 16:39:56 UTC (rev 25347)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2011-03-10 17:05:57 UTC (rev 25348)
Changed blocks: 1, Lines Added: 35, Lines Deleted: 0; 1261 bytes

@@ -6,6 +6,41 @@
 ]>
 <changelog>
 
+  <logentry entrytype="feature">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="SHOW SLAVE STATUS"/>
+      <manual type="Last_IO_Error"/>
+      <manual type="Last_SQL_Error"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="11765599"/>
+      <fixes bugid="58584"/>
+      <seealsobug bugid="43535"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.6.3"/>
+    </versions>
+
+    <message>
+
+      <para>
+        MySQL 5.6.1 added timestamps to the error messages shown in the
+        <literal>Last_IO_Error</literal> and
+        <literal>Last_SQL_Error</literal> columns of the output of
+        <literal role="stmt">SHOW SLAVE STATUS</literal>. Now these
+        timestamps are shown in separate columns of their own, named
+        <literal>Last_IO_Error_Timestamp</literal> and
+        <literal>Last_IO_Error_Timestamp</literal>, respectively.
+      </para>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="bug">
 
     <tags>


Modified: trunk/refman-5.6/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.6/sql-syntax-server-administration.xml	2011-03-10 16:39:56 UTC (rev 25347)
+++ trunk/refman-5.6/sql-syntax-server-administration.xml	2011-03-10 17:05:57 UTC (rev 25348)
Changed blocks: 3, Lines Added: 51, Lines Deleted: 21; 4178 bytes

@@ -8726,14 +8726,21 @@
           </para>
 
           <para>
-            Beginning with MySQL 5.6.1, an error message appearing in
-            the <literal>Last_IO_Error</literal> column is prefixed with
-            the timestamp showing when the most recent I/O thread error
+            Beginning with MySQL 5.6.1, I/O error information includes a
+            timestamp showing when the most recent I/O thread error
             occurred. This timestamp uses the format <literal>YYMMDD
             HH:MM:SS</literal>.
           </para>
 
           <para>
+            Previous to MySQL 5.6.3, this timestamp was prefixed to the
+            error message text shown in the
+            <literal>Last_IO_Error</literal> column. In MySQL 5.6.3 and
+            later, the timestamp appears instead in the
+            <literal>Last_SQL_Error_Timestamp</literal> column.
+          </para>
+
+          <para>
             Issuing <literal role="stmt">RESET MASTER</literal> or
             <literal role="stmt">RESET SLAVE</literal> resets the values
             shown in these columns.

@@ -8755,32 +8762,21 @@
           </para>
 
           <para>
-            Beginning with MySQL 5.6.1, an error message appearing in
-            the <literal>Last_SQL_Error</literal> column is prefixed
-            with the timestamp showing when the most recent SQL error
+            Beginning with MySQL 5.6.1, SQL error information includes a
+            timestamp showing when the most recent SQL thread error
             occurred. This timestamp uses the format <literal>YYMMDD
             HH:MM:SS</literal>.
           </para>
 
           <para>
-            Example:
+            Previous to MySQL 5.6.3, this timestamp was prefixed to the
+            error message text shown in the
+            <literal>Last_SQL_Error</literal> column. In MySQL 5.6.3 and
+            later, the timestamp appears instead in the
+            <literal>Last_SQL_Error_Timestamp</literal> column.
           </para>
 
-<programlisting>
-Last_SQL_Errno: 1051
-Last_SQL_Error: 101118 22:35:20 error 'Unknown table 'z'' on query 'drop table z'
-</programlisting>
-
           <para>
-            The message indicates that the table <literal>z</literal>
-            existed on the master and was dropped there, but it did not
-            exist on the slave, so <literal role="stmt">DROP
-            TABLE</literal> failed on the slave. (This might occur, for
-            example, if you forget to copy the table to the slave when
-            setting up replication.)
-          </para>
-
-          <para>
             Issuing <literal role="stmt">RESET MASTER</literal> or
             <literal role="stmt">RESET SLAVE</literal> resets the values
             shown in these columns.

@@ -8910,6 +8906,40 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <literal>Last_IO_Error_Timestamp</literal>
+          </para>
+
+          <para>
+            A timestamp in <literal>YYMMDD HH:MM:SS</literal> format
+            that shows when the most recent I/O error took place.
+          </para>
+
+          <para>
+            This column was added in MySQL 5.6.3. Previously in MySQL
+            5.6, this timestamp was prepended to the error text shown in
+            <literal>Last_IO_Error</literal>.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            <literal>Last_SQL_Error_Timestamp</literal>
+          </para>
+
+          <para>
+            A timestamp in <literal>YYMMDD HH:MM:SS</literal> format
+            that shows when the last SQL error occurred.
+          </para>
+
+          <para>
+            This column was added in MySQL 5.6.3. Previously in MySQL
+            5.6, this timestamp was prepended to the error text shown in
+            <literal>Last_SQL_Error</literal>.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
     </section>


Thread
svn commit - mysqldoc@oter02: r25348 - in trunk: dynamic-docs/changelog refman-5.6jon.stephens10 Mar