Got fatal error 1236 from master when reading data from binary log
来源:互联网 发布:java 编码url 空格 20 编辑:程序博客网 时间:2024/04/30 00:40
模拟断电,master和slave非正常关机,slave重启后出现如下错误。
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:
'Client requested master to start replication from position > file size; the first event 'binlog_45_3316.000025' at 1930538,
the last event read from '/mysql5.6/logs/binlog_45_3316.000025' at 4, the last byte read from '/mysql5.6/logs/binlog_45_3316.000025' at 4.'
# at 1924965
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> CHANGE MASTER TO
-> MASTER_PORT=3316,
-> MASTER_LOG_FILE='binlog_45_3316.000025',
-> MASTER_LOG_POS= 1924965,
-> MASTER_CONNECT_RETRY=10;
Query OK, 0 rows affected (0.03 sec)
mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> show slave status\G
Last_SQL_Errno: 1755
Last_SQL_Error: Cannot execute the current event group in the parallel mode.
Encountered event Xid, relay-log name /mysql5.6/logs/relay_45_3316.000002,
position 288 which prevents execution of this event group in parallel mode.
Reason: the event is a part of a group that is unsupported in the parallel execution mode.
mysql> set global slave_parallel_workers=0;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%paral%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| slave_parallel_workers | 0 |
+------------------------+-------+
1 row in set (0.00 sec)
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:
'Client requested master to start replication from position > file size; the first event 'binlog_45_3316.000025' at 1930538,
the last event read from '/mysql5.6/logs/binlog_45_3316.000025' at 4, the last byte read from '/mysql5.6/logs/binlog_45_3316.000025' at 4.'
找到master的binlog,binlog_45_3316.000025找到最后一个POS是1924965,而没有错误中说的是 the first event 'binlog_45_3316.000025' at 1930538
# at 1924965
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> CHANGE MASTER TO
-> MASTER_PORT=3316,
-> MASTER_LOG_FILE='binlog_45_3316.000025',
-> MASTER_LOG_POS= 1924965,
-> MASTER_CONNECT_RETRY=10;
Query OK, 0 rows affected (0.03 sec)
mysql> start slave;
Query OK, 0 rows affected, 1 warning (0.03 sec)
mysql> show slave status\G
Last_SQL_Errno: 1755
Last_SQL_Error: Cannot execute the current event group in the parallel mode.
Encountered event Xid, relay-log name /mysql5.6/logs/relay_45_3316.000002,
position 288 which prevents execution of this event group in parallel mode.
Reason: the event is a part of a group that is unsupported in the parallel execution mode.
mysql> set global slave_parallel_workers=0;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%paral%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| slave_parallel_workers | 0 |
+------------------------+-------+
1 row in set (0.00 sec)
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
0 0
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Got fatal error 1236 from master when reading data from binary log
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find
- Got fatal error 1236 from master when reading data from binary log
- Got fatal error 1236 from master when reading data from binary log
- MySQL之Got fatal error 1236 from master when reading data from binary log
- MySQL 的一次错误处理 Got fatal error 1236 from master when reading data from binary log
- mysql主从同步报错 Got fatal error 1236 from master when reading data from binary log
- Got fatal error 1236 from master when reading data from binary log: ‘Slave can not handle replicatio
- Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not h
- Got fatal error 1236 from master when reading data from binary log: 'A slave with the same server_uu
- Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo
- Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary lo
- 主库磁盘满,从库io线程报错Got fatal error 1236 from master when reading data from binary log
- 刚建的mysql主从,但是主机的bin日志没有开启,报如下错:Got fatal error 1236 from master when reading data from binary log: '
- error 1236 from master when reading data from binary log: 'Slave can not handle replication events w
- Got fatal error 1236 from master
- Last_IO_Error: Got fatal error 1236 from master解决方法
- 关于面试的一些小记
- 密码学基础知识(七)公钥密码
- IOS学习之strong-weak,assign,nonatomic关键字整理
- 推荐一个手把手叫学greendao的好教程
- 技术分享-2015.7.8编
- Got fatal error 1236 from master when reading data from binary log
- 访问FTP站点下载文件,提示“当前的安全设置不允许从该位置下载文件”
- 排序算法!~
- BaseExpandableListAdapter的用法
- 黑马程序员————第十八天
- 【MapReduce】常用计算模型详解
- qt 正则表达式
- [安卓]新闻客户端(四) 主页面之slidingMenu & fragment(2)
- Android 自定义View 之 format 详解