Error initializing relay log position: Could not find target log during relay log initialization
How do I specify the target log other than what I'm doing? See below for details.
Daniel Gibby wrote:
The problem isn't that it can't connect to the master. The IO is running fine. It is just the SQL slave thread that won't restart. I have looked in the server log and that just has a duplication of the message I get when I try to CHANGE MASTER TO RELAY_LOG_FILE=...
Error initializing relay log position: Could not find target log during relay log initialization
My master server was hard booted and now my slave can't execute the replicated binary sql logs.
mysql> show slave status\G *************************** 1. row *************************** Master_Host: post.somehost.com Master_User: replicator Master_Port: 3306 Connect_retry: 60 Master_Log_File: post-bin.118 Read_Master_Log_Pos: 651380657 Relay_Log_File: backups-relay-bin.025 Relay_Log_Pos: 4 Relay_Master_Log_File: post-bin.111 Slave_IO_Running: No Slave_SQL_Running: No Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 1 Exec_master_log_pos: 462778298 Relay_log_space: 5987610630 1 row in set (0.00 sec)
I can execute slave start and the IO will keep on running. (I think I had to execute some command to accomplish this, but it was a couple of weeks ago, and I don't remember what the command was.)
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G *************************** 1. row *************************** Master_Host: post.somehost Connect_retry: 60 Master_Log_File: post-bin.118 Read_Master_Log_Pos: 651817308 Relay_Log_File: backups-relay-bin.025 Relay_Log_Pos: 4 Relay_Master_Log_File: post-bin.111 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 1 Exec_master_log_pos: 462778298 Relay_log_space: 5988047320 1 row in set (0.00 sec)
As you can see, my relay logs are starting to take up a _lot_ of space and I really need to start executing them or I'll never catch up.
This is the contents of my directory where the logs are:
-rw-rw---- 1 mysqld mysqld 79 Oct 7 23:10 backups-bin.001
-rw-rw---- 1 mysqld mysqld 79 Oct 10 08:47 backups-bin.002
etc....
-rw-rw---- 1 mysqld mysqld 3035 Feb 9 14:18 backups-bin.023
-rw-rw---- 1 mysqld mysqld 573 Mar 8 18:41 backups-bin.024
-rw-rw---- 1 mysqld mysqld 79 Mar 9 10:39 backups-bin.025
-rw-rw---- 1 mysqld mysqld 450 Mar 9 10:39 backups-bin.index
-rw-rw---- 1 mysqld mysqld 611349208 Mar 9 07:42 backups-relay-bin.024
-rw-rw---- 1 mysqld mysqld 1073741983 Mar 10 08:52 backups-relay-bin.025
etc...
-rw-rw---- 1 mysqld mysqld 1073742041 Mar 15 11:12 backups-relay-bin.029
-rw-rw---- 1 mysqld mysqld 19673092 Mar 15 11:34 backups-relay-bin.030
-rw-rw---- 1 mysqld mysqld 168 Mar 15 11:12 backups-relay-bin.index
-rw-rw---- 1 mysqld root 315954 Mar 15 11:31 backups.somehost.com.err
-rw-rw---- 1 mysqld mysqld 5 Mar 9 10:39 backups.somehost.com.pid
-rw-rw---- 1 mysqld mysqld 10485624 Mar 1 22:32 log.0000000055
etc...
-rw-rw---- 1 mysqld mysqld 9005000 Mar 15 11:14 log.0000000063
drwx------ 2 mysqld mysqld 16384 Aug 18 2003 lost+found
-rw-rw---- 1 mysqld mysqld 81 Mar 15 11:34 master.info
-rw-r--r-- 1 mysqld mysqld 5023 Mar 9 10:39 my.cnf
drwx------ 2 mysqld mysqld 4096 Nov 18 06:52 mysql
-rw-rw---- 1 mysqld mysqld 59 Mar 9 11:13 relay-log.info
and the directories for my databases.
I used mysqlbinlog to check what the last part of the backups-relay-bin.024 contents were and queried and saw that it really has completed it's statements. Looking at the head of the backups-relay-bin.025 reveals that its queries haven't been executed. So I think I need to somehow change the server to start executing at 025, right?
When I execute CHANGE MASTER TO RELAY_LOG_FILE='backups-relay-bin.025' RELAY_LOG_POS=4; I get this:
ERROR 1105: Failed initializing relay log position: Could not find target log during relay log initialization
What does that mean? I can't find documenation on it anywhere.
Am I going about recovering this correctly? HELP!
Thanks, Daniel Gibby
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
