binlog was corrupted after shutdown and restart the server

25 views
Skip to first unread message

Weixiang Zhai

unread,
Sep 14, 2012, 5:29:54 AM9/14/12
to percona-d...@googlegroups.com
HI, All
Recently we stopped the server and restart it as below:
1. execute "stop slave"
2. execute "flush tables"
3. drop cache:

sync ; sync ; sync ;
echo 3 > /proc/sys/vm/drop_caches


4. mysqladmin –uroot –h127.0.0.1 shutdown


the server was shutdown normally.


we restarted the server later, and  Last MySQL binlog information in error log is :

InnoDB: Last MySQL binlog file position 0 59707, file name /home/mysql/data3306/mysql/mysql-bin.063722


but the actual size of mysql-bin.063722 is 4096, and the io thread of slave reported an error that binlog was corrupted


Is there anyone knows why this happen?


Version: Percona Server 5.5.18



Reply all
Reply to author
Forward
0 new messages