← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/include/wait_for_slave_sql_error.inc

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/include/wait_for_slave_sql_error.inc
 
1
# ==== Purpose ====
 
2
#
 
3
# Waits until the SQL thread of the current connection has got an
 
4
# error, or until a timeout is reached. Also waits until the SQL
 
5
# thread has completely stopped.
 
6
#
 
7
# ==== Usage ====
 
8
#
 
9
# source include/wait_for_slave_sql_error.inc;
 
10
#
 
11
# Parameters:
 
12
#
 
13
# $slave_sql_errno
 
14
#   The expected SQL error number.  This is required.
 
15
#   (After BUG#41956 has been fixed, this will be required to be a
 
16
#   symbolic name instead of a number.)
 
17
# 
 
18
# $slave_timeout
 
19
#   See wait_for_slave_param.inc for description.
 
20
# 
 
21
# $master_connection
 
22
#   See wait_for_slave_param.inc for description.
 
23
 
 
24
if (`SELECT '$slave_sql_errno' = ''`) {
 
25
  --echo !!!ERROR IN TEST: you must set \$slave_sql_errno before sourcing wait_fro_slave_sql_error.inc
 
26
  exit;
 
27
}
 
28
 
 
29
let $slave_param= Slave_SQL_Running;
 
30
let $slave_param_value= No;
 
31
let $slave_error_message= Failed while waiting for slave to stop the SQL thread (expecting error in the SQL thread);
 
32
source include/wait_for_slave_param.inc;
 
33
 
 
34
let $_error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1);
 
35
if (`SELECT '$_error' != '$slave_sql_errno'`) {
 
36
  --echo Slave stopped with wrong error code: $_error (expected $slave_sql_errno)
 
37
  source include/show_rpl_debug_info.inc;
 
38
  exit;
 
39
}