setup slave from backup i got error

Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'

MASTER

MariaDB [(none)]> SHOW BINLOG EVENTS IN 'mysqld-bin.140180' FROM 101070557 LIMIT 4;
+-------------------+-----------+----------------+-----------+-------------+---------------------------------------+
| Log_name          | Pos       | Event_type     | Server_id | End_log_pos | Info                                  |
+-------------------+-----------+----------------+-----------+-------------+---------------------------------------+
| mysqld-bin.140180 | 101070557 | Gtid           |         7 |   101070595 | BEGIN GTID 0-7-8640143404             |
| mysqld-bin.140180 | 101070595 | Table_map      |         7 |   101070647 | table_id: 4446293 (dating.users_hits) |
| mysqld-bin.140180 | 101070647 | Update_rows_v1 |         7 |   101070695 | table_id: 4446293 flags: STMT_END_F   |
| mysqld-bin.140180 | 101070695 | Query          |         7 |   101070778 | COMMIT                                |
+-------------------+-----------+----------------+-----------+-------------+---------------------------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> show binary logs ;
+-------------------+------------+
| Log_name          | File_size  |
+-------------------+------------+
| mysqld-bin.140100 |  134219175 |
...
| mysqld-bin.140180 |  134217853 |
| mysqld-bin.140181 |  134232575 |
| mysqld-bin.140182 |  134229889 |
...
| mysqld-bin.140570 |   46141034 |
+-------------------+------------+
547 rows in set (0.00 sec)
#>for f in $(cat mysqld-bin.index); do test -f $f || echo "Not found $f" ; done;
<no output>
 
#>head mysqld-bin.index
./mysqld-bin.140100
./mysqld-bin.140101
./mysqld-bin.140102
./mysqld-bin.140103
./mysqld-bin.140104
./mysqld-bin.140105
./mysqld-bin.140106
./mysqld-bin.140107
./mysqld-bin.140108
./mysqld-bin.140109

SLAVE

MariaDB [(none)]> change master to master_host='10.8.2.31', master_user='replica', master_password='', master_log_file='mysqld-bin.140180 ', master_log_pos=101070557;
Query OK, 0 rows affected (0.00 sec)
 
MariaDB [(none)]> start slave IO_THREAD;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: 
                  Master_Host: 10.8.2.31
                  Master_User: replica
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysqld-bin.140180 
          Read_Master_Log_Pos: 101070557
               Relay_Log_File: relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mysqld-bin.140180 
             Slave_IO_Running: No
            Slave_SQL_Running: No
...
          Exec_Master_Log_Pos: 101070557
...
                Last_IO_Errno: 1236
                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'
160330 15:18:42 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.140180 ' at position 101070557, relay log './relay-bin.000001' position: 4
160330 15:18:42 [Note] Slave I/O thread: connected to master 'replica@10.8.2.31:3306',replication started in log 'mysqld-bin.140180 ' at position 101070557
160330 15:18:42 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
160330 15:18:42 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file', Internal MariaDB error code: 1236
160330 15:18:42 [Note] Slave I/O thread exiting, read up to log 'mysqld-bin.140180 ', position 10

最新文章

  1. SQLSERVER 2012 收缩日志
  2. 利用Theme自定义Activity间的切换动画
  3. PHP正则表达式模式修饰符详解
  4. js中自己实现each方法来遍历多维数组
  5. commonjs amd cmd的区别
  6. UITableView cell中label自动换行和自定义label自动换行
  7. 如何使用GCD(ZZ)
  8. 基于lucene的案例开发:查询语句创建PackQuery
  9. 结构-行为-样式-angularJs 指令实现滚动文字
  10. 【iOS】swift 保持代码优美的10个方法
  11. javascript之DOM对象
  12. logback 指定每隔一段时间创建一个日志文件
  13. .gz解压
  14. SQL中什么时候需要使用游标?使用游标的步骤
  15. [Go] 理解 golang 中的 nil
  16. RxJava学习;数据转换、线程切换;
  17. 静态编译opencv3.4.0
  18. cookie保存用户名及密码
  19. 【linux】centos6.5搭建svn
  20. 记一次MacBook Pro无法连接wifi网络修复

热门文章

  1. BZOJ 4027: [HEOI2015]兔子与樱花 树上dp
  2. Windows Sysinternals Suite
  3. javascritp 字符串截取
  4. HAproxy + keepalived 实现双机热备
  5. OpenWrt包管理软件opkg的使用(极路由)
  6. 关于DIV多层嵌套的margin-top的BUG
  7. Jquery实战——横纵向的菜单
  8. JavaScript中typeof详解
  9. easyui 设置一加载,搜索框立即弹出的效果
  10. STM32F103 GU906B模块GPRS、短信收发、拨号等功能的实现