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 List-Archive: http://lists.mysql.com/commits/63743 Message-Id: <200901211631.n0LGVF43002332@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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 @@ - GRANT 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. + GRANT 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. @@ -5392,9 +5392,9 @@ - The host name of the client issuing the statement (except for - system user where there is no host). As - of MySQL 4.0.12, SHOW + The host name of the client issuing the statement (except + for system user where there is no host). + As of MySQL 4.0.12, SHOW PROCESSLIST reports the host name for TCP/IP connections in host_name:client_port @@ -5873,6 +5873,18 @@ example, if you forget to copy the table to the slave when setting up replication.) + + + + 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 + SHOW SLAVE STATUS shows a nonzero value + for Last_Errno even though + Slave_SQL_Running still displays + Yes. + + 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 @@ - GRANT 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. + GRANT 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. @@ -6504,8 +6505,8 @@ - The host name of the client issuing the statement (except for - system user where there is no host). + The host name of the client issuing the statement (except + for system user where there is no host). SHOW PROCESSLIST reports the host name for TCP/IP connections in host_name:client_port @@ -7316,6 +7317,18 @@ example, if you forget to copy the table to the slave when setting up replication.) + + + + 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 + SHOW SLAVE STATUS shows a nonzero value + for Last_Errno even though + Slave_SQL_Running still displays + Yes. + + 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 @@ - GRANT 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. + GRANT 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. @@ -5669,8 +5670,8 @@ connected_host - The host name or IP address of the cluster management server to which the - MySQL server is connected + The host name or IP address of the cluster management server to which + the MySQL server is connected connected_port @@ -7428,8 +7429,8 @@ - The host name of the client issuing the statement (except for - system user where there is no host). + The host name of the client issuing the statement (except + for system user where there is no host). SHOW PROCESSLIST reports the host name for TCP/IP connections in host_name:client_port @@ -8285,6 +8286,18 @@ the Last_Error value is not empty, it also appears as a message in the slave's error log. + + + + 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 + SHOW SLAVE STATUS shows a nonzero value + for Last_Errno even though + Slave_SQL_Running still displays + Yes. + + 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 @@ Last_SQL_Errno and Last_SQL_Error. + + + + 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 + SHOW SLAVE STATUS shows a nonzero value + for Last_SQL_Errno even though + Slave_SQL_Running still displays + Yes. + +