Grokbase Groups MySQL mysql July 2010
FAQ
Hello MySQL-users list,

We are having an issue with replication and binlog files and I was hoping that this list could shed a little light on the issue for us. We have a pair of 5.1.41-community MySQL servers. We attempted to restore from the slave server, and in the process I zeroed out the mysql-bin.index file with the echo command (I know this makes me a terrible person; in my own defense, this was effective technique for restoration on on 5.0 MySQL machines).

Now, when we run:

mysql> show master status;

We see

+------------------+-----------+--------------+------------------+
Fil| Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+-----------+--------------+------------------+
mysql-bin.000121 | 429017611 | | |
+------------------+-----------+--------------+------------------+

But if we run

mysql> SHOW BINARY LOGS;

We see

Empty set (0.00 sec)

And the RESET MASTER command has no effect.

We saw on http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

Prior to MySQL 5.0.60, PURGE BINARY LOGS TO and PURGE BINARY LOGS BEFORE did not behave in the same way (and neither one behaved correctly) when binary log files listed in the .index file had been removed from the system by some other means (such as using rm on Linux). Beginning with MySQL 5.0.60, both variants of the statement fail with an error in such cases. (Bug#18199 <http://bugs.mysql.com/bug.php?id=18199> , Bug#18453 <http://bugs.mysql.com/bug.php?id=18453> ) To handle such errors, edit the .index file (which is a simple text file) manually to ensure that it lists only the binary log files that are actually present, then run again the PURGE BINARY LOGS <purge-binary-logs.html> statement that failed.

However running PURGE BINARY LOGS against a file listed in the mysql-bin.index file (once this file has been updated to reflefc all of the logs contained within it's directory) still results in

ERROR 1373: Target log not found in binlog index

Can anyone shed some light on this issue for us?

Thanks!

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 6 | next ›
Discussion Overview
groupmysql @
categoriesmysql
postedJul 21, '10 at 5:44p
activeAug 12, '10 at 8:42p
posts6
users5
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2022 Grokbase