Hi Serge
In the WL, there are 5 test items described, but only test 1 is
implemented in this test, why the other items are not included?
And please use:
let $errno= query_get_value("SHOW SLAVE STATUS", Last_SQL_Errno, 1);
echo Last_SQL_Errno = $errno;
let $error= query_get_value("SHOW SLAVE STATUS", Last_SQL_Error, 1);
echo Last_SQL_Error = $error;
instead of SHOW SLAVE STATUS if the test case only cares about the SQL
error.
Serge Kozlov wrote:
> #At file:///home/ksm/sun/repo/mysql-5.1-rpl-WL3690/
>
> 2662 Serge Kozlov 2008-08-27
> WL#3690: Added test case for replication event to denote gap in replication.
> added:
> mysql-test/suite/rpl_ndb/r/rpl_ndb_denote_gap.result
> mysql-test/suite/rpl_ndb/t/rpl_ndb_denote_gap.test
>
> === added file 'mysql-test/suite/rpl_ndb/r/rpl_ndb_denote_gap.result'
> --- a/mysql-test/suite/rpl_ndb/r/rpl_ndb_denote_gap.result 1970-01-01 00:00:00 +0000
> +++ b/mysql-test/suite/rpl_ndb/r/rpl_ndb_denote_gap.result 2008-08-26 20:26:51 +0000
> @@ -0,0 +1,46 @@
> +stop slave;
> +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
> +reset master;
> +reset slave;
> +drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
> +start slave;
> +
> +SHOW SLAVE STATUS;
> +Slave_IO_State Waiting for master to send event
> +Master_Host 127.0.0.1
> +Master_User root
> +Master_Port #
> +Connect_Retry #
> +Master_Log_File #
> +Read_Master_Log_Pos #
> +Relay_Log_File #
> +Relay_Log_Pos #
> +Relay_Master_Log_File #
> +Slave_IO_Running Yes
> +Slave_SQL_Running No
> +Replicate_Do_DB
> +Replicate_Ignore_DB
> +Replicate_Do_Table
> +Replicate_Ignore_Table
> +Replicate_Wild_Do_Table
> +Replicate_Wild_Ignore_Table
> +Last_Errno 1590
> +Last_Error The incident LOST_EVENTS occured on the master. Message: mysqld startup
> +Skip_Counter 0
> +Exec_Master_Log_Pos #
> +Relay_Log_Space #
> +Until_Condition None
> +Until_Log_File
> +Until_Log_Pos 0
> +Master_SSL_Allowed No
> +Master_SSL_CA_File
> +Master_SSL_CA_Path
> +Master_SSL_Cert
> +Master_SSL_Cipher
> +Master_SSL_Key
> +Seconds_Behind_Master #
> +Master_SSL_Verify_Server_Cert No
> +Last_IO_Errno #
> +Last_IO_Error #
> +Last_SQL_Errno 1590
> +Last_SQL_Error The incident LOST_EVENTS occured on the master. Message: mysqld
> startup
>
> === added file 'mysql-test/suite/rpl_ndb/t/rpl_ndb_denote_gap.test'
> --- a/mysql-test/suite/rpl_ndb/t/rpl_ndb_denote_gap.test 1970-01-01 00:00:00 +0000
> +++ b/mysql-test/suite/rpl_ndb/t/rpl_ndb_denote_gap.test 2008-08-26 20:26:51 +0000
> @@ -0,0 +1,38 @@
> +#############################################################
> +# Author: Serge Kozlov <skozlov@stripped>
> +# Date: 08/25/2008
> +# Purpose: Testing replication event to denote gap
> +# (LOST_EVENTS) in cluster replication.
> +#############################################################
> +--source include/have_ndb.inc
> +--source include/ndb_master-slave.inc
> +--echo
> +
> +# Stop master mysql server
> +--connection master
> +--write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.1.expect
> +wait
> +EOF
> +--shutdown_server 10
> +--source include/wait_until_disconnected.inc
> +
> +# Wait while slave lost connection to master
> +--connection slave
> +--source include/wait_for_slave_io_to_stop.inc
> +
> +# Start master server again
> +--append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.1.expect
> +restart
> +EOF
> +
> +# Reconnect to master
> +--enable_reconnect
> +--source include/wait_until_connected_again.inc
> +
> +# Wait for stop slave SQL thread with error LOST EVENTS
> +--connection slave
> +--source include/wait_for_slave_sql_to_stop.inc
> +--replace_column 4 # 5 # 6 # 7 # 8 # 9 # 10 # 22 # 23 # 33 # 35 # 36 #
> +--query_vertical SHOW SLAVE STATUS
> +
> +# End of test 5.1
>
