|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
我的博客已迁移到xdoujiang.com请去那边和我交流
1、mysql版本
5.5.24
2、ip
10.1.1.1
3、查看下slave状态
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting
for
master to send event
Master_Host: 10.1.1.1
Master_User: repl
Master_Port: 1111
Connect_Retry: 60
Master_Log_File: 29.001312
Read_Master_Log_Pos: 6783188
Relay_Log_File: 10-relay-bin.006100
Relay_Log_Pos: 93356016
Relay_Master_Log_File: 29.001309
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: 1594
Last_Error: Relay log
read
failure: Could not parse relay log event entry. The possible reasons are: the master
's binary log is corrupted (you can check this by running '
mysqlbinlog
' on the binary log), the slave'
s relay log is corrupted (you can check this by running
'mysqlbinlog'
on the relay log), a network problem, or a bug
in
the master
's or slave'
s MySQL code. If you want to check the master
's binary log or slave'
s relay log, you will be able to know their names by issuing
'SHOW SLAVE STATUS'
on this slave.
Skip_Counter: 1
Exec_Master_Log_Pos: 365359563
Relay_Log_Space: 372590271
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1594
Last_SQL_Error: Relay log
read
failure: Could not parse relay log event entry. The possible reasons are: the master
's binary log is corrupted (you can check this by running '
mysqlbinlog
' on the binary log), the slave'
s relay log is corrupted (you can check this by running
'mysqlbinlog'
on the relay log), a network problem, or a bug
in
the master
's or slave'
s MySQL code. If you want to check the master
's binary log or slave'
s relay log, you will be able to know their names by issuing
'SHOW SLAVE STATUS'
on this slave.
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2229
1 row
in
set
(0.00 sec)
ERROR:
No query specified
4、解决办法
stop slave;
change master to master_host=
'10.1.1.1'
,master_port=3306,master_log_file=
'29.001310'
,master_log_pos=1;
start slave;
show slave status\G;
|
本文转自 xdoujiang 51CTO博客，原文链接：http://blog.51cto.com/7938217/1662067，如需转载请自行联系原作者
