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
|