Mysql Error 1201 Could Not Initialize Master Info Structure
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss error reading master configuration the workings and policies of this site About Us Learn more about
Error 1201 (hy000) Could Not Initialize Master Info Structure
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Error Counting Relay Log Space
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each
Failed To Open The Relay Log
other. Join them; it only takes a minute: Sign up Error: “could not initailize master info structure” while doing Master Slave Replication in MySQL up vote 26 down vote favorite 6 I am trying to do Master Slave Replication for MySQL. When i am typing the following command: CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228; mysql> START could not find target log during relay log initialization SLAVE; it throws the following error: ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log Any help would be greatly appreciated. mysql replication master slave share|improve this question edited Feb 17 '11 at 20:51 Vijay Dev 9,261145589 asked Feb 17 '11 at 13:22 user619684 131123 add a comment| 2 Answers 2 active oldest votes up vote 89 down vote TRY TO RESET IT, IT DOES MAGIC! ON SLAVE THE SLAVE MYSQL COMMAND TYPE: RESET SLAVE; THEN TRY AGAIN: CHANGE MASTER TO MASTER_HOST='10.1.100.1', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=451228; mysql> START SLAVE; share|improve this answer answered Mar 29 '12 at 21:10 Neo 4,73913655 1 thanks a lot, had same problem here... –eran Nov 12 '12 at 16:15 1 Thanks a lot. This worked for me :D Power! (y) hehe –marknt15 May 15 '14 at 7:13 2 Worked for me. This blew my mind. –Logan Bissonnette May 28 '14 at 20:51 2 This is the solution, in my case in happened af
Start here for a quick overview of the site Help Center Detailed answers to any questions failed to open the relay log 'first' (relay_log_pos 4) you might have Meta Discuss the workings and policies of got fatal error 1236 from master when reading data from binary log: this site About Us Learn more about Stack Overflow the company Business Learn more about hiring change master to developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and http://stackoverflow.com/questions/5029485/error-could-not-initailize-master-info-structure-while-doing-master-slave-rep network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Hard reboot causes MySQL replication to break up vote 0 down vote favorite I have encountered an issue with my http://serverfault.com/questions/715849/hard-reboot-causes-mysql-replication-to-break replication setup. Under normal circumstances it performs as intended, but it breaks if it encounters a hard reboot (I pull the power cable). Setup The setup consists of two servers, server-1 and server-2. The replication setup is a circular replication. Both servers are slaves replicating from the other host as if it were the master. Software Red Hat 6.5 MySQL 5.1.73-3 MySQL-libs 5.1.73-3 MySQL-server 5.1.73-3 Redundancy configuration The replication configuration is as follows for server-1, and is mirrored for server-2: GRANT REPLICATION SLAVE ON *.* TO 'replicant'; FLUSH TABLES WITH READ LOCK;" #Use "SHOW MASTER STATUS \G;" to determine log position and log file UNLOCK TABLES; # set status on slave server using the values retieved earlier CHANGE MASTER TO MASTER_HOST='server-2', MASTER_USER='replicant', MASTER_LOG_FILE='[log file]', MASTER_LOG_POS=[log pos];" START SLAVE; Error information This information is retrieved when the server-2 has encountered a hard reboot and the replication is broken. server-1 slave status *************************** 1. row *************************** Slave_IO_State: Waiting for master
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Replication :: Can't restart slave - Could not initialize master info structure New Topic Advanced Search Can't restart slave http://forums.mysql.com/read.php?26,259192 - Could not initialize master info structure Posted by: Rasmus U () Date: April 23, 2009 07:03AM Hi, I've set up replication for backup/logging/statistics purposes. Everything is working okay, EXCEPT if the slave server i down more than a few hours/days, I can't restart the slave process. The error message is ERROR 1201 (HY000): Could not initialize master info structure; and [ERROR]Failed relay log to open the relay log '/var/run/mysqld/....' [ERROR] Could not find target log during relay log initialization As I understand, the logs get flushed after prolonged downtime/reboot. Is it any way I can configure the slave server, so that it'll catch up with the master server, without me having to get a new snapshot/master position etc (which is a cumbersome process). - The could not initialize slave already knows the last position it has reached at the master, so I do not understand the significance of the relay log... Does it make a difference whether the slave is STOPped before stopping the mysqld service? Thanks for your help! Edited 1 time(s). Last edit at 04/23/2009 07:03AM by Rasmus U. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Views Written By Posted Can't restart slave - Could not initialize master info structure 8502 Rasmus U 04/23/2009 07:03AM Re: Can't restart slave - Could not initialize master info structure 4011 Rick James 04/24/2009 10:44PM Re: Can't restart slave - Could not initialize master info structure 3199 Rasmus U 04/28/2009 03:11AM Re: Can't restart slave - Could not initialize master info structure 2976 Rick James 04/28/2009 10:44PM Re: Can't restart slave - Could not initialize master info structure 2827 Rasmus U 04/29/2009 09:19AM Re: Can't restart slave - Could not initialize master info structure 2944 Rick James 04/29/2009 08:39PM Re: Can't restart slave - Could not initialize master info structure 3544 Rasmus U 04/30/2009 04:42AM Re: Can't restart slave - Could not initialize master info struct