080204 16:02:24 Error reading packet from server: Could not find first log file name in binary log index file (server_errno=1236)
080204 16:02:24 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
080204 16:02:24 Slave I/O thread exiting, read up to log 'DB9_ph-bin.001', position 64382992
080204 16:08:17 Slave I/O thread: connected to master 'repl@172.17.12.188:3306', replication started in log 'DB9_ph-bin.003' at position 79
我今天更改一台业务DB的logbin目录,更改后DR报上边的错误,再Index找不到那个logbin文件。
原来是因为我将原来log目录下的binlog移动到/db/logbin下边,而之前DR读到的DB 的 logbin文件还是第一个,然后引起上边报错,这个应该是因为绝对路径的问题,后来重新做了change master 更改master_log_file和master_log_pos,就好了
[root@DB9_ph logbin]# more DB9_ph-bin.index
/log/DB9_ph-bin.001
/db/logbin/DB9_ph-bin.002
/db/logbin/DB9_ph-bin.003